Question:
Hi BW Gurus
I have got problem as below :-
I am developing report which takes data from ODS objects -sales order header data and billing item data .
The common link between these two is sales document number .
I have created infoset using both these ODS objects .
When I developed query using this infoset I found that characteristics do not have any SAP delivered/
Custom created variables at all. Why it is so ? Actually I was planning to use some SAP deliverd variables
in query .
I have tried with multicube also. But since the characteristics I want are not present in both ODS objects
I am not getting desired data on query built on multiprovider .
Any other solution for this ?
Answer:
There is probably many ways of solving this. We have quite a few similar cases where the only link between 2 cubes is a number.
What we have done before, is to work with 2 queries. Create the main query with all the relevant selection options on the dataset that is at the lower level of granularity.. make sure the sales order number is part of the output.
Create a replacement path variable on the sales order number and use that in the second querie on the sales header data.
Pull both queries into a workbook and do your final layout using VLOOKUP to match the data.(Quick and Dirty)
This is only really an option if the report layout is static.