SAP BO XI R/3 ONLINE TRAINING

INTRODUCTION:

·         Datwarehouse concepts

·         Difference between Versions 5.x/6/5/XI  R1, R2, R3

·         Business objects XIR3 Suite

·         Extendibility of Business objects XIR3 (Introduction to BO- SAP Intergration/Dashboard/Xcelsius/Query as Web Service)

·         Role of Business objects in Data warehousing real time life cycle.

Designer:

• Understanding how universes allow users to query databases using their everyday business terms
• Creating an ODBC connection to the course database
• Creating a universe
• Populating the universe structure
• Defining joins in a universe
• Understanding classes and objects
• Creating classes and objects
• Understanding measure objects
• Working with LOVs in Designer
• Creating a cascading LOV
• Resolving loops using aliases
• Resolving loops using shortcut joins
• Resolving loops using contexts
• Resolving chasm traps
• Resolving fan traps
• Restricting the data returned by objects
• Using @ Functions
• Working with hierarchies
• Using derived tables
• Creating links between universes
• Setting access restrictions on a universe
• Documenting universes
• Deploying and maintaining universes

Advanced Designer:

• Use your universe design and Business Objects Universe Designer knowledge to solve Business problems
• Define aggregate awareness
• Apply aggregate awareness to objects
• Combine database functions in objects
• Construct relative data-time objects
• Create complex predefined conditions
• Work with advanced LOVs
• Work with advanced join syntaxes
• Define connection and user credential parameters
• Work with Central Management Server (CMS) universe security
• Move content from development to production
• Maintain universe design
• Work with OLAP universes

Designing Topics We can Show by using Following Databases

• Oracle
• Ms-Access
• SqlServer
• TeraData
• External Files (Flat files)
• SAP BW

Desktop Intelligence:

• Introduction to desktop intelligence
• Report Creation
• Publishing the report
• Report conversation (desktop) to (Webi)

Webi Reporting:

• Accessing information with Web Intelligence
• Understanding how universes allow you to query database using everyday business terms
• Understanding Web Intelligence core functionalities
• Creating a document in the Web Intelligence Rich Client
• Viewing a Web Intelligence document in Info View
• Building a simple query
• Modifying a document query
• Working with query properties
• Restricting data with query filters
• Modifying a query with a predefined query filter
• Applying a single-value query filter
• Using prompts to restrict data
• Using complex filters
• Working in the Report Panel
• Displaying data in tables and charts
• Using breaks and cross tabs
• Formatting break, calculations, and report filters
• Formatting breaks and cross tabs
• Using default and custom sorts
• Ranking data to see top or bottom values
• Using alerter to highlight information
• Organizing a report into sections
• Copying data to other applications
• Preparing document for PDF and print
• Document formatting
• Formatting charts
• Understanding formulas and variables
• Understanding how Web Intelligence calculates data
• Creating formulas and variables to calculate data
• Adding a new query using a personal data provider
• Creating multiples queries in a document
• Synchronizing data with merged dimensions
• Analyzing the data cube
• Drilling into the data
• Setting Web Intelligence drill options
• Exporting documents from the Rich Client
• Accessing Info View
• Managing documents in Info View
• Scheduling a Web Intelligence document
• Setting Info View preference

Advanced Webi reporting:

• Using combined queries
• Using sub-queries
• Creating a query based on another query
• Changing data sources
• Understanding the impact of the query drill on performance
• Understanding calculation contexts
• Redefining calculation context
• Using character string functions
• Using the replace( ) function
• Using the right ( ) function
• Using the Substring ( ) function
• Using the Pos ( ) function
• Using If ( ) to group data
• Using data tracking
• Using additional report function
• Understanding the options for creating hyperlinks in Web Intelligence
• Creating hyperlinks in the different Web Intelligence interfaces

Webi rich client:

·         Web Intelligence Rich Client general preferences

·         To create a new document in Web Intelligence Rich Client without Universe

·         To select a universe in Web Intelligence Rich Client

·         How does Web Intelligence generate combined queries?

·         Scope of analysis

·         Levels of scope of analysis

·         To set the scope analysis

Query as Web service:

• Usage of Query as web service
• How to configure and use
• Viewing the Universe and Webi reports using web service

·         Viewing the Crystal XCelsius reports using web service

Introduction to Dashboard:

Creating Dashboards

Contents:

What is Dashboard Builder?

Creating an Analytic based on a Universe Query

Creating a Corporate Dashboards folder

Creating a pie chart based on sales of product lines

·         Selecting data for the pie chart

·         Saving your pie chart

Creating a bubble chart that compares product line sales to Revenues

·         Selecting data for the bubble chart

·         Saving your bubble chart

Scheduling an Analytic Refresh

·         Scheduling a refresh on your bubble chart

Designing a Corporate Dashboard

·         Analytics in dashboards

·         Set the dashboard preferences

·         Creating a dashboard

·         Add a text analytic to the dashboard

Creating a speedometer gauge that shows profit margins

·         What is a speedometer?

·         Getting Started Creating Dashboards

·         Selecting the data for the speedometer

Creating a dashboard tab that contains analytics

Creating a dashboard sub tab with web page and viewer analytics

·         Creating a sub tab

·         Adding a web page analytic to the sub tab

·         Adding a viewer to the dashboard sub tab

Data source Migration:

• Migrating reports and data sources
• Migration options
• Modifying the migration setting

Import Wizard / Report Conversation:

• Using Import wizard
• Creating of BIAR
• MIGRATING The BO objects from one CMS TO ANOTHER CMS
• Migrating the objects from one domain to another (dev/stage/Prod)

Publishing:

• Publish the Webi report between different CMS
• Publish the converted reports (deski to webi) to destination servers
• Publishing the repository objects

CMC/CCM/CMS:

• Introduction of Window and web based Central management in BOXIR3
• Roles and responsibilities of Contents of CCM/CMS/CMC
• When to use CCM/CMS/CMC
• Detail description of contents of CCM/CMS/CMC
• Case study

BO-SAP INTEGRATION:

• Understanding common interfaces between BOXIR3 and SAP
• Installation and Integration methods
• Bring the SAP environment in to BOXIR3 and vice versa
• Working with SAP objects in Crystal 2008 (Info cubes/SAP Table)

Crystal Report 2008

Crystal Reports:

• Introduction to Crystal Reports
• Creating Reports
• Selecting Records
• Organizing Data on Reports
• Formatting & Section Formatting
• Creating basic and complex formulas
• Using Variables and Arrays
• 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
• Using sub Reports
• Using Custom Functions
• How to Publish Crystal Report in Bo-Enterprise Portal
• Scheduling

CRYSTAL XCELSIUS:

• Understanding crystal xcelsius
• Creating templates
• Building query template in xcelsius
• Creating scorecard and dashboard using xcelsius

BO-VOYAGER:

• Understanding Voyager
• Creation of personal and corporate voyager
• Publishing the voyager
• Importing cubes in voyager & Report Development

Bo-Administration:

• Computer setup
• Business Objects Enterprise Architecture
• Creating Folders, Users and groups
• Publishing and configuring the servers
• Scheduling

 Topic on Report Conversion Tools

Reporting & Business Intelligence with

SAP and Business objects

Overview:

• SAP reporting difficulties
• SAP and non-SAP data sources
• Connectivity options BOXIR3-SAP/BOXIR3-SAPR3/BOXIR3-SAP Metadata.
• Publishing options BW Publisher

SAP Integration with BOX/IR3:

• Business Objects Enterprise XI Integration Kit for SAP Overview
• Understanding the Integration Kit for SAP
• Determining Which Features to Implement
• Supported Versions of SAP R/3 and SAP BW
• Installing and Configuring Business Objects Enterprise XI and the Integration Kit for SAP
• Configuring BO-SAP Environment
• Making single sign on Environment
• Authentication of Users in SAP R/3 and SAP BW Roles
• Required SAP R/3 and SAP BW Authorizations
• Configuring the Security Definition Editor for SAP R/3
• Creating Folders and Categories for Grouping SAP R/3 Content
• Leveraging SAP BW Integration to Create and Manage Folder for SAP BW Content
• Basic Troubleshooting of the Business Objects XI Integration Kit for SAP

SAP-BO Terminology:

SAPBO Universe Design:

• Creating a SAP BW OLAP Connection
• Modifying Connection Time Parameters
• Changing Universe Connection for a Target OLAP Data Source
• Creating a Universe that Accesses SAP BW
• Saving and Exporting a BW OLAP Universe
• Building the Universe Structure
• Creating Dimension Objects
• Creating Measure Objects
• Resolving Loops in a Universe
• Resolving SQL Traps
• Applying Restrictions on Objects
• Using @ functions with Objects

• Using Hierarchies
• Using Lists of Values
• Creating Derived Tables and Indexes
• Linking Universes

·         Applying Universe Access Restrictions

·         Managing Universes

·         Working with Aggregate Awareness

·         Designing Advanced Objects

·         Creating Complex Predefined Conditions, LOVs, and Joins

·         Securing Universes

·         Maintaining and Optimizing Universes

·         Creating Universes from Other Data Sources

Creating Crystal Reports from SAP BW Queries:

• Formatted Reporting
• Creating New Queries for the Crystal Reports
• Creating a Crystal Report based on a query
• Create a Crystal Report from SAP R/3 Tables
• Saving Crystal Report from SAP BW
• Applying Number, Currency, Date, Time and Date/Time Formatting
• Formatting Report Selections using the Section Expert
• Save and view report as SAP user in Info View
• Publishing SAP R/3-Based Crystal Reports
• Publishing SAP BW-Based Crystal Reports
• Batch Publishing of Crystal Reports from SAP BW to Business Objects Enterprise XI
• Migrating Crystal Reports Between SAP BW Environment
• Using Crystal Reports 2008 on Top of Simple SAP BW Queries
• Creating Reports with Hierarchies Derived from SAPBW
• Use SAP Variables with Crystal Reports 2008
• Creating Reports with Multiple Structures Derived from SAP BW
• Using Key data Variables with Crystal Reports 2008

SAPBO WEB INTELLIGENCE:

• Introducing Web Intelligence
• Creating Web Intelligence Documents with Queries
• Restricting data Returned by a Query
• Report Design
• Enhancing the Presentation of Data in Reports
• Formatting Reports
• Calculating Data with Formulas and variables
• Using Multiple Data Sources
• Analyzing Data
• Managing and Sharing Web Intelligence Documents
• Working with Advance Query Techniques
• Working with Calculation Contexts
• Creating Formulas with Character and Date String Functions
• Using If Logic
• Working with Additional Reporting Techniques
• Creating Hyperlinks

SAPBO-XCELSIUS:

• Introducing Crystal Xcelsius with SAP implementation options.
• Create a Crystal Xcelsius Dashboard from SAP data stored in a Microsoft Excel spreadsheet sourced through Crystal Reports or Web Intelligence
• Create a Crystal Xcelsius Dashboard fon SAP data stored in a Microsoft Excel Spreadsheet created through the use of live Office
• Create a Crystal Xcelsius Dashboard from SAP data stored in a Microsoft Excel spreadsheet
• Created through the use of query as a Web Service (QaaWS)
• Crystal Xcelsius Dashboards Using Analytics as part of Dashboard Manager
• Create an Analytic Dashboard from SAP data through a Universe

SAPBO-VOYGER:

• Getting Started with Business Objects Voyager
• Using Queries to Analyze Cube Data
• Highlighting Exceptions in Data
• Using Voyager with SAP
• Logging on to SAP
• Member Selector with SAP data
• Using variable
• Mandatory and optional variables
• Variable types
• More about variables
• Free characteristics
• Key figures and formatted values
• Formatting with no key figure
• Display attributes
• Compounded characteristics
• Mutually exclusive hierarchies
• SAP display attributes

SAPBO-WIDGETS:

• Installing BI Widgets
• Using BI Widgets to Access BI Content 19
• Login to Bi Widgets
• Locating content BI Content on one or more XI R3 servers
• Using BI Widgets Explorer to view contents
• Using BI Widgets with Xcelsius documents as a widgets
• Selecting and Opening a Web Intelligence Report
• Viewing a Web Intelligence Document
• Creating a Report Part Widget from a Report

SAPBO-DASHBOARD BUILDER

• Getting Started with Dashboard BUlider
• Creating Corporate Dashboards using Dashboards using Dashboard Builder
• Creating Personal Dashboards using Dashboard Builder
• Analyzing Dashboard Content
• Setting Dashboard Preferences in Info View
• Customizing Dashboards

SAPBO-LIVE OFFICE REPORTING:

• Getting Started with Live Office
• Inserting Live Office Objects from SAP BI Components
• Managing Live Office Objects
• Publishing and Viewing Live Office Documents
• Save Live Office documents to the repository
• Open and view Live Office documents from the repository

SAPBO-WEBSERVICES:

• Installing Query as a Web Service
• Launching the query as a Web Service Client Tool
• Creating and Publishing a Query as a Web Service for SAP OLAP Universe
• Managing Query as a Web Service & Consuming Query as a Web Service with Different Applications