Using the Connection Wizard to set up an ASO cube

In this recipe, we will create a Data Source and minischema for the ASOsamp application. We will also set up joins for tables that have a recursive relationship, and identify the dimensions, attributes, and fact tables in our model. Finally, we will review why the ASO model is a good choice for the ASOsamp application.

Getting ready

To get started, open SQL Server Management Studio, and add a database called ASOsamp. We are using the SQL Server scripts in this example, but Oracle PL SQL scripts are available as well.

How to do it...

1. Open up SQL Server Management Studio, click on the ASOsamp database, click on the File menu, select Open, and click on File ….

2. Open the script, 3265_04_01tsql.sql.

3. Make sure that ASOsamp is selected in your Available Database window.

4. Click on Execute.

5. Click on the File menu, and then on Open, and click on File…. Open the script 3265_04_01_sampledata.sql.

6. Make sure that ASOsamp is selected in your Available Database window...