TM1 Forum

Dear all, we do a) slice b) "active form" a cube view. We do measure (several times but it is without fluctuations) afterwards the time needed to recalculate/rebuild the resulting Excel sheet. a) F9 --> 1 sec. a) ALT-F9 --> 1 sec. b) F9 --> 52 sec. b) ALT-F9 --> 39 sec. IBM says this is a ...

Thank you lotsaram!

Now I remember, that I have read about this a while ago.

It wirks now this way:

LevelAntecessor = EXPAND ( '%' | 'level' | NUMBERTOSTRING(index) | '%' );
LevelSuccessor = EXPAND ( '%' | 'level' | NUMBERTOSTRING(index+1 ) | '%' );

Hello, I can use variables in formulas, of course. But can I define which variable to use itself within a formula? So far I can create the variable name by code, but that produces only a string with the name of the variable. I simplified my code to zoom on my problem. I want to get rid of the lines ...