Course Content

SAP Business Objects 4.1SAP BO 4.1 Course Content

1. DWH (Basics)
2. WEB Intelligence 4.0 (BO4.0 SP2-BI launch pad 4.0)
3. Information Design Tool (BO4.0 SP2)
4. Administration/Security (CCM and CMS)
5. Universe Designer Tool
6. Web-Intelligence (INFOVIEW/ BI launch pad)
7. Web-Intelligence Rich Client XI 3.1/4.0
8. BO Administration (CMC)
9. Crystal Xcelsius Dashboard

BRIEF OUTLINE OF OUR COURSE

WEB Intelligence 4.0 (BO4.0 SP2)/XI 3.1

• What’s New
• Overview of Interactive Analysis core functions
• Creating Interactive Analysis documents with queries
• Restricting data returned by a query
• Designing Interactive Analysis reports
• Enhancing the presentation of data in reports
• Formatting reports
• Calculating data with formulas and variables
• Using multiple data sources
• Analyzing data
• Managing and sharing Interactive Analysis documents
• Reporting from Other Data Sources
• Introducing Web Intelligence
• Accessing corporate information with Web Intelligence
• Understanding how universes allow you to query databases using everyday business terms.
• Managing documents in InfoView
• Viewing a Web Intelligence document in InfoView
• Customizing InfoView
• Setting InfoView Preferences
• Creating Web Intelligence Documents with Queries
• Getting new data with Web Intelligence
• Creating a new Web Intelligence document
• Modifying a document’s query
• Working with query properties
• Restricting Data Returned by a Query
• Modifying a query with a predefined query filter
• Applying a single-value query filter
• Using prompts to restrict data
• Using complex filters
• Displaying data in tables and charts
• Presenting data in free-standing cells
• Enhancing the Presentation of Reports
• Using breaks, calculations, sorts and report filters
• Ranking data to see top or bottom values
• Using alerters to highlight information
• Organizing a report into sections
• Copying data to other applications
• Alternative Query Techniques Using Combined Queries Using Sub-Queries
• Creating a Query based on another Query

Information Design Tool 4.0

• What is the Information Design Tool (IDT)
• Create the data foundation
• Create a database connection
• Create a data foundation
• Define joins in a data foundation
• Create a business layer
• Create folders and objects
• Create measure objects
• Resolve Loops Use alias
• Resolve Loops Use contexts
• Define data restrictions
• Work with LOVs
• Use Parameters restrict data
• Use @functions also Aggregate Awareness
• Create Derived Tables and Index Awareness
• Maintain universes
• Deplore and manage and maintain universes
• Document universes

Universe Designer 4.0/XI 3.1

• Understanding Business-Objects Universes.
• Understanding how universes allow users to query databases using their everyday business terms.
• Creating Universe Connections.
• The course database and universe.
• Creating the universe.
• Building and populating the Universe Structure.
• Defining joins in a universe.
• Creating Dimension Objects.
• Understanding classes and objects.
• Creating Measure Objects.
• Understanding measure objects.
• Using List of Values.
• Resolving Loops.
• Resolving loops using aliases.
• Resolving loops using contexts.
• Chasm traps and Fan traps.
• Restricting the data returned by objects.
• Using Functions with Objects.
• Using @ Functions.
• Using Hierarchies.
• Working with hierarchies.
• Aggregate Awareness.
• Linking Universes.
• Creating links between universes.
• Securing Universes.
• Managing Universes.

Web-Intelligence Rich Client 4.0/XI R3
• Introducing Web Intelligence
• Accessing information with Web Intelligence
• Understanding how universes allow you to query databases using everyday business terms
• Create reports using webservises as a Data source
• Understanding Web Intelligence core functionalities
• Creating a document in the Web Intelligence Rich Client
• Viewing a Web Intelligence document in InfoView
• Creating Web Intelligence Documents with Queries
• Building a simple query
• Restricting data with query filters
• Applying a single-value query filter
• Using prompts to restrict data
• Using complex filters
• Report Design
• Working in the Report Panel
• Displaying data in tables and charts
• Presenting data in free-standing cells
• Enhancing the Presentation of Data in Reports
• Using breaks, calculations, and report filters
• Formatting breaks and crosstabs
• Using default and custom sorts
• Ranking data to see top or bottom values
• Tracking data changes
• Using alerters to highlight information
• Organizing a report into sections
• Copying data to other applications
• Formatting Reports
• Character and Date String Functions
• Using character string functions
• Concatenating different data types
• Using date functions
• Calculation Contexts
• Understanding calculation contexts
• Redefining calculation contexts
• Using If Logic
• Grouping data with If() logic
• Using IF/ELSEIF
• Additional Reporting Techniques
• Using data tracking
• Displaying data restricted by a filter or ranking
• Using additional report functions
Basic BO Administration (CMC)

• Understanding BusinessObjects Enterprise What is BusinessObjects Enterprise? Working in InfoView

• Working in the Central Management Console BusinessObjects Enterprise Architecture
• Understanding the BusinessObjects Enterprise architecture Busi nessObjects Enterprise Security
Creating users, groups, and folders The Busi nessObjects Enterprise security model
• Categories
• Guidelines for planning security
• Profiles
• Publishing
• Scheduling
Crystal Xcelsius Dashboard:

• Introducing Xcelsius with SAP
• Xcelsius Components
• Xcelsius and other connectivity options
• Xcelsius from Web service Report
• Creating a Model
• Adding Interactivity to Model
• Creating a Connected Model
• Creating complex dashboards
• Working with different components such as charts, maps, Guages, Labels etc.,
• Working with advanced options like Dynamic Visibility
• Creating Drill Down dashboard reports
• Connect to WebI reporting data to create Dashboard
• Creating Dashboards using QAAWS and Live office

Dashboard Designer