on 09-19-2012 3:47 AM
Hi experts,
I have on DP planning book, for all key figure, i have calculation type S for aggregation. I have CVC as plant-parent code-component. I have one macro to calculate the component demand, formula is: component demand= parent item deand*ratio.
if in a certain plant, i drill down the component level, i will see my planning book showing as below.
P1 p2 p3
KF1 parent item demand 100 100 100 (total)
componet1 50 50 50
componet2 50 50 50
ratio
componet1 1 1 1
componet2 2 2 2
KF2 component demand
componet1 50 50 50
componet2 100 100 100
Now the problem is , i don't want to use the detail level parent item demand, i want to use total level. I would like to have result for component like this:
P1 p2 p3
KF1 parent item demand 100 100 100 (total)
componet1 50 50 50
componet2 50 50 50
ratio
componet1 1 1 1
componet2 2 2 2
KF2 component demand
componet1 100 100 100
componet2 200 200 200
What would be the correct way to achieve this? I tried to change calcuation type to N for KF1 parent itme demand, but it is not able to save the data in aggregation level. Could someone give me some idea?
Thank you very much in advance.
Anna
Hello Anna,
Just few observations I have made out of your scenario are:
1.If you use normal drill_down function It will not be helpful for you because once you copy the total value from parent time demand and try to drill down to component details on Ratio . Then the Parent Time Demand Keyfigure will also be drilled down so you will get the same result as you are getting now.
2. Work around will be Copy the detailed value of the Parent Time Demand Key figure in a variable row using VEC_LAYOUTVARIABLE_SET. and then drill down to component details. then multiply the variable to the component demand .
I think this may help you.
Regards,
Anurag
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
11 | |
4 | |
3 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.