Oracle Hyperion Profitability & Cost Management 11.1.1 Modeling

This course teaches you how to create and manage applications by using Profitability and Cost Management. You create an application in Performance Management Architect and deploy it to a Profitability and Cost Management server. You create a model structure and driver formulas to allocate source intersections to destination intersections. You calculate the database and transfer data to a reporting database. You create profitability analysis reports with different types of allocation data.

Learn To:

• Create dimensions
• Create model stages
• Create drivers and driver formulas
• Create assignments
• Calculate model stages
• Create and view reports

A Live Virtual Class (LVC) is exclusively for registered students; unregistered individuals may not view an LVC at any time. Registered students must view the class from the country listed in the registration form. Unauthorized recording, copying, or transmission of LVC content may not be made.

Audience

• Business Analysts
• Administrator

Course Topics Introduction to Models

• Models and Cost Analysis
• Model Components
• Models and Allocations
• Navigating Models

Essbase Concepts

• Relational Database and Essbase
• Essbase Dimensions
• Calculations Scripts
• Aggregation and Storage Options
• Attribute Dimensions
• Block Storage and Aggregate Storage Databases

Managing Dimensions with Performance Management Architect

• Creating Dimensions
• Creating Members
• Managing Members
• Managing Dimensions with Grid Editor

Loading Dimension Metadata

• Setting Up Load Files
• Setting Up Interface Tables
• Loading Metadata
• Viewing Job Status

Creating Applications

• Required Dimensions
• Local and Shared Dimensions
• Creating Applications with the Application Wizard
• Managing Local and Shared Dimensions

Setting Up Profitability and Cost Management Dimensions

• Setting Up Common Dimension Properties
• Adding Custom Driver Measures
• Setting Up Business Dimensions
• Setting Up POV Dimensions
• Adding Member Descriptions
• Assigning Attributes and UDAs

Deploying Applications

• Validating Applications
• Comparing Applications
• Duplicating Applications
• Deploying Applications

Creating the Model Structure

• Setting Model Preferences
• Creating Stages
• Adding Points of View
• Copying Points of View

Adding Data to Models

• Loading Data
• Viewing and Editing Stage Data
• Viewing and Editing Driver Data

Setting Up Assignments

• Assignments and Measures
• Creating Assignments
• Creating Assignment Rules

Creating Drivers

• Driver Formulas
• Formula Variables
• Formula Types
• Creating Drivers
• Selecting Drivers
• Adding Exceptions to Driver Selections

Managing Calculations

• Validating the Model Structure
• Running the Driver Data Report
• Running Calculations
• Running the Stage Balancing Report
• Running Trace Allocations Reports

Lifecycle Maintenance and Security

• User Authentication
• Assigning Security Roles
• Importing Model Metadata from Staging Tables
• Migrating Applications Using Lifecycle Management

Creating Reports

• About Essbase Outlines
• Reporting Measures
• Reporting on Stage Data
• Reporting on Direct Allocation Data
• Reporting on Genealogy Data

Course Objectives

• Create dimensions for Profitability and Cost Management models
• Deploy applications from Performance Management Architect
• Create model stages and points of view
• Create drivers and driver formulas
• Create assignments
• Calculate models
• Create reports