List of Custom Calculations Criteria

Custom calculation functionality depends on a variety of specified criteria. Table 209 provides a brief description of the criteria used to define custom calculations. Review these terms before continuing.

Table 209. Description of Custom Calculations Criteria

Criteria

Description

POV

A symmetric region in the database that describes the context in which custom calculations are performed.

Attribute members cannot be used for this argument.

Calculation script

A calculation script expressed in MDX.

Attribute members cannot be used in the left side of the equation.

Target

A tuple argument expressed in MDX that defines the region in the database where calculation results are written. This argument is combined with left side of each formula and the offset to determine where the results and offset values are written.

Attribute members cannot be used for this argument.

(Optional) Offset

The location in the database where an offsetting value for each source amount is written.

Attribute members cannot be used for this argument.

(Optional) Credit and debit members

In double-entry accounting, balancing journal entries for one transaction. Both are MDX member expressions. The debit member indicates a member to which positive result values are written, and the credit member indicates a member to which negative result values are written.

Attribute members cannot be used for this argument.

Source region

An MDX set expression specifying the region of the cube referred to by the formulas in the script.