AddCubeDependency

Post Reply
pmakulski
Posts: 60
Joined: Mon Jun 06, 2011 6:07 pm
OLAP Product: TM1
Version: 9.5.2
Excel Version: 2010

AddCubeDependency

Post by pmakulski »

http://publib.boulder.ibm.com/infocente ... 65300.html

says
Syntax: AddCubeDependency('CubeA','CubeB');
Argument Description
CubeA The name of the base cube.
CubeB The name of the dependent cube.
Cube B relies on a rule that is dependent on Cube A.

But the user guide says:
AddCubeDependency(BaseCube, DependentCube);

BaseCube
The name of a cube that depends on another cube for data. Most commonly, this would be a cube that uses rules to pull data from an external cube.

DependentCube
The name of the cube upon which the BaseCube is dependent.

Example
AddCubeDependency('SalesCube', 'PriceCube');

This example establishes a dependency between the SalesCube and the PriceCube.

These seem to say the opposite to each other.

I would guess the sales cube has a rule referencing the price cube. (unless pricess are set by sales volumes, which would be weird).

Can anybody clarify?

Say Cube C contains a rule that references Cube D. And Cube D contains a feeder rule that feeds Cube C. What order do C and D take in AddCubeDependency?
lotsaram
MVP
Posts: 3706
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: AddCubeDependency

Post by lotsaram »

Did you try a search? This was discussed in this quite recent thread.
http://www.tm1forum.com/viewtopic.php?f=3&t=6402
harrytm1
Regular Participant
Posts: 226
Joined: Thu Apr 02, 2009 2:51 pm
OLAP Product: IBM Planning Analytics
Version: Latest version
Excel Version: 2003 to 2019

Re: AddCubeDependency

Post by harrytm1 »

yes, that post will answe all the questions you have on cube dependency function. A good post indeed! :D
Planning Analytics latest version, including Cloud
pmakulski
Posts: 60
Joined: Mon Jun 06, 2011 6:07 pm
OLAP Product: TM1
Version: 9.5.2
Excel Version: 2010

Re: AddCubeDependency

Post by pmakulski »

Yes, I did do a search, but looks like I didn't read all the way through that post. :oops:
pmakulski
Posts: 60
Joined: Mon Jun 06, 2011 6:07 pm
OLAP Product: TM1
Version: 9.5.2
Excel Version: 2010

Re: AddCubeDependency

Post by pmakulski »

OK, Now that I have read the other topic ...
I think I'll continue this topic, as the other topic is getting quite long, and I'm about to get more specific.

I have run a TI that sets cube dependencies (in the correct order per the other discussion).
But, when I look at the log, I still see many instances of those same dependencies being set. And many "cube load" messages, for cubes that are already loaded. I have attached a small sample of the message log.

Any idea why I would be seeing this behaviour? (I still need to triple check the setting of parallel interaction, which my IT guys assure me is set on correctly.)
Attachments
logsample.png
logsample.png (71.79 KiB) Viewed 3568 times
Post Reply