38 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. You can also use custom allocations 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:

• Custom Calculations on Aggregate Storage Cubes

• Custom Allocations on Aggregate Storage Cubes

• Data Load Buffers for Custom Calculations and Allocations

• Offset Handling for Custom Calculations and Allocations

• Credit and Debit Processing for Custom Calculations and Allocations