You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Copy data using XREF from different members to unique member (Fastest way)

Accepted answer

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)

---Product1 (nevershare)

---Product2 (nevershare)

---Product3 (nevershare)

---ProductNA (nevershare)

I need value of Total_Product saved in Product_NA of my target cube.

Which is fastest way creating blocks if is necessary?



Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!