on 07-03-2007 3:59 PM
Hello All,
We have a macro which calculates the simple logic (c = a - (b*0.005)). This logic is being correctly calculated at aggregated level (all locations). But if I disaggregate at each location level, the calculations are mismatching. My guess is something wrong in running the MACRO in the background. Can someone please let me know thier thoughts on this issue?
Appreciate your help.
Thanks.
If you make sure that in the planning area admin, disaggregation type for KF <b>c</b> is not based on another KF
a way to do this is to allow the macro to run only at the disaggregated level (by a drill downcalculation drill up macro in a collective macro) you might get the desired result when it aggregates back up
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
no its not intensive. Just dont set it on default or level change. Put it on start or exit and it should work when you change values and save
you can see collective macros as an option when you create a new macro
you basically create 3 macros and use the collective macro to <i>wrap</i> them. Helps particularly when you want to do a drill up and drill down at a detailed level while you are at an aggregated level
pl see and Somnaths reply in it for some more insight and for looking at the sample macro
I suggest you also read 433166
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Sarath,
Attach your macro to the Level Change type and check it out.
Regards,
Siva.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Sarath,
Is your macro attached in Level Change type?
Regards,
Siva.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
15 | |
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.