Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

About the MultiCube Query Design

Hello:

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:

Guid Opportunity-0CRM_OHGUID,Activity-0CRM_OPPGUI.

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.

Regards&Thanks

zagory

replied

I think when u create a muticube there is an 'identification' button,on clicking this u get a screen where u can specify the value of which characteristic in muticube should map to which infoprovider's characteristic.

As the characteristics in your case are present in both the infoproviders,u need to tick the checkboxes for both the(same) characteristics from the 2 infoproviders that map to the multicube's required characteristic.

Maybe the mapping in your case is made only to the characteristics from Activity but not made for Opportunity.

cheers,

Vishu

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question