TM1 Forum

Hi Experts,
What I am asking maybe is a common thing to TM1 but since I am a newbie I will help your assistance
I have a cube with two dimensions lets say
Months
Products
and another cube with three dimentions
Month
Products
Sold (which has two elements yes/no)
I want to move the data of the first cube to the second one by using a rule and another cube defining if the product for the specific month is sold or not.
For Example on the first cube I have the following
Jan Prod1 100
and on the control cube I have defined that
Jan Prod1 Yes
then I want in the third cube the following
Jan Prod1 Yes 100
Which is the best way to right the rule?

gdimit wrote:and another cube defining if the product for the specific month is sold or not.

So, that "other" cube is essentially equal to your second cube (the target cube, the one containing the rule) !

Anyway, to give a starting point:

['Yes']=N:If(DB('cube_3',!Month, !Products, 'Sold') = 0,DB('cube_1',!Month, !Products),0);
['No']= N:If(DB('cube_3',!Month, !Products, 'Sold') = 1,DB('cube_1',!Month, !Products),0);

Obviously in real life, one would model this much better, but this should give you food for thought.

Firstly thanks a lot for your feedback
To be honest is what I thought to do ( regarding the rule)

What about the feeders?
Should I place feeders and on the cube2?

I came into this solution as I have a number and the user habe to define if it is sold or not for month. Imagine that there more 3 dimentions in the cube for the sake of the example I did not mention

I am very curious if you have to propose another way of achieve this.