Mail :
India : +91-8143-111-555
USA : +1-703-445-4802
uk : +44-20-3287-2021
Whats app : +91-8143-110-555
Facebook Twitter Google Plus Pinit Stumbleupon Youtube Blog Blog

Workday HCM Demo New Batches Starting from Friday... 30-3-2018
Search Course Here

Live Chat
Oracle OLAP  Online Training

Oracle OLAP


Oracle OLAP is a world class multidimensional analytic engine embedded in Oracle Database 11g. Oracle OLAP cubes deliver sophisticated calculations using simple SQL queries producing results with speed of thought response times. This outstanding query performance may be leveraged transparently when deploying OLAP cubes as materialized views enhancing the performance of summary queries against detail relational tables
  • All attendees should have
    • Basic SQL knowledge
    • A basic understanding of OLAP concepts.
  • It is a 12 days program and extends up to 2hrs each.
  • The format is 40% theory, 60% Hands-on.

  • It is a 3 days program and extends up to 8hrs each.
  • The format is 40% theory, 60% Hands-on.
    Private Classroom arranged on request and minimum attendies for batch is 4.
course content
  • 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
Oracle OLAP videos will be updated soon
To Watch More Videos Click Here

Flash News

AngularJS New Batch Starting From 8th April & 9th April.

Hadoop Dev New Batch Starting From 8th April & 9th April.

IBM COGNOS TM New Batch Starting From 8th April & 9th April.

Informatica Dev New Batch Starting From 8th April & 9th April.

Mean Stack New Batch Starting From 8th April & 9th April.

SAP BODS new Batch Starting From 8th April & 9th April.

SAP S/4 HANA New Batch Starting From 8th April & 9th April.

Tableau New Batch Starting From 8th April & 9th April.


(1) Workday Technical Demo Training

Demo Schedule : 09:30 P.M EST / 08:30 P.M CST / 6:30 P.M PST on 13th April & 07:00 A.M IST on 14th April

Email :
Rediff Bol :
Google Talk :
MSN Messenger :
Yahoo Messenger :
Skype Talk :