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