Working in OBIEE 10g/11g with Multidimensional OLAP Cube

Time to move into new topic always :) ….a new BI era with OBIEE11g and again with Oracle’s so called emerging OLAP Cube  technology.My personal experience using OBIE11g  is pretty slow. Couple of the reasons have been already reported under Oracle Support web which will be put together later but just sharing my last report execution time comparing two version OBIEE 10g and OBIEE 11g  accessing the same database cube .

Below snapshot represent the difference of the execution timings for couple of my reports below (while fetching the cube data using OBIEE11g/10g) and it is substantial indeed !

My application server environment like below:

  • Oracle Database ( with OLAP option pack
  • Oracle OLAP 11g- Analytic Workspace Manager
  • OBIEE Repository OBIEE  
  • OBIEE Plug-in – Revision 1
  • OS – Windows 2003 Enterprise Server 64 bit (Dedicated Virtual Env)
  • Intel Xeon CPU 2.67 Ghz, 8 GB RAM , 200GB HDD

Only thing that is different is that my Database environment hosted into a 32 bit Windows 2003 R2 platform and OBIEE 10g was in that same box but 11g in different box .But that doesn’t and shouldn’t make the huge difference !

Also my overall experience with OBIEE 11g and general opinion derived is that it is pretty slow.

What I can say now … Come on OBIEE 11g … Come on Oracle ..! Lets hope for the best !@

About Debashis Paul * A Passionate Blogger *

Hello there , Welcome to my Business Intelligence Online Journal ! Being an enthusiastic fan and lover of Oracle Business Intelligence I am working in OBIEE(Now Fusion Middleware) for last couple of years across designations like Developer, Senior Developer , Designer, Consultant and BI Architect .In this blog I would like to share my thoughts, experience, problems that I encountered in BI space and the solutions, workarounds during the implementation and execution. All the voices here are of my own and does not necessarily reflect the views of my employer. Thanks for visiting my Journal.Have a Good Day !!!

Posted on September 26, 2011, in Oracle OLAP and tagged , , , . Bookmark the permalink. 1 Comment.

  1. I enjoy reading your blog as another pharma OBIEE user. This is my blog:

Leave a Reply

Please log in using one of these methods to post your comment: Logo

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