SAP BO at MindMajix - Hyderabad

Data Ware Housing Concepts:
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
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 Object.
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 Mangement 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.
Prompts.
Cascading LOVs
Aggregate Awareness.
Aggregate Navigation.
Hierarchies.
Securities.
Check Integrity.
Performance Tuning Tips & Tricks
Debugging.
Reporting: ( Web I, Desk I, Web I Rich Client & Xcelsius):
Simple Ad hoc Report creation on Universe
Report creation on Personal Files.
Cross Tab Reports
Charts.
Repot level Filters.
Report level Prompts.
Combined Queries.
Custom SQL.
Functions.
Merge Dimensions.
Drill Reports.
Variable Creation.
Filters
Input Controls
Track
Break
Sections
Sort
Alerts
Rank
Purge
Report Properties
Hyperlinks
Charts.
QAAWS Connection.
Live Office Connection.
Xcelsius Dashboard Reporting.
Dashboards
Performance Tuning
Administration:
User Creation.
Groups Creation.
Assigning Privileges.
Handling the services.
Scheduling.
Report Bursting.