SAP BO-XI-R/3 Online Training
SAP BO-XI-R/3 Online Training
BusinessObjects XI Built for SAP is the first and only BI platform that delivers a complete set of market-leading BI capabilities to SAP customers for use across the enterprise. BusinessObjects XI Built for SAP includes the industry’s best reporting,query and analysis,performance management, and extract, transform, load (ETL) technology to increase the speedof your BI deployment.
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
Related posts:
- SAP BO Training SAP Busine
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