3 arrows

Get 50% Off ForgeRock Training Bundles


Oracle Hyperion Profitability Cost Management 11.1.2 Modeling (

  • Tuition USD $4,000
  • Reviews star_rate star_rate star_rate star_rate star_half 3223 Ratings
  • Course Code D89886GC20
  • Duration 4 days
  • Available Formats Classroom

This course is designed to teach you how to create and manage Standard Profitability and Management Ledger models by using Profitability and Cost Management. You create applications for Standard Profitability and Management Ledger models in Performance Management Architect and deploy them to a Profitability and Cost Management server. You define stages for a Standard Profitability model, create drivers, and assign destination intersections to source intersections. You generate calculation scripts and calculate the model. You use stage balancing and trace allocation reports to validate the model. You create rules and rule sets for a Management Ledger model. You configure the execution order of the rules and run calculations. You use rule balancing and trace allocation reports to validate the model.

Learn To:
  • Create and view reports
  • Generate calculation scripts and calculate model stages
  • Create model stages and points of view
  • Create and deploy Profitability and Cost Management applications
  • Load data into Profitability and Cost Management applications
  • Create drivers, driver selections, and assignments
  • Create Management Ledger applications
  • Create Management Ledger rule sets and rules

Skills Gained

  • Create model stages and points of view
  • Load data into Profitability and Cost Management applications
  • Create and deploy Standard Profitability applications
  • Create drivers
  • driver selections
  • and assignments
  • Generate calculation scripts and calculate model stages
  • Create and view reports
  • Create and deploy Management Ledger applications
  • Create Management Ledger rule sets and rules


  • Oracle Essbase 11.1.2 Bootcamp

Course Details

Introduction to Profitability and Cost Management

  • Oracle’s Enterprise Performance Management System
  • About Profitability and Cost Management
  • Product Architecture
  • Product Components
  • Profitability and Cost Management Implementation Process

Navigating Standard Profitability Models

  • About Standard Profitability Models
  • Model Levels
  • Model Components
  • Accessing Models

Essbase Concepts

  • Profitability and Cost Management Repository and Essbase
  • Multidimensional Analysis
  • Administration Services Console
  • Essbase Outlines
  • Calculation Scripts
  • Member Properties
  • Block Storage and Aggregate Storage Databases

Managing Dimensions with Performance Management Architect

  • Performance Management Architect Overview
  • Dimension Library
  • Dimensions for Standard Profitability Applications
  • Creating Dimensions
  • Creating Members
  • Managing Members
  • Organizing Shared Library
  • Managing Dimensions with Grid Editor

Loading Dimension Metadata

  • About Loading Dimension Metadata
  • Setting Up Text Files
  • Setting Up Interface Tables
  • Loading Metadata
  • Viewing Job Status

Creating Standard Profitability Applications

  • About Performance Management Architect Applications
  • Creating Standard Profitability Applications with Application Wizard
  • Managing Local and Shared Dimensions
  • Adding Dimensions to Applications
  • Changing Local Dimensions to Shared Dimensions
  • Overriding Inherited Property Settings
  • Excluding and Showing Members
  • Synchronizing Local with Shared Dimensions

Setting Up Standard Profitability Application Dimensions

  • Setting Up Common Dimension Properties
  • Adding Custom Driver Measures
  • Setting Up Business Dimensions
  • Setting Up POV Dimensions
  • Adding Member Descriptions
  • Assigning Attributes
  • Adding User-Defined Attributes
  • Adding Member Formulas

Deploying Standard Profitability Applications

  • About Deploying Applications
  • Validating Applications
  • Comparing Applications
  • Duplicating Applications
  • Deploying Applications to Application Servers
  • Viewing Job Status

Creating the Model Structure for Standard Profitability Applications

  • About Models
  • Setting Model Preferences
  • About Stages
  • Stages and Dimensions
  • About Points of View
  • Adding Points of View
  • Copying Points of View
  • Deploying Essbase Databases

Adding Data to Models

  • About Adding Data to Models
  • Loading Data
  • Viewing and Editing Stage Data
  • Viewing and Editing Driver Data

Setting Up Assignments

  • About Assignments
  • Creating Assignments
  • Creating Assignment Rules
  • Design Considerations

Introduction to Drivers

  • About Drivers
  • Driver Formulas
  • Driver Formula Example
  • Formula Types
  • Driver Basis Types
  • Priority Sequence Drivers

Creating Drivers for Allocations

  • Creating Drivers
  • Selecting Drivers
  • Adding Exceptions to Driver Selections

Managing Calculations

  • About Managing Calculations
  • Validating the Model Structure
  • Running Driver Data Reports
  • Running Calculations
  • Running the Stage Balancing Report
  • Running Trace Allocation Reports

Analyzing Data

  • Creating Smart View Queries
  • Navigating Smart View
  • Connecting to Data Sources
  • Creating Ad Hoc Grids
  • Setting the Point of View
  • Associating Data Sources with Worksheets

Working with Management Ledger Applications

  • Creating and Deploying Management Ledger Applications
  • Creating Rule Sets
  • Create Allocation Rules
  • Creating Custom Calculation Rules
  • Viewing Rule Balancing and Trace Allocations reports
  • Creating Smart View Queries
  • Validating the Model

Security and Lifecycle Management

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

When does class start/end?

Classes begin promptly at 9:00 am, and typically end at 5:00 pm.

Does the course schedule include a Lunchbreak?

Lunch is normally an hour long and begins at noon. Coffee, tea, hot chocolate and juice are available all day in the kitchen. Fruit, muffins and bagels are served each morning. There are numerous restaurants near each of our centers, and some popular ones are indicated on the Area Map in the Student Welcome Handbooks - these can be picked up in the lobby or requested from one of our ExitCertified staff.

How can someone reach me during class?

If someone should need to contact you while you are in class, please have them call the center telephone number and leave a message with the receptionist.

What languages are used to deliver training?

Most courses are conducted in English, unless otherwise specified. Some courses will have the word "FRENCH" marked in red beside the scheduled date(s) indicating the language of instruction.

What does GTR stand for?

GTR stands for Guaranteed to Run; if you see a course with this status, it means this event is confirmed to run. View our GTR page to see our full list of Guaranteed to Run courses.

Does ExitCertified deliver group training?

Yes, we provide training for groups, individuals and private on sites. View our group training page for more information.

Does ExitCertified deliver group training?

Yes, we provide training for groups, individuals, and private on sites. View our group training page for more information.

Great resources to follow along with the instructor and the virtual facilitation worked very well.

The course was very detailed and the instructor was clear and answered all my questions.

The content of the course and the instructions for activities was good. The instructor was good

Well planned presentations. Live Demo. Excellent labs to ensure comprehension.

This AWS training is very well designed and supported in the virtual lab. One of the best virtual lab experiences I have had, and I have had many. Sean the instructor made the material easy to grasp with his high-level drawings to supplement the slides.

0 options available

There are currently no scheduled dates for this course. If you are interested in this course, request a course date with the links above. We can also contact you when the course is scheduled in your area.

Contact Us 1-800-803-3948
Contact Us
FAQ Get immediate answers to our most frequently asked qestions. View FAQs arrow_forward