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

Best Practices for using Dynamic Calc in Accounts for FCCS

Received Response


Hello Experts,

We have created about 2000 dynamic calc accounts with member formulas as we needed to categorize the balances to multiple accounts based on product codes associated with each account originally loaded from ERP. These dynamic calc accounts sit under an alternate hierarchy outside the standard Balance sheet hierarchy.

We are worried about data retrieval performance as it is taking about 15 seconds for a single period and single entity. Is there any better way to enhance the performance?

We have added @NONEMPTYTUPLE(); for every member formula which helped to get it to 10 seconds for one entity and one period.

Howdy, Stranger!

Log In

To view full details, sign in.


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