Page 1 of 1
Oracle OLAP
Posted: Tue Jan 03, 2012 10:32 am
by AnthonyT
Hi all
Hope this is the correct place for this post
Can anyone point me in the direction of finding out, or let me know their own experience in, the difference between Oracle OLAP and TM1?
Thanks
Anthony
Re: Oracle OLAP
Posted: Wed Jan 04, 2012 3:19 pm
by jim wood
When you say Oracle OLAP do you mean the old Oracle Express or do you mean Essbase?
Re: Oracle OLAP
Posted: Thu Jan 05, 2012 9:34 am
by AnthonyT
Hi Jim
I mean "Oracle OLAP is a world class multidimensional analytic engine embedded in Oracle Database 11g" from the Oracle Technology Network website - definately not Essbase - accesed using the Analytic Workspace Manager
I think.....
Thanks
Re: Oracle OLAP
Posted: Thu Jan 05, 2012 10:20 am
by lotsaram
AnthonyT wrote:Hi Jim
I mean "Oracle OLAP is a world class multidimensional analytic engine embedded in Oracle Database 11g" from the Oracle Technology Network website - definately not Essbase - accesed using the Analytic Workspace Manager
I think.....
Thanks
I think this is what was Siebel Analytics?
Re: Oracle OLAP
Posted: Thu Jan 05, 2012 2:09 pm
by jim wood
Siebal Analytics is now know as Oracle Business Intelligence Enterprise Edition. (OBIEE) Which is very similar to the likes of Cognos BI 10 and Business Objects. Calling it an OLAP tool is a bit of a stretch. Business Objects does the same as you break the information out in to dimensions and measure dimensions but there the similarity ends. The calculation engine within OBIEE is not an OLAP based calculation engine. It is able to do simple calculations. For example to handle version and time based variances you have 2 options: 1) Create hundreds of measures for each instance or 2) Create look up tables in your database that adds for example dates to give you year to date values. Even then option 2 doesn't handle variance exceptions very well. (Income versus expense for example) Also option 2 when you bring it through to the user can be very confusing.