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

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