1. User's Guide
  2. Working with Detailed Profitability
  3. About Detailed Profitability and Cost Management Models and Scenarios

15 About Detailed Profitability and Cost Management Models and Scenarios

A model is a representation of part or all of an organization. Oracle Hyperion Profitability and Cost Management models enable you to accurately trace the processes and activities that contribute to costs and revenue within the organization.

A model is comprised of the following elements:

  • Stages, which organize the Source and Destination allocations for revenue or expenses in the organization

  • Dimensions, which are data categories that are used to organize business data for retrieval and preservation of values. Within Detailed Profitability and Cost Management, the following types of dimensions are used:

    • System dimensions, such as the MeasuresDetailed allocation dimension.

    • Measures dimensions contain the members required to build, validate, and calculate a model, such as measures for revenue, and driver definitions.

    • Business dimensions, which describe the objects within each stage in the model, such as products, customers, regions, and so on. The dimensions and members are the foundation of the model.

    • POV dimensions identify a specific point of view or version of the model, such as year, scenario, period, and version. Version dimensions enable you to maintain multiple versions of a model. These versions can be used to create alternate, or what-if, scenarios of the model, or different perspectives.

    • Alias dimension is used to assign alternate names, descriptions, languages, or other items that help to define dimensions.

    • Attribute dimensions enable analysis based on the attributes or qualities of dimension members. Attributes describe characteristics of data, such as the size or color of products.

  • Drivers that determine how revenue or expense source values are calculated and allocated. Selected drivers are applied to the entire dimension, a portion of the hierarchy, a single member, or even a single intersection.

  • Assignment rules that define source or destination member selections

  • Assignments that map source data to the destination

  • Multi-source Calculation Rules that define allocations from multiple sources to multiple destinations.

  • Single-source Calculation Rules to execute individual assignments that act as exceptions to the Multi-source rules.

  • Calculation Rules are a super set of calculation artifacts, encapsulating sources, destinations, and drivers, that allow to use sources, destinations and drivers to create broad allocations, reserving individual assignments to create exceptions to these calculation rules.

  • Financial data, which is imported from user-defined relational databases.

The MeasuresDetailed, Business, Measure, and POV dimensions are created in the Profitability Applications Console, and deployed to the Profitability and Cost Management relational database. Stages, drivers, driver selections, assignments, and calculation rules are created in Profitability and Cost Management.