Data from two cubes to display in same grid - Actual/planned comparison

[Former Member]

Hi All,

I want to show planned and actual data in the same grid. For example,

qty-2011001 qty-2011002 qty-2011012

actual plan actual plan actual plan

Here quantity is shown for fiscal year periods. For each fiscal year period actual and planned quantity should be shown in adjacent columns in bex analyzer. But in my model actual and planned data are in two different cubes. So how can I show in the same grid.

I thought of creating a multiprovider or infoset and by combining them we can pull data from both of them to show in the same grid. But it resulted in errors.

I was wondering if there are any interesting workaround for this.

Thanks and Regards,

Jerry

[gregor_dieckmann · Accepted solution]

Hi,

this is a standard requirement and very easy to model. To key figures (actual and plan) are not need.

1. Create a cube for actuals A and one for plan data P. Both contain the same key figure.

2. Create a multiprovider with both cubes and use the default mapping for key figures and characteristics

3. Create an aggregation level on top of the multiprovider with the characteristics and key figures you need

4. Create a query with two restricted key figures, e.g.

Quan actual: restrict by 0INFOPROV = A

Quan plan: restrict by 0INFOPROV = P, make this element input-ready.

Drill-down 0FISCPER on columns.

Thats all.

Regards,

Gregor

[Former Member · Accepted solution]

Hi Gregor,

I created two keyfigures and put that in rows. But i tried to restrict the keyfigures with infoprovider and fiscal year period which created problem. Thankyou Gregor for the info. Now the issue has been resolved after fiscal year period was drilled down in columns.

Thanks Gregor and girish,

Regards,

Jerry

[Former Member]

You can create a multiprovider with two keyfigues, actual and plan and assign them accordingly.

In the report, keep the characterstic fiscal year/period in the columns and below that add two keyfigues actual and plan,