Exclude calculate () from consolidation

JanGLi

Hi,

I wanted to exclude the calculate () routines that i have created in calculation manager when i consolidate. I want to execute calculate manually. How can i achieve this?

HFM version = 11.1.2.4.204

Regards

ericerikson

Hi. You cannot run the Calculate subroutine manually - the consolidation process is coded to look for the subroutine and run it. What you can do is set up a switch. Basically, in the subroutine use a GetCell and a If/Then to see if an intersection has a 1 or not. If 1, then End Sub. If not 1, then skip the switch and proceed through the subroutine normally. Alternatively, if you’re using Calculation Manager, you can create a blank ruleset in the Calculate subroutine and then choose whether the blank or the regular ruleset is marked for deployment.

Eric

ericerikson

Hi. You cannot run the Calculate subroutine manually - the consolidation process is coded to look for the subroutine and run it. What you can do is set up a switch. Basically, in the subroutine use a GetCell and a If/Then to see if an intersection has a 1 or not. If 1, then End Sub. If not 1, then skip the switch and proceed through the subroutine normally. Alternatively, if you’re using Calculation Manager, you can create a blank ruleset in the Calculate subroutine and then choose whether the blank or the regular ruleset is marked for deployment.

Eric

JanGLi

Thanks for help... what a solution i must say

Regards