AnsweredAssumed Answered

cascade down same number to the hierarchy (relationship)

Question asked by chherreroj on Jun 14, 2018
Latest reply on Jun 14, 2018 by chherreroj

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

Outcomes