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

Alternative to LOOP or any other improvements

Accepted answer


Alternative to LOOP function is needed.

Content (required):


Attached rule is taking 15 minutes to run. it is taking that much of a time because of the LOOP. it goes for 13 passes.

I have also attach the log file.

Is there any alternative to LOOP that any one use to speed up time.

I have inserted the loop, because opening balance account value takes previous balance of closing balance. And closing balance is calculated by taking current opening balance + some other accounts.

We have two dense dimensions, that is account and period. other than that 10 sparse dimensions.

Version (include the version you are using, if applicable):

Howdy, Stranger!

Log In

To view full details, sign in.


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