About us   Registration   Site map    
      New user|Forgot password  
Select Your Country to check the Schedule for this Course
Time Zone:
Course Name Course Code
Course Contents

SAP Business Information Warehouse

          (BW 3x) Course Content

  1.  Introduction:
        General Introduction
        Sap Introduction
        Data Warehousing/ Bw/ Bi Introduction
        Objects, Master Data, Attributes, Texts And Hierarchies

      2.    Data Modeling
                 InfoObjects: Definitions
                Types: Characteristics, Key Figures, Time, and Unit.
                 InfoCubes: Definitions.
                Types: Standards, Real time, Remote.
                Design of InfoCube: Star Schema concepts

               ODS / DSO
                Types: Standards, Real time
                 MultiProviders: Scenarios to create Multiproviders
                 Infocube VS DSO
          Standard Naming conventions in SAP and BI Customization

3.      Metadata and Document Management
Business Content: Definitions, How to install BI contents
MetaData Repository: Searching for MetaData

4.      Data Extraction
Data Extraction from SAP Source Systems
Data Extraction from Non-SAP Source Systems
Data Extraction from SAP Flat Files
LO Cockpit
LO Extraction
Generic Extraction
DataSource Enhancement

5.      Defining Transfer Rule & Update Rule
Creating Transfer Rule
Creating Update Rule
Routines in Transfer Rule and Update Rule
Routines in InfoPackage
Creating InfoSource

6.      Defining Data Flow
Creating Process Chains
Schedule Automatic Load
Full Load & Delta Load
The OLAP Concept and differences between OLAP and OLTP

7.      Performance Optimization:
Creating Aggregate for an InfoCube
Performance during Data load and in Reporting
Data Model for Performance: Line Item Dimensions, Navigational attributes
BW Statistics: Query Analysis Tools, Performance Tables
Reporting Performance: Effective query design, Line-Item, Compression, Partitioning
Aggregates: Creating Aggregates
Data Load Performance: Parallelism, Impact of Aggregates
Partitioning: Logical Partitioning, Table Partitioning.

8.      Scheduling and Monitoring
Checking process chain runs
Monitor for extraction processes

9.      BI SUITE: Business Explorer

10.  Bex Query Designer
Queries: New queries, Restricting Characteristics, Formulas and Exception Cells
Query Design: Defining Exceptions, Conditions, Restricted and Calculated Key Figures
Variables: The Variable Wizard, Variable Types and Processing Types, query Properties
Component Properties: Properties of Characteristics, Attributes, Structure, Formula, Key Figures
Structures: Creating Re-Usable Structures
Functions on BW Server: Copying queries between Cubes, Deleting Query Elements
Bex Analyzer
Execute Queries
Creating Workbooks
Save multiple queries in Workbook
Workbook Design

11.  Authorizations                                                                                                             Setting up standard authorizations
defining analysis authorizations
Creating Authorization Role

12.  Transports
Transport Objects from Development to QA and Production Server
Discussion real time Transport Problems
Transport Sequence

13.  Web Application Designer
WAD: Functions of WAD, Web Items Window, Template Window, Properties Window
Web Applications: Creating Web Applications, Settings, Style sheets, Symbols and Properties
Design: Designing the Layout of Web Templates, working with Library for Web Items
Web Items: Tables, Filters, Checkboxes, Dropdown Box and other web items and their attributes

14.  Career Related Support
How to build SAP Resume with sample resumes
frequently asked interview questions
Real Time / common Production issues, transport issues

15.  Small Project

16.  Free Bonus with the course - New Features in BI 7.0