Consolidation issue with Inspection rule 40 - DSO Application — 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

Consolidation issue with Inspection rule 40 - DSO Application

edited Apr 10, 2025 1:16PM in Financial Consolidation and Close 25 comments

We have a DSO application with two custom dimensions. The following code is one part of the consolidation logic, but it's taking a significant amount of time to run.

Content (please ensure you mask any confidential information):

In this code, we are using Movement (a dense dimension) as the anchor dimension. I attempted to switch the anchor to a sparse dimension (Data Source member), but that did not improve the performance.

The logic shown below is for just three movement members, but we have similar logic applied to all base members of the Movement dimension—over 30 in total. I would appreciate any suggestions on how we can optimize this code.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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