SAP BO Course

SAP

SAP – BO COURSE CONTENT

1. 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.
2. 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
3. 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
4. Designing Topics We can Show by using Following Databases
   •  Oracle
   •  Ms-Access
   •  SqlServer
   •  TeraData
   •  External Files (Flat files)
   •  SAP BW
5. Desktop Intelligence:
   •  Introduction to desktop intelligence
   •  Report Creation
   •  Publishing the report
   •  Report conversation (desktop) to (Webi)
6. 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
7. 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
8. 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
9. 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
10. 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
11. Data source Migration
    •  Migrating reports and data sources
    •  Migration options
    •  Modifying the migration setting
12. 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)
13. Publishing
    •  Publish the Webi report between different CMS
    •  Publish the converted reports (deski to webi) to destination servers
    •  Publishing the repository objects
14. 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
15. 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)
16. Crystal Report 2008
    •  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
17. CRYSTAL XCELSIUS
    •  Understanding crystal xcelsius
    •  Creating templates
    •  Building query template in xcelsius
    •  Creating scorecard and dashboard using xcelsius
18. BO-VOYAGER
    •  Understanding Voyager
    •  Creation of personal and corporate voyager
    •  Publishing the voyager
    •  Importing cubes in voyager & Report Development
19. Bo-Administration
    •  Computer setup
    •  Business Objects Enterprise Architecture
    •  Creating Folders, Users and groups
    •  Publishing and configuring the servers
    •  Scheduling
20. Topic on Report Conversion Tools