Profitability and Cost Management Major Operations and Performance Considerations

The following table highlights the major processes involved in the creation and calculation of a Profitability and Cost Management model. The table also shows the areas for each main model task that may require some tuning over time, such as the number of attributes or assignments.

Table 26. Major Processes in Developing the Profitability and Cost Management Model

Operation	Components Involved	Actions	User Design Considerations	Technical Considerations
Metadata Management	Performance Management Architect	Manage dimensions Synchronize metadata and data movement between Oracle applications	Number of dimensions and members
Performance Management Architect Deploy	Performance Management Architect Profitability and Cost Management	Performance Management Architect writes new metadata out to XML Profitability and Cost Management reads XML, and updates its databases: New deployment sends all members to Profitability and Cost Management Redeployment sends full member sets of dimensions that have been edited	Number of dimensions and members Use of Attributes	JVM memory settings Database tuning
Profitability and Cost Management Staging Import	Profitability and Cost Management	Profitability and Cost Management reads data from staging table database and updates its database	Staging table size - especially explicit assignments View use may have an impact on performance	Database tuning
Essbase Database Deploy	Profitability and Cost Management Essbase	User creates Essbase database, with metadata stored in Profitability and Cost Management Profitability and Cost Management calls Essbase to deploy metadata and constructs and Essbase Database, Application and Outline Profitability and Cost Management updates Performance Management Architect applications with cloned dimensions	Member counts Dimension count. Stage settings can multiply dimensions several times	Tune Essbase, considering the following: Dense and Sparse settings Outline ordering Caches
Allocation Model Definition	RDBMS Oracle	Create and manage business model Generate automatic calc scripts	Manage the number of model elements, such as: Stages Number of Assignments Drivers	Database tuning
Calc Script Generation	Profitability and Cost Management Essbase	Store Cost and Revenue and Driver data. Profitability and Cost Management generates large text-based file and writes it to the Essbase Database	Model size, including Stages and Dimension/members Model complexity, or the density of assignment paths Use of intrastage assignments Heavy use of explicit assignments. This option causes scripts to quickly increase in size. Remove “0” data values from the allocation, if they are not necessary. Meaningless data (such as zeroes or very small values) may take up space that can either be removed or aggregated.	JVM memory settings
Calc Script Execution	Profitability and Cost Management Essbase Calculation Cube	Calculate Model and store results. Profitability and Cost Management launches a job (calc script execution) in Essbase.	Use of explicit assignments Use of rules without well-defined boundaries. For example, creating Assignment “All x” cross “All y” where only a few combinations have actual driver data present	JVM memory settings Tune Essbase settings, such as: Dense or Sparse settings Outline ordering Caches
Genealogy Calculation	Profitability and Cost Management Essbase	Profitability and Cost Management queries Essbase Reporting cube, calculates results and writes back	Model complexity: Number of stages Number of stages included in the calculation Density of assignment paths	JVM memory settings
Profitability and Cost Analysis	Essbase Reporting Database	S9 BI+ Oracle Hyperion Financial Reporting, Fusion Edition Oracle's Hyperion® Web Analysis Profitability Analysis Cost Management Analysis - Genealogy Data