Oracle OLAP

Post Reply
AnthonyT
Posts: 40
Joined: Mon May 19, 2008 10:25 am
OLAP Product: TM1, EV
Version: 9.0 9.1 9.4 9.5 10.1 10.2
Excel Version: 2003 2007 2010 2015
Location: London, UK

Oracle OLAP

Post by AnthonyT » Tue Jan 03, 2012 10:32 am

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
Anthony

That's no moon - that's a space station

User avatar
jim wood
Site Admin
Posts: 3507
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: TM1 10.2.2
Excel Version: 2007
Location: 1639 Route 10, Suite 107, Parsippany, NJ, USA
Contact:

Re: Oracle OLAP

Post by jim wood » Wed Jan 04, 2012 3:19 pm

When you say Oracle OLAP do you mean the old Oracle Express or do you mean Essbase?
Struggling through the quagmire of life to reach the other side of who knows where.
Application Consulting Group (ACG) TM1 Consulting
OS: Windows 7 64-bit. TM1 Version: 10.1.1

AnthonyT
Posts: 40
Joined: Mon May 19, 2008 10:25 am
OLAP Product: TM1, EV
Version: 9.0 9.1 9.4 9.5 10.1 10.2
Excel Version: 2003 2007 2010 2015
Location: London, UK

Re: Oracle OLAP

Post by AnthonyT » Thu Jan 05, 2012 9:34 am

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
Anthony

That's no moon - that's a space station

lotsaram
MVP
Posts: 3008
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TM1, CX
Version: TM1 10.2.2 PA 2.0x
Excel Version: 2010 2013 365
Location: Switzerland

Re: Oracle OLAP

Post by lotsaram » Thu Jan 05, 2012 10:20 am

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?

User avatar
jim wood
Site Admin
Posts: 3507
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: TM1 10.2.2
Excel Version: 2007
Location: 1639 Route 10, Suite 107, Parsippany, NJ, USA
Contact:

Re: Oracle OLAP

Post by jim wood » Thu Jan 05, 2012 2:09 pm

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.
Struggling through the quagmire of life to reach the other side of who knows where.
Application Consulting Group (ACG) TM1 Consulting
OS: Windows 7 64-bit. TM1 Version: 10.1.1

Post Reply