ORACLE EPM Course Content



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

Enquiry Form                         

CONTACT US

  1. 10521 Shadow Ridge Ln Apt 203,
  2. Louisville KY-40241
  3. Contact No : 606 909 4722
  4. Email : contact@coloursit.com

TESTIMONIALS

  I am Pleased to compliment your organization for your efficiency and professionalism.     
– Kranthi Ch
MD, Siri IT Solutions



  I am Pleased to compliment your organization for your efficiency and professionalism.     
– Sreedhar J
Manager, Siri IT Solutions

Copyright © 2014 Colours IT Consulting | All Rights Reserved.