SAP Business Objects

DWH Architecture
DWH Characteristics
Evolutions of Data warehousing
Data Modeling
ER Modeling
Dimension Modeling
Schema (Star ,Snow Flack & Galaxy)
Fact Tables
Dimension Tables
Slowly Changing Dimension (SCD)
OLTP Vs OLAP
Oracle/Database/SQL Concepts

Introduction to Oracle
Data Types
SQL Statements
Constraints
Functions
SELECT statement usage
Joins
Set operators
Sub Queries
Performance Tuning Tips & Tricks

SAP Business Objects

Introduction to Business Objects
Business Objects – Architecture
Installation & Configuration of SAP Business Objects
Business Objects – components and there usage
Business Objects – Versions
New features in SAP Business Objects

Components

Designer
Infoview
Web I reporting
Web I Rich Client
Desk I Reporting
Live Office
QAAWS( Query As A Web Service) Xcelsius – 2008
Import Wizard, CCM ( Central Configuration Manager )
CMC ( Central Management Console )
Crystal Report Basics
Translation Manager
Report Conversion Tool

Universe development

Connections
Universe Creation
Table Browser
BO Joins
Join Problems
Loops
Traps
Alias
Context
Derived Tables
Universe Parameters
Universe Linking
Class, Objects, Condition Objects and Prompts
Cascading LOVs
Aggregate Awareness
Aggregate Navigation and Hierarchies
Securities and Check Integrity
Performance Tuning Tips & Tricks

Reporting: ( Web I,Desk I,Web I Rich Client & Xcelsius)

Simple Adhoc Report creation on Universe
Report creation on Personal Files
Cross Tab Reports, Charts
Repot level Filters, Report level Prompts
Combined Queries, Custom SQL and Functions
Merge Dimensions, Drill Reports
Variable Creation, Filters and Input Controls
Track, Break, Sections, Sort and Alerts
Rank, Purge, Report Properties and Hyperlinks
Charts, QAAWS Connection and Live Office Connection
Xcelsius Dashboard Reporting and Dashboards
Performance Tuning

Administration

User Creation
Groups Creation
Assigning Privileges
Handling the services
Scheduling
Report Bursting