SAP BW (Business Warehouse)Learn how to create and modify data warehouses, perform data management tasks, generate reports and develop analytics applications.
Preview SAP BW (Business Warehouse) courseView Course Curriculum Price Match Guarantee Full Lifetime Access Access on any Device Technical Support Secure Checkout   Course Completion Certificate
- 73% Started a new career
BUY THIS COURSE (
USD 10 USD 140)
- 86% Got a pay increase and promotion
Students also bought -
- SAP BW/4HANA
- 30 Hours
- USD 10
- 349 Learners
- SAP BW/4HANA (basic to advanced)
- 50 Hours
- USD 10
- 1778 Learners
- Bundle Ultimate - SAP Finance and SAP TRM (FICO - BPC - TRM - S/4HANA Finance - S/4HANA TRM)
- 120 Hours
- USD 17
- 691 Learners
SAP BW (Business Warehouse) is a model-driven data warehousing product based on the SAP NetWeaver ABAP platform.
SAP BW collects, transforms and stores the data generated in SAP and non-SAP applications and makes it accessible through built-in reporting, business intelligence and analytics tools, as well as third-party software. It is also a development platform that programmers use to create and modify data warehouses, perform data management tasks, generate reports and develop analytics applications.
Business users typically access SAP BW through an application built by a developer, such as an executive dashboard or mobile app. SAP BW integrates data from different sources, transforms and consolidates the data, performs cleansing, and stores it.
SAP BW also includes data modeling, administration and staging area. The data in SAP BW is managed with the help of a centralized tool known as SAP BI Administration Workbench.
SAP BI is an integrated layer built on top of BW for analyzing and reporting of data from different heterogeneous data sources.
Business Explorer (BEx) is a reporting and analysis tool that supports query, analysis and reporting functions in BI.
SAP Netweaver BW can optimize the business workflow with the market, creating decisive competitive advantages for organization.
SAP BW/4HANA is a packaged data warehouse based on SAP HANA. As the on-premise data warehouse layer of SAP's Business Technology Platform, it allows you to consolidate data across the enterprise to get a consistent, agreed-upon view of your data.
SAP Business Intelligence (BI) means analyzing and reporting of data from different heterogeneous data sources. It allows you to acquire data from multiple data sources, data staging, which can be further distributed to different BI systems. A SAP Business Intelligence system can work as a target system for data transfer or source system for distribution of data to different BI targets
This SAP BW training by Uplatz provides you detailed knowledge of the BW processes, how they interact, the tools & utilities involved, and create an optimized structure of the organization's business warehouse.
Course/Topic - SAP BW - all lectures
In this first tutorial on SAP BW, you will get an in-depth knowledge and some core concepts on this module, how it helps in the reporting process in the SAP system, what is cube and ADSO in SAP BW, the Architecture level and also you will get a deeper understanding on the Info Objects. You will also learn the initial
This is the continuation of Lecture 1.1 - Overview of SAP BW
In this tutorial, you will learn about the whole of the ETL process, how the data flows and how ETL process is implemented in the SAP BW. This will be proceeded with a detailed and practical demonstration by the instructor on the following concepts.
This is the continuation of Lecture 2.1 - Working on the ETL process.
In this tutorial, you will clearing doubts on the practical sessions.
In this tutorial, you will be getting the practical demonstrations on how to work with the ETL process, creating InfoArea, working with the InfoObject Catalog, adding new BW system and defining Master Data and Attribute Data. Also, you will be seeing the instructor explaining each and every step to the student on how to work with some of the concepts of BW module in the SAP system screen.
This is the continuation of Lecture 4.1 - Working with the ETL Process
This is the continuation of Lecture 4.2 - Working with the ETL Process
In this tutorial, you will learn how you can load your data in the SAP BW system. You will get a detail demonstration from both the instructor as well as will be seeing the student practicing the process of working on the Data Warehousing Workbench, changing data source, creating and changing transformation, mapping the attributes through InfoProvider and also the Data Transfer process
This is continuation of Lecture 5.1 - How to load data in SAP BW system
This is the continuation of Lecture 5.2 - How to load data in SAP BW system
In this tutorial, you will be seen the instructor helping the student in creating InfoObjects in BW system. This will be practical demonstration of the entire work being done by the student and not by the instructor.
In this tutorial, you will be learning on how to create the Data Source in the SAP BW system and also will get a detailed and practical demonstration of loading Transaction Data. You will also understand the terms sales quantity, sales amount and key figures/measures which are the vital elements of Sales in the SAP system. You will also learn how to work on the Data Warehousing Workbench and also understand the terms ADSO Advanced and ADSO Classic and what is its work in the SAP BW system.
This is the continuation of Lecture 7.1 - Creating Data Source and Loading Transaction Data - Part 1
In this tutorial, you will be learning about the DSO and the cube in the BW system. This will be demonstrated with a detailed explanation by the tutor on the SAP system screen.
This is the continuation of Lecture 8.1 - Working with DSO
In this tutorial, you will be learning on how to work with the Joined Operations in the SAP BW system along with the Sales Cost of the Joined Operations, attributes like Multi-Provider and InfoSet and a deeper understanding on the components like DS, ADSO, CP and Query. You will also be learning about the input of query’s in the Query Designer Screen of the SAP BW system.
In this tutorial, you will learn a detailed understanding on how to load data in the BW system, what are the different examples of data that might be associated with Sales in the BW system and a detailed explanation on the Info Object and the different attributes.
This is the continuation of Lecture 10.1 - Loading data in BW system - Part 2
In this tutorial, you will learn how you can create a Data Source for InfoObjects and manage InfoProvider in the SAP BW system. You will also learn how data moves between different tables i.e. the Active and the Change Log table while working with creating the Data Source process. The complete video tutorial will be a practical demonstration by the instructor in the SAP system.
This is the continuation of Lecture 11.1 - Creating Data Source for InfoObject - Part 1
In this tutorial, you will learn how to work with the tables in cube process, some concepts on BW reporting and third-party reporting tools, 0 data services, what is a Star and Extended Star Schema, how to connect the Fact Table with the Dimension Table and the M:N Relationship Modeled in Two Dimension Tables.
This is continuation of Lecture 12.1 - Working with Tables in Cube
Lecture 13 - Star Schema in Data Warehousing Model
• Become Zero to Hero in SAP BW Modeling from this course
• Do Modeling, Extraction and Reporting in SAP BW 7.4
• Hands on experience on BW Modeling tools
• You can Design and Do Modeling in SAP BW
• Complete and In-Depth knowledge of SAP BW Modeling
• You can work on SAP BW projects
• Learn to extract valuable data and use it to benefit the business
• SAP Professionals with skills in Business Intelligence are offered a high salary
• It offers Several Job Opportunities with skills of BW such as Junior Consultant, Business Analyst, Data Analyst, and more
- Introduction to ERP, SAP, Data Warehouse
- Overview of BW, BI, Data Base.
- Overview of BW Architecture, Landscape
- Multi-Dimensional Star Schema (Classical Approach)
- Multi-Dimensional Star Schema in BW (Extended star Schema)
- The OLAP Concept and differences between OLAP and OLTP
- Info Area
- Info Object Catalogs
- Info Objects
- Application Component
- Info Source
- Data Source
- Transfer Rules
- Update Rules
- Transfer Structure
- Communication Structure
- Info Package
- Data Transfer Process
- Loading Transactional Data into BW info Cube
- Loading MD with TD into BW System
- BW and BI Comparisons
- Master data loading-new (BI) ETL process
- Info cube & Types
- Standard Info cube and Loading with new ETL Process
- Generate Report with BI master and Transaction Data
- Manual Uploading of MD like Attributes, Text, and Hierarchy
- Different Types of Attributes
- Transformations, Rule types
- Start Routine
- End Routine
- Expert Routine
DTP (Data Transfer Process)
- Standard DTP
- Error DTP
- Direct Access DTP
- Real time DTP
DSO (Data Store Object)
- Standard DSO
- Write optimized DSO
- Direct update DSO
- APD (Analysis Process & Design)
- Full updates
- Delta Updates
- Multi Providers
- Info set
- Virtual Providers
- Open-Hub Destination
- Data Marts
Info Cube Maintenance
- Process Chains, Process Types
- Monitor (Header, Status, Details)
- Business Explorer
- BEX Query designer
- BEX Analyzer
- BEX WAD
- BEX Report Designer
Functional Overview of Bex Query Designer
Reusable Query Elements
- Query Controls with Variables
- Calculated Key Figures
- Restricted Key Figures
Variable Definition in Detail
- Characteristic values variables
- Text Variables
- Formula Variables
- Hierarchy Variable
- Hierarchy Node Variable
- Analysis Functions
- Reporting Drilldown
- Drilldown to DSO from Info Cube (RRI)
- Copying Queries from Cubes
- Bex Analyzer
- Bex WAD
- Bex Report Designer
- Migration Objects from BW 3.x to BI 7.0
- Generic Data Extraction using MD/TD Tables
- COPA Extraction
- Business Content Extractions using MD/TD
- LO-COCKPIT Data Extraction
- Delta types for
This SAP BW training course is designed for clearing the SAP Certified Application Associate-Business Intelligence with SAP BW 7.4 & SAP BI 4.1exam. The complete SAP BW course content connects with the certification program and helps the participants to clear it with ease.
In SAP BW Course module the participants can learn to explore the SAP BW solution based on the SAP Netweaver ABAP platform. In the SAP BW course, the participants will learn about BW processes and data analytics. This seems to be an essential learning for all SAP BW module users.
The SAP BW Certification is an important benchmark in becoming an expert BW Consultant as the course covers business objects dashboard, business objects web intelligence, analysis and crystal reports. SAP BW tutorial helps the participants to learn all the key components of SAP BWsoftware thus attaining a unique SAP certification. SAP BW course offers complete information about SAP BWsoftware with BI features thus making the participant an expert SAP BW Consultant.
Uplatz online training guarantees the participants to successfully go through the SAP BWcertification provided by SAP. Uplatz provides appropriate teaching and expertise training to equip the participants for implementing the learnt concepts in an organization.
Uplatz Course Completion Certificate will be awarded upon the completion of the SAP BW course training.
The SAP BW certification exam verifies that the participants possess basic knowledge and can prove their skills in the area of SAP Business Intelligence with SAP BW and SAP BI. This SAP BW certification exam validates that the participant has an overall understanding about this consultant profile, and able to implement the knowledge practically in projects.
Below given are the certification Details of SAP Certified Application Associate-Business Intelligence with SAP BW 7.4 & SAP BI 4.1
• Certification Level: Associate
• Exam Name: SAP Certified Application Associate- Business Intelligence with SAP BW 7.4 & SAP BI 4.1
• Exam Code: C_TB130_74
• Exam Mode: Online
• Total Number of Questions: 80
• Pass Score: 60%
• Time Duration: 180 Minutes
• Exam Price: $550
The SAP BW Consultant draws an average salary of $83,974 per year depending on the knowledge and hands-on experience. The SAP BW Consultant job roles are in high demand and make a rewarding career.
The SAP BW Consultants are recognized across the globe. The increased usage of the SAP NetWeaver BW in many companieshelp the participants to find a job opportunity easily. The leading companies hire SAP BW Consultant considering the skill of handlingthe data collectionvia enterprise data warehouse in an organization. The Learners earn most beneficial SAP BWcertification through our expert training and course curriculum. Being SAP BWcertified is definitely valuable credential and adds value to every organization.
The SAP BW certification is targeted to those participants who are from Sap Netweaver or business background and excel as SAP BW consultant
The following are the job titles:
• SAP BW Expert
• SAP BW Associate
• Data Warehouse Consultant
• BI Consultant
• SAP BI/BW Associate
The SAP BW online course provides you with an opportunity to explore career opportunities as SAP BW Consultant.
1) What is SAP BW/BI? What is the purpose of SAP BW/BI?
SAP BW/BI stands for Business Information Warehouse, also known as business intelligence. For any business, data reporting, analyses and interpretation of business data is very crucial for running business smoothly and making decision. SAP BW/BI manage the data and enables to react quickly and in line with the market. It enables the user to analyze data from operative SAP applications as well as from other business.
2) In SAP BW/BI what are the main areas and activities?
a) Data Warehouse: Integrating, collecting and managing entire company's data.
b) Analyzing and Planning: Using the data stored in data warehouse
c) Reporting: BI provides the tools for reporting in web-browser, Excel etc.
d) Broad cast publishing: To send the information to the employees using email, fax etc.
e) Performance: Performance of the company
f) Security: Securing the access like using SAP logon tickets from portal
3) What is data Integrity?
Data integrity is to eliminate duplicate entries in the database.
4) What is table partition?
Table partition is done to manage the huge data to improve the efficiency of the applications. The partition is based on 0CALMONTH and 0FISCPER. There are two type of partitioning that is done
a) Database partitioning
b) Logical partitioning
5) What is data flow in BW/BI?
Data flows from a transactional system to the analytical system (BW). DS ( Data Service) on the transactional system needs to be replicated on BW side and attached to infosource and update rules respectively.
6) What is ODS (Operational Data Store)?
'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 rather than dimensional analysis, and it is not based on the star schema. ODS (Operational Data Store) objects do not aggregate data as infocubes do. To load the data into an IDS object, new records are inserted, existing records are updated, or old records are deleted as specified by RECORDMODE value.
7) What is an 'Infocube'?
'Infocube' is structured as the star schema and it is a data storage area. To create an infocube, you require 1 'fact table' surrounded by 4 dimensions. The 'fact table' is surrounded by different dim table, which are linked with DIM' ids. And as per the data, you will have aggregated data in the cubes.
8) How many tables does info cube contain?
Info cubes contain two tables, Fact table and Dimensions table.
9) Mention what are the maximum number of dimensions in info cubes?
In info cubes, there are 16 dimensions (3 sap defined and 1 customer defined)
10) What is the difference between ODS and Info-cubes?
The difference between ODS and Info-cubes are
a) ODS has a key while Info-cubes does not have any key
b) ODS contains detailed level data while Info-cube contains refined data
c) Info-cube follows Star Schema (16 dimensions) while ODS is a flat file structure
d) There can be two or more ODS under a cube, so cube can contain combined data or data that is derived from other fields in the ODS
11) What is the dimension in BW? How would you optimize the dimensions?
A dimension in BW is a collection of reference information about a measurable event in data warehousing. In this context, events are known as "facts". For example, a customer dimension's attributes could include first and last name, gender, birth date etc. To optimize the dimensions, do not add most dynamic characteristics into the same dimension and make the dimension smaller. Also, define as many dimensions as possible, and the dimension should not exceed 20% of the fact table size.
12) What are info objects?
Characteristics and key figures will be called as info objects. 'Info-objects' are similar to fields of the source system, data based on which we organize data in different info provider in BW.
13) What is modelling?
Designing of data base is done by using modelling. The design of DB (Data Base) depends on the schema, and schema is defined as the representation of tables and their relationship.
14) What is extended star schema?
Star Schema comprises of Fact tables and Dimension Tables, while the table that consists the Master data are kept in separate tables. These separate tables for Master data are referred as Extended Star Schema.
15) What are the extractors and mention their types?
To extract data from the system program is used which is known as Extractor. The types of extractors in BW are:
a) Application Specific: BW content FI, HR, CO, SAP CRM, LO cockpit
b) Customer-Generated Extractors: LIS, FI-SL, CO-PA
c) Cross Application (Generic Extractors) : DB View,Infoset, Function Module
16) What is a 'Fact Table'?
Fact table is the collection of facts and relations that mean foreign keys with the dimension. Actually fact table holds transactional data.
17) What are the data types for the characteristics info object?
There are 4 data types:
18) What is the use of the process chain?
The use of the process chain is to automate the data load process. It automates the process like Data load, Indices creation, Deletion, Cube compression etc. Process chains are only to load your data.
19) What are the transaction codes or T-codes for Info-objects?
The T-codes for Info-Cubes are
a) LISTCUBE: List viewer for InfoCubes
b) LISTSCHEMA: Show InfoCube schema
c) RSDCUBE, RSDCUBED, RSDCUBEM: Start InfoCube editing
20) What is the maximum number of key figures and characteristics?
The maximum number of key figures is 233 and characteristics are 248.
21) How can you convert an info package group into the process chain?
You can convert package group into a process chain by double clicking on the info package group, then you have to click on the ' Process Chain Maint ' button where you have to type the name and description, this will insert individual info packages automatically.
22) Can an Info-object be an Info-provider?
Yes, info-object can be an info-provider. In order to do this, you have to right click on the Info Area and select " Insert characteristics as data target".
23) What is multi-provider in SAP BI ? What are the features of Multiproviders?
Multi-provider is a type of info-provider that contains data from a number of info-providers and makes it available for reporting purposes.
a) Multi-provider does not contain any data.
b) The data comes entirely from the info providers on which it is based.
c) The info-providers are connected to one another by union operations.
d) Info-providers and Multi-providers are the objects or views relevant for reporting.
e) A multi-provider allows you to run reports using several info-providers that are, it is used for creating reports for one or more than one info-provider at a time.
24) What is Conversion Routine?
Conversion routine is used to convert data types from internal format to external format or display format.
25) Explain the difference between the Start routine and Conversion routine?
In the 'start routine', you can modify the data packages, when data is loading. While conversion of routine, usually refers to routines bound to info objects for conversion of internal and display format.
26) How to un-lock objects in Transport Organizer?
To unlock the objects in transport organizer, go to SE03a Request TaskaUnlock objects. When you enter your request and select unlock and execute, it will unlock the request.
27) What is update or transfer routine?
The update routine is used to define Global Data and Global Checks. They are defined as the object level. It is like the Start Routine.
28) What are the types of Multi-providers?
The types of Multi-providers are
a) Homogeneous Multiproviders: It consists of technically identical info-providers, such as infocubes with exactly the same characteristics and key figures.
b) Heterogeneous Multiproviders: These info-providers only have a certain number of characteristics and key figures. It can be used for the modelling of scenarios by dividing them into sub-scenarios. Each sub-scenario is represented by its own info-provider.
29) What are the transaction codes for process chain?
a) RSPC: Process Chain Maintenance
b) RSPC1: Process Chain Display
c) RSPCM: Monitor daily process chains
d) RZ20: To see log for process chains
30) Explain what is the T.code for Data Archival and what is the advantage?
SARA is the T.code,and its advantage is minimizes space, query performance and load performance.
31) What is BEx Map in SAP BI?
BEx Map is BW's Geographical Information System (GIS). BEx Map is one of the characteristics for SAP BI, and it gives the geographical information like customer, customer sales region and country.
32) What is B/W statistics and how it is used?
The sets of cubes delivered by SAP are used to measure performance for query, loading data etc. B/W statistics as the name suggests is useful in showing data about the costs associated with the B/W queries, OLAP, aggregative data etc. It is useful to measure the performance of how quickly the queries are calculated or how quickly the data is loaded into BW.
33) What is the data target administration task?
Data target administration task includes
a) Delete Index
b) Generate Index
c) Construct database statistics
d) Complete deletion of data target
e) Compression of the info-cube etc.
34) What are the options when defining aggregates?
a) * - Groups according to characteristics
b) H - Hierarchy
c) F - Fixed Value
d) Blank - None
35) What do you mean by the term 'slowly changing dimension'?
Dimensions that changes with time are called slowly changing dimensions.
36) Explain how you can create a connection with LIS Info Structures?
To create a connection with LIS info-structure, LBW0 connects LIS info-structures to BW.
37) What are the delta options available when load from flat file?
Three options are available for delta management with flat files
1) Full upload
2) New status for changed records
3) Additive delta
38) What are the steps within SAP BI to create classes for BW?
To create classes or nodes for BW you have to follow the following steps,
a) Click on post-processing of data sources
b) Execute/Click on IMG activity
c) Select BW or any desired node
d) Click on context menu
e) Press F6 or select "Create node"
After following these steps, a new dialog box will appear, where you can insert your node or class for BW.
39) What is data ware-housing hierarchy?
To define data aggregation hierarchy can be used. It is a logical structure that use ordered levels as a means of organizing data. For instance, by using time dimension hierarchy, it is possible to aggregate data from the month level to the quarter level to the year level.
40) How will you debug errors with SAP GUI?
To debug errors in SAP GUI you have to follow the path
a) Run Bexanalyzer
b) Business Explorer menu item
c) Installation check
This will show an Excel sheet with start button, on clicking on it, it will verify the GUI installation and if there is any error you can fix it or either re-install it.