1. Administering Oracle Profitability and Cost Management Cloud Learning Path
  2. Understand Calculation Concepts
  3. Review Important Concepts
  4. Start with Dimensions

Start with Dimensions

Dimensions are categories within a database that organize application data for retrieval and preservation of values. Dimensions usually contain hierarchies of related members grouped within them. For example, a Year dimension often includes members for each time period, such as Quarter and Month.

Oracle Profitability and Cost Management Cloud includes the following dimensions:

  • Business dimensions that reflect the business-specific elements of the application, such as departments, accounts, activities, customers, or products

  • Point of View (POV) dimensions that identify a specific point of view or version of the application, such as year, scenario, period, and version

  • Attribute dimensions that enable analysis based on the attributes or qualities of dimension members, such as the size or color of products

  • Alias dimensions (optional), used to assign alternate names, descriptions, languages, or other items

  • System dimensions that are reserved for use by Oracle Profitability and Cost Management Cloud for system requirements

Oracle Profitability and Cost Management Cloud has two system dimensions, illustrated here as database outlines:

  • Rule dimension, that stores allocation instructions as Rule members for up to 1000 rules:


    List of Rule dimension members: NoRule, and then R0001, R0002, through R1000.

  • Balance dimension, that stores calculation inputs and outputs as Balance members:


    List of Balance members, such as Input, Net Change, Remainder, and Outflow.

When each rule runs, you can trace all the inputs and outputs and see how they balance.