Skip to Content
0
Former Member
Nov 30, 2006 at 05:55 PM

problem: having blank fields in query on multiprovider

40 Views

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