I have a small problem with the report created on two Z Cubes one on Plan data and another on Actual data. I updated them from a flat file. The details are as follows:
Version : BI 7.0
The structure of each of the cubes is:
Materail - Material group - Vendor - Order quantity - Unit - Currency
Materail - Material group - Vendor -Plan Order quantity - Unit - Currency
I've built a multi provider to compare Plan Vs Actual data.
In identification for characteristics, selected the Material 0calday from both the cubes and the relevant keyfigure from each cube.
The query definition has, Material in rows and Actual and Plan data in 2 columns. The query is displaying only the Actual data, leaving the Plan data field blank.
Could you please help me resolve this?
Thanks and best wishes,