Most business intelligence environments benefit from dimensional models that optimize relational query performance in the database. Warehouse Builder is unique in that you can also deploy to the multi-dimensional Oracle OLAP server. Use this session to learn about dimensional modeling with Warehouse Builder.
Level:
Intemediate
Coverage:
Versions 9.0.4, 9.2, 10g
Publication:
Online and hands-on
Intended audience:
Users who want to start leveraging the dimensional modeling features of Warehouse Builder.
Business intelligence architects, who want to use Warehouse Builder to design dimensional models.
Know some of the features Warehouse Builder provides that leverage Oracle database features.
Pre-requisites
Awareness of dimensional modeling concepts.
Content
Warehouse Builder enables the design of dimensions and cubes in the graphical environment. Generated code can be deployed to the relational database, but integration with Oracle OLAP server is provided as well. The materials below cover the dimensional design components. Refer to the related materials for deployment into the relational database and Oracle OLAP server.
Component
Version
Estimated Duration (h)
Delivery
Availability
Watch the Warehouse Builder dimensional modeling recorded demo online*
9.0.4 / 9.2 / 10g
0:10
March 2004
Go through Demo 2 - Dimensional Design - in the hands-on demo**
9.0.4
0:30***
March 2004
9.2 / 10g
0:30***
March 2004
* Note: you may have to disable your popup blocker in order to view the recorded demo.
** Note: you may want to go through the OWB self-service
education - installation session on how to setup Warehouse Builder.
*** Note: excluding setup, included in the demo document. Legend: = recorded, = online, = paper, = hands-on
Bookmark
= online, 
= paper, 
