O'Reilly logo

Oracle Business Intelligence: The Condensed Guide to Analysis and Reporting by Yuli Vasiliev

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Building dimensional data stores with Oracle Warehouse Builder

In the following sections, you'll learn how to build a sample warehouse with Oracle Warehouse Builder. In particular, you will learn how to perform the following:

  • Working with Design Center, the primary tool of Warehouse Builder
  • Creating a project for a warehouse
  • Defining source and target modules
  • Creating dimensions and cubes
  • Populating dimensions and cubes with data

Launching Design Center

On Windows, to launch Design Center, you can select Start | Programs | OWB_ORACLE_HOME | Warehouse Builder | Design Center from the Windows Start menu. On a Linux platform, run the following script OWB_ORACLE_HOME/owb/bin/unix/owbclient.sh.

As a result, you should see the Design Center Logon dialog ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required