Hierarchy

[srikanthbwbw]

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

[Former Member · Accepted solution]

Hello Ram,

Yes, he should be able to get correct results.

San.

[Former Member]

Hi Ram,

If the Hierarchy has nodes M100 , M200 ..... M1000

under material group MC1 then they will be displayed in

the report. Check the hierachy for material group MC1.

Regards,

Prakash B