hi all,
i have a multiprovider over an ODS,cube1 and cube2
in ods i have sales order, line item and kf1
in cube1 i have sales order, line item , char3,char4 and kf2
in cube2 i have sales order, line item , char3 char4
i want the final report to look like
sales order, line item , char3, char4 kf1 kf2
when i create the multiprovider and execute the query it is showing as
sales order, <b>line item from cube1</b>, char3, char4 kf1 blank
sales order, <b>line item from ods </b> , Not assigned, Not assigned blank kf2
Note:
<b>blank values in kf1 and kf2 is acceptable because the line item in cube1 is not present in ods and vice versa,</b>
the problem is , all the sales orders and line items are present in cube2 from which i need to derive the vlaues
of char3 and char4 in my query . the values for char3 and char4 are getting populated in query only for line items from cube1 but not for those in ods,
i did list cube to verify entries are exising and i checked the identification in multiprovider also
identification as follows,
sales order , line items - ods, cube1 ,cube2
char3, char4 - cube1, cube2
as sales order and line item are join conditions, they should pull data for char3 and char4 from cube 2 and diplay it
for all line items in the query, but it is not happening
I tried RSRT- multiprovider explain, system recommended identification, list cube to confirm data..
plz help where else i need to change things
>> points will be assigned for inputs
Message was edited by:
ravi a