-
IBM has posted an FAQ article to address the expiring TM1 SSL certificates issue
http://www-01.ibm.com/support/docview.wss?uid=swg21990940Please note that IBM has released a new technote yesterday (22/09/2016) – an FAQ article to address the expiring TM1 SSL certificate issue here There are a lot of general questions being answered in the article in regards to the issue, but we would like to highlight the following notes: 1. For those users that are using TM1…
-
Expiring TM1 SSL certificates
The default 1024-bit TM1 SSL certificates shipped and installed with the TM1 software is expiring on the 24th November 2016 – which means, if no actions are taken prior to this time, TM1 will stop working. Now, before we all collectively jump into a state of panic, be assured that there are solutions to the problem and that…
-
Optimizing dimension order in a Cube
Cube optimization/dimension re-ordering is only suitable for numeric-only cubes. If the cubes contain string data then the last dimension can’t be changed and therefore there will be a minimal benefit as the last dimension is the most important by far for cube optimisation. Optimising dimensions in a cube structure does not change the actual order…
-
IBM Cognos TM1 – Multi Threaded Queries (MTQ) in TM1 10.2
What is a Multi-Threaded Query? Users may want to improve the processing performance of queries by allowing queries to split into multiple processing threads.Multi-threaded queries allow IBM Cognos TM1 to automatically load balance a single query across multiple cores. This can improve efficiency and processing time for large queries and rules. Problems Solved by IBM…
-
Determining the exact version of TM1 you have installed
First, you will need to navigate to the root directory where TM1 is installed. In later versions of TM1 the default install path is C:Program Filesibmcognostm1_64 In Windows Explorer navigate to this directory then find the bin64 folder or bin folder in client or older server installs. Once in the bin folder follow these instructions:…
-
Things you might not know about TM1 security – Part 2
There’s more to security than read, write and none although for most intents and purposes these are the only modes that matter from an end-user perspective. However, for object security squeezed in between write and admin are two additional security levels; hold and lock. These confer additional rights beyond write access to the object. Hold:…
-
Anti-virus scanning software and TM1
Or have you ever sought to mitigate or prevent virus-scanner related performance issues by ordering scanning exceptions only to have your windows admin or security team scoff at you and refuse to take any action without something official in writing from IBM recommending excluding TM1 from virus scanning? Many of us have probably been there.…
-
Things you might not know about TM1 Security – Part 1
Have you ever wondered what the ReadOnlyUser field in the }ClientProperties cube actually does? This is a numeric property that takes Boolean values of either 1 (true) or 0 (false). This property has been around at least since v9 and probably even before. It isn’t used very often (or even as often as it actually…
-
Deprecated and discontinued functionality in IBM Cognos TM1
Functionalities that have been removed as per a particular IBM Cognos TM1 version are listed below, by version. Version Feature/Functionality 10.2.1 IBM Cognos Executive Viewer version 10.2.1 would be the last version of this product (more information). 10.2 …