Skip navigation.
spilling the beans

turbo integrator

commenting out portions of code in TI

developers
|

You would like to comment out portions of code for legacy or future use instead of removing it. Appending # at the front of every line is ugly and messes up the indenting. Here is a quick, neat and simple fix...


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.


padding zeroes

developers
|

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

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

(from olap forums)


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.


silence is fool's gold

developers
|

TM1 processes will not complain when their input source is empty.
So although the "process successful" or "chore successful" message will popup, your cube will remain desperately empty.
In order to solve that "silent" bug (or Cogglix feature), you will need to add specific code to your TI processes to test against empty sources.


Syndicate content