PeopleSoft Supply Chain Management Warehouse

PeopleSoft Supply Chain Management Warehouse

• Getting Started with PeopleSoft Supply Chain Management Warehouse

  • PeopleSoft Supply Chain Management Warehouse Overview

  • 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 Supply Chain Warehouse

  • Supply Chain Warehouse Overview

  • Understanding the Supply Chain Warehouse Structure

• Running SCM Warehouse Implementation Jobs

  • Prerequisites

  • Running SCM Warehouse Implementation Jobs

• 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

• 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