Detailed Course Outline
Examining the Role of Oracle OLAP within the Oracle BI / DW Platform
- Oracle OLAP and the Oracle BI / DW Platform
- Features of the Oracle OLAP Option
- Accessing Oracle 11g OLAP data
Understanding the Dimensional Model
- Stored and Calculated Measures
- Dimensions
- Hierarchies
- Levels
- Attributes
Building OLAP Cubes
- Using the Cube Building Tool
- Creating Dimensions
- Designing Cubes
- Creating Measures
- Mapping to Source Data
- Loading Data
Examining Cube-Organized Materialized Views (Cube MVs)
- Benefits of Cube MV Summary Management
- General Requirements for rewrite to MVs
- Designing Cube MVs
- Using Cube MVs
Creating Calculated Measures
- Examining OLAP Calculation Types
- Using the Calculation Builder
- Creating Common Business Calculations
- Creating Custom Calculations
Using SQL to Query Oracle OLAP Cubes
- Understanding Cube Views
- Querying OLAP Cubes: The Basics
- Leveraging Cube Summaries
- Applying Query Filters
- Joining OLAP and Relational Data
Enhancing Analytic Content
- Creating Cubes with Varying Dimensionality
- Integrating Measures from Data with Different Dimensionality
- Creating Forecast Measures Using OLAP DML
Using Ad Hoc Query and Reporting Tools Against OLAP Data
- Exploring OLAP Data Using Oracle Application Express (APEX)
- Performing Ad Hoc Query of OLAP Data Using Oracle BI Answers
- Examining Metadata Requirements for BI Tools
Implementing Cube Security
- Understanding Authentication Requirements
- Authorizing Access to Cube Data
- Examining User and Object Privileges
- Examining Methods for Scoping User Views of Data
Designing Cubes for Performance and Scalability
- Objectives of Performant and Scalable Design
- Examining how Data is Stored in Oracle Cubes
- Identifying Cube Features that Impact Performance and Scalability
- Implementing Design Techniques for Performance and Scalability
Examining Performance Tuning
- Describing How Cubes are Stored
- Understand Cube Build Processing
- Examining Balanced Configurations
- Correcting Performance Bottlenecks