Duration : 50 Hours
DATA WAREHOUSING/DIMENSIONAL MODELING PRACTICAL CONCEPTS
OLTP vs. OLAP
Types of OLAP
Dimensional modeling
Data mart/Data warehouse Life cycle
Star/Snow/Extended Star schema design
Introduction to SAP Business Objects
DATABASE CONCEPTS NEEDED FOR DATA WAREHOUSING
Joins & Cardinality
Views/Materialized Views
Date/Time Functions
Conversion functions
Derived table & Stored Procedure
ARCHITECTURAL OVERVIEW
Client tier components
Application tier components
Intelligence tier
Processing tier
Data tier
Security management
Information flow
UNIVERSE DESIGN
Understanding Business Objects Universes
Creating the Course Universe
Building the Universe Structure
Creating Dimension Objects
Creating Measure Objects
Resolving Loops in a Universe
Resolving SQL Traps
Using List of Values
Applying Restrictions on Objects
Using @Functions with Objects
Using Hierarchies
Deriving Tables & Indexes
Working with Aggregate Awareness
Designing Advanced Objects
Creating Predefined Condition
LOVs & Joins
Securing Universes
Implementing Universe Life Cycle Mgmt
Maintaining & Optimizing Universes
Creating Universe from Other Data sources
WEB INTELLIGENCE
Understand concepts of Web intelligence
Create Web Intelligence documents with Queries
Restrict data returned by a query
Design a report
Enhance the presentation of data in reports
Format a report
Calculate data with formulas and variables
Use multiple data sources
Analyze data
Manage and share Web Intelligence documents
Work with Advanced Query techniques
Work with calculation contexts
Create formulas with character & date string functions
Use “If” logic
Work with additional reporting techniques
Create hyperlinks
CRYSTAL REPORTS
Planning a Report
Selecting Records
Formatting a Report
Representing Data Visually
Distributing Reports
Creating Basic Formulas
Organizing Data on a Report
Applying Section Formatting
Applying Conditional Reporting
Using the Repository
Using Report Templates
Creating Formulas
Building Parameterized Reports
Summarizing Data with Cross-Tabs
Using Report Sections
Managing Reports
Presenting Data Visually
Add hyperlinks to a report
DASHBOARD BUILDER
Understanding Dashboard Manager
Setting Up Dashboard Manager
Creating Metrics
Automating Dashboards with Rules
Creating Analytics
Creating Personal Dashboards
Creating Corporate Dashboards
Guiding Dashboard Navigation
MIGRATION TO BOXIR3
MIGRATION FUNDAMENTALS
How Business Objects Enterprise XI 3.0
Migration concepts
Import Wizard Concepts
Understanding object migration
Understanding user and group migration
Migration planning and assessment
After migration with the Import Wizard
ADMINISTRATION
Understand the Business Objects
Enterprise interface & architecture
Manage Business Objects Enterprise content
Secure Business Objects Enterprise content
Secure application security
Schedule content
Publish reports
Identify Business Objects Enterprise architecture
Perform common server management tasks
Manage the Business Objects Enterprise servers
WIDGETS
Installing BI Widgets
Using BI Widgets to Access BI Content
working with widgets
BI Widgets Content Authoring Guidelines
Auto refresh of Widgets
DESKTOP INTELLIGENCE
Introduction to desktop intelligence
Scope of analysis
Report creation
saving the reports in local repository
publishing the report
Report conversion (desktop) to (Webi)
WEBI-RICH CLIENT
Installing Web Intelligence Rich Client
Web Intelligence Rich Client working modes
Launching Web Intelligence Rich Client
To set user preferences in Web Intelligence Rich Client
Working with documents
Working with universes in Web Intelligence Rich Client
Accessing Web Intelligence from Info View
Working with queries in Web Intelligence Rich Client
Working with reports
UNIVERSE BUILDER & QUERY BUILDER
Universe Builder basics
Building universes from XML metadata sources
Updating XML metadata source universes
Exporting a universe to a XML file format
QUERY AS WEB SERVICE
Configuring the QWS with BO System
Creating Webservice report from Universes
Creating WSDL reports
Using WSDL reports in external application
VOYAGER
Getting Started with Business Objects Voyager
Using Queries to Analyze Cube Data
Using Charts to Visualize Data
Selecting Members to Display in Crosstabs and Charts
Sorting, Filtering, and Ranking Data
Highlighting Exceptions in Data
Saving and Sharing Voyager Workspaces
SECURITY IMPLEMENTATION
Creating Secured users & group
Creation secured connections
Creation of Secured objects
Creation of security at Table, Column &row level
Creation of secured restriction set and mapping to users or groups
IMPORT WIZARDPUBLISHING WIZARD
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)
Backup & Maintenance Deployment
BUSINESS VIEW MANAGER
Creation of Semantic layer for Crystal reports
Creation of Dynamic list of values in Crystal reports
Creation of Cascading list of values in Crystal reports
Creating Data connection and Dynamic data connection
Creation of Data foundation
Creation of Business Element
Creation of Business View
Creation of LOV
Saving the Business view to repository
Accessing the Business View in Crystal reports using Database expert
Creation of Crystal reports using Business
LIVE OFFICE REPORTING
Describe the benefits of using Live Office
Connect to the repository
Navigate the Live Office menu
Insert charts, crosstabs, and fields from a Crystal report
Insert report parts from a Web Intelligence document
Insert a new query based on a Universe
Insert Live Office objects into an email
Navigate and refresh Live Office objects
Enable consolidated prompts
Set refresh settings for objects
Set parameter binding
Take a snapshot
Save Live Office documents to the repository
Open and view Live Office documents from the repository
SAP WEBI/DASHBOARD REPORTING:
Creation of Web intelligence reports using Info cube & BW Query
INTRODUCTION TO BO-SDK
Introduction of BO Enterprise SDK
Choosing the right SDK
Customizing the Webi reports using SDK
INTRODUCTION TO BO EXTENSION POINTS
HOW TO USE & LEVERAGE BO EXTENSION POINTS IN BUSINESS OBJECTS
Comparison of all BO Versions (5.x/6.5/XIR1/XIR2/XIR3)
Performance Tuning of Database w.r.t BO
Installation of BOXIR3 suite with System/Audit/Performance mgmt repositories
Using Oracle/SQLSERVER/SAPBW
Testing & Migration of BO components from Dev/Stage/Production environment
BO XI R3 CERTIFICATION GUIDELINES:
Sample questions on Business Objects Certified Professional – Business Objects Web
INTELLIGENCE XI 3.0 – LEVEL ONE
Sample questions on Business Objects Certified Professional – Business Objects Web
Intelligence XI 3.0 –Level two
