Copy data using XREF from different members to unique member (Fastest way)
Hello experts I have a requeriment to do.
I have to catch some data using XREF. I have one dimension that is available for both cubes (Product: Sparse Dimension) and I need sum of all members of Source dimension and save data in only one member of target cube.
In sparse dimension I have dimension product
Total_Product (dynamic calc)
I need value of Total_Product saved in Product_NA of my target cube.
Which is fastest way creating blocks if is necessary?