Oracle EPM

ORACLE EPM ONLINE TRAINING

ORACLE ENTERPRISE EPM CORE TECHNICAL ACCELERATED

DESCRIBING THE EPM SOLUTION

  • ETL process in EPM
  • Operational Warehouse – Staging
  • Operational Warehouse – Enriched
  • Multidimensional Warehouse
  • PeopleSoft EPM Warehouses and Reporting
  • PeopleSoft EPM Analytical Applications
  • Finding information about EPM in PeopleBooks

ETL OVERVIEW

  • Describing IBM WebSphere DataStage Server and Client Components
  • Describing IBM WebSphere DataStage Terminology
  • Describing DataStage Administrator, Designer, and Director
  • Describing Other DataStage Components
  • Describing ETL Load Strategies in EPM
  • Describing Error Handling in ETL Jobs
  • Loading Source Data into Operational Warehouse – Staging (OWS) Tables

USING DATASTAGE ADMINISTRATOR

USING DATASTAGE DESIGNER

  • Describing DataStage Designer
  • Managing Repository Objects
  • Analyzing Repository Object Usage
  • Importing and Exporting Repository Components
  • Working with Table Definitions
  • Building DataStage Jobs
  • Compiling and Running Jobs
  • Editing Job Properties

USING DATASTAGE DIRECTOR

DESCRIBING EPM BUSINESS RULES SETUP

  • Describing EPM Business Rule Setup
  • Defining EPM Sources
  • Defining Country and State Data
  • Accounting Calendars Setup
  • Unit of Measure Setup
  • Describing Multi-Currency Setup and Currency Conversion Rules
  • Defining Dimensions

DEFINING WAREHOUSE BUSINESS UNITS

  • Describing Warehouse Business Units
  • Creating Warehouse Business Units

RESOLVING DIMENSION COLLISIONS

  • Using the Business Unit Creation Wizard
  • Defining Collision Maps

WORKING WITH TREES

  • Describing PeopleSoft Trees
  • Describing Tree Utilities

WORKING WITH METADATA FOR THE OWE AND ANALYTICAL APPLICATIONS

  • Describing Metadata for the EPM Analytical Applications
  • Defining Record Metadata
  • Defining TableMap Metadata
  • Defining DataMap Metadata
  • Defining Filters, Constraints, and Expressions
  • Defining Metadata for the Profit Manager Tool
  • Defining Rule Metadata for Models

WORKING WITH MODELS AND SCENARIOS

  • Describing Models and Scenarios
  • Describing How Models Are Used in EPM Applications
  • Defining Models and Scenarios

WORKING WITH JOBSTREAMS

  • Describing Jobstreams
  • Defining and Running Jobstreams

USING DATA ENRICHMENT TOOLS

  • Describing Allocation Manager
  • Setting Up Allocation Manager Rules
  • Setting Up Allocation Manager Rule Sets
  • Defining Fixed Dimensions
  • Running Allocation Manager

USING DATA MAPPER

  • Describing Data Mapper
  • Defining Data Mapper Rule Sets
  • Defining Data Mapper Rule Groups
  • Defining Data Mapper Values

USING EPM SECURITY

  • Describing EPM Security
  • Understanding EPM Security
  • Setting Up Security by User
  • Setting Up Security by Role
  • Setting Up Metric-Level Security
  • Using Security APIs
  • Using LDAP Security Data

LOADING THE MULTIDIMENSIONAL WAREHOUSE, EPM WAREHOUSES, AND REPORTING

  • Loading Data Into the MDW
  • Describing the EPM Warehouses
  • Using Oracle OBIEE to Report on Data Stored in EPM Warehouses

USING ETL-BASED TREE PROCESSING FOR THE MULTIDIMENSIONAL WAREHOUSE