Data flow: Copy cube down to a more granular one

Jordi Vilamajo · 2024-02-27T16:39:54+00:00

There was an error rendering this rich post.

Hi, we have a cube with data at Regional level and would like to copy it to another Cube at Country level. So we are going from a higher and aggregated level to a more granular one.

The target cube has already data so we would like that the copy spreads the total by Region to its different country members. It should be easy but we could not find the way.

Could you please help us on this? Thanks in advance

Find more posts tagged with

Dataflow

Entity

Accepted answers

Lorenzo Aiani

Hi @Jordi Vilamajo ,

if I understand correctly you want to have as a result in target cube the allocation, using itself as driver. There is no predefined procedure step/action to perform this in one step. You should first prepare your driver and then perform the calculation.

You can find some hints in how perform allocation in How to Guide sections (below a couple of links).

Anyway in my opinion you should first calculate your driver, then use it to allocate. Something like:

1- Copy target cube at country level into a temporary cube (let's call it Cube A) (with the same structure) to use as denominator

2- Copy target cube into a temporary where you aggregated at Regional Level (Cube B)

3- Perform the allocation (Target Cube = Source Cube*Cube A/Cube B).

If you prefer, step 3 can be divided in 2, first calculate the driver in another temporary cube (Cube C= Cube A/Cube B), then Target = Source *Cube C).

https://community.board.com/discussion/16977/how-to-allocate-with-a-dynamic-driver

https://community.board.com/discussion/17051/how-to-do-multi-level-allocation

Regards,

Lorenzo

All comments

Remo Bollhalder

Hi @Jordi Vilamajo

Copying a cube including its content is not currently a feature in board. The "Copy Existing Cube" feature when you create a new cube copies the settings of the target cube, without its name and data.

To reach your goal you need to create a new cube and create a data flow from the existing cube to the new cube with extend calculation on country activated.

If you have any further questions please let me know.

Remo