Skip to Content
0
Former Member
Apr 04, 2006 at 09:52 AM

About the MultiCube Query Design

53 Views

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