PeopleSoft Campus Solutions Warehouse

PeopleSoft Campus Solutions Warehouse

• Getting Started with PeopleSoft Campus Solutions Warehouse

  • PeopleSoft Campus Solutions Warehouse Overview

  • PeopleSoft Application Fundamentals

  • 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 Campus Solutions Warehouse

  • Campus Solutions Warehouse Overview

  • Admissions and Recruiting Data Mart

  • Campus Community Data Mart

  • Institutional Research Data Mart

  • Student Records Data Mart

  • Student Financial Services Data Mart

  • Common and Shared Dimensions in the Campus Solutions Warehouse

• Running Campus Solutions Warehouse Implementation Jobs

  • Prerequisites

  • Running Campus Solutions 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

• Implementing Audit Jobs

  • Understanding Audit Jobs

  • Understanding Audit Job Implementation

  • Creating Audit Triggers and Running Trigger Scripts

• Managing Source System Deletes and Archiving

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

  • Understanding Source System Archives

  • Enabling the Source-Delete Diagnostic Feature

  • Adjusting the Source-Delete Diagnostic Option after Implementation

  • Implementing the Source-Archiving Diagnostic Feature

• 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

• 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

• Frequently Asked Questions for Campus Solutions Warehouse Implementation

  • Implementation Scenarios

  • ETL Load Sequence

  • Environmental Parameters Configuration

• Using the PeopleSoft EPM Lineage Spreadsheets

  • Understanding the EPM Lineage Spreadsheets

  • Viewing Lineage Information

  • Generating Lineage Information for a Job