Best Practices for using Dynamic Calc in Accounts for FCCS

Summary:

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.