OBIEE Online Expert level by STAR IT TECHNOLOGIES

Repository Basics
- Exploring Oracle BI architecture components
- Exploring a repository s structure, features, and functions
- Using the Oracle BI Administration Tool
- Creating a repository
- Loading a repository into Oracle BI Server memory

Building the Physical Layer of a Repository
- Importing data sources
- Setting up connection pool properties
- Defining keys and joins
- Examining physical layer object properties
- Creating alias tables

Building the Business Model and Mapping Layer of a Repository
- Building a business model
- Building logical tables, columns, and sources
- Defining logical joins
- Building measures
- Examining business model object properties

Building the Presentation Layer of a Repository
- Exploring Presentation layer objects
- Creating Presentation layer objects
- Modifying Presentation layer objects
- Examining Presentation layer object properties

Testing and Validating a Repository
- Checking repository consistency
- Turning on logging
- Defining a repository in the initialization file
- Executing analyses to test a repository
- Inspecting the query log

Managing Logical Table Sources
- Adding multiple logical table sources to a logical table
- Specifying logical content

Adding Calculations to a Fact
- Creating new calculation measures based on existing logical columns
- Creating new calculation measures based on physical columns
- Creating new calculation measures using the Calculation Wizard
- Creating measures using functions