Copying data between different dimensions

[djarko]

I have 2 cubes with different dimensionality. Both of tchem include „Client” dimension but with another granularity.
In „Cube 1” there is dimension „Client”.

Dim_Client.PNG (17.79 KiB) Viewed 822 times

„Cube 2” has „Client_N” dimension.

Dim_Client_N.PNG (6.62 KiB) Viewed 822 times

I would like to copy data from cube 1 to cube 2.


How should be such proccess written? Please help.

[Steve Rowe]

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,