Displaying Actual & Planned Data
I need to create a query which is built on a MultiProvider. This m/p looks at 2 Infocubes for it's data - one i/c containing actual data the other containing planned data.
The query I need to create should have account numbers in the rows, but the more complicated requirement relates to the columns.
In the columns I need to display the periods of the year. Within each period, I need to display the credit & debit posting values.
The above can be created easily enough, but the issue I have is how to display the actual data for the periods that have actual data and then just display the planned data for the remaining periods.
The problem relates to the Planned data InfoCube as this contains "old" planned data for periods where we now have Actual values.
Can anyone suggest anyway of doing this?