39 Performing Custom Calculations and Allocations on Aggregate Storage Cubes
Custom calculations extend the analytical capabilities of Essbase by enabling the execution of recurring calculations on aggregate storage (ASO) cubes. Allocations are used in the budgeting process to distribute revenues or costs.
The information in this section applies only to aggregate storage cubes.
Custom calculations and custom allocations share the following functionality:
-
Aggregate storage data load buffers
-
Credit and debit processing
-
Offset handling
You can use MDX Insert to perform custom calculations and allocations. Enable this feature at the application level using the CUSTOMCALCANDALLOCTHRUINSERT configuration setting. Enable it for a calculation script using the USE_MDX_INSERT command.
Essbase also provides API functions and structures for performing custom calculations and custom allocations. The following APIs validate the syntax of MDX expressions used in performing custom calculations and allocations:
-
Java API: IEssCube.verifyMDXExpression
-
C API: EssVerifyMDXExpression
Topics in this section: