Talk:Comparison of OLAP servers

Scope: MDX only?

Should this page cover only OLAP engines that support MDX, or all OLAP engines?

An edit in November 2016 by an anonymous user added "supporting MDX language", and an edit in September 2017, also by an anonymous user removed servers that did not support MDX.

In my opinion, MDX is not essential for OLAP. The essentials, per OLAP, are a multidimensional data model, dimensional operations (slice and dice etc.) and interactive response time.

I am hesitant to describe SQL engines as OLAP, because cross-dimensional calculations are difficult to express in SQL, but it is difficult to know where to draw the line.

I backed out the above edits. I think more discussion is needed.

--Julianhyde (talk) 21:08, 26 September 2017 (UTC)

I guess is acceptable but the least is filling in tables. It's not the case for 'cubes' that I think we should give 1 month to update or we should remove, if no this page will get useless.

If we don't have MDX language, we have a problem with a few tables that are very MDX oriented. Shouldn't we make the effort to make an abstraction of the concepts.

--David.alvarez.iccube (talk) 14:38, 10 October 2017 (UTC)

I don't see why SQL engines as OLAP is an issue as most Relational-OLAP servers prefer to use an SQL based server. I just added MariaDB Columnstore Server to this list and I think clickhouse and MonetDB are valid OLAP servers too. AbdealiJK (talk) 07:04, 29 May 2018 (UTC)

SAS Olap (Teradata) and Business Objects Olap

Good comparison, particularly Mondrain and Palo. Kieran (talk) 00:32, 15 September 2011 (UTC)

How about SAS's olap server?

http://www.sas.com/technologies/dw/storage/mddb/index.html

Teradata used it.

http://www.teradata.com/tdmo/v08n03/Tech2Tech/AppliedSolutions/CubesByDesign.aspx —Preceding unsigned comment added by TimothyZhang (talk • contribs) 16:41, 8 October 2009 (UTC)

Business Objects is another too. Now bought out by SAP, and also encompasses Crystal Reports. http://www.sap.com/solutions/sapbusinessobjects/large/business-intelligence/index.epx Kieran (talk) 00:32, 15 September 2011 (UTC)

Multiple time hierarchies

Crysb, I'd like to add the value for icCube Server. But I don't understand what do yo mean by 'Multiple time hierarchies' , what are you expecting out of this ? In MDX there is little difference between a time and a no time dimension.

--Alvarez 04:30, 18 November 2010 (UTC) —Preceding unsigned comment added by Alvarezdebrot (talk • contribs)

Please elaborate on "OLAP Features"

The list of OLAP features is not clear:

Why is parent-child hierarchies listed, when the answer is always "yes"? If you add Excel Pivot Tables to the list, you could have a "no".

How about multiple parallel hierarchies? E.g. Year -> Quarter -> Month -> Day, Year -> Week -> Day, Year(chinese) -> moon -> day. country -> Region (by geographic location) -> city vs. Country -> Region (by management responsibility) -> City.

Multiple entries in dimensions of the same name, but with differnt keys?

What is meant by "Semi-additive measures", "measure groups" and "paritioning"? Where are these terms defined? A layman will not understand "write-back", which is called "splashing" by some by the way.

Thanks in advance. — Preceding unsigned comment added by 80.130.29.135 (talk) 20:37, 7 June 2012 (UTC)

I agree, can someone with better understanding please define these ... AbdealiJK (talk) 07:04, 29 May 2018 (UTC)

External links modified

Hello fellow Wikipedians,

I have just modified one external link on Comparison of OLAP Servers. Please take a moment to review my edit. If you have any questions, or need the bot to ignore the links, or the page altogether, please visit this simple FaQ for additional information. I made the following changes:

• Added archive https://web.archive.org/web/20100514124342/http://www.jedox.com:80/en/home/overview.html to http://www.jedox.com/en/home/overview.html

When you have finished reviewing my changes, please set the checked parameter below to true or failed to let others know (documentation at {{Sourcecheck}}).

This message was posted before February 2018. After February 2018, "External links modified" talk page sections are no longer generated or monitored by InternetArchiveBot. No special action is required regarding these talk page notices, other than regular verification using the archive tool instructions below. Editors have permission to delete these "External links modified" talk page sections if they want to de-clutter talk pages, but see the RfC before doing mass systematic removals. This message is updated dynamically through the template {{source check}} (last update: 18 January 2022).

• If you have discovered URLs which were erroneously considered dead by the bot, you can report them with this tool.
• If you found an error with any archives or the URLs themselves, you can fix them with this tool.

Cheers.—InternetArchiveBot (Report bug) 02:34, 29 November 2016 (UTC)

Oracle's "Other" OLAP engine

Worth adding the Oracle Retail Predictive Application Server (RPAS). Now included as a see also pointing to the linked article.

I haven't the time to update the tables properly but here is what should be added.

General Info Company=Oracle Latest stable version V16.0 (on premise) V16.x (SaaS, semi-annual update) Software license Prop. License Pricing '-'

Storage Modes: MOLAP Yes, ROLAP Yes HOLAP Yes, In Memory No Offline No

API and query. SQL via ODBC (read only). SOAP?. Custom functions in C++ (on premise only).

Data Exchange via ETL flat files (in and out) and ROLAP via Oracle RDBMS tables (MOLAP friendly data model structures created by RPAS rather than mapping existing schema as per true ROLAP).

Distinctive features: Real time Yes? Writeback Yes?, rest NO. Strength is high performance MOLAP for large cubes with Excel-like interface and workbooks supporting what if analysis and large cube computation in batch, and ability to develop key algorithms in C++. Depending on data structure, can partition workload across multiple processors in parallel. Allegedly better performance for MOLAP use cases than EssBase although more recent versions of EssBase may now match/exceed the performance of RPAS.

Data modelling: Multi Cubes yes, KPI Yes?, rest ?

System Limits (recent versions): all unrestricted except cube dimensions (show as ?)

Security: LDAP (certified with Oracle Identity/Oracle Access Management), otherwise like Oracle Database OLAP

OS: Linux Yes (from version 14), Windows Yes (non-production only), AIX Yes, HP-UX Yes, Solaris Yes, Dynix yes (all dependant on version, HP-UX/Dynix not available in recent versions), Z/OS no.

Support My Oracle Support.

--194.72.50.58 (talk) 10:20, 11 April 2017 (UTC)