Skip to Content

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Apr 19, 2006 at 05:11 AM

    Hello Ram,

    Yes, he should be able to get correct results.

    San.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 19, 2006 at 05:12 AM

    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

    Add comment
    10|10000 characters needed characters exceeded