TM1 Object dependency walker- get list of all dependent objects

Post Reply
7Zark7
Posts: 81
Joined: Tue May 31, 2011 6:29 am
OLAP Product: TM1 and EV
Version: 9.1 SP3
Excel Version: Excel 2010

TM1 Object dependency walker- get list of all dependent objects

Post by 7Zark7 »

Hi Guys,

Is there a free tool available to get a list of dependencies ( i.e. TM1 objects ) that are dependent on what are you targeting?

For example target cube A , has dependent dimensions A, B, C and D, and also has a Rule file
This rule file also points to other cubes etc. I would like to grab these objects as well + other associated processes.

What I want to be able to do is pass in the name of cube for example then call this script and punch out a file with
a list of dependent objects and then call 7zip to target this file and zip up the objects.

Any ideas?

Cheers

Zark
BariAbdul
Regular Participant
Posts: 424
Joined: Sat Mar 10, 2012 1:03 pm
OLAP Product: IBM TM1, Planning Analytics, P
Version: PAW 2.0.8
Excel Version: 2019

Re: TM1 Object dependency walker- get list of all dependent objects

Post by BariAbdul »

I don't know how much it going to help you ,but worth having a look at this thread:
http://www.tm1forum.com/viewtopic.php?f ... ram#p58483 Thanks
"You Never Fail Until You Stop Trying......"
Drg
Regular Participant
Posts: 159
Joined: Fri Aug 12, 2016 10:02 am
OLAP Product: tm1
Version: 10.2.0 - 10.3.0
Excel Version: 2010

Re: TM1 Object dependency walker- get list of all dependent objects

Post by Drg »

I do not think that there are any real means to track the following dependencies(With the exception of staff resources that are not represented in any SDK):
Cube A

Code: Select all

DB( 
DB('Get cube for rule feeders',!a,!b,!c) 
, !a 
,!b 
,!c 
, !d
, if(!a@='true'
                    ,'total'
                    ,'subtotal')
, SUBST(
             ATTRS( 'MEASURE' 
                         , !e 
                         , 
                         DB('Get attribute name'
                              ,!a
                              ,!b
                              ,!c) 
                        )
              , 4
              , LONG(
                          ATTRS( 'MEASURE' 
                                      , !e 
                                      , DB('Get attribute name'
                                             ,!a
                                             ,!b
                                             ,!c) 
                                      )
                           )  -4 
              )
);
It is clear that very few people in the life so silently return, but met similar designs or design with a large nesting if(if(...).....if(...)).
7Zark7
Posts: 81
Joined: Tue May 31, 2011 6:29 am
OLAP Product: TM1 and EV
Version: 9.1 SP3
Excel Version: Excel 2010

Re: TM1 Object dependency walker- get list of all dependent objects

Post by 7Zark7 »

Thanks BariAbdul

Looks interesting. This might give me enough to work with. I suppose I better understand how perl works.

Cheers

Zark
User avatar
tiagoblauth79
Posts: 25
Joined: Fri Aug 26, 2016 1:42 pm
OLAP Product: Cognos BI and TM1
Version: 10.2.2
Excel Version: 10
Contact:

Re: TM1 Object dependency walker- get list of all dependent objects

Post by tiagoblauth79 »

tm1server.log registers cube dependencies at server startup. It might help you.
Post Reply