List of where Dims, Views in subset are applied

Suggest and discuss enhancements for TM1
Post Reply
Helmar
Posts: 13
Joined: Thu Jun 25, 2009 8:12 am
Version: 9.1 SP4
Excel Version: 2003

List of where Dims, Views in subset are applied

Post by Helmar »

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
ScottW
Regular Participant
Posts: 152
Joined: Fri May 23, 2008 12:08 am
OLAP Product: TM1 CX
Version: 9.5 9.4.1 9.1.4 9.0 8.4
Excel Version: 2003 2007
Location: Melbourne, Australia
Contact:

Re: List of where Dims, Views in subset are applied

Post by ScottW »

Yes absolutely. That's why we built such a tool.

TM1 Documenter
Cheers,
Scott W
Cubewise
www.cubewise.com
Helmar
Posts: 13
Joined: Thu Jun 25, 2009 8:12 am
Version: 9.1 SP4
Excel Version: 2003

Re: List of where Dims, Views in subset are applied

Post by Helmar »

... seems to be exactly what I've been looking for :D
How can the documenter be obtained/purchased?

Kind regards!
Helmar
Post Reply