TM1 Forum

I have a process attemping to process all user-created cubes which include a particular dimension, such as 'Year'.

But I can't find a function in TM1 to determine whether a particular dimension (say 'Year') is the dimension of a cube. Can someone help?



Many thanks.

Regards,
Chris

Yes , there's no such function in TM1 , you have to loop throught all dimesnion within a cube using TABDIM , and try to locate the dimesnion you want .

wang_chris wrote:I have a process attemping to process all user-created cubes which include a particular dimension, such as 'Year'.

But I can't find a function in TM1 to determine whether a particular dimension (say 'Year') is the dimension of a cube. Can someone help?



Many thanks.

Regards,
Chris

Then How do I know the total number of dimensions of a cube, which is necessary in the loop?

wang_chris wrote:Then How do I know the total number of dimensions of a cube, which is necessary in the loop?

You don't need to know that. You just keep looping until TabDim returns either the dimension you're looking for, or an empty string (which signifies that it's reached the end of the dimension list).

OK, get it, thanks a lot.

BTW, if I add some attributes on dimension '}cube' to manually indicate the existing of those dimensions, is there some potential problem for TM1 system?

From memory the "}Cubes" and "}Dimensions" dims are completely rebuilt on a server restart based on what it finds in the data directory, as such manual changes end up being lost.

OK, understand.

I have created the loop in process. Thank you for your advice.


Chris

There is also a generic IBM process that determines whether dim is unused in the model.

Can be handy for you as well: http://www.ibm.com/developerworks/libra ... s-page632/

Great.

Just curious why IBM don't integrate these good practices into formal function/utility of TM1?


Chris