Course Description

SAP’s BI is a very pervasively employed data warehouse / analytical enterprise software solution, often utilized heavily by companies that essentially run their business on SAP operational systems such as SAP Enterprise Resource Planning (SAP ERP).SAP’s BI solution contains a large number of predefined extractors, a very significant amount of pre-defined business content in the form of Info Cubes, master data (i.e. objects representing the entity for Customer or Material), authorization roles, query views and reports all delivered in the software by SAP.

Some of the significant benefits of this approach include the ability to leverage SAP’s substantial business knowledge from many years of developing extremely sophisticated software systems for the world’s largest companies typically shortening project development cycles in the process.

The pre-defined business content can be modified to meet an organization’s specific requirements, while at the same time taking advantage of general aspects of these delivered data models and reports that are somewhat foundational and have broad application in business, government, and education.

Course Contents

• What is the purpose of Data warehousing Application
• What is OLTP System and What is OLAP System
• Sap BI/BW is an end to end Data warehousing Solution
• What are the strong selling points of SAP BI
• Architecture of SAP Applications
• Architecture of SAP BW
• Simple Data flow in SAP BI
• Data Targets and Info providers in SAP BI
• System Landscape of SAP BI

• Overview of Star Schema
• The SAP BW Extended Star Schema Concept
• Info cubes
• Overview of BI 7.X Data Flows
• Loading Master Data (Text, Attributes, Hierarchies)
• Loading Transaction Data

• Data Store objects
• Virtual providers and real time data acquisition

BI Reporting & Query Design
• Restricted Key figures
• Calculated Key Figures
• Properties of Key Figures
• Structures and Cells
• Properties and Attributes of Characteristics
• Types of Variable
• Processing Types of Variables
• Exceptions and Conditions

SAP Business Objects Suite
• BOBJ overview
• BI reporting tools implementation and its usage
Reporting with Web Intelligence
• Understand concepts of Web intelligence
• Create Web Intelligence documents
• Restrict data returned by a query
• Design a report
• Enhance the presentation of data in reports
• Creation of Web intelligence report with auto scheduling
• Calculate data with formulas and variables
• Use multiple data sources
• Analyze data
• Manage and share Web Intelligence documents
• Work with Advanced Query technique
• Creation of Web intelligence reports using Info cube & BW Query

• Reporting with Crystal Reports
• Planning a Report
• Selecting Records
• Formatting a Report
• Representing Data Visually
• Distributing Reports
• Creating Basic Formulas
• Organizing Data on a Report
• Applying Section Formatting
• Applying Conditional Reporting
• Using the Repository
• Using Report Templates
• Creating Formulas
• Building Parameterized Reports
• Summarizing Data with Cross-Tabs
• Using Report Sections
• Managing Reports
• Presenting Data Visually
• Add hyperlinks to a report

Business Objects dashboard aka xcelsius
• Connect to Web intelligence report data and
• Create Dashboard
• Connect to Business Objects Universes


SAP BIBO Course Road Map

int(31) int(0) array(3) { ["status"]=> bool(false) ["debug"]=> string(28) "{"course_id":31,"user_id":0}" ["warnings"]=> array(0) { } }

Course Assignments

SAP BIBW Support Forum

SAP BIBW Course Discussion Room- Chat Room

News forum

SAP BIBO Course Road Map

Activity For BIBW

Loading Data to Master Data/Text Table through Flat File

SAP BIBW Video Session Recordings

Comments are closed.