determine whether a particular dimension belongs to a cube

[wang_chris]

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

[hyunjia]

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 .

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

[wang_chris]

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

[Alan Kirk]

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).

[wang_chris]

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?

[declanr]

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.

[wang_chris]

OK, understand.

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


Chris

[EvgenyT]

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/

[wang_chris]

Great.

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


Chris