Skip to Content

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

Multiprovider Issue : No data displayed from ODS

Hi all,

Checked threads and help about multiproviders but could'nt find a solution yet about the situation mentioned below:

There're 2 infoproviders <b>infocube X</b> and <b>ODS Y</b> we want to report as combined.

Both of them have order number 0DOC_NUM and order item 00RD_ITEM in common.

Cube A keeps order item based key figures: S Keyfigure &

D Keyfigure.

ODS B has detail order item based characteristics Char1 & Char2, which don't exist in cube A.

For example:

<b>Cube A</b>

Order Number___Order Item____S Keyfigure___D Keyfigure

100_______________10____________25___________23______

100_______________20____________45___________40______

100_______________30____________30___________30______

<b>ODS B</b>

Order Number____Order Item_____Char1________Char2

100_______________10____________SSS_________Blue______

100_______________20____________TTT_________Blue______

100_______________30____________SSS_________Black____

We want the query to display the way below:

Order Number_Order Item__Char1___Char2____S KF___D KF

100____________10________SSS____Blue_____25______23

100____________20________TTT____Blue_____45______40

100____________30________SSS____Black____30______30

But when we combine these two in a multiprovider, query result doesn't list the data from ODS.

When I check the multiprovider in LISTSCHEMA transaction, I displays data as we want, as above. But not the query.

Any ideas/suggestions ?

Thanks..

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