Dear Friends
I have 2 DSOs :
DSO 1 : whole year's Price at detail sub-component level.
DSO 2 : Quantity at Quarter level and whole product (groups the sub-components) level.
For example :
DSO 1 : PRICE
Customer__Product group__sub-component_____KF_Price (for whole year)
================================================================
Ravi_____ Vacuum cleaner___ motor ___________$100
Ravi_____ Vacuum cleaner___ housing__________$80
DSO 2 : QTY ( not at sub-component level)
Customer__Product group___________________KF_Qty (at each Quarter level)
================================================================
Ravi_____ Vacuum cleaner___ _____ ___________50___55___93___98
Ravi_____ Vacuum cleaner___ ________________20____76___87___38
Currently, I have the Quantity reported on an infoset of DSO 2 to show Qty at quarter levels and at customer + product group levels . The sub-component is not necessary in this report. The Quantity is at Product group level. Price is at sub-component level.
A new report is needed to show at Quater level, the Price x Qty = sales also.
I am not sure to use a multiprovider consisting DSO 1 and DSO 2 or
to use an infoset of DSO1 and DSO2.
What should be the deciding factors?
If Multiprovider :
1. how should yearly Price (DSO 1) be selected for Quarter level Quantity (DSO2 )?
2. how should the the 3 KFs : Qty, Price, Sales amount be restricted when Qty is at Quarter level but Price is at Year level ?
If Infoset :
1. I have tried this and it resulted in Doubling of Qty for the Product group if there are 2 sub-components for the same Product group.
So, I need your advise which option to use. At the moment, it seems like Multiprovider is the way to go but I am not able to show the price at quater level.
Also, if user drills down to the sub-component level, the report may not know that the Quantity is for product group level and not sub-compenent level.
eg. Lets say there are 100 pieces of product group and this product group has 2 sub-components found in the price dso.
Each sub-component has its own price. The user wants to see the product group level sales. Using infoset, the report would show same quantity for each sub-component, thereby doubling.
So, I believe that the multiprovider method should avoid this problem but would like to hear your opinion on this .
I think if user can be convinced not to drill down to sub-component level, the qty doubling would be avoided.
Looking forward to hearing advice from you.
Best regards
M Russo