TM1 Forum

Cube A:
----------
Version (Actual)
Container Type(A,B,C)
Container Size (20,40,40H)
Period
Measure

Note: Every Container Type has all Sizes.

Cube B:
Version (Budget)
Container Type (A,B,C)
Container Size (OneSize)
Period
Measure

When I am copying data from cube A to cube B(using TI process menu driven-just mapping the dimensions/elements etc-not writing any code) few rows are missing. Since in Cube B we want data @ Container Type level, I am using another element called 'OneSize' @ cube B. And wrote a formula @TI variable:
tgtContainerSize = 'OneSize' (Type:String, Element)

Let say in CubeA under 20size if there are 5 rows, when copying to cube B; I can see only the first row out of the 5 rows which means the rest are omitted or skipped.
Is there any way that I can do to pump those missing rows from Cube A to Cube B?
please help me.
Thanks in advance.

I'm not sure how to do this using the wizard, but what you need to do in TI will be to set 'OneSize' as your global container size in cube B as you have done and then in the Data tab use;

Cell Put N( vValue + CellGetN(same variables), variables);

This will retrieve any value in the cell already and add the the data to it.

Christopher Kernahan wrote:I'm not sure how to do this using the wizard, but what you need to do in TI will be to set 'OneSize' as your global container size in cube B as you have done and then in the Data tab use;

Cell Put N( vValue + CellGetN(same variables), variables);

This will retrieve any value in the cell already and add the the data to it.

If you're going through the wizard you need to select 'Accumulate Values' as Data Action on the Cube sub-tab (part of the Maps tab) to have this code generated.

Michel

Michel Zijlema wrote:

Christopher Kernahan wrote:I'm not sure how to do this using the wizard, but what you need to do in TI will be to set 'OneSize' as your global container size in cube B as you have done and then in the Data tab use;

Cell Put N( vValue + CellGetN(same variables), variables);

This will retrieve any value in the cell already and add the the data to it.

If you're going through the wizard you need to select 'Accumulate Values' as Data Action on the Cube sub-tab (part of the Maps tab) to have this code generated.

Michel

Thanks Michel, it worked.