Member formula performance after DSO Migration — Cloud Customer Connect
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

Member formula performance after DSO Migration

in Financial Consolidation and Close 1 comment

Hi everyone!

I am looking for some advice. We have several member formulas on the Account dimension that we used prior to the DSO migration that used to run less than a minute and after DSO migration they are now running closer to 6 minutes. We find the time difference unacceptable for users. I have included the formulas and their solve orders below, however, is there anything more we can do to these formulas to reduce their calculation time or is it better to consider insertion rules? Any help would be great! Thanks!

This is the process for calculating Days Sales Outstanding (DSO):

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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