Dimension Requirements

The database outline provides the data structure for the application, and includes calculation instructions and formulas.

Dimensions in the Oracle Essbase outline are hierarchical. Data is stored at dimension intersections The following are Profitability and Cost Management dimension requirements:

  • Applications must contain at least one POV dimension and can have up to four POV dimensions.

  • Applications must contain one and only one system dimension named Rule.

  • Applications must contain one and only one system dimension named Balance.

    System dimension members in the Balance dimension cannot be edited.

  • There must be at least one business dimension.

    Caution:

    Members must not be repeated within the same dimension. However, members can be repeated across several dimensions.