Hello BOARD community.
I wanted to contribute before I asked a question but this issue is perplexing and I really want to know if it can be achieved. I want to disseminate values of a cube to other cubes which have the exact same members but use differently named entities and live as parents in other trees.
I do appreciate that a solution which uses a csv file, re-loaded into the target cube, would achieve what I want, however, I want to know if it is achievable without using a CSV file - OLAP only.
I have attached an illustration that I hope will make this easy to understand.