TM1 Forum

I have 2 cubes with different dimensionality. Both of tchem include „Client” dimension but with another granularity.
In „Cube 1” there is dimension „Client”. „Cube 2” has „Client_N” dimension. I would like to copy data from cube 1 to cube 2.


How should be such proccess written? Please help.

Most cube to cube data transfers follow this sequence

Prolog tab
Define the Destination View and ViewZeroOut

Define the Source View and declare it to the datasource.

Data tab
Update dims if required (use the direct functions)
Write data

Epilog
Clean up objects
DimensionUpdateDirect if you used the direct functions.

So when you define the source you will set the set for the client dimension to be just the Group members as these are the N levels in the destination view.

This means that your view will only contain consolidations.

Depending on exactly how you have defined the view you will need to make sure that consolidations are not being suppressed (this is the default behaviour, usually)

HTH gives you an idea of the direction you need to head.

Cheers,