Skip to Content
0
Jan 01, 2011 at 07:15 PM

Show data from different levels of hierarchy in a report

33 Views

Hi,

We have to show Budget Vs Actual for sales. We have multiprovider on two cubes (Plan & Actual).

We want to report using Customer Hierarchy.

Customer hierarchy is like -

Level 1

---> Level 2

-


> Level 3

-


> Level 4

-


> Customer1

-


> Customer2

-


> Customer3

-


> Customer4

...

Actual data is avbl at Customer but Budget is at avbl only upto Level1 or 2 .

Budget Infocube structure

Level1 Level2 Material Calmonth Sales QTy

Actual Infocube structure

Customer Calmonth Material Sales Qty

So how to create a BEx query so that I can show Budget Vs Actual for avaialble data?

If I drill down uptp Level2 it will show Budget Vs Actual and for further drill downs only actual data.

Thanks,

Vikram.

Edited by: Vikram Kate on Jan 2, 2011 12:46 AM