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

4 comments:

Всеволод Брускин said...

Hello,

If you know how to fix this problem please tell.

I load outline and data separately and have the following problems:

1. When I'm loading outline with ODBC connection, I have a success but except сyrillic symbols. Unfortunately there is no way to make this elements as aliases.

2. When I'm loading outline or data with OCI connection, the amount of loaded information is different for each new attempt. But sometimes I can get a full outline in Essbase and I don't have any problems with cyrillic.

What could be the reason for this problems?

Thanks for your attention.

Всеволод Брускин said...

I'm talking about loading data with Essbase Studio.

Daniel Poon said...

Excellent article on Essbase. I am a big fan of the technology for years.

Barbie Chiu said...

There are certain point in our life that we encounter failure but it doesn't mean you will lose hope and give up everything but it only means that every failure there's an exchange and that is new beginning. Well, thank you for sharing your article and keep on posting. Visit my site too for more information.

triciajoy.com

www.triciajoy.com