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

Workday HCM Demo New Batches Starting from Wednesday... 14-12-2016
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 Start From 14th DEC & 15th DEC.

Hadoop Dev New Batch Start From 15th DEC & 16th DEC.

IBM COGNOS TM New Batch Start From 16th DEC & 17th DEC.

Informatica Dev New Batch Start From 17th DEC & 18th DEC.

Mean Stack New Batch Start 18th DEC & 19th DEC.

SAP BODS new Batch Starting From 19th DEC & 20th DEC.

SAP S/4 HANA New Batch Start From 20th DEC & 21st DEC

Tableau New Batch Start From 21st DEC & 22nd DEC


(1) Workday Technical Demo Training

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

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