SAP BO-XI-R/3 Online Training
SAP BO-XI-R/3 Online Training
Course Contents
Introduction
- General Introduction.
- SAP introduction.
- Data warehousing/ BW/ BI Introduction
- Master data; Attributes, Texts, and Hierarchies.
- Standard Naming conventions in SAP and BI
Data Modeling
- InfoObjects: Definitions
- Types: Characteristics, Key Figures, Time, and Unit.
- InfoCubes: Definitions.
- Types: Standards, real time, remote.
- Design of Infocube: Star Schema concepts. Precautions.
- DataStore objects (DSO):
- Types: Standards, Real time.
- InfoSets
- MultiProviders: Scenarios to create Multiproviders.
- Infocube VS DSO
Metadata and Document Management
- BI Content: Definitions, How to install BI contents,
Defining extraction
- For SAP source systems: Creating Generic dataSource and maintaining SAP delivered dataSource.
- Or for files: Creating DataSources for File Source Systems
Defining transformations
- Transformations and different scenarios.
Defining the data flow
- Creating data transfer processes
- Creating process chains
Scheduling and monitoring
- Checking process chain runs
- Monitor for extraction processes and data transfer processes
Performance optimization
- Creating the first aggregate for an InfoCube
- Using the BIA index maintenance wizard
User management
- Setting up standard authorizations
- Defining analysis authorizations
Transports
Real business scenarios on different system environments, Moving objects from one system to another.
BI SUITE: Business Explorer
BEx Query Designer
- Queries: New queries, Restricting Characteristics, Formulas and Exception Cells
- Query Design: Defining Exceptions, Conditions, Restricted and Calculated KeyFigures
- Variables: The Variable Wizard, Variable Types and Processing Types, query Properties
- Component Properties: Properties of Characteristics, Attributes, Structure, Formula, KeyFigures
- Structures: Creating Re-usable structures
- Functions on BW Server: Copying queries between Cubes, Deleting Query Elements
Web Application Designer
- WAD: Functions of WAD, Web Items Window, Template Window, Properties Window
- Web Applications: Creating Web Applications, Settings, Stylesheets, Symbols and Properties
- Design: Designing the Layout of Web Templates, working with Library for Web Items
- Web Items: Tables, Filters, Checkboxes, Dropdown Box and other web items and their attributes
Activities
- BEx Analyzer
- BEx Web Application Designer
- BEx Report Designer
BI Platform
- Information Broadcasting (Overview)
- Functions of the Broadcaster: Precalculating and Exporting into Enterprise Portal
- User Guide: Distributing Queries and Web Templates, Scheduling Broadcasting Settings
- Example Scenarios: Monthly Sales Reports, Ad-hoc Distribution Options.
OLAP
- OLAP v OLTP: The OLAP Concept and differences between OLAP and OLTP
- OLAP Functions: Aggregation, Currency Translation, Report-to-Report Interface
- MetaData Repository: Searching for MetaData
Performance in depth
- Data Model for Performance: Line Item Dimensions, Navigational attributes, Time-Dependent
- BW Statistics: Query Analysis Tools, Performance Tables
- Reporting Performance: Effective query design, Line-Item, Compression, Partitioning
- Introduction to Aggregates
- Data Load Performance: Parallelism, Impact of Aggregates
SAP Business Objects
Introduction to SAP BO
- Introduction : Integration with SAP BI – BO
- Query As A Web Service
- Universe Designer
- Live Office
- Xcelcius
- Web Rich Client ( Web Intelligence)
- Crystal Report
1.Query as Web service
- Usage of Query as web service
- How to configure and use
- Viewing the Universe and Webi reports using web service
- Viewing the Crystal XCelsius reports using web service
2. Universe Designer
- Understanding how universes allow users to query databases using their everyday business terms
- Creating an ODBC connection to the course database
- Creating a universe
- Populating the universe structure
- Defining joins in a universe
3. Live Office
- Introduction
- How Data can be extracted using Live office
- Extracting data in Xcelcius using Live Office
4.Xcelcius
- Introducing Crystal Xcelcius with SAP implementation options.
- Create a Crystal Xcelsius Dashboard from SAP data stored in a Microsoft Excel spreadsheet
- sourced through Crystal Reports or Web Intelligence
- Create a Crystal Xcelsius Dashboard fon SAP data stored in a Microsoft Excel Spreadsheet
- created through the use of live Office
- Create a Crystal Xcelsius Dashboard from SAP data stored in a Microsoft Excel spreadsheet
- Created through the use of query as a Web Service (QaaWS)
- Crystal Xcelsius Dashboards Using Analytics as part of Dashboard Manager
- Create an Analytic Dashboard from SAP data through a Universe
5.Web Rich Client ( Web Intelligence)
- Introduction to desktop intelligence
- Report Creation
- Publishing the report
- Understanding how universes allow you to query database using everyday business terms
- Understanding Web Intelligence core functionalities
- Creating a document in the Web Intelligence Rich Client
- Viewing a Web Intelligence document in Info View
- Building a simple query
- Modifying a document query
- Working with query properties
- Restricting data with query filters
- Modifying a query with a predefined query filter
- Applying a single-value query filter
- Using prompts to restrict data
- Using complex filters
- Working in the Report Panel
- Displaying data in tables and charts
- Using breaks and cross tabs
- Formatting break, calculations, and report filters
- Formatting breaks and cross tabs
- Using default and custom sorts
- Ranking data to see top or bottom values
- Using alerter to highlight information
- Organizing a report into sections
- Copying data to other applications
- Preparing document for PDF and print
- Document formatting
- Exporting documents from the Rich Client
- Accessing Info View
6.Crystal Reports:
- Introduction to Crystal Reports
- Creating Reports
- Selecting Records
- Organizing Data on Reports
- Formatting & Section Formatting
- Creating basic and complex formulas
- Using Variables and Arrays
- Using Report Templates
- Applying Conditional Reporting
- Building parameterized and specialized reports
- Summarizing Data with Cross Tabs
- Using Report Sections
- Representing Data Visually
- Managing Reports
- Distributing Reports
- Using Repository and Repository data sources
- Report Processing
- Using sub Reports
Shared Post
No related posts.
Related posts brought to you by Yet Another Related Posts Plugin.
Did you enjoy this post? Why not leave a comment below and continue the conversation, or subscribe to my feed and get articles like this delivered automatically to your feed reader.









I am interested in the ‘SAP BO-XI-R/3 Online Training’ training. Please advise about the cost & procedures. Thanks