Skip to Content
0
Former Member
Nov 26, 2011 at 02:58 PM

Use Multiprovider or Infoset ?

28 Views

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