Testing nonemptytuple on Planning Custom Calculation ASO (Groovy)
Summary:
Now that Essbase 21C is under the hood of Planning, did anyone notice performance gains from adding NonEmptyTuple to Custom Calculations in ASO?
I have been adjusting a custom groovy calculation script but did not notice any major impact after testing the scripts before and after changes.
Content (please ensure you mask any confidential information):
After applying the suggested change to my script as described in
Optimize Custom Calculations with NONEMPTYTUPLE (link)
Syntax
use_optimized_way;
tuple := [NONEMPTYTUPLE (nonempty_member_list)] numeric_value_expression;
Before
..strScript = "([EUR_Reporting]) := ([LC]);"..
After:
…strScript = "use_optimized_way; ([EUR_Reporting]) := NONEMPTYTUPLE([LC]) ([LC]);"
Tagged:
1