SAP BI/BW Training
SAP-BW & BW on HANA – course Content
- Unit-1 – Introduction
- What is SAP BUSINESS WAREHOUSE
- Types of Source System
- Difference between OLTP and OLAP System.
- Overview of Master data and Transaction Data.
- Unit – II
- Info-object catalog
- Creation of Info-objects
- Application component
- Creation of Data-source
- Creation of Info-package and Execute.
- Unit – III
- Master Data Loading and its types
- Master data attributes
- Master data Text
- Master data hierarchy
- Transformation and its Rules
- Data Transfer Process and its options
- Unit – IV
- Data-store object and its types
- Standard dso
- Write-optimized dso
- Direct-update dso using in APD
- Selective delection of DSO.
- Introduction of Info-cubes
- Standard Info-cube
- Virtual Info-cube – MP and Info-set
- SPO- Semantically Partition of object
- Open-Hub Destination
- Destination as a File ( Local file or Application server
- Destination as a Data-base table
- Destination as a Third-party system.
- Introduction to Business content Extraction
- Overview of ECC and its Importance
- Master data extraction (Attributes & Text & Hierarchy)
- Types of Extraction
- Standard Extraction
- Logistics Extraction— Update Modes: direct delta, queued delta, un-serialized v3 delta.
- Generic Extraction and its types
- Creation of Tables
- Creation of Views
- Discuss about End to End Flow From ECC to BW System.
- Unit – VIII
- Bex—Business Explorer
- Query Designer
- Query Analyzer
- How to create a report.
- Characteristic properties
- Calculated key-figures
- Restricted key-figures
- Free characteristics
- Variables and its Types
- Broadcasting the Bex Reports
Unit – IX Bw related ABAP Concepts
- Basic Abap concepts
- Types of Data-types
- Introduction of Internal Table
- FI-Data-source Enhancement
- Logistics data-source Enhancement.
- Routines – Start routine, field-to-field routines and End routine
- Customer Exits
Unit – X BW ON HANA CONTENT
Introduction to Hana
Architecture of Hana and Hana Information views.
10.1 ADSO (Advanced Data-store Object)
10.2 Composite Provider
10.3 Transient Provider
10.4 Open-ODS Views
10.5 Consuming HANA Models into SAP BW
Unit – XI Real-Time Issues in Support Project
11.1 Land-scape of Project [End to End Flow]
11.2 How to Monitor the Process chains in Live system.
11.3 How to handle the errors in Process chains.
11.4 How to handle bad data issues.
11.5 How to handle lock issues.
11.6 How to resolve the short-dump Issues.
11.7. Discuss about frequently used T:codes in Support Project
11.8 Discuss about critical Issues in Support Project.
Unit – XII Real-Time Issues in Implementation Project
12.1 Discuss about End to End Flow of Implantation Project
12.2 Discuss about real-time reporting requirement
12.3 Discuss about enhancement concepts
12.4 Introduction to Transports
12.5 Creation of Package and Transport request
12.6 Transporting the objects across land-scape( Theorytically)
SAP BusinessObjects BI (SAP BO, also historically BOBJ) is a reporting and analytics business intelligence (BI) platform aimed at business users. It consists of a number of reporting applications that allow users to discover data, perform analysis to derive insights and create reports that visualize the insights. SAP BO is intended to make reporting and analysis simple for business users so they can create reports and perform processes like predictive analytics without needing the input of data analysts.SAP BusinessObjects BI applications use drag-and-drop functions and allow users to search and analyze data from a wide variety of sources. SAP BO is a front-end BI platform, so the data is not stored at the application level but is integrated from the various back-end sources
- He is an SAP-certified ABAP professional
- Extensive skills in handling teams and managing the work-relationship building, negotiation, collaboration, advocacy, governance, and consensus-building
- Demonstrate excellent verbal, written communications and presentation skills including technical and non-technical users
- Communicate well within the organization and management teams utilizing strong presentation skills combined with a solid technical background
- Strong interpersonal and communication skills, both verbally, in writing and via presentations
- Detail-oriented and self-motivated with strong problem-solving skills
- Work in an ambiguous environment and streamline, excellent solution provisioning skills with varied technologies within SAP strong analytical and communication skills, including the ability to rapidly gather data, structure hypotheses and develop synthesized findings and recommendation.