Detailed Profitability and Cost Management Applications

A Detailed Oracle Hyperion Profitability and Cost Management model employs a user-defined schema to organize relational tables with existing data and associated lookup tables to extend that data.

Data for the Detailed Profitability and Cost Management model is housed in relational databases only.

You create the model in the Profitability Applications Console, and define the business dimensions, aliases, measures, and so on within the organization. Within Profitability and Cost Management, the data is mapped to the application to enable you to build the Detailed Profitability model. The application can handle extremely large volumes.

The application does not use a hierarchical structure, but processes all allocations in a flow between a single Source and Destination combination. Allocation is handled through a restricted MeasuresDetailed dimension, rather than by creating an AllocationType.

The MeasuresDetailed dimension contains a limited set of members to process all allocations.

After the application is deployed to Detailed Profitability and Cost Management, you build the model, creating the drivers and assignments that generate the flow of funds. The models are constructed using a single Source and Destination table combination for selected Measures, with up to five Source dimensions, and up to 25 Destination dimensions. The allocations are completed based on calculations and formulas that you specify in the drivers and assignments.

Points of View (POVs) represent a specific instance of the model, and can be used to view or calculate different versions of a model; for example, to view values for different months or quarters, to compare budget versus actual figures, or to play scenarios to measure the impact of various changes on the bottom line.

The model is validated after creation to ensure that all allocations are accounted for, and that calculations are balanced for each stage.

The model can be calculated, and the results analyzed.

For more information about creating and working with Detailed Profitability applications, see Steps to Create Detailed Profitability Models.