Quantum Thoughts

New OBE Tutorial. Creating and querying OLAP cubes on 11g. Sample Schema Included.

Posted on: December 22, 2008

The first tutorial concerns the creation of cubes with the analytic workspace manage. More precisely as OBE article states.

In this tutorial, you use the Analytic Workspace Manager 11g (AWM 11g) tool to build an OLAP cube. You:
* Create a cube and its dependent components, including:
o Dimensions
o Measures (stored and calculated)
* Map the OLAP model to source data
* Enable MV rewrite to the cube
* Load data into the dimensions and measures
* View the OLAP data

The second one build on top of the first makes advanced use of the BI package to create and execute simple queries against the already existing cubes.

In this tutorial, you query OLAP data that was created using Analytic Workspace Manager 11g (AWM 11g). Using SQL Developer, you query OLAP cubes directly using SQL.

You learn how to create analytic reports of cube data, including both stored and calculated measures, and apply techniques that leverage unique characteristics of cubes.

Optionally, you learn how SQL summary queries against the relational fact table may be automatically re-written to the cube using Cube MVs.

A sample database schema can be found here. IMHO is a pretty good workout for vacations time plus that you wil get an idea of how analytic workspaces work on Oracle 11g.



Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

RSS Tweets

  • An error has occurred; the feed is probably down. Try again later.

RSS Reader Shared

  • An error has occurred; the feed is probably down. Try again later.

Flickr Photos

My Bookmarks

December 2008
« Aug   Jan »

Blog Stats

  • 82,941 hits
%d bloggers like this: