Locking and updating locked cubes
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
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
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.