TOPIC 2: SAP BUSINESS OBJECTS BI INFORMATION DESIGN TOOL 4.0
SAP BO Integration Kit
Installation & Configuration
SAP BO integrated solution
Server administration
SAP Authorization administration scenario
Topic: 2 Data Ware Housing Concepts
OLTP vs. OLAP
OLAP Types
Dimensional modeling
Star/Snow/Extended Star schema design
Data mart/Data warehouse Life cycle
Topic: 3 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
Topic: 4 SAP Business Objects
Introduction to Business Objects
Business Objects – Architecture
Installation & Configuration of SAP Business Objects
Business Objects – components and their usage
Business Objects – Versions
New features in SAP Business Objects
TOPIC 6:FILTERING DATA IN OBJECTS
OLTP vs. OLAP
OLAP Types
Dimensional modeling
Star/Snow/Extended Star schema design
Data mart/Data warehouse Life cycle
Topic: 5 Architectural Overview
Application tier components
Client tier components
Processing tier
Intelligence tier
Data tier
Information flow
Security management
Topic: 6 Universe Design
Understanding Business Objects Universes
Creating Dimension Objects
Resolving SQL Traps
Applying Restrictions on Objects
Using Hierarchies
Working with Aggregate Awareness
Creating Predefined Condition
Securing Universes
Maintaining & Optimizing Universes
Topic: 7 Universe Development
Connections
Universe Creation
Table Browser
BO Joins
Join Problems
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
Debugging
Topic: 8 Administration
User Creation
Groups Creation
Assigning Privileges
Handling the services
Scheduling
Report Bursting