SAP Business Information Warehouse (BW) - Configuration Advanced

This course shows how data is extracted from an OLTP system. The learner will then be shown how to optimize SAP BW after it has been implemented.

Visit

Audience

The intended audience for this course are those who need to learn how to use SAP Business Information Warehouse and members of project teams (organizational and conceptual phases).

Objective

  • Extract data.
  • OLTP extraction.
  • External data extraction.
  • Operational data store.
  • Advanced considerations.
  • Production support.
  • Advanced data modeling
  • BW as a source system.

Topics Include

Unit 1: Data Extraction

  • OLTP Extraction: - Overall Process. - Extract Structure and Replication. - OLTP Scenario - InfoSource. - OLTP Scenario - InfoCube and Upload.
  • External Data Extraction: - RemoteCube. - SAP RemoteCube. - Defining an SAP RemoteCube.
  • Operational Data Store: - PSA and ODS. - Architecture. - Scenario: ODS Object Definition. - Scenario: Upload Data to the PSA. - Scenario: Upload Data to the ODS.

Unit 2: Advanced Considerations

  • Production Support: - BW Statistics. - Aggregates. - InfoCube Maintenance.
  • Advanced Data Modeling: - Extended Star Schema - Details. - Tracking History. - Data Grouping. - Aspects of Dimension Modeling. - MultiCubes.
  • BW as a Source System: - Exporting InfoCube Data. - Data Marts.

Duration

6

Minimum Requirements

The CDROM version of this course requires:

  • At least a 486DX 33Mhz CPU.
  • Microsoft Windows 3.1 or higher and a Microsoft compatible mouse.
  • At least 8MB RAM.
  • At least VGA graphics capability with a minimum 512K video RAM (1MB video RAM recommended).
  • At least a double speed CDROM drive.
  • An MPC compliant sound card with attached speakers or headphones is recommended (Currently only the CDROM version supports audio).
The network version of this course requires:
  • At least a 486DX 33Mhz CPU.
  • Microsoft Windows 3.1 or higher and a Microsoft compatible mouse.
  • At least 8MB RAM and 22MB available hard disk space or file server space.
  • At least VGA graphics capability with a minimum 512K video RAM (1MB video RAM recommended).

Media


Serebra Learning Corporation 119 - 7565 132nd Street Surrey BC    V3W 1K5 Canada