Operators

Essbase formulas can include mathematical, conditional, and cross dimensional operators. Mathematical operators perform arithmetic on data values. Conditional operators help you control the flow of formula logic. Cross dimensional operators pinpoint the data values of specific member combinations.

You can use the following types of operators in formulas:

Table 17-1 List of Operator Types

Operator Type	Description
Mathematical	Perform common arithmetic operations. For example, you can add, subtract, multiply, or divide values. See Mathematical Operations.
Conditional	Control the flow of formula executions based on the results of conditional tests. For example, you can use an IF statement to test for a specified condition. See Conditional Tests.
Cross-dimensional	Point to the data values of specific member combinations. For example, you can point to the sales value for a specific product in a specific region. See Work with Member Combinations Across Dimensions.

Operator Type

Description

Mathematical

Perform common arithmetic operations.

For example, you can add, subtract, multiply, or divide values.

See Mathematical Operations.

Conditional

Control the flow of formula executions based on the results of conditional tests.

For example, you can use an IF statement to test for a specified condition.

See Conditional Tests.

Cross-dimensional

Point to the data values of specific member combinations.

For example, you can point to the sales value for a specific product in a specific region.

See Work with Member Combinations Across Dimensions.

For information about using operators with #MISSING, zero, and other values, see Operation Results on #MISSING Values and Zero (0) Values.