SAP BOBJ

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

Database Concepts needed for Data warehousing

Joins & Cardinality

Views/Materialized Views

Date/Time Functions

Conversion functions

Package

Derived table & Stored Procedure

BOXIR3 Architecture

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

Xcelsius(SAP Dashboard Design)

Creating a Model

Adding Interactivity to a Model

Creating a Connected Model

Connect to Crystal Reports data and create Dashboard

Connect to Web intelligence report data and

Create Dashboard

Connect to Business Objects Universes

Using Query as a web service and create Dashboard

Use Live Office data and create Dashboard

Use other connectivity components and create Dashboard

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

ZABO

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 InfoView

Working with queries in Web Intelligence Rich Client

Working with reports

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

OLAP Universe

Creation of OLAP Universe by connecting to an Info cube

Updating the OLAP Universe (Cube)

Creating the Custom Hierarchies in OLAP Universes.

Accessing multiple info cubes to create an OLAP Universe

Import Wizard\Publishing 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

View

Performance Management

Creation of Metric Universe

Creation of Metrics & Analytics

Creation of Dashboard using Metric

Creating Performance dashboards using set analysis

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

BO-SAP Integration Series

Understanding BO-SAP Integration kit

Configuring single sign on authentication

Creating SAP Authentication in BO

Importing the roles of SAP into BO

Entitlement settings of SAP & BO System

SAP Webi/Dashboard Reporting:

Creation of Web intelligence reports using Info cube & BW Query

Comparison of all BO Versions (5.x/6.5/XIR1/XIR2/XIR3)

Architecture changes

Report creation charges

Universe level changes

Security level changes

Addition of new features

Performance Tuning of Database w.r.t BO

BO Query tuning

BO Execution plan/Tracing

Combined Query

Views/Derived tables

Performance Tuning of BO

Universe Tuning

Webi report Tuning

Database Tuning

Deployment methods

Crystal reports tuning

BO Query optimization & Customizatio

Polestar/Business Explorer

Creating Polestar Reports

Configuring Pole star with BO Syste