Skip to Content
Oct 01, 2009 at 01:23 PM

How to Report Actuals vs. Plan


Hi, I have 2 InfoCubes, one for plan and one for actuals and both are in my multiprovider. Both have a version characteristic. The Planning Cubes Version is populated with a version number say 146.9. The Actuals Cube version is always populated with 000.

If I want to report on plan vs. actual for selected periods and the user selects version 146.9 for a specific plan version how do I keep the query from not filtering out the actuals version 000?