I have 2 DSOs:
DSO # 1:
Key Field - Deliv no and Deliv item
Data field - Material, Batch, Serial no, Customer, Delivery quantity, Delivery type and delivery date
DSO # 2:
Key Field - Notification no and Notification item
Data field - Material, Batch, Serial no, Customer, Complaint quantity, Notification date.
Based on these 2 DSOs, we have a cube containing all characteristics and key figures mentioned above.
Query requirement on cube:
Variable selection: Material, Customer, Notification date, Delivery date.
As long as Material and Customer are selected in variable screen. query should work fine.
But what if user selects notification date range or delivery date range. Data will show separate lines for Notification and Delivery data.
How do I create query for this type of data.