
SAP BUSINESS OBJECT COURSE CONTENT
SAP Business Objects 3.0,3.1 Training Course
This course will cover following Topics
· SAP Business Objects Universe Designer
· SAP Business Objects Web Intelligence
SAP Business Objects Universe Designer
Understanding BusinessObjects Universes
o BusinessObjects universe concepts
o Understanding universe development cycle
Creating the Basic Universe
o Getting started to create the universe
Building the Universe Structure
o Create the universe structure
o Defining joins in a universe
Dimension Objects
o Understand classes and objects
o Creating classes and objects
Measure Objects
o Measure object concepts
o Creating measure objects
Loops in a Universe
o Understanding loops concept
o Resolving loops using aliases
o Resolving loops using contexts
Understanding and Resolving SQL Traps
o Understanding SQL traps and universes
o Detecting and resolving chasm traps
o Detecting and resolving fan traps
Applying Restrictions on Objects
o Restricting the data returned by objects
Using @functions with Objects
o Defining @functions
o @prompt
o @prompt syntax
o @select
o @where
o @aggregate_aware
Hierarchies
o Hierarchies and universes concept
o Working with hierarchies
Lists of Values
o Creating a list of values
o Working with LOVs in Universe Designer
o Creating a cascading LOV
Derived Tables and Indexes
o Derived tables concept and its use
o Applying index awareness
Linking Universes
o Linked universe concept
o Creating links between universes
Universe Access Restrictions
o Setting access restrictions on a universe
Universe Management
o Documenting universes
o Deploying universes
o Maintaining universes
Web Intelligence Intro
o Web Intelligence concepts
Creating Web Intelligence Documents with Queries
o Creating a new report
o Editing Report query
o Understanding query properties
Restricting Data Returned by a Query
o Restricting data with query filters
o Predefined query filter
o Single-value query filter
o wildcards in query filters
o prompts
o complex filters
Designing Web Intelligence Reports
o Working with Web Intelligence documents
o Displaying data in tables and charts
o Creating tables
o Working with tables
o Presenting data in free-standing cells
o Presenting data in charts
Various features of WebI in Reports
o Breaks, calculations
o Sorts
o Formatting breaks and cross tabs
o Report filters
o Ranking data to see top or bottom values
o Tracking data changes
o Using alerters to highlight information
o Organizing a report into sections
o Copying data to other applications
Formatting Reports
o Formatting documents
o Formatting charts
Calculating Data with Formulas and Variables
o Explaining formulas and variables
o Using formulas and variables
Using Multiple Data Sources
o Synchronizing data from multiple data sources
o Creating multiple queries in a document
o Synchronizing data with merged dimensions
o Using a personal data provider
Analyzing Data
o Analyzing the data cube
o Drilling in Web Intelligence documents
o Setting Web Intelligence drill options
Managing and Sharing Web Intelligence Documents
o Exporting documents to the CMS
o Managing documents in InfoView
o Viewing a Web Intelligence document in InfoView
o Sharing Web Intelligence documents
o Setting InfoView preferences
o Web Intelligence report panels