SAP BO Online Training

What is Business Objects

Business Objects  is a French enterprise software company, specializing in business intelligence (BI). Since 2007, it has been a part of SAP AG. The company claimed more than 46,000 customers worldwide in its final earnings release. Its flagship product is BusinessObjects XI, with components that provide performance management, planning, reporting, query and analysis and enterprise information management. Business Objects also offers consulting and education services to help customers deploy its business intelligence projects.

SAP BusinessObjects offers a broad portfolio of tools and applications designed to help you optimize business performance by connecting people, information, and businesses across business networks.

Business Objects Course Content

DATA WAREHOUSING/DIMENSIONAL MODELING PRACTICAL CONCEPTS

  • OLTP vs. OLAP
  • Types of OLAP
  • Dimensional modeling
  • Data mart/Data warehouse Life cycle
  • Star/Snow/Extended Star schema design

DATABASE CONCEPTS NEEDED FOR DATA WAREHOUSING

  • Joins & Cardinality
  • Views/Materialized Views
  • Date/Time Functions
  • Conversion functions
  • Derived table & Stored Procedure

ARCHITECTURAL OVERVIEW

  • Client tier components
  • Application tier components
  • Intelligence tier
  • Processing tier
  • Data tier
  • Security management
  • Information flow

UNIVERSE DESIGN

  • Understanding Business Objects Universes
  • Creating the Course Universe
  • Building the Universe Structure
  • Creating Dimension Objects
  • Creating Measure Objects
  • Resolving Loops in a Universe
  • Resolving SQL Traps
  • Using List of Values
  • Applying Restrictions on Objects
  • Using @Functions with Objects
  • Using Hierarchies
  • Deriving Tables & Indexes
  • Working with Aggregate Awareness
  • Designing Advanced Objects
  • Creating Predefined Condition
  • LOVs & Joins
  • Securing Universes
  • Implementing Universe Life Cycle Mgmt
  • Maintaining & Optimizing Universes
  • Creating Universe from Other Data sources

WEB INTELLIGENCE

  • Understand concepts of Web intelligence
  • Create Web Intelligence documents with Queries
  • Restrict data returned by a query
  • Design a report
  • Enhance the presentation of data in reports
  • Format a report
  • Calculate data with formulas and variables
  • Use multiple data sources
  • Analyze data
  • Manage and share Web Intelligence documents
  • Work with Advanced Query techniques
  • Work with calculation contexts
  • Create formulas with character & date string functions
  • Use “If” logic
  • Work with additional reporting techniques
  • Create hyperlinks

CRYSTAL REPORTS

  • Planning a Report
  • Selecting Records
  • Formatting a Report
  • Representing Data Visually
  • Distributing Reports
  • Creating Basic Formulas
  • Organizing Data on a Report
  • Applying Section Formatting
  • Applying Conditional Reporting
  • Using the Repository
  • Using Report Templates
  • Creating Formulas
  • Building Parameterized Reports
  • Summarizing Data with Cross-Tabs
  • Using Report Sections
  • Managing Reports
  • Presenting Data Visually
  • Add hyperlinks to a report

DASHBOARD BUILDER

  • Understanding Dashboard Manager
  • Setting Up Dashboard Manager
  • Creating Metrics
  • Automating Dashboards with Rules
  • Creating Analytics
  • Creating Personal Dashboards
  • Creating Corporate Dashboards
  • Guiding Dashboard Navigation

MIGRATION TO BOXIR3

MIGRATION FUNDAMENTALS

  • How Business Objects Enterprise XI 3.0
  • Migration concepts
  • Import Wizard Concepts
  • Understanding object migration
  • Understanding user and group migration
  • Migration planning and assessment
  • After migration with the Import Wizard

ADMINISTRATION

  • Understand the Business Objects
  • Enterprise interface & architecture
  • Manage Business Objects Enterprise content
  • Secure Business Objects Enterprise content
  • Secure application security
  • Schedule content
  • Publish reports
  • Identify Business Objects Enterprise architecture
  • Perform common server management tasks
  • Manage the Business Objects Enterprise servers

WIDGETS

  • Installing BI Widgets
  • Using BI Widgets to Access BI Content
  • working with widgets
  • BI Widgets Content Authoring Guidelines
  • Auto refresh of Widgets

DESKTOP INTELLIGENCE

  • Introduction to desktop intelligence
  • Scope of analysis
  • Report creation
  • saving the reports in local repository
  • publishing the report
  • Report conversion (desktop) to (Webi)

WEBI-RICH CLIENT

  • Installing Web Intelligence Rich Client
  • Web Intelligence Rich Client working modes
  • Launching Web Intelligence Rich Client
  • To set user preferences in Web Intelligence Rich Client
  • Working with documents
  • Working with universes in Web Intelligence Rich Client
  • Accessing Web Intelligence from Info View
  • Working with queries in Web Intelligence Rich Client
  • Working with reports

UNIVERSE BUILDER & QUERY BUILDER

  • Universe Builder basics
  • Building universes from XML metadata sources
  • Updating XML metadata source universes
  • Exporting a universe to a XML file format

QUERY AS WEB SERVICE

  • Configuring the QWS with BO System
  • Creating Web service report from Universes
  • Creating WSDL reports
  • Using WSDL reports in external application

VOYAGER

  • Getting Started with Business Objects Voyager
  • Using Queries to Analyze Cube Data
  • Using Charts to Visualize Data
  • Selecting Members to Display in Crosstabs and Charts
  • Sorting, Filtering, and Ranking Data
  • Highlighting Exceptions in Data
  • Saving and Sharing Voyager Workspaces

SECURITY IMPLEMENTATION

  • Creating Secured users & group
  • Creation secured connections
  • Creation of Secured objects
  • Creation of security at Table, Column &row level
  • Creation of secured restriction set and mapping to users or groups

IMPORT WIZARDPUBLISHING WIZARD

  • Using Import wizard
  • Creation of BIAR
  • Migrating the BO objects
  • From one CMS TO ANOTHER CMS
  • Migrating the objects from one
  • Domain to another (dev/stage/Prod)
  • Backup & Maintenance Deployment

BUSINESS VIEW MANAGER

  • Creation of Semantic layer for Crystal reports
  • Creation of Dynamic list of values in Crystal reports
  • Creation of Cascading list of values in Crystal reports
  • Creating Data connection and Dynamic data connection
  • Creation of Data foundation
  • Creation of Business Element
  • Creation of Business View
  • Creation of LOV
  • Saving the Business view to repository
  • Accessing the Business View in Crystal reports using Database expert
  • Creation of Crystal reports using Business

LIVE OFFICE REPORTING

  • Describe the benefits of using Live Office
  • Connect to the repository
  • Navigate the Live Office menu
  • Insert charts, crosstabs, and fields from a Crystal report
  • Insert report parts from a Web Intelligence document
  • Insert a new query based on a Universe
  • Insert Live Office objects into an email
  • Navigate and refresh Live Office objects
  • Enable consolidated prompts
  • Set refresh settings for objects
  • Set parameter binding
  • Take a snapshot
  • Save Live Office documents to the repository
  • Open and view Live Office documents from the repository

SAP WEBI/DASHBOARD REPORTING

  • Creation of Web intelligence reports using Info cube & BW Query

INTRODUCTION TO BO-SDK

  • Introduction of BO Enterprise SDK
  • Choosing the right SDK
  • Customizing the Webi reports using SDK

INTRODUCTION TO BO EXTENSION POINTS

HOW TO USE & LEVERAGE BO EXTENSION POINTS IN BUSINESS OBJECTS

  • Comparison of all BO Versions (5.x/6.5/XIR1/XIR2/XIR3)
  • Performance Tuning of Database w.r.t BO
  • Installation of BOXIR3 suite with System/Audit/Performance mgmt repositories
  • Using Oracle/SQLSERVER/SAPBW
  • Testing & Migration of BO components from Dev/Stage/Production environment

BO XI R3 CERTIFICATION GUIDELINES

  • Sample questions on Business Objects Certified Professional – Business Objects Web

INTELLIGENCE XI 3.0 – LEVEL ONE

  • Sample questions on Business Objects Certified Professional – Business Objects Web
  • Intelligence XI 3.0 –Level two