Planning book Details level not working???

[Former Member]

Hello,

In the planning i have written a macro whick will call one user defined function and it will populate the key figure in the Planning book.Here i am getting every thing correct.But when i drilled down to the "Details all" level in the planning book it is not showing the values,at the same time if i execute the macro again it is showing the values.The problem is the macro is not getting executed when we Drilled down to details all level.

Is there any setting needs to be done to execute the macro in the details all level???

Can any please suggest some solution to this problem.

Thanks,CSR.

[Former Member · Accepted solution]

Are your macro is executable at level change?

[Former Member]

set up a macro with fucntion DRILL_DOWN()

set up another with function DRILL_UP

create a collective macro and put the following steps

drill down

calculate using your custom macro

drill up

this should work.