AutomaticallyAddCubeDependencies

Post Reply
User avatar
macsir
MVP
Posts: 785
Joined: Wed May 30, 2012 6:50 am
OLAP Product: TM1
Version: PAL 2.0.9
Excel Version: Office 365
Contact:

AutomaticallyAddCubeDependencies

Post by macsir »

Hi all, just want to know under which circumstances, we need to set this parameter as false and refresh dependencies manually in TI?
In TM1,the answer is always yes though sometimes with a but....
http://tm1sir.blogspot.com.au/
lotsaram
MVP
Posts: 3704
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: AutomaticallyAddCubeDependencies

Post by lotsaram »

macsir wrote:Hi all, just want to know under which circumstances, we need to set this parameter as false and refresh dependencies manually in TI?
Never.
What would be the point of dependencies not being read from rules and feeders on startup?
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
declanr
MVP
Posts: 1831
Joined: Mon Dec 05, 2011 11:51 am
OLAP Product: Cognos TM1
Version: PA2.0 and most of the old ones
Excel Version: All of em
Location: Manchester, United Kingdom
Contact:

Re: AutomaticallyAddCubeDependencies

Post by declanr »

I once worked with a model where a start up chore essentially destroyed all rules and then rewrote them. As part of a standard operating day various TIs would do similar things and rewrite rules (changing sources and targets)... it was a strange and very specific use case.

That could have benefited from this as it would start up quicker but if I recall it started in about a minute anyway...

But as Lotsa says 99.999999% of cases wouldn't have any reason to ever consider it.
Declan Rodger
User avatar
macsir
MVP
Posts: 785
Joined: Wed May 30, 2012 6:50 am
OLAP Product: TM1
Version: PAL 2.0.9
Excel Version: Office 365
Contact:

Re: AutomaticallyAddCubeDependencies

Post by macsir »

Thanks, guys.

I am just checking a model which is using process and dependency cube to refresh dependencies although this parameter is set true. Since I never touched this parameter, so just curious about it.
In TM1,the answer is always yes though sometimes with a but....
http://tm1sir.blogspot.com.au/
User avatar
Steve Rowe
Site Admin
Posts: 2464
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: TM1 v6,v7,v8,v9,v10,v11+PAW
Excel Version: Nearly all of them

Re: AutomaticallyAddCubeDependencies

Post by Steve Rowe »

In a release that I worked on a while back the server was not picking the attribute links in the rules. These are still regarded as cube links under the hood and the server was then setting these up on the fly on first use leading to locking problems with TI processes.

We were therefore setting the cube links up as part of single threaded launch job in our multi threaded sequence.

May have been fixed in current releases, have not gone back to check.

(I think I may have mis-read the question...)
Technical Director
www.infocat.co.uk
User avatar
macsir
MVP
Posts: 785
Joined: Wed May 30, 2012 6:50 am
OLAP Product: TM1
Version: PAL 2.0.9
Excel Version: Office 365
Contact:

Re: AutomaticallyAddCubeDependencies

Post by macsir »

:lol:
In TM1,the answer is always yes though sometimes with a but....
http://tm1sir.blogspot.com.au/
lotsaram
MVP
Posts: 3704
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: AutomaticallyAddCubeDependencies

Post by lotsaram »

macsir wrote:Thanks, guys.

I am just checking a model which is using process and dependency cube to refresh dependencies although this parameter is set true. Since I never touched this parameter, so just curious about it.
Personally I have set up quite a few models doing this (and I still keep it in my models even though it shouldn't be needed anymore). So if the model is an old one it might even be one of mine. :roll:

When PI was first introduced in 9.5 the server didn't pre-set dependencies and to avoid locking and get PI to work you had to do it yourself.
Then on server startup in 10.1 dependencies were read from inter-cube feeders
Then in 10.2 dependencies were parsed from rules as well as feeders (but there was a bug and the order of dependency was reversed for attribute cubes)
Then in 10.2.2 they more or less got it all worked out but dependencies still can't be read if say the cube name domes from a "dynamic reference" (say a DB or AttrS), this will only be picked up on a CellGet or ViewConstruct

You can automatically populate a cube dependency mapping cube by reading the tm1server.log file and parsing out the Cube.Dependency loggers. So although you don't need this technique anymore in 99% of cases I do still keep it around in the (rare) case of a dynamic reference.
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
User avatar
macsir
MVP
Posts: 785
Joined: Wed May 30, 2012 6:50 am
OLAP Product: TM1
Version: PAL 2.0.9
Excel Version: Office 365
Contact:

Re: AutomaticallyAddCubeDependencies

Post by macsir »

lotsaram wrote:Personally I have set up quite a few models doing this (and I still keep it in my models even though it shouldn't be needed anymore). So if the model is an old one it might even be one of mine. :roll:

When PI was first introduced in 9.5 the server didn't pre-set dependencies and to avoid locking and get PI to work you had to do it yourself.
Then on server startup in 10.1 dependencies were read from inter-cube feeders
Then in 10.2 dependencies were parsed from rules as well as feeders (but there was a bug and the order of dependency was reversed for attribute cubes)
Then in 10.2.2 they more or less got it all worked out but dependencies still can't be read if say the cube name domes from a "dynamic reference" (say a DB or AttrS), this will only be picked up on a CellGet or ViewConstruct

You can automatically populate a cube dependency mapping cube by reading the tm1server.log file and parsing out the Cube.Dependency loggers. So although you don't need this technique anymore in 99% of cases I do still keep it around in the (rare) case of a dynamic reference.

Thanks for the sharing, dude. Possibly, the one I am looking at was from your hands. :D :D :D
In TM1,the answer is always yes though sometimes with a but....
http://tm1sir.blogspot.com.au/
Post Reply