Alternative to LOOP or any other improvements
Alternative to LOOP function is needed.
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):