Skip to Content

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

Hierarchy

Hello Gurus

We have two cubes:

<b>cube 1</b>[Data coming from R/3]

Material group, Material, Qty, Revenue

MC1, M100,100,1000

MC1, M200,200,2000

MC1, M300,200,2000

MC1, M400,200,2000

MC1, M500,200,2000

Cube 2: [Data coming for POS]

Material group, Material, Qty, Revenue

MC1, M600,100,1000

MC1, M700,200,2000

MC1, M800,200,2000

MC1, M900,200,2000

MC1, M1000,200,2000

Our issue is we have hierarchy created on 0MATERIAL. Material group is above material.

For transaction data loading from POS,Some of the material do not exist in R/3. In report when a user execute a query on material group will he get the correct results..i mean when user gives MC1, will he be able to get values of M500 to M1000 after i create multiprovider on these both cubes...

REgards

Ram

Helpful Answer

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