Data missing in report on Multi provider

[Former Member]

Hello Gurus,

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:

Actuals cube

Materail - Material group - Vendor - Order quantity - Unit - Currency

Plan cube

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,

raj

[Former Member · Accepted solution]

Use RSRT to execute the query with the Execute + Debug option. Choose the Explain MultiProvider option. The upper area of the screen, in which the query result is displayed, contains messages with information about how the query has been divided. Based on the messages you can do necessary corrections. Check below link for different messages.

http://help.sap.com/saphelp_nw70/helpdata/en/0f/17b63d799f6b3be10000000a114084/frameset.htm

Hope it helps.

[Former Member]

first

check your plan cube in listcube

is there right records??

[Former Member]

include the INFOPROVIDER in query and check

[Former Member]

Data in the cubes if fine.

The data in multi provider is shown as follows:

Materail - Material group - Vendor - Order quantity Plan Order quantity -

M1 MG1 V1 23 0

M2 MG2 V2 45 0

M3 MG3 V3 67 0

M4 MG4 V4 89 0

M1 MG1 V1 0 59

M2 MG2 V2 0 68

M3 MG3 V3 0 77

M4 MG4 V4 0 86

Is the multi provider definition and the data display OK ?

please confirm.

Thanks,

raj

[Former Member]

Is the data over cube n MP are same n equal?

If not,then MP is not getting union values and the other option would be of creating Infoset.

Please verify the same,

Thanks,

shana

[Former Member]

this is correct displey of your query

M1 MG1 V1 23 59 (only first row)

maybe you badly use IDENTIFICATION characteristic when you create multi