I create a MultiCube(Opportunity & Activity) in BW,upload data from CRM.
The business scenario is One Opportunity can link to one or more Activity.So I want to create a Query to link the two cube infomation.
I indetification like this:
Description from Opportunity.
Number from Activity.
The other characterisitic all from both cube.
But when I execute the query on this multicube. The description from Activity.and Number form Activity but can not corresponding to Opportunity.
Hope this clear.Hope anyone can give me some advices for this.