17 Understanding Management Ledger Profitability Application Architecture

Accessed through Oracle Hyperion Enterprise Performance Management Workspace, Oracle Hyperion Profitability and Cost Management is an analytical tool that resides on top of Oracle Essbase.

Profitability and Cost Management enables business users to model their business for profitability and cost management, and use that model information to create Essbase databases that can be fine-tuned for profitability and cost analysis without having to understand a scripting language. For a description of Management Ledger Profitability, see Management Ledger Profitability.

Figure 17-1 Management Ledger Profitability Product Architecture

The model metadata from EPM Workspace is used in the creation of the Profitability and Cost Management model, and the calculated results can be output in a variety of reporting and analysis tools.

Profitability and Cost Management leverages Oracle Hyperion Shared Services for the centralized management of application metadata and security.

Application administrators create the Profitability and Cost Management dimensions using the Profitability Applications Console. User access is managed centrally with Shared Services. When the dimension metadata is ready, it is deployed to a Profitability and Cost Management application, or model.

The model design contains the information needed to generate the Essbase outline and calculation script required by the Essbase component of the model. Each model requires access to the following databases:

• Relational database that stores the model design

• Essbase database that includes an aggregate storage (ASO) database for both calculation and reporting.

  Note:

  Only one database is required to store multiple models.

Results may be viewed in reporting and analysis tools, such as Oracle Hyperion Financial Reporting and Oracle Smart View for Office.