When logging in to the OWB Design Center for the first time, you can create a Warehouse Builder user with which to log in. You create a new user, a new, highly privileged repository owner, and install the Warehouse Builder repository.

Select Start > Programs > {your Oracle - OWB10gR2clientHome} > Warehouse Builder > Design Center.

The Design Center Logon screen appears.

If the Get Started button is not visible, click Show Details. Click Get Started. The Welcome screen of the Repository Assistant Wizard appears. Click Next.

In the Install Type window, choose Basic Install. Click Next.

In the Repository User and Connection Information window, create a user named rep_user, by entering the following values:

Click Next.

In the Password Confirmation window, re-enter the password rep_user, and click OK.

In the Repository Owner Information window, if no existing owner is detected, Warehouse Builder offers a default owner name (such as OWB_10_1_2_3_31) on the basis of the Warehouse Builder version installed).

Instead, you can also provide your own owner name. The repository owner is a highly privileged Warehouse Builder user with access to additional security features. Enter rep_owner as username and password. Click Next.

Note: If you have already created another repository owner before this course, click Cancel to exit the Repository Assistant and create rep_owner now by invoking the Repository Assistant as follows:

1. Select Start > Programs > {your Oracle - OWBclientHome}> Warehouse Builder > Administration > Repository Assistant. Click Next on the Welcome Page.
2. Choose Advanced Setup and follow the prompts to create a new repository owner, naming it rep_owner. Then rerun steps 1 through 5.

The scripts in the following section assume the existence of rep_owner.

In the Password Confirmation window, re-enter the password rep_owner and click OK.

In the Summary window, examine the information and click Finish.

An Installation Progress window appears. The installation of the repository owner will take several minutes.

An Installation Successful window appears. Click OK. The Repository Assistant closes.

If the Design Center Logon window is still open, click Cancel to close it. In the Warehouse Builder Warning window, click Yes to quit Warehouse Builder. You will be logging in later in this lesson.

Before you can begin working with the lessons, you need to run the scripts from the owbdemo_files.zip file that you downloaded.

Log in to SQL*Plus as sys and run the create_users.sql script that you downloaded into the D:\newowbdemo folder.

To run the script, enter the following command at the SQL> prompt:

@d:\newowbdemo\create_users.sql;

Exit SQL*Plus.

Note: The create_users.sql script will create two users: xsales and eul_from_owb. If you plan to work with xsales source data, you need to import the xsales.dmp file that you downloaded and extracted from the xsales.zip file.

To import the dmp file, enter the following command at the DOS command prompt:

<ORACLE_HOME>\db_1\bin\imp xsales/xsales@<orcl or your database service name> file=<PATH>\xsales.dmp full=y

Substitute <ORACLE_HOME> with your Oracle home path and <PATH> with the location where you extracted the xsales.dmp file.

Note that the step of importing the xsales.dmp file is optional and only required of you want to use the xsales source data for your own examples.

Now you will run a set of tcl scripts to create a predefined OWB project. First, you need to edit the owbdemoinit.tcl script that defines and sets variables used by the other tcl scripts. The owbdemoinit.tcl script is provided to you with the following variables; edit them to match the values in your computer's environment:

set owbclient rep_owner
set owbclientpwd rep_owner
set sysuser sys
set syspwd sys
set host localhost
set port 1521
set service orcl
set project OWB_DEMO
set sourcedir d:/newowbdemo
set dataspace USERS
set indexspace USERS
set tempspace TEMP
set snapspace USERS
set sqlpath d:/oracle/10.2.0/db_1/BIN
set sid orcl

You need to set all the values shown in bold above, as per your database and Warehouse Builder setup.

Note: The scripts are written to run on default tablespaces. It is advised that you use default tablespaces for this hands-on. If you intend to run them on your own defined tablespaces you need to set them in this script as well as in multiple other scripts.

To run the tcl scripts, start the OMB Plus environment. There are two ways to start OMB Plus. Within the Design Center, select OMB Plus from the Window menu. Or select Start > Programs > [Oracle - OWB10gR2clientHome] > Warehouse Builder > OMB Plus.

On the OMB+> prompt, enter the cd command as shown below: (it is case sensitive):

cd d:\\newowbdemo\\

The cd command changes the working directory to the folder where you have unzipped the setup tcl scripts. After this command, enter the source command on the OMB+> prompt as shown below. The source command executes the loadall.tcl script that in turn runs all the other tcl scripts in desired sequence.

source loadall.tcl

Exit the OMB Plus environment.

The scripts have created a partially defined OWB project, OWB_DEMO, in which you will do your work.

Select Start > Programs > [Oracle - OWB10gR2clientHome] > Warehouse Builder > Administration. This displays the range of components that make up the OWB product.

Examine the menu choices:

Select Start > Programs > [Oracle - OWBclientHome] > Warehouse Builder > Design Center.

The Design Center Logon window appears. Enter rep_owner as username and password. By default, Connection details option is selected.

If you cannot see Connection details option, click Show Details.

Enter host as localhost or <name of your computer>, port as 1521, and service name as orcl or <your database service name>. Click OK.

The Design Center appears. The Design Center is divided into three panels: Project Explorer, Connection Explorer, and Global Explorer.

The Project Explorer on the left side contains two projects: MY_PROJECT, an empty project created when OWB is installed, and OWB_DEMO, a partially defined project that you created with the setup scripts.

A project is a container to manage your design work. After you create a project, you can create all the other Warehouse Builder objects.

Warehouse Builder contains wizards, object editors, property sheets, and object finding tools that assist you in designing your business intelligence system.

In the Project Explorer panel's navigation tree, expand the OWB_DEMO project. Various object types appear in the tree: Databases, Files, Applications, Data Profiles, and so on.

Expand the Databases node, and you see various object types that can be included in design of your warehouse: Oracle databases, non-Oracle databases, and transportable modules.

Expand the Oracle node, and you see two modules predefined by the setup scripts: SALES_WH and XSALES. Modules are logical groupings of source or target definitions.

Expand the SALES_WH module. The various object types appear in the tree: mappings, transformations, dimensions, cubes, tables, and so on. Expand some of these nodes to see the objects that have been predefined by the setup scripts.