Business Intelligence – Oracle

Creating a Hyperion Essbase(Analytic Server) Cube

Posted by Venkatakrishnan J on July 21, 2007

In this example, I would be using Sales Warehouse data that comes in Oracle SH schema. It would make a lot of sense if one creates a cube out of transactional data. But for the sake of simplicity I would be focussing on the cube creation process with a simple warehouse schema.

Before you start, ensure that you have all the components (Analytic Server and Analytic Integration Services up and running)

Open up the Analytic Integration Services Console. As soon as you start, it would prompt you to create an OLAP catalog.

 

essbase1.jpg

Enter connection details for a schema that you generally use for storing metadata (recommended to create a separate schema in order to store the metadata). Once that is done it would automatically take us to the following screen

 

essbase2.jpg

 

On to the left is the OLAP metadata connection. Enter the details that you entered in the previous screen. On to the right is the Analytic Administration Services connection. Enter those details here. The next step is to create an OLAP Model.

essbase3.jpg 

Next is the screen to establish a connection to the data source. As I said, I would be connecting to the Sales Warehouse schema.

 

 essbase4.jpg

 

There are two types of files that we would be dealing here. They are

ü      Olap Model

ü      MetaOutline

In Olap Model one can establish all the joins of the tables that they want in their schema. It requires a fact table and their corresponding dimensions. Hierarchies should be specified here.

 

essbase5.jpg

 

Metaoutline is a file type wherein one can create the dimensions and specify the measures. Once the Olap model is created the next step is to design the Metaoutline.

 

essbase6.jpg

 

The next step is to load the data.

essbase7.jpg

essbase8.jpg

Then one can use the excel add in to view the data.

This is one of the ways to create a cube. One can also create the cube directly from the Analytic Administration Services. Also, I have not gone into lots of other features that would make essbase stand part. This was just to show an overview for people would like to start with Essbase but do not know where to begin from.

Advertisements

16 Responses to “Creating a Hyperion Essbase(Analytic Server) Cube”

  1. Hi Venkatakrishnan J,

    Very good blog post, it’s most interesting seeing the basics of setting up Essbase. I look forward to reading your postings in the future. I’ve also added you to our blogroll.

    — regards, Mark

  2. […] weekend, and as a parting link, here’s a new Oracle BI blogger who’s recently posted a “getting started with Hyperion Essbase” article – good […]

  3. Venkatakrishnan J said

    Thanks Mark.

    -Venkat

  4. MDT said

    Venkat,
    Very nice posts so far. Provides much needed blog content around the various MOLAP servers. Suggestion – provide comments on how to load and extract data directly into cubes from external apps like ETL. Thanks.

  5. Soundararaj D said

    let me know exact meaning cube in hyperion essbase?what is the purpose in project?

  6. Vasanth Kumar J said

    Hi Venkat,

    Gr8 article………..infact, it helped me in understanding my current project requirement!

    If possible, can you please post a similar article on developing an essbase aso cube without using AIS?

    Thanks,
    Vasanth Kumar

  7. harsha said

    very informative

  8. Avinash Kumar said

    Hi All,
    Please help me out in finding hyperion essbase right from starting as Iam going to work on this technology in new project.

    With Regards,
    Avinash Kumar

  9. Saurabh said

    Hi,
    I m new to hyperion essbase and i have to learn it regarding my new project. I want to know how to start learing it regarding project.
    thanks

  10. rithima said

    i joined Hyrerion essabase cource .is it any nessary to learn VB/SQL technologies learning For ESSBASE

  11. Jack said

    Thans your share very much!

  12. subash said

    hi venkatkrishnan,

    could you please tell me if it possible to load the transactional data directly to essbase cubes instead of sending it to global data warehouse.

    thanks & regards,
    Subash

  13. Pritam B said

    Hi Venkat,

    Amazin stuff for a novice beginners in essbase like me … thx for a simple post …

    Regards
    Pritam

  14. Steven said

    I am unable to see this cube in OBIEE (I did import from Multi-Dimenesional Source); Also, MS Excel is not showing it. Please advise. Thanks

  15. Steven said

    hi,

    Please advise how can I use the metadata created below. Alternatively how to create metadata accessible by OBIEE.

    Thanks,

    Steven

  16. Saraswathi said

    Hi Venkat,

    I have a fact table w_src_f which has attributes like prog_id,camp_id,event_id etc which are all strings.I actually want to aggregate these to do the count of programs ,campaigns and events.

    Any suggestions as to know I can do the count on the string attributes.

    Thanks,
    Saraswathi

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: