Question on Reducing Calculation Time on Script

Zut Alors

Greetings,

I have a calc script which takes 50 mns to run and would like to reduce the time it takes to run by about half.  I've tried various things such are adding calcparallel and calctaskdim, which helps a bit.  Below is a simplified version of the script.

The issue arises when running this script for all 50 states (plus some additional entries for international regions) - basically I need to sum up all states/regions into geo_combined and then perform some additional math (not shown here).  Just the @sum() adds a lot of time to the calculation.  Any input to improve on this simple calc is greatly appreciated...  Thank you.

fix( @relative( "year total", 0), working, @relative(account, 0 ) )

fix( @relative("cost center", @list( "geo_fl", "geo_ark", "geo_alaska", etc )

     "geo_combined" = @sum( "geo_fl", "geo_ark", "geo_alaska", etc) * some_math...

endfix

endix

regards,

cl

user111989

Try to put and check if it reduces time. also check if it works for all the combination because we need target block for this to work

SET FRMLBOTTOMUP ON;

https://docs.oracle.com/cd/E57185_01/ESBTR/set_frmlbottomup.html

user111989

Try to put and check if it reduces time. also check if it works for all the combination because we need target block for this to work

SET FRMLBOTTOMUP ON;

https://docs.oracle.com/cd/E57185_01/ESBTR/set_frmlbottomup.html

Jeo123

If you go to the logs when the calc is run, it'll tell you a bunch of useful things.  In particular, are you seeing notifications about calc mode being set to cell mode or something similar in there?

More importantly though, why not just agg the  geography dimension and then reference the total instead of doing a sum of the dimension on every entity?  Is there something in your app design that prevents that?

Zut Alors

@Jeo123

that's correct, aggregating a section of the dim would have helped, except there is some additional one-off calculation that need to occur

thanks,

cl

Zut Alors

that reduced the calc time by 80% - thank you!