Essbase my first cube

After finaly installing Essbase it's time for my first cube.

This one is based on the Oracle SH (Sales History) Demo schema.

Log in to your essbase studio:

Step 1 set up a Data Source:

Get the tables:

Skip creating a mini schema:

Goto the default minischema and check the joins:

In the Metadaa Navigator create a "source" folder and drag all the fields you want to use to it:

Next create a Hiearchies Folder:

Create Locations Hiearchy:

Create the Channels Hierarchy:

Create the Products Hiearchy:

Create the Calendar Hierarchy:

Create the Promotions Hierarchy:

Create the Accounts (measure) Hierarchy:

Next we create a Cube schema:

Based on the cube schema we create an Essbase model:

Set the model to ASO:

Because Essbase doesn't like the same element description in different hiearchy path we have to add some prefix coding to some of the dimensions:

Promotions: {PROMO_SUBCATEGORY}

Calendar: {CALENDAR_MONTH_DESC}

In the info tab of the calendar hiearchy we have to set Time and Dense Dimension Storage

Now open the Administration Services Console to add a new Essbase application and database:

Create a new apllication "using aggregate storage"

Create the database:

Go back to the studio and open the Cube deployment wizard:

Select the Application and Database:

Check Build outline and load data.

Check Delete and Restore database.

Press Yes

Wait a little bit:

Succes..?

Back to the administration services:

On the database press preview data:

Succes!

(a special thanks to Mark Rittman for pointing me in the right direction!)

Till Next Time