Wednesday, June 17, 2009

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:

image_thumb28

Step 1 set up a Data Source:

image_thumb1

Get the tables:

image4_thumb

Skip creating a mini schema:

image11_thumb

Goto the default minischema and check the joins:

image_thumb29

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

image_thumb30

Next create a Hiearchies Folder:

Create Locations Hiearchy:

image_thumb31

Create the Channels Hierarchy:

image_thumb32

Create the Products Hiearchy:

image_thumb33

Create the Calendar Hierarchy:

image_thumb34

Create the Promotions Hierarchy:

image_thumb35

Create the Accounts (measure) Hierarchy:

image_thumb36

Next we create a Cube schema:

image_thumb37

Based on the cube schema we create an Essbase model:

image_thumb38

Set the model to ASO:

image_thumb2

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}

image_thumb39

Calendar: {CALENDAR_MONTH_DESC}

image_thumb40

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

image_thumb41

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

image_thumb42

Create a new apllication "using aggregate storage"

image_thumb43

Create the database:

image_thumb

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

image_thumb45

Select the Application and Database:

image_thumb46

Check Build outline and load data.

Check Delete and Restore database.

image_thumb47

Press Yes

Wait a little bit:

image_thumb48

Succes..?

image_thumb49

Back to the administration services:

image_thumb50

On the database press preview data:

image_thumb3

Succes!

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

Till Next Time

Saturday, June 6, 2009

Essbase install

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:

image

Start the installtool.cmd:

image

image

Select a language:

image

image

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

image

Select a install directory

image

image

Check if only the essbase components are selected.

image

image

image

image

Wait untill the instal is finished.

image 

Start the EPm System Configurator:

image

Select a configuration database type:

image

image

Enter the crenditals for the confugration database.

image

image 

image

Deploy the application

image

image

image

image

image

image

Deploy the essbase application:

image

image

image

image

image

Start the essbase server:

image

Start the essbase studio console:

image

image

Login admin / password

image

Let's get started!

 

Till Next Time