In this Oracle OBIEE 11g training course, you will use the Oracle BI Administration Tool to build, manage, and maintain an Oracle BI repository. In this OBIEE training class you will learn several techniques to build a dimensional model to meet business intelligence requirements. This OBIEE course takes a close look at the Oracle BI Answers to build and execute queries, as well as test and verify a dimensional business model. You will learn the Oracle BI Administration Tool to manage the Oracle BI Server.
Course ID: OBI400
Duration: 5 days
Audience: Application developers,Reports developers,Oracle BI developer,Data Warehouse developers,Data warehouse administrators,Business analysts
Prerequisites: None
Topics:
|
Repository Introduction
- Oracle BI architecure
- Repository structure and features
- Oracle BI Administration Tool
- Creating a repository
- Loading a repository into memory
Building Repository Physical Layer
- Importing data sources
- Connection pools
- Keys and joins
- Physical layer object properties
- Tables and aliases
Business model and mapping layer
- Building a business model
- Logical tables, columns, and sources
- Logical joins
- Building measures
- Business model object properties
Repository presentation layer
- Exploring presentation layer objects
- Creating presentation layer objects
- Modifying presentation layer objects
- Examining presentation layer objects
Testing and validating repository
- Repository consistency
- Repository logging
- Defining repository in initialization file
- Testing repository with Oracle BI Answers
- Query log
Calculations
- Calculation based on existing logical column
- Calculation based on physical columns
- Calculation Wizard
Dimension hierarchies and level-based measures
- Dimension hierarchies
- Level-based measures
- Share measures
- Rank measures
Aggregates
- Introduction to aggregates
- Query performance with aggregates
- Testing aggregate navigation
- Aggregate Persistence Wizard
|
Partitions and fragments
- Introduction to partitions and fragments
- Partition types
- Modeling partitions in Oracle BI repository
Repository Variables
- Session variables
- Repository variables
- Initialization blocks
- Variable Manager
- Filtering with dynamic repository variables
Modeling time series data
- Time comparisons
- Oracle BI time series functions
Many-to-many relationships
- Using bridge tables
- Using helper tables
Implicit fact columns
- Adding fact columns to dimension-only queries
- Predetermined fact table sources
- Default join paths between dimension tables
Security
- Users and groups
- User and group permissions
- Authenticating with external database
- Authenticating with database authentication
- Query limits and timing restrictions
- Personalization using filters
Cache Management
- Non-cachable tables
- Cache Manager
- Cache reports
- Purging cache entries
- Modifying cache parameters and options
- Seeding the cache
Usage tracking
- Tracking and storing Oracle BI Server usage
- Usage tracking statistics
- Analyzing usage tracking reports
Multi-user development
- Setting up environment for multiple users
- Developing repository for multiple developers
- Tracking development project history
|
