TM1 Forum

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?

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');