SAP BO Report Development

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

 

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

If you have questions, please contact us at info@erpmastering.com .