ETL and Reporting - Business objects (BO): Major topics

Refresh on OLAP and Business Intelligence
Static reporting vs Ad hoc reporting
Business Objects and its components
Designer
Security
Business objects reporting
Universe Creation
BO universe and its advantages
Creating BO universe
simple model
creating a universe
how to add tables
cardinality
Derived tables etc
Classes and Objects
Working with Dimensions and Measures.
Object types
Dimension
Measure
Detail
Joins in BO
Normal Join
Theta Join
Shortcut join
Join Problems
Loops
Chasm trap
Fan trap
Functions
Working with list of Values and Hierarchies
How to test the Universe by creating certain reports and its SQL’s.
BO Reporting

BO reporting and advantages