List of where Dims, Views in subset are applied
Posted: Fri Apr 23, 2010 10:16 am
Hi,
I've been searching for functions to well administrate TM1 structures and missed to find an easy way to list where
Dims are applied in cubes,
Subsets in Views,
Views in TI processes etc.
Although a list of dims used in a cube can principally be gained by using the TABDIM() function, however, this is quite cumbersome for the other way round (to find cubes where a dim is used).
To find all the views a given subset is part of is like looking for a needle in a bundle of hay, especially for a large number of views... TM1 at least prevents you from deleting such a subset, but unfortunately does not provide the names of these views...
It would also be helpful to know the TI processes a given view is referenced by. Yes, this might be impossible, as cube view names can also be determined in run time with DatasourceCubeview function, but it would at least help in most cases to read back the Data source name field entry.
Although workarounds are somehow possible, I am missing a REAL, inbuilt administrative tool in TM1 for these purposes. Don't you?
Thank you!
Helmar
I've been searching for functions to well administrate TM1 structures and missed to find an easy way to list where
Dims are applied in cubes,
Subsets in Views,
Views in TI processes etc.
Although a list of dims used in a cube can principally be gained by using the TABDIM() function, however, this is quite cumbersome for the other way round (to find cubes where a dim is used).
To find all the views a given subset is part of is like looking for a needle in a bundle of hay, especially for a large number of views... TM1 at least prevents you from deleting such a subset, but unfortunately does not provide the names of these views...
It would also be helpful to know the TI processes a given view is referenced by. Yes, this might be impossible, as cube view names can also be determined in run time with DatasourceCubeview function, but it would at least help in most cases to read back the Data source name field entry.
Although workarounds are somehow possible, I am missing a REAL, inbuilt administrative tool in TM1 for these purposes. Don't you?
Thank you!
Helmar
