Question:
Here's a puzzler others must have faced: We have a data view with two default macros. Each macro calculates a different key figure. Say Macro1 calculates KF1 and Macro2 calculates KF2. In addition, Macro2 uses KF1 to calculate KF2; in other words, Macro2 uses the result of Macro1.
When a planner makes a change, both Macro1 and Macro2 execute (because they are default macros). The calculation of course takes place at the level of the data (Selection) currently loaded. Thus, KF1 and KF2 are recalculated at that level. In addition, the results "radiate" up and down, that is, the results disaggregate and aggregate according to normal system logic. (The KF disaggregation is set to "pro rata.")
Our problem occurs in that the disaggregated values may now be out of line between KF1 and KF2 because the macros have not executed at the detailed level. Our dilemma is how to overcome this.
Using DRILL_DOWN and DRILL_UP macro functions does not appear to offer a solution because several "lower-level" characteristics would need to be considered when drilling down to perform the calculation at the detailed level.
Any suggestions would be appreciated.
Thanks.
SoxFan
Answer:
Hi,
If you want the macro disaggregation to be effected to all the levels
try using the setting
in the Advanced Macros screen, whiel creating the Macro , in the first screen
choose 'All Planning Objects' from the below selection.
1)Details only
2)All Plannign Objects
3)Certain Levels.
Hope this helps you.
reply back if it doesnot
thanks,
SAPAPOer
Answer:
Dear SAPAPOer – Thank you for your response. Sorry about my delayed reply. Your suggestion did not work as expected. Reason in a nutshell: Even with the “All Planning Objects” radio button selected, the macro still only executes at the currently displayed levels in the data view. You see, the problem is not getting disaggregation to work (because that happens automatically in the system); the problem is that the macros do not execute at those disaggregated levels. We have developed a work-around instead.
Thanks again.
SoxFan
Answer:
could you please tell us, how you managed to use a workaround, we have a similar situation.
Thanks,
SAPAPOer
Answer:
Dear SAPAPOer – Our work-around does not exactly address the problem I have described. Our work-around addresses a related problem. The problem may be described as follows: Most of the key figures in our planning area are set with Calculation type “I”, meaning that disaggregation takes place pro-rata unless the value is initial, in which case the disaggregation is based on another key figure. We are using the system constant proportional factors (key figure APODPDANT) for that other key figure. In some cases, we would prefer to have existing values disaggregated using APODPDANT, rather than have them disaggregated pro-rata. To facilitate this, we have employed a simple three-step process utilizing two simple macros:
Step 1: For the value(s) you want to disaggregate, use a macro to copy the value(s) to some temporary key figure and zero out the original key figure.
Step 2: Save.
Step 3: Use another macro to copy the value(s) from the temporary key figure back to the original key figure.
Because you have saved a zero value in the original key figure, when you now copy the value back to that original key figure, the system will use APODPDANT to do the disaggregation.
SoxFan