Disable Preloader

SAP Business Intelligence and Business Warehousing domains. We are provided that SAP BI/BW teaching based on specific needs of the students especially we will present innovative online Classes which has big opportunities in the present IT marketplace.

This Training Course is about all the important aspects of the SAP Business Intelligence and Business Warehousing domains. SAP Business intelligence (BI) is one of the components of SAP NetWeaver it enables efficient and robust reporting, analysis and evaluation of business data. SAP Business Warehousing is the name of the BI, analytical, reporting, and Data Warehousing solution provided by SAP AG.

Module List

  • End to end Data warehousing module and Architecture of SAP-BW
  • Sap BW Modelling
  • Transformation and Scheduler
  • Data Schema
  • SAP BW-Info providers
  • Data store object (DSO)-Direct object
  • Data store object (DSO)-write optimized
  • Infoset
  • Info Cubes
  • Multi provider and Infoset
  • Routines in transformations(Start & end routines)
  • What is Extraction in BW
  • Lo-Cockpit Description
  • CO-PA Extractor
  • SAP BW Reporting
  • Restriction and Exceptions

SAP BI\BW Course Details

    SAP has a 3 tier architecture based on R/3, 3 tiers namely Presentation Server, Application Server, Database Server. Basically, sapgui.exe is a program as presentation server it is installed on the user workstation. What you will learn in this part is:Introduction to SAP then its  SAP architecture, understanding the SAP Business Intelligence and Business Warehouse, an overview of SAP Business Warehousing Works, the description of Business Warehousing works model, understanding Persistent Staging Area data sources, data transfer process, Char and Key Figure Model.

    The most interesting part is the data warehouse is front end where the user gets its data on an online analytical tool or data mining tool. But at the same time, we cannot ignore a lot of what is going on in the back end to bring this reliable and clean data to the user. This part will broaden understanding of the data warehousing module, reporting and ETL, introduction to data warehousing workbench, concepts, and description.

    SAP modeling helps to create an information view, it also creates a multidimensional data model, different type of attributes are used in modeling that we will learn about in this part of the tutorial apart from that we will also learn SAP business warehouse data modelling, learning about SAP Source and Non SAP Source, understanding the source system, persistent staging area Info Providers like info, char, cubes, do modelling.

    The task of a transformer is to transfer data from a particular source format to a target format in data warehouse layer while the scheduler is used mainly for load process of defining parameters for data transfer of a particular data source. Therefore it is important to Learn about the SAP Business Warehousing Data Transformation, and Scheduler, how to extract data from flat files to SAP business warehouse, you will also learn about the differences between internal and external sources, how to change data sources, create and working with metadata of target, editing info object catalog, creating of company application, and working with Scheduler.

    Live demo to extract data from flat files to SAP business warehouse then hands-on too on changing data sources, editing info object catalogue, creating and working with metadata of the target, creating company application, deploy a scheduler.

    Data schema tells about the logical configuration of all part of a relational database there are different types of schema namely classical data schema (others schema: Extended Star Schema) which is multidimensional data model based on fact table. This part will deepen your Understanding of SAP architecture via SAP BI/Business Warehousing data schema, learning about Extended Star Schema, understanding Master Data Table, master data load, attribution of master data, hierarchies and text of master data.

    Info-Providers have very different characteristic values still every BW-infoprovider provides data for every query. So this part will be all about: what is an SAP BW info provider, Introduction to data store object, How to design and work with standard data store object, Edit and display data store object, Loading of data in DSO as an info provider, Displaying and changing transformation in DSO.

    Hands-on Exercise – everyone will be assisted to Design and work with standard data store object, how to edit and display data store object, loading data in DSO as an info provider, displaying and changing transformation in DSO

    A data store serves as a storage location for aggregated and cleansed data.

    There are 3 types of data store object i.e. Standard data store object, direct data store object, write optimized data store object. This module explains about direct data store object, functionalities of DSO, its advantages, drawbacks, and creation of Datastore object.

    A data store serves as a storage location for aggregated and cleansed data. Write optimized data store object is one of the 3 data store types which will be discussed in this part of the tutorial. The Data in DSO is stored in a transparent and flat database tables. Write-optimized data store objects, learning to create write-optimized data store objects, the basic characteristics and rules concepts are explained in this module.

    The Infoproviders provide data for every query. Infoset is special kind of infoprovider it does not store data physically although it logically joins data and provide that data for BI query, it also describes the data source which is defined as a rule of join on datastore objects. The learner will be Introduced to Infoset, the rules of Infoset, deployment of Infoset for data modeling, a specific kind of Info providers, the Join Concept and application of Infoset.

    Infocube is also an area or data storage area in which physically extracted data from source system are stored. It is also described as a self-contained dataset. This part will make you understand the multidimensional data structure, creating a standard info cube, there are various types of info cubes, important rules for designing an info cube, main characteristics and key features, understanding Star Schema, Extended Star Schema and fact tables.

    Multi-provider is built on basic infocubes, infosets etc. A multi-provider queries uses union, while Infoset uses join. Multi-provider is working as union operator and brings all records irrespective of the target for the given selection.  Infoset is used to bring data which are common in the infoproviders.  Both are structures. This module will help the learner to understand the concept of Multi-provider, rules of updating, combining data from various info providers, learn about Virtual and Hybrid providers.

    The learner will also learn on how to work with virtual and hybrid providers, combine data from various info providers, setting the rules of updating, work with virtual and hybrid providers.

Training Advantages
35 contact hours
Industry Case Studies
Industry case studies
Real time training


    • Data Warehouse: Integrating, collecting and managing entire companys data
    • Analyzing and Planning: Using the data stored in data warehouse
    • Reporting: BI provides the tools for reporting in web-browser, excel etc.
    • Broad cast publishing:  To send the information to the employees using email, fax etc.
    • Performance: Performance of the company
    • Security: Securing the access like using SAP logon tickets from portal

    Data integrity is the process to eliminate duplicate entries in the database.

    Table partition helps to manage the large amount of data which improves the efficiency of the application.

    Database partitioning and Logical partitioning

    In BW/BI, data flows from a transactional system to the analytical system. On the transactional system, data service replicates on BW side and gets attached to info-source and update rule.

    ‘Operational Data Store’ or ‘ODS’ is used for detailed storage of data. It is a BW architectural component that appears between PSA (Persistent Staging Area) and infocubes, it allows BEX (Business Explorer) reporting. It is primarily used for detail reporting

    Info cubes contain two tables, E table and F (fact table).


    Extractor is defined as extracting data from the system program. The different types of extractors are:

    • Application Specific:  BW content FI, HR, CO, SAP CRM, LO cockpit
    • Customer-Generated Extractors:  LIS, FI-SL, CO-PA
    • Cross Application (Generic Extractors): DB View, Infoset, Function Module

    There are 4 types – CHAR, NUMC, DATS and TIMS

    • LISTCUBE: List viewer for InfoCubes
    • LISTSCHEMA: Show InfoCube schema
    • RSDCUBE, RSDCUBED, RSDCUBEM: Start InfoCube editing

    The maximum number of key figures is 233 and characteristics are 248.

    Data target administration task includes

    • Delete Index
    • Generate Index
    • Construct database statistics
    • Complete deletion of data target
    • Compression of the info-cube etc.