SAP BI-BW Training

SAP NETWEAVER BUSINESS WAREHOUSE 7.3.

1. SAP BI Overview.

ERP overview.

  • What is ERP and Why ERP?

SAP history and different Sap Products.

  • Sap Cross Industry Applications
  • Sap Industry Specific solutions.

Role of SAP BI.

  • Implementation
  • Support
  • Upgrade and Migration.

Basics of Data Warehousing.

  • Star Schema
  • Extended Star Schema
  • Advantages of Extended Star Schema

Terminology and Project Orientation

2. Data Modeling, DW Design and Data loading From File sys.

BI System architecture.

  • Data warehouse
  • ETL
  • Bex Suite
    • Functions of Data warehousing workbench.
    • Development of Info objects.
  • Characteristics
  • Key Figures
    • Development of Attributes and all the Tabs of Chars and Key figure.
  • Display attribute
  • Navigational attributes
  • Transitive attribute
  • Compounding attribute
    • Designing the different types of  Infocubes  and DSO
    • Master Data loading—Attribute/Text/Hierarchy
    • Transaction data loading—-Loading to DSO and Info cube.
  • Full upload
  • Initialization
  • Delta uploads
    • Real time Data acquisition and Direct data Access (Virtual Provider)
    • Error Stack and Error Dtp //Issues in data Loading
    • Installing Objects from BI content.
    • Info sets and Multi Providers.
  • Inner Join/Left Outer Join
  • Union
    • Placing Flat Files in Application Server.
    • Data Modeling Tasks in a Project Environment

3. Data loading from SAP ERP and Database systems.

  • Source system interfaces and logical systems. Remote function calls.
  • Source system application and data source overview. Types of Extractors.
  • Logistics Data Extraction
  • Full upload
  • Initialization of data source
  • Delta uploads
    • Generic Extraction
  • Full upload
  • Initialization of data source
  • Delta uploads
    • DB extraction
    • Controlling Data Extraction.
  • Full upload
  • Initialization of data source
  • Delta uploads
    • Finance Extractors.
    • Master data Extraction from Sap ERP sys.
    • Data source Enhancement.

4. Business Explorer Business Intelligence.

  • Basics of Reporting. Components and Tools of Reporting.
    • Query Designer and Different Elements
  • Free chars
  • Filters/Restriction
  • Conditions/Exceptions
  • Restricted key figure/Calculated key figure/New selection/New formula
  • Variables-all types.
    • Analyzer
  • Design Mode
  • Analysis Mode
  • Report Designer and Formatting Techniques of Report Designer.
  • Web application Designer and Web Analyzer.
  • Bex Broadcaster.
  • Visual Composer Reporting.

5. BW 7.0 Topics & Supporting.

  • Start , End  & Expert routines
  • Remodeling
  • BI Accelerator,
  • BW Statistics.
  • Performance Issues.
  • Query Performance
    • Compression
    • Aggregates/Rollup
    • Indexes
    • Line item Dimension, Cardinality Height
    • Query trace/SQL Trace
    • Attribute and Hierarchy change run/etc…
  • Extraction performance
  • PSA partitioning/PSA and Change log Table Data Deletion
    • Transportation
    • Process chains Designing and Monitoring
    • Supporting Issues, Tickets and Miscellaneous topics.

6. BW 7.3 DeltaS

  • Hybrid Providers
  • Composite Providers
  • Transient Providers.
  • Scenarios For New Info providers.
  • Semantic partitioned objects
  • DSO Partitioning
  • Data Flow Copy and Data Flow Migration tool
  • Loading Hierarchies By using 7.3
  • Other 7.3 Features.