Simple Question About Cube Calculation

Post Reply
keigo840413
Posts: 15
Joined: Wed Oct 13, 2010 6:09 am
OLAP Product: COGNOS
Version: 9.4
Excel Version: 2003

Simple Question About Cube Calculation

Post by keigo840413 »

Hi all,
I have a simple question about Cube Calculation.
For example,
I have three dimensions:
Dima,Dimb,Dimc,all of them have two elements element1 and element 2
i create CUBE1 by Dima and Dimb, CUBE2 by Dima and Dimb and Dimc.
Now i want to move data from cube2 to cube1, because dimc is not included in the cube1, in my opinion, it should aggregate automatically in Dimc dimension of cube2 then move data to cube1.
The rule i set is:[]=DB('TESTB',!DIMA,!DIMB);
But it seems not work all the data in cube1 is zero.

Does there some one can give me a help?
tomok
MVP
Posts: 2836
Joined: Tue Feb 16, 2010 2:39 pm
OLAP Product: TM1, Palo
Version: Beginning of time thru 10.2
Excel Version: 2003-2007-2010-2013
Location: Atlanta, GA
Contact:

Re: Simple Question About Cube Calculation

Post by tomok »

keigo840413 wrote:Now i want to move data from cube2 to cube1, because dimc is not included in the cube1, in my opinion, it should aggregate automatically in Dimc dimension of cube2 then move data to cube1.
TM1 is not going to aggregate anything for you "automatically". You have to do it yourself. You need to add a rollup to Dimc that aggregates all the elements and then reference that rollup in your DB reference:

[]=DB('Cube2',!DIMA,!DIMB,'Total of DIMC');
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
Post Reply