Consolidation issue with Inspection rule 40 - DSO Application

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.