You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Copy data from form Actual to Forecast - Performance issue

21
Views
4
Comments
edited Sep 19, 2023 10:51AM in Financial Consolidation and Close 4 comments

Hello All,

in our FCC application we created a specific calculation rule to copy data (in our example Account NSALI and HEADI) from Actual to Forecast scenario. We tried to launch the rule for a specific period and for a single entity. The rule runs successfully with no errors but it runs very slowly. Some of the source elements are set as Dynamic calc as data storage (for example "DESTINATION" or "TOTCOMPANY")

Here below the script:

FIX ("FCCS_Periodic","No Custom1","No Custom2","No Custom3","FCCS_No Intercompany","FCCS_Local GAAP","FCCS_Data Input")

FIX("Mvmts_EBITDA")

"NSALI"(

       "NSAL0000"->"DESTINATION"->"TOTCOMPANY"->"FCCS_TotalInputAndAdjusted"->"FCCS_Intercompany Top"->"Mvmts_EBITDA"->"Actual";)

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!