PeopleSoft Financial Management Solutions Warehouse

PeopleSoft Financial Management Solutions Warehouse

• Getting Started with Financial Management Solutions Warehouse

  • PeopleSoft Financial Management Solutions Warehouse Overview

  • Oracle's PeopleSoft Products

  • Other Sources of Information

• Understanding the EPM Warehouses

  • Overview of PeopleSoft EPM Warehouses

  • Components of PeopleSoft EPM Warehouses

  • EPM Architecture and Data Flow

  • Reporting on the EPM Warehouses

• Understanding the FMS Warehouse

  • FMS Warehouse Overview

  • Understanding the FMS Warehouse Structure

• Running the FMS Warehouse Implementation Jobs

  • Prerequisites

  • Running FMS Warehouse Implementation Jobs

• Activating Inactive Dimension Keys in Fact Tables

  • Activating Inactive Dimension Keys in the PS_F_LEDGER Table

  • Activating Inactive Dimension Keys in the PS_F_BEGIN_BAL Table

  • Activating Inactive Dimension Keys in the PS_F_KK_LEDGER Table

  • Activating Inactive Dimension Keys in the PS_F_KK_BALANCES Table

• Implementing Materialized View Logs

  • Understanding Materialized View Logs

  • Implementing Materialized View Logs in the Oracle Database

  • Working with Materialized View Logs in Delivered ETL Jobs

• Configuring Slowly Changing Dimensions

  • Understanding Slowly Changing Dimensions

  • Understanding Slowly Changing Dimensions in EPM

  • Converting Type 1 Slowly Changing Dimension Jobs to Type 2

• Managing Source System Deletes

  • Understanding Source System Deletes and the Source-Delete Diagnostic Staging Jobs

  • Enabling the Source-Delete Diagnostic Feature

  • Adjusting the Source-Delete Diagnostic Option after Implementation

• Implementing Audit Jobs

  • Understanding Audit Jobs

  • Understanding Audit Job Implementation

  • Creating Audit Triggers and Running Trigger Scripts

• Implementing Currency Conversion for Multiple Currencies

  • Understanding Currency Conversion

  • Understanding Currency Conversion Methodology

  • Understanding Currency Conversion Rules

  • Setting Up Currency Conversion

  • Running the ETL Currency Conversion Process

• Setting Up Multilanguage Processing and Running the Language Swap Utility

  • Understanding Multilanguage Processing

  • Understanding the Language Swap Utility

  • Running the Language Swap Jobs

• Processing Trees and Recursive Hierarchies

  • Understanding Tree and Recursive Hierarchy Processing

  • Understanding Tree and Recursive Hierarchy Process Results

  • Setting Up Parameters for Tree and Recursive Hierarchy Processing

  • Running the Tree and Recursive Hierarchy ETL Process

• Extending the Multidimensional Warehouse Data Model

  • Considerations for Modifying an EPM Warehouse

  • Adding a Fact or Dimension Table to the Multidimensional Warehouse Data Model

  • Extending a Fact Table in the Multidimensional Warehouse Data Model

  • Extending a Dimension Table in the Multidimensional Warehouse Data Model

• Using the PeopleSoft EPM Lineage Spreadsheets

  • Understanding the EPM Lineage Spreadsheets

  • Viewing Lineage Information

  • Generating Lineage Information for a Job