Essbase 101

Essbase my first cube

2009-06-17T00:18:00.001-07:00

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

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

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

Essbase install

2009-06-06T12:31:00.001-07:00

Finally took the time to get my Essbase virtual working.

First get of all copy all the assemblies into the same directory in the install directory:

Start the installtool.cmd:

Select a language:

The error on my install is caused by the fact thast my VM doesn't have a static IP adress.

Select a install directory

Check if only the essbase components are selected.

Wait untill the instal is finished.

Start the EPm System Configurator:

Select a configuration database type:

Enter the crenditals for the confugration database.

Deploy the application

Deploy the essbase application:

Start the essbase server:

Start the essbase studio console:

Let's get started!

Till Next Time

Welcome to Essbase 101

2008-07-24T00:56:00.000-07:00

Hi, My name is John Minkjan and I'm a senior BI-consultant at CIBER in the Netherlands. I reserverd a couple of ...101 blogspots. At the moment I'm mostly active on OBIEE101. I will start posting here as soon as my focus in back on Essbase.

Till Next Time

John