cascade down same number to the hierarchy (relationship)

Previous Member

How to cascade a number from an entity to another entity related (relation ship like  Europe - > Countries defined in entities).  We have a cube with a number by Area (let's say Europe) and we want to use it in calculations at Country level or/and to copy it to a cube with Country dimension (not Area where it belongs to). Without create 10 cubes and long procedures if possible. Is there a feature somewhere or a trick, to easily copy from Area to its members.

Example  Europe  2     - >     France  2    Spain 2    Italy  2 ....    etc

                America 5    - >     USA 5         Canad 5    Mexico  5

Daniel Zillmann

Hi Juan,

 

That is very easy, you will only need another cube with the country entity, then you can copy the values from your original cube to your new cube in one procedure step (Dataflow: Original Cube =  New Cube).

 

I hope that helped you to achieve your desired result.

 

Cheers,

Daniel

Previous Member

thanks a lot for your prompt answer. 

This is what we have done but we did not manage all Areas at the same time,  it worked selecting  first Europe1, then another with America1, then Asia1, then Oceania1 (we have around 10) etc...   but selecting the whole world in original cube and copying it in once to the country cube ran for very very very very lont time and we had to kill it. 

We have found a work around with intermediates cubes which is working but sound too complex for a such simple thing. we are curious if there is some short cut to go from all Areas to its individual members in less steps.  We might have the same need in another entity with much more top members and this would be a nightmare with our today's solution.

Cheer

Juan

Daniel Zillmann

That is very surprising. I assume that you have other entities in your original cube as well? What is the structure of that cube? I would expect that copying values from an aggregated entity to a related detailed entity would take not even a second. 

Previous Member

You are right we had an issue with dimensions!  We started it from the beginning and made a more stric selection and it did finally work !  That will save us quite a few cubes and time !!! 

Thanks a lot!  

Cheers

Juan