Course Content
INTRODUCTION
- Data WareHouse 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.
Universe 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
Desktop Intelligence:
- Introduction to desktop intelligence
- Report Creation
- Publishing the report
- Report conversation (desktop) to (Webi)
Web Intelligence 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
Live Office
- What is live office and features
- How to represent the data in the live office
- Connecting Webi, Deski, Crystal reports from live office Creation of Live office
- Creation of manual calculations and prompts in live office
- Refreshing the live office documents
- Publishing the live office docs in to Info view
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-enterprises Portal
- Scheduling
Webi Rich Client
- Use of Web rich Client and Features
- Creation of Web rich document
- Publishing the report
- Creation of Webi Rich client using Personal files and Universes
SAP Business Objects Dashboard builder with SAPBI
- Understanding Dashboard Manager
- Setting up Dashboard Manager
- Creating a Personal Dashboard &
Corporate Dashboard
- Automating Dashboard with rules
