Book a Free Consultation

Understanding Business Objects Enterprise
What is Business Objects Enterprise?
Working with SAP BO Launchpad ( Infoview)

SAP Business Objects Dashboards 4.1
BI launch pad: What’s new in 4.1
Restricting data returned by a query
Enhancing the presentation of data in reports
Formatting reports
Calculating data with formulas and variables
Using multiple data sources
Analysing data
Managing and sharing Interactive Analysis documents
Reporting from Other Data Sources
Introducing Web Intelligence
Accessing corporate information with Web Intelligence
Understanding how universe allow you to query databases using everyday business terms.
Managing documents in InfoView
Viewing a Web Intelligence document in InfoView
Setting Info View 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 alerts to highlight information
Organising 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 behaviour
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
Using Date Functions User-Defined Objects Creating User Objects
Using a User Object in a Query
Editing a User Object Deleting a User Object Storing a User Object Grouping Data

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

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.
Derived Tables
Securing Universes.
Managing Universes

Crystal Xcelsius 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.0 Creating a Visualisation
Producing interactive visualisations
Getting around in Xcelsius
Working with your Excel workbook
Visualising data with charts
Using Xcelsius Components
Formatting a Visualisation
Applying formatting options
Using themes and templates to apply formatting
Adding Interactivity to a Visualisation
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

Creating reports
Selecting records
Organising data on reports
Formatting & section formatting
Creating basic and complex formulas
Using variables
Using report templates
Applying conditional reporting
Building parameterised and specialised reports
Summarising data with crosstabs
Using report sections
Representing data visually
Managing reports
Distributing reports
Using repository and repository data sources
Report processing
Linking Crystal Reports to Web reports
Drill down reports