AutomaticallyAddCubeDependencies
- 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
Hi all, just want to know under which circumstances, we need to set this parameter as false and refresh dependencies manually in TI?
-
- 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
Never.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?
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.
-
- 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
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.
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
- 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
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.
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.
- 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
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...)
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
www.infocat.co.uk
-
- 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
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.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.

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.
- 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
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.![]()
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.


