O'Reilly logo

Oracle Essbase 11 Development Cookbook by Jose R. Ruiz

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

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 ...

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