SAP & IT Training

SAP Business Objects 4.1 Course Content

SAP Business Objects Web Intelligence

BI launch pad: What's new in 4.1
Customizing BI launch pad
Creating Interactive Analysis documents with queries
Restricting data returned by a query
Types of filters
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
Accessing corporate information with Web Intelligence
Understanding how universes allow you to query databases using everyday business terms.
Managing documents
Creating Web Intelligence Documents with Queries
Modifying a document's query
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
Character and Date String Functions Using the character string functions Concatenating different data types Using date functions
Using If Logic
Grouping data using If() logic
Using If() to modify calculation behavior
Advanced Reporting Features Formatting breaks
Creating custom sorts
Displaying document data in free-standing cells
Alternative Query Techniques Defining Combined Query Types Using Combined Queries
Using Sub-Queries
Creating a Query on a Query
Character and Date String Functions Understanding Character Strings
Linking to documents and URLs in Web Intelligence
Create the reports on top of Sap BEX queries

Web-Intelligence Rich Client 4.1

Introducing Web Intelligence
Create reports using webservises as a Data source
Using complex filters
Report Design
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
Preparing documents for PDF and print
Calculating Data with Formulas and Variables
Understanding formulas and variables
Understanding how Web Intelligence calculates data
Creating formulas and variables to calculate data
Using Multiple Data Sources
Adding a new query using a personal data provider
Creating multiple queries in a document
Synchronizing data with merged dimensions
Analyzing Data
Drilling into the data
Setting Web Intelligence drill options
Using sub-queries
Creating a query based on another query
Changing data sources
Using the query drill
Using query sampling
Understanding dimensions and details
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
Additional Reporting Techniques
Using data tracking
Displaying data restricted by a filter or ranking
Using additional report functions

Information Design Tool 4.1

What is the Information Design Tool (IDT)
Create a project
Create a connection to a relational database (Single and Multiple databases)
Create the data foundation with Single & Multiple databases
Define the different types joins in a data foundation
Create a business layer
Create folders and objects
Resolve Loops and Use alias
Resolve Loops Use contexts
Resolving the fan traps and Chasm traps problem
Define data restrictions
Work with LOVs
Use Parameters restrict data
Use @functions also Aggregate Awareness
Create Derived Tables and Index Awareness
Maintain universes
Deploy and manage and maintain universes
Documentation of the universes
SAP BW Integration with BO
Creating OLAP Connection(Using BICS middleware)

Universe Designer Tool 4.1

Understanding Business-Objects Universes.
Understanding how universes allow users to query databases using their everyday business terms.
Creating Universe Connections.
Creating the universe on different databases
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.
Derived Tables
Securing Universes.
Managing Universes.

BO Administration (CMC)

Understanding BusinessObjects Enterprise What is BusinessObjects Enterprise?
Installation and configuration
Managing all servers
Configure the Audit databases to monitor BO server health Checkup
Working in the Central Management Console BusinessObjects Enterprise Architecture
BO Cluster Setup and maintaining the load balancing
Understanding the Business Objects Enterprise architecture Enterprise Security Creating users, groups, and folders
BusinessObjects Enterprise security model
Guidelines for planning security
Configuring the FTP and SMTP Server
Setting up groups and users
Organizing and changing Folders & Categories
Controlling Universes
Scheduling through CMC
User Security
Database Configuration
Modify Settings for Applications
Access Levels
Managing Content in Multiple Deployments
Understanding the Import Wizard
Understanding Upgrade Management Tool

SAP Business Objects Dashboards 4.1 (4hrs)

Xcelsius Dashboard Overview
Creating Dashboards using Query As A Web Service (QAAWS) and Live Office
Create Drill Down dashboard reports
What's new in SAP Business Objects Dashboards 4.1
Creating a Visualization
Producing interactive visualizations
Getting around in Xcelsius
Working with your Excel workbook
Visualizing data with charts
Using Xcelsius Components
Formatting a Visualization
Applying formatting options
Using themes and templates to apply formatting
Adding Interactivity to a Visualization
Using selectors
Adding dynamic visibility
Using live data sources
Connecting to BO Universes using Query as a Web Service
Using Live Office data
Creating Complex dashboards

SAP Crystal Reports 2011 (2hrs)

Crystal Report Overview
Creating reports
Selecting records
Organizing data on reports
Grouping & section formatting
Creating basic and complex formulas
Using variables
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 data sources
Report processing
Linking Crystal Reports to Webi reports
Drill down reports
Quick Enquiry