Understanding Standard Profitability Product Architecture

4 Understanding Standard Profitability Product 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. The application 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.

Figure 4-1 Standard Profitability and Cost Management Product Architecture

The model metadata 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 the Profitability Applications Console for the centralized management of application metadata and security.

Application administrators use the Profitability and Cost Management dimensions. User access is managed centrally with Oracle Hyperion 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, including the dimension metadata
Essbase database that includes a Calculation database (BSO) and a Reporting database (ASO).

Note:

Only one database is required to store multiple models.

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