Oracle Integrated Operational Planning 11.1.2: Create Models

Course Description

In this course, you learn modeling concepts in Oracle® Integrated Operational Planning Fusion Edition, 11.1.2. You configure an Integrated Operational Planning model and a spreadsheet interface for analyzing data. You perform administrative tasks such as user provisioning and model migration. In addition, you analyze Integrated Operational Planning data and explore a pre-built complex model in Integrated Margin Planning.Learn to:Configure a basic model Configure a spreadsheet interface to support end-user workflows for data analysis Provision users and migrate models Analyze Integrated Operational Planning data Analyze data using a pre-built Integrated Margin Planning model 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.

Skills Gained

• Describe Integrated Operational Planning modeling concepts
• Configure a basic model
• Configure a spreadsheet interface to support end-user workflows for data analysis
• Administer Integrated Operational Planning
• Analyze Integrated Operational Planning data
• Analyze data using a pre-built Integrated Margin Planning model

Who Can Benefit

• Administrator
• Data Modelers
• Functional Implementer
• Sales Consultants

Prerequisites

• Familiarity with relational or multidimensional databases
• Familiarity with Microsoft Excel
• Knowledge of operational and business planning concepts
• Basic knowledge of accounting concepts

Syllabus

Introduction to Integrated Operational Planning

• Oracle's Enterprise Performance Management System
• Oracle Integrated Operational Planning
• Hyperion Planning and Essbase Integration
• Integrated Operational Planning Architecture
• Basic Modeling Concepts

Defining Dimensions

• Defining Dimensions
• Defining Data Sources
• Defining Data Source and Dimension Mappings

Defining Row Sources

• Defining Row Sources
• Creating Mappings
• Modifying Row Sources
• Creating Data Load Filters

Defining Cubes

• Adding Cube Dimensions
• Creating Cube Measures
• Publishing Models

Defining Spreadsheets

• Planning Worksheets
• Defining Inline Reports
• Reporting and Data Collection Worksheets
• Workbooks and Analysis Types
• Defining Navigation Options and Key Metrics

Administering Integrated Operational Planning

• managing User Accounts in Hyperion Shared Services
• Reviewing Logs and Error Files
• Defining Security Filters and Analysis Types
• Defining Batch Processing Scripts
• Exporting Data to Relational Tables
• Rviewing Weekly and Daily Scripts

Analyzing Integrated Operational Planning Data

• Creating and Managing Scenarios
• Performing Ad-hoc Navigation
• Performing What-if Analysis
• Adding Comments and KPIs
• Creating and Managing Alternate Scenarios

Migrating Models

• Model Migration Process
• Restoring and Backing Up Databases

Modeling with the Materials Cube and Cross-Cube Mappings

• The Materials Cube Structure
• Adding Complex Roll-Up Measures
• Mapping Materials and Demand Cubes
• Publishing a Model