Skip to content

SQLMDX

Eventually it's all about data

  • About
  • Contact

Blogroll

  • Database Whisperers
  • Frits Hoogland
  • Jonathan Lewis
  • Miladin Modrakovic
  • Sayan Malakshinov
  • Tanel Poder

Categories

  • Oracle
  • Perl
  • PowerShell
  • Python
  • R
  • Scala

Archives

  • May 2020
  • April 2020
  • March 2020
  • July 2016
  • May 2016
  • March 2016
  • December 2015
  • October 2014
  • September 2014
  • May 2014
  • December 2013
  • November 2013
  • March 2011

Tags

12c 10053 built-in packages CBO differentiation domain indexes Extensible Indexing Extensible Optimizer external procedures internals materialized views OLAP parallel execution partitioning performance tuning regular expressions sqlplus sql trace transformations

OLAP

Oracle OLAP option. Quick dive.

There are quite a few tools and ways to build and manage cubes in Oracle so in this post I’ll try to clarify some concepts.
Good top level introduction could be found in article by Arup Nanda – Data Warehousing and OLAP.
Detailed step by step tutorial – Building OLAP Cubes.
The easiest way to start is to explore existing sample schema.
Continue reading →

Comment
March 26, 2016April 14, 2016 sqlmdx
OLAP
Create a website or blog at WordPress.com