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

renaming elements

developers
| |

renaming elements without activating aliases? Yes we can!
The dimension editor and dimension worksheets cannot rename elements directly, so let me introduce you to SwapAliasWithPrincipalName.


TM1 9.5.1

TM1 9.5.1 was released this week.
The release notes can be found here


TM1 sudoku

admins
| | |

Beyond the purely ludic and mathematical aspects of sudoku, this code demonstrates how to set up dimensions, cubes, views, cell formating, security at elements and cells levels all through Turbo Integrator in just one process.


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)