PeopleSoft EPM Core & Technical Accelerated Rel 9.1

Total time
Logo Oracle University

Need more information? Get more details on the site of the provider.

Starting dates and places

There are no known starting dates for this product.

Description

This course covers core concepts necessary to deploy and maintain PeopleSoft’s EPM solution. Students will learn about EPM Warehouses and Analytical Applications, IBM WebSphere DataStage, EPM business rules, metadata for Analytical Applications, EPM security, and Jobstreams.

Students will also create detailed ETL jobs using IBM WebSphere DataStage and learn how models, scenarios and warehouse business units are defined and used in EPM. They will define trees and tree metadata and become acquainted with metadata management utilities and other tools used in EPM.

Learn to:
  • Describe and create metadata for the Analytical Applications
  • Describe ETL in EPM
  • Create DataStage ETL Jobs
  • Use Models …

Read the complete description

Frequently asked questions

There are no frequently asked questions yet. Send an Email to info@springest.com

Didn't find what you were looking for? See also: Time management, C/C++, Business Management, Hour of Code, and Executive MBA.

This course covers core concepts necessary to deploy and maintain PeopleSoft’s EPM solution. Students will learn about EPM Warehouses and Analytical Applications, IBM WebSphere DataStage, EPM business rules, metadata for Analytical Applications, EPM security, and Jobstreams.

Students will also create detailed ETL jobs using IBM WebSphere DataStage and learn how models, scenarios and warehouse business units are defined and used in EPM. They will define trees and tree metadata and become acquainted with metadata management utilities and other tools used in EPM.

Learn to:
  • Describe and create metadata for the Analytical Applications
  • Describe ETL in EPM
  • Create DataStage ETL Jobs
  • Use Models and Scenarios
  • Create Warehouse Business Units
  • Set up EPM security

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
  • Administrator
  • Business Intelligence Developer
  • Developer
  • Functional Implementer
  • Technical Administrator
  • Data Warehouse Administrator
  • Data Warehouse Analyst
  • Technical Consultant

Course Topics 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
Course Objectives
  • Describe and use the EPM solution
  • Describe EPM architecture
  • Create Warehouse Business Units
  • Describe and create EPM metadata
  • Describe and create trees
  • Describe ETL in EPM
  • Use DataStage Administrator
  • Use DataStage Designer
  • Use DataStage Director
  • Set up EPM security
  • Create models and scenarios
  • Create and use EPM jobstreams
  • Use Allocation Manager
  • Use Data Mapper

There are no reviews yet.

Share your review

Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate $1.- to Stichting Edukans.

There are no frequently asked questions yet. Send an Email to info@springest.com