Thursday, July 30, 2009

Hyperion Essbase Book


One good news for people who wants to learn Hyperion Essbase on their own.
There are not many books available on Essbase and I know only one book which is available 'Look smarter than you are with Hyperion Essbase' by Edward Roske.

Sarma and Joseph have written a 444 page book on Hyperion Essbase 9 with the title

'Oracle Essbase 9 Implementation Guide'.

The book covers Installation, Essbase cube designing and creation, loading data, Excel add-in, MDX, Max-L, calculation scripts, reports etc and explained them with real time examples in sufficient step by step details with the help of pictures, Notes and Hints.

The book is for students who are new to Essbase and Multidimensional OLAP concepts as well as professionals who are already working on the Essbase technology wants to refresh their knowledge.

For those who feel that Essbase is only for financial applications, this book will completely change their belief as at one place the author mentioned as
"Oracle Essbase is widely known as a financial analytical tool. We want to change the mindset just a bit, right here and now. Oracle Essbase absolutely is a superior financial OLAP tool, but it is an equally superior OLAP tool for just about any type of data analysis."
As the Authors have rich real time implementation experience in a Motor company, most of the examples are from that domain only. I am sure the readers would greatly benefit from these real time examples.

I am happy to see that Venkat has reviewed this book and feel proud to have worked with him in Oracle.

Though this is a great attempt to bring out such a nice book there are few points which I think should have been added in this book to make it more useful and practical.

1. As Essbase is not like other BI tools where you can visualise the schema and how dimensions are joined or related to facts, it becomes difficult in Essbase to visualise that. For that reason, it would have been helpful if a small cube have been designed with some small dimensions and facts and a relation is shown with a OLAP schema diagram. I am saying this because I myself was not able to understand how the data which is getting loaded into the Essbase cube is related to each other and it took me so much time to understand that. Please excuse me if I am the only one having this problem.

2. I do not think Essbase is complete without EIS(Essbase Integration Services) in version 9.3.1 or Essbase studio in Version 11.
Even though you can do almost all of the Essbase stuff without them but it would have been much better even if a small portion has been described about either of them in the book. As going forward Essbase studio is going to replace EIS, a small chapter on Essbase studio is desirable.

You can download one complete chapter Essbase Data and Design Considerations. By downloading this chapter in pdf format you can also see the list of chapters and table of contents.

All in all, a great attempt and thanks to people involved in bringing out a much needed book on Essbase.

Manohar Rana


Rajesh Bhogadi said...

Hi Manohar,

Have you come across any documented procedure of how to replicate BI and DAS services on 9.3?


Nomad said...

Hi Manohar,
Just wanted to say you have an excellent blog put up here.


kbrydc said...

Hi, Recruiter in DC needs help teching' aa hyperion develooper over 9..3.. They are interviewing in nPelase reply to apologize if ths po

Anonymous said...


what will be the answer for imple mentaion in hyperion...

Phani Kumar Thota said...

hai its nice to have useful information.

Sudha Kalidas's Karnatic Music said...

Hi ,

I have a requirement for a part time consultant who knows Hyperion Essbase. Do you know anyone available. The total work will be around 100 Hrs

saroja said...

Hi Sudha Kalidas's Karnatic Music ,

I am looking for a job in hyperion essbase. Please let me know your mail id so i can send my resume. Thanks

mahesh said...

Hi Manohar Rana,

How are you?

i have problem with making connection from web analysis studio to relation database?

Can you please tell me the way to solve this problem?


Anubhav said...
This comment has been removed by the author.
Anubhav said...

Not sure whether you remember me. This is "Anubav Gaur" from BVP. Do contact me on It's been ages..!!

pooja said...

Hi Manohar,

What are the career prospects in OBIEE,i have been working in the same for past one year..can you suggest career path to grow in this area..


mads said...

Im new 2 Hyperion...wer to start??can nyone help me??

Vijayabhaskarareddy said...

Hi Manohar,

It is excellent blog , having lot of information on Hyperion Essbase. Wanted to know any online trainings available for Hyperion Essbase, especially like from you. Thanks.

paul said...

Hi Manohar,

I have a question for you, I am working on Hyperion Financial management reprot studio.we have created some reports in a folder and also we have created books out of these reports at the same location, and now we are moving those books and those reports to other location, and we deleting the reports from the old location.

The problem is, the book in the new location is taking the reports form the old location only, and I cannot run the books. How I can change the path of the books, so that It can read the reports fromt he new location.