Skip navigation.
spilling the beans
sharing and organising free knowledge for BI implementations with a focus on IBM Cognos TM1.

Locking and updating locked cubes

admins
| | |

Locking cubes is a good way to insure your (meta)data is not tampered with.
Right click on the cube you wish to lock, then select Security->Lock.
This now protects the cube contents from TI process and (un)intentional admins' changes.


padding zeroes

developers
|

This a short simple syntax to easily pad zeroes to an index value:

Period = 'Period ' | NumberToStringEx(index, '00','','');

(from olap forums)


TM1 9.5

TM1 9.5 was released this week.
Expect a very large amount of clicks and several logging prompts before reaching the actual download link for that software.

New features:


Duplicate elements in rollups

admins
| | |

Large nested rollups can lead to elements being counted twice or more within a rollup.
The following process helps you to find, across all dimensions of your system, all rollups that contain elements consolidated more than once under the rollup.


TM1 9.1 SP4

TM1 9.1 SP4 was released last week.
It can be downloaded from the Customer Support page.