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?
Simple Question About Cube Calculation
-
- Posts: 15
- Joined: Wed Oct 13, 2010 6:09 am
- OLAP Product: COGNOS
- Version: 9.4
- Excel Version: 2003
-
- 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
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: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.
[]=DB('Cube2',!DIMA,!DIMB,'Total of DIMC');