SAP BW 7.4

Data Warehouse Introduction

BW / BI Introduction

SAP Landscape

DSS

Standard Naming convention in SAP- BI

Discussion Groups

OLTP Vs OLAP

ETL

Star Schema

Snow Flake Schema

Business Warehouse Architecture

Extended Star Schema

DIM / SID Tables

Data Storage

Data Acquisition

Reporting and Analysis Tools

InfoArea ,Info Object ,InfoObject Catalog

Info Object Definitions : Characteristics , Key Figures, Time and Unit

Dimension / Key Figures

Basic Cube / Transactional Cube

Virtual/Remote Cube

Multi-Provider

ODS / Data Store Object ( DSO )

PSA

Aggregates

InfoSets

Compression

Indexes and Partition

Business Content, How to install BI contents.

R/3 Data ETL Process

Flat File ETL Process

Monitor

Source System

Master Data ( Attributes , Texts and Hierarchies )

Extract Structure – DataSource/Transfer Structure

Communication Structure

Transfer / Update Rules / Transformations

Info Package

R3 / Flat File Data

Delta Extraction

Standard BC

Custom Table Extraction

Creation of Data Transfer Process ( DTP )

Info Package

Process Chain

Queries, Tabular Queries

Query Properties

Variables: variable wizard , variable types and processing types.

Restricted Key Figures

Calculated Key Figures

Structures: creating re-usable structures

Cell Definition

Conditions and Exceptions

Query Copy/Delete between cubes.

Workbook

Queries

Personalize Variables

Data Area and Query Area

Web Template iView Creation

Publish Web Template in the portal