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.



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




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.


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




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.




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.




The next step is to load the data.



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.

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.


  4. MDT said

    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?

    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

    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.

  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,

  13. Pritam B said

    Hi Venkat,

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


  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


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



  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.


Leave a Reply

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

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

Google photo

You are commenting using your Google 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 )

Connecting to %s

%d bloggers like this: