Skip to Content

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

Query on a Multi-cube

Hi,

We are trying to get a query to link data from one multi-cube to another in the query. The report is printing all of the data from cube 1, then the data from cube 2, not combining the data as we expected.

What we are getting:

cube1_data

cube1_data

cube1_data

cube2_data

cube2_data

cube2_data

Example:

cube1_data

cube2_data

cube2_data

cube2_data

cube1_data

cube2_data

Is this a problem with the query or with the way the data was loaded?

Former Member
Former Member replied

Dear Gayle

After you check on in all of possible components belong your MultiProvider. I suggest the next steps:

Check on in your query, such as Ashish said, whether the characteristics are you used in query design, are in Cube1 and Cube2. (Remember that the combining of each characteristic of each dimension it is a key field). For add both value that come from of different IncoCube, you need match its key field. If you have different combination in each Cube of key field, you couldn't merge in one line.

Futhermore, of check on the comment above, take a look in both InfoCube (Cube1 and Cube2) display the data through each InfoCube with the same criteria of the query and the same fields (characteristic and key figure) that you have selected. You should see the same behavior between Cube1, Cube2 and the Query. Try to find how the three component read the data, maybe there are differences between them. For do this checking, the 0INFOPROV characteristic is quite helpful.

Activate 0INFOPROV from business content, add as Inforprovider, and join in your MultiCube.

I hope this can help you understand what are happend!

Luis

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question