DW BOXI Contents

BOXI-R3.1

Introduction

* Datwarehouse concepts
* Differences between Versions 5.x/6/5/XI R1, R2, R3.
* Architecture of XIR2
* Business objects XIR3 Suite
* Extendibility of Business objects XIR3 (Introduction to BO-SAP Integration/Dashboard/Xcelsius/Query as Web Service)
* Role of Business objects in Data warehousing real time Life cycle
* New face of Business objects-MOLAP

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
* Creating 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
* Applying aggregate awareness to objects
* Using derived tables
* Applying index awareness
* Creating links between universes
* Setting access restrictions on a universe
* Documenting universes
* Deploying and maintaining universes

Advanced Designer

* Use your universe design to solve Business problems
* Business Objects Universe Designer knowledge to solve Business problems
* Define aggregate awareness
* Apply aggregate awareness to objects
* Combine database functions in objects
* Construct relative date-time objects
* Work with analytic functions
* 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 universes
* Optimize universes
* Apply best practices for universe design
* Create a universe from an XML metadata file
* Create stored procedure and JavaBeans universes
* Work with OLAP universes

Desktop Intelligence

* Introduction to desktop intelligence
* Zabo
* Report creation
* Publishing the report
* Report conversion(desktop) to (Webi)

Webi reporting

* Accessing information with Web Intelligence
* Understanding how universes allow you to query databases 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
* Presenting data in free-standing cells
* Using breaks, calculations, and report filters
* Formatting breaks and crosstabs
* Using default and custom sorts
* Ranking data to see top or bottom values
* Tracking data changes
* Using alerter to highlight information
* Organizing a report into sections
* Copying data to other applications
* Preparing documents 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 multiple 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
* Sharing documents in Info View
* Scheduling a Web Intelligence document
* Setting Info View preferences

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 contexts
* Using character string functions
* Using the Replace () function
* Using the Right () function
* Using the Substring () function
* Using the Pos () function
* Concatenating different character strings
* Using date functions
* Using If () to group data
* Using the If () function to modify calculation behavior
* Using data tracking
* Using additional report functions
* 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 of 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

Query Builder

* Using query builder to identify the objects ids
* Using query builder to build query on Bo objects

Migration of BO5/6.5.XIR1,R2 to XIR3

* What is migration
* Top challenges as you migrate
* What migrates and what does not
* Tools for migration
* The migration roadmap
* Assessment
* Installation
* Content import
* Post migration validation
* Administration
* BusinessObjects 5.x/6.x administration and security
* Creating a system backup
* Using the Import Wizard

Introduction to Performance Management

* What is Dashboard Manager
* Metrics
* Creating a Metric
* Rule
* Scheduler
* Analytic
* Creating simple dashboard

Data source Migration

* Migrating reports and data sources
* Migration options
* Modifying the migration settings

Import Wizard/Report Conversion

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

Publishing

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

Business view Manager

* Creating a Business View
* Using the Business View Manager
* Migrating the BusinessObjects Enterprise Repository
* Creating Data Connections
* Managing Business Elements

CMC/CCM/CMS

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

BO-SAP INTEGRATION

* Understanding common interfaces between BOXIR3 and SAP
* Installation and Integration methods
* Bringing the SAP environment in to BOXIR3 and vice versa.
* Working with SAP objects in BO (Info cubes/SAP Table)

BO-CRYSTAL INTEGRATION

* Understanding common interfaces between Crystal and SAP
* Installation and Integration methods
* Bringing the SAP environment in to Crystal 2008 and vice versa.
* Working with SAP objects in Crystal2008 (Info cubes/SAP Table)

CRYSTAL XCELSIUS

* Understanding crystal xcelsuis
* Creating templates
* Building query template in xcelsuis
* Creating scorecard and dashboard using xcelsuis

BO-WIDGETS

* Understanding widgets
* Creation of personal and corporate widgets
* Publishing the widgets to 3-tier environment

BO-HYPERLINKS

* Creating hyperlinks
* Creating child reports
* Embedding dynamic images or logos
* Linking webi and crystal report