SAP NetWeaver BW BI 7.3 Online Training

SAP NetWeaver BW BI 7.3 Online Training

0 STUDENTS ENROLLED

     

    Introduction

    SAP BW is a Data Warehouse tool. In simple terms, it integrates data from different sources, transforms and consolidates, cleanse and stores data as well. It also includes data modeling, administration and staging area. The content-rich SAP BW sets a precedent for speed and ease of implementation and maintenance because it’s pre-configured with intelligence about a company’s business process, providing a faster return on information. SAP BW remains open to the different source system, and it will also come as a pleasant surprise for its ease of introduction and maintenance. The demand from end user companies needing expertise in the integration of ERP data into corporate data warehouses is growing exponentially. Thus resulting in great opportunities for certified SAP BW professionals in defining their career path.

    Pre-requisites

    1. Basic knowledge of Data Warehousing
    2. Pre-requisites Materials provided:SQL Tutorial
    3. Pre-requisites Materials provided Data Modeling and DW concepts

    Course Objective

    After the completion of this course, Trainee will:
    1. Expertise their skills in Modelling concepts like DSO, DTP, and Multi-dimensional model
    2. Attain knowledge in basic concepts of Data Extractions
    3. Understand basics and advanced concepts of Reporting
    4. Enhance their knowledge in new features of SAP BW like Hybrid Provider, Open Hub Services, etc.
    5. Gain ability to perform Web Reporting using new Web Application Designer

    Course Curriculum

    I. MODELING

    Unit 1: The Multi-dimensional Model in SAP BI

    1. The SAP BW Star Schema Concept
    2. Data warehousing Workbench (DWB)
    3. Info Objects
    4. Info Cubes

    Unit 2: Data Extraction and Data Flow within SAP BI 7.3 NW 2004S

    1. 3.x Dataflow
    2. Overview of BI 7.3 Dataflow
    3. Comparison of 3.x and BI 7.3 Data flows
    4. Loading Master Data (Attributes, Texts, Hierarchies)
    5. Loading Transaction Data

    Unit 3: New Data source Concept of BI 7.3

    1. Overview of new Datasource
    2. Emulation of Data source in BI 7.3
    3. Datasource Lifecycle with In BI 7.3 NW 2004S
    4. Migration of 3.x data source to BI 7.3 data source

    Unit 4: Transformation in BI 7.3(ETL)

    1. In depth coverage of Transformation
    2. Routines in Transformations (Start routine, End routine, Expert routine, transformation routine) with different Real Time examples
    3. Transformation Groups
    4. Unit and currency Conversions

    Unit 5: DTP (Data Transfer Process)

    1. Overview of DTPS
    2. Trouble shooting techniques in DTPS
    3. Debugging ABAP routines Using DTPS

    Unit 6: UPGRADING DATAFLOWS FROM 3.X TO BI 7.3

    Unit 7: Business Content

    1. Business Content (BCT)

    Unit 8: Administration of InfoCubes and Aggregates

    1. Managing Basic Cubes
    2. Aggregates
    3. BI Accelerators

    Unit 9: DSO (DATA STORE OBJECTS)

    1. DTP and its role in loading data to InfoCube in Extraction mode
    2. Real-time Data Replication from Source system to BW and Real-time HANA Optimized InfoCubes

    Unit 9: SLT Configuration, MultiProviders and Extractions

    1. Steps for performing SLT ConfigurationData Store Objects concept

    Unit 10: Virtual Cubes and Multi Providers

    1. Virtual Cubes
    2. Multi Providers

    II. DATA EXTRACTIONS (ETL)

    Unit 1: Overview of ECC6.0 Extractions

    1. Types of ECC extractions

    Unit 2: Generic Extractions

    1. Generic Extraction using
      1. Database Table
      2. View
      3. Classical Info sets
      4. Functional Module

    Unit 3: Business Content Extractions

    1. Overview of Business Content Extractions
    2. Examples from Financial, Logistics, HRMS modules

    Unit 4: CO-PA Extractions (COST PROFITABLE ANALYSIS)

    Unit 5: LO-COCK PIT Extractions (LOGISTICS)

    Unit 6: FI-SL Extractions (Financial special purpose ledger)
    SAP CRM extractions

    1. Marketing Extractions
    2. CRM SALES Extractions
    3. CRM SERVICE Extractions (CRM Extractions are Very High in demand)

    Unit 7: Delta Management

    1. Business Content (BCT)

    Unit 8: Extracting Master Data from CC (Attributes, Text, Hierarchies)

    1. Managing Basic Cubes
    2. Aggregates
    3. BI Accelerators

    Unit 9: Datasource Enhancement

    1. DTP and its role in loading data to InfoCube in Extraction mode
    2. Real-time Data Replication from Source system to BW and Real-time HANA Optimized InfoCubes

    Unit 10: Process Chains in Detail covering all process Types

    1. Steps for performing SLT ConfigurationData Store Objects concept

    Unit 10: Virtual Cubes and Multi Providers

    1. Real time examples on process Chains (Meta Chains)
    2. Multi Providers

    III. REPORTING

    Unit 1: Introduction to BI Enterprise Reporting

    1. The SAP BI Overview

    Unit 2: Navigating in Reports

    Unit 3: First Steps in Query Designer

    1. Query Designer
    2. Info providers in query Designer

    Unit 4: Key Figures

    1. Restricted Key Figures
    2. Calculated Key Figures
    3. Properties of Key Figures
    4. Structures and cells

    Unit 5: CHARACTERSTICS

    1. Properties and Attributes of Characteristics
    2. Integrating attributes and hierarchies in reports

    Unit 6: Attributes

    1. Characteristic Variables
    2. Hierarchy variables
    3. Hierarchy Node variables
    4. Formula Variables
    5. Text variables
    6. Variable Processing types

    Unit 7: Exceptions and Conditions

    1. Exceptions
    2. Conditions

    ADVANCED REPORTING Topics
    Unit 8: RRI (report to report interface)

    Unit 9: Bex Analyzer

    Unit 10: Bex Web Analyzer

    Unit 11: Overview of Information Broadcaster

    Unit 12: Web Reporting using new Web Application Designer

    1. In depth of Web reporting using New Web Application Designer
    2. Detail Coverage of Dash Board Reports and each and every Web item of new WAD

    NEW ENHANCEMENTS OF SAP BW 7.3

    1. UNIT 1: Hybrid provider
    2. UNIT 2: New monitors in BW Administration cockpit
    3. UNIT 3: Generic delta functionalities for further types of Data Sources
    4. UNIT 4: Hierarchies
      1. Integration of hierarchies into process flow (DTP, Transformation)
      2. Remote hierarchies for direct access to hierarchies in the source system
      3. Loading hierarchies from flat file using the new Data Source and Transformation technology
    5. UNIT 5: Data Transfer Process (DTP)
    6. UNIT 6: Open Hub Service
      1. SAP Net Weaver BW data can be exported in XML format
      2. Possibility to change the format and length of BW data for export even into a non-SAP specific format
      3. Hierarchy extraction supported by Open Hub
    7. UNIT 7: Transformation
      1. Semantic grouping possible in Transformations (in addition to semantic grouping in DTPs)
      2. Possibility to select the Info Objects (fields) the user wants to use in a Start- / End routine
      3. Currency and unit conversion for Data Store object and Info Source as target of a Transformation
      4. Navigation attributes of Info Cubes/Data Store objects can be used as source fields in the Transformation and as filter/select options in the DTP
      5. Automated generation of a proposal by mapping fields of the Data Source to Info Objects
    8. UNIT 8: SAP BODS (New ETL Tool of SAP) Integration

     

    Write a Review

    Your email address will not be published. Required fields are marked *

    Course Reviews

    N.A

    ratings
    • 5 stars0
    • 4 stars0
    • 3 stars0
    • 2 stars0
    • 1 stars0

    No Reviews found for this course.

    PRIVATE COURSE
    • PRIVATE
    • 1 month, 1 week
    Contact Us

    +1 475-212-0075

    Drop us a query

    Error: Contact form not found.

    Job Support

    Error: Contact form not found.

    Course Features

    Live Instructor-led Classes

    This isn't canned learning. Its dynamic, its interactive, its effective

    Expert Educators

    Only the best or they're out. We are constantly evaluating our trainers

    24&7 Support

    We never sleep. Need something answered at 3 am? No Problem

    Flexible Schedule

    You don't learn as per our calendar. We work according to yours.

    Customized Training's

    The most part self-managed and adaptable to suit a person's particular adapting technology needs

    Priority Based Training's

    Real-time Scenario based Assignments and Case Studies

    COPYRIGHT © 2020 KEEN IT TECHNOLOGIES PVT.LTD, ALL RIGHTS RESERVED