SAP Business Objects ( BO )

WHAT IS IT ABOUT ?

SAP Business Objects (SAP BO / BOBJ) is a flagship product delivering reporting and analysis for SAP Applications. SAP Business Objects has a range of tools to deliver reporting in various different types through which the enterprise can view and share information efficiently. SAP BO can also work as a reporting layer for SAP BW application. The course also focuses on how SAP BO can be integrated with SAP BI. SAP Business Objects BI 4.1 offers a more consistent and unified interface, which will allow users to seamlessly move between applications. A key feature is that most products now offer a ribbon menu, similar to that in Microsoft Office, from which most functionality is available.

Course Overview

Who is it for ?


  • IT Analysts
  • Any programming language specialists
  • Reporting Analyst
  • Any one working on Reports and Data
  • Database Administrators
  • BW Consultants

Pre Requisites


  • Knowledge / Experience of SAP BW will be beneficial

What will you learn ?


1. Introduction:

  • Understanding BusinessObjects Enterprise
  • What is BusinessObjects Enterprise?
  • Working with SAP BO Launchpad ( Infoview)

2. SAP Business Objects Web Intelligence and BI Launch Pad 4.1 

  • 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
  • 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
  • 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 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
  • 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

 3. Information Design Tool 4.0 

  • 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

4. Universe Designer Tool 4.0 

  • 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

5. SAP Business Objects Dashboards 4.0 (Crystal Xcelsius 2011)

  • 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 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

6. SAP Crystal Reports 2011 

  • Creating reports
  • Selecting records
  • Organizing data on reports
  • Formatting & 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 and repository data sources
  • Report processing
  • Linking Crystal Reports to Webi reports
  • Drill down reports