1. Database Administrator's Guide for Oracle Essbase
  2. Develop Formulas for Block Storage Cubes
  3. Essbase Formula Syntax
  4. Constant Values

Constant Values

In Essbase formulas, you can assign a constant value to a member. Use caution, as it can lead to excessive block creation.

For example:

California = 120;

In this formula, California is a member in a sparse dimension and 120 is a constant value. Essbase automatically creates all possible data blocks for California and assigns the value 120 to all data cells. Many thousands of data blocks may be created.

To assign constants in a sparse dimension to only those intersections that require a value, use a FIX statement. Refer to Constant Values Assigned to Members in a Sparse Dimension.