Hey folks. I'm looking for some ideas for optimising a BSO calc script. It's currently running for about 6 hours. The good news is that it does work, does the calculations that I'm expecting. It's an allocation script where I am FIXING on all of the sparse dimensions in the cube, and then taking a sum on about 100 members from the Subaccount dimension and assigning that sum value to a Stat Account member (ST:SE7), then taking the value of all of that summarized Stat Account and assigning it and multiplying it by an allocation rate to Account member "A:~NA~" at the end.
All of this is working as expected but the calc is taking way too long.
I'd thought about possibly using the @SUMRANGE but the subaccounts aren't really in a range, it's a discrete subset of memebrs that are spread all over the outline. I'm not allowed to create either a UDA/Attribute tag to identify them or create an alternate hierarchy. I have to hard-code the list of ~100 subaccounts used inside the FIX.
Thanks in advance!!
SET MSG SUMMARY;
SET LOCKBLOCK HIGH;
SET CACHE ALL;
SET FRMLRTDYNAMIC OFF;
SET REMOTECALC OFF;
SET UPDATECALC OFF;
SET AGGMISSG OFF;
note: for some reason, the editor here removed the "+" signs between each cross-dimensional member combination inside the FIX statement. Each of those cross-dim members is added with a + between them. THANKS!!