SAP Courses

SAP BUSINESS OBJECT COURSE CONTENT

SAP Business Objects 3.0,3.1 Training Course

Download PDF

This course will cover following Topics
A. SAP Business Objects Universe Designer
B. SAP Business Objects Web Intelligence

A. SAP Business Objects Universe Designer

• Understanding BusinessObjects Universes
- BusinessObjects universe concepts
- Understanding universe development cycle



• Creating the Basic Universe
- Getting started t- create the universe

• Building the Universe Structure
- Create the universe structure
- Defining joins in a universe

• Dimension Objects
- Understand classes and objects
- Creating classes and objects

• Measure Objects
- Measure object concepts
- Creating measure objects

 Loops in a Universe
- Understanding loops concept
- Resolving loops using aliases
- Resolving loops using contexts

• Understanding and Resolving SQL Traps
- Understanding SQL traps and universes
- Detecting and resolving chasm traps
- Detecting and resolving fan traps

• Applying Restrictions on Objects
- Restricting the data returned by objects

• Using @functions with Objects
- Defining @functions
- @prompt
- @prompt syntax
- @select
- @where
- @aggregate_aware

• Hierarchies
- Hierarchies and universes concept
- Working with hierarchies

• Lists of Values
- Creating a list of values
- Working with LOVs in Universe Designer
- Creating a cascading LOV

• Derived Tables and Indexes
- Derived tables concept and its use
- Applying index awareness

• Linking Universes
- Linked universe concept
- Creating links between universes

• Universe Access Restrictions
- Setting access restrictions on a universe

• Universe Management
- Documenting universes
- Deploying universes
- Maintaining universes

• Web Intelligence Intr- 
- Web Intelligence concepts

• Creating Web Intelligence Documents with Queries
- Creating a new report
- Editing Report query
- Understanding query properties

• Restricting Data Returned by a Query
- Restricting data with query filters
- Predefined query filter
- Single-value query filter
- wildcards in query filters
- prompts
- complex filters

• Designing Web Intelligence Reports
- Working with Web Intelligence documents
- Displaying data in tables and charts
- Creating tables
- Working with tables
- Presenting data in free-standing cells
- Presenting data in charts

• Various features of WebI in Reports
- Breaks, calculations
- Sorts
- Formatting breaks and cross tabs
- Report filters
- Ranking data t- see top or bottom values
- Tracking data changes
- Using alerters t- highlight information
- Organizing a report int- sections
- Copying data t- other applications

• Formatting Reports
- Formatting documents
- Formatting charts

• Calculating Data with Formulas and Variables
- Explaining formulas and variables
- Using formulas and variables

• Using Multiple Data Sources
- Synchronizing data from multiple data sources
- Creating multiple queries in a document
- Synchronizing data with merged dimensions
- Using a personal data provider

• Analyzing Data
- Analyzing the data cube
- Drilling in Web Intelligence documents
- Setting Web Intelligence drill options

• Managing and Sharing Web Intelligence Documents
- Exporting documents t- the CMS
- Managing documents in InfoView
- Viewing a Web Intelligence document in InfoView
- Sharing Web Intelligence documents
- Setting InfoView preferences
- Web Intelligence report panels

Download PDF