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. |