Multiprovider Issue : No data displayed from ODS
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 &
ODS B has detail order item based characteristics Char1 & Char2, which don't exist in cube A.
Order Number___Order Item____S Keyfigure___D Keyfigure
Order Number____Order Item_____Char1________Char2
We want the query to display the way below:
Order Number_Order Item__Char1___Char2____S KF___D KF
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 ?