OBIEE training in Hyderabad

Oracle Business Intelligence Enterprise Edition @ Sadguru technologies
OBIEE – ORACLE BUSINESS INTELLIGENCE ENTERPRISE EDITION COURSE CONTENT

1. OBIEE ADMINISTRATOR ARCHITECTURE:
ü Creation of the ODBC Data Source Name (System DSN) for different
Databases at Operating System Administrator
ü ODBC connectivity between Database and Oracle BI Administrator
ü Development of RPD(Repository Directory) file at OBI Administrator
2. REPOSITORY CREATION:
ü Physical layer: development of physical diagram (ROLAP) using physical objects.
ü Import tables from different databases
ü Connection pool verification
ü Working with type conversion and referential integrity in physical layer.
ü Working with new foreign key and complex join in Physical Diagram.
ü Business model and mapping layer (MOLAP):
Ø Development of logical diagram using logical fact tables and logical dimensional tables.
Ø For standard requirements (detailed),
Ø Multi dimensional requirements (summarized) using arithmetic operators, aggregate functions
Ø Case statement generation (IF statement, IF-ELSE statement, SWITCH statement
Ø Working with various join types( Inner, Left outer, Right outer and Full outer)
Ø Creation of global filters
ü Develop the dimensions for drill down analysis (multi dimensional Analysis)
ü Development Meta Data in Business Model for Business Requirements
ü Converting the technical columns information into end user vocabulary.
ü Overview of various facts (measures) in BMM layer.
ü Presentation layer: Divide or Recombine the Meta data created in the Business Model for easy analysis