Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Displaying Actual & Planned Data

Hello,

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?

Former Member
replied

create restricted keyfigures which go to actual cube and plan cube separately and then do a formula

if actual is not initial use actual else plan

hope this helps

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question