Question:
Hi All,
We have a scenario where quantity for a material and unit cost of the material must be multiplied to get the total cost. However, both of these information are from different datasource.
we tried using before aggregation but the result is not what we expected.
eg.
Material QUantity Costs/Unit Total Costs
A 10 3 30
B 20 5 100
C 15 2 30
D 50 6 300
Total costs =460
However, when we drill down by only Company Code (assuming the is only one Company Code)
Company Code Quantity Costs/unit Total Costs
XYZ 95 16 1520
Which is WRONG. it should be 460 and not 1520. We need to calculate at the material level.
any help is very much appreciated.
thanks
eddie
Answer:
I guess you have 1 multiprovider, which refers 2 infoproviders (cubes or ODS).
Let say Cube 1 and Cube 2.
Cube 1 contains Material and quantity
Cube 2 contains Material and Unitary Cost
Before agregation will calculate at each line level, which is not good, since the value for Quantity is not available in cube 2 at line level, and vice versa. So it'll calculate quantity multiplied by not assigned, and cost multiplied by not assigned, and then sum the results.
I would say that creating a new infoprovider filled in by the 2 sources is the best (only?) way to achieve what you want to do.
_________________
When my car stops, I first look at the gasoline's level before dismounting the engine.
Tuly Idiot's fan club active member.
Answer:
eddie, Fred, I guess you won't mind me deleting the exchange between those two posts, as there was no real value addition.
Ch