Comparison of OLAP servers

The following tables compare general and technical information for a number of online analytical processing (OLAP) servers. Please see the individual products articles for further information.

General information


OLAP Server	Company	Website	Latest stable version	Software license	License Pricing
Druid	Open source community	^[1]	0.11.0	Apache 2.0	free
Essbase	Oracle	^[2]	11.1.2.4	Proprietary
IBM Cognos TM1	IBM	^[3]	10.2.2 FP7	Proprietary	-
icCube	icCube	^[4]	6.7.1	Proprietary	community/
Infor BI OLAP Server	Infor	^[5]	10.6.0	Proprietary	-
Jedox OLAP Server	Jedox	^[6]	7.0	GPL v2 or EULA, Proprietary
Kyvos BI on Big Data	Kyvos Insights	^[7]	4.0	Proprietary	-
Microsoft Analysis Services	Microsoft	^[8]	2016	Proprietary
MicroStrategy Intelligence Server	MicroStrategy	^[9]	9	Proprietary	-
Mondrian OLAP server	Pentaho	^[10]	3.7	EPL	free
Oracle Database OLAP Option	Oracle	^[11]	11g R2	Proprietary
SAP NetWeaver BW	SAP	^[12]	7.30	Proprietary	-
SAS OLAP Server	SAS Institute	^[13]	9.4	Proprietary	-

Data storage modes

OLAP Server	MOLAP	ROLAP	HOLAP	Offline
Druid	Yes	Yes	Yes	Yes
Essbase	Yes	No	No
IBM Cognos BI	Yes	Yes	Yes
IBM Cognos TM1	Yes	No	No	Cognos Insight Distributed mode
icCube	Yes	No	No	Offline Cubes
Infor BI OLAP Server	Yes	No	No	Local cubes
Jedox OLAP Server	Yes	No	No	No
Kyvos BI on Big Data	Yes	Yes	No	Yes
Microsoft Analysis Services	Yes	Yes	Yes	Local cubes, PowerPivot for Excel, Power BI Desktop
MicroStrategy Intelligence Server	Yes	Yes	Yes	MicroStrategy Office, Dynamic Dashboards
Mondrian OLAP server	No	Yes	No
Oracle Database OLAP Option	No	Yes	No
SAP NetWeaver BW	Yes	Yes	No
SAS OLAP Server	Yes	Yes	Yes

APIs and query languages

APIs and query languages OLAP servers support.

OLAP Server	XML for Analysis	OLE DB for OLAP	MDX	Stored procedures	Custom functions	SQL	LINQ^[14]	Visualization	JSON	REST API
Druid	No	No	No	No	Yes	Druid SQL	No	Superset, Pivot	Yes	Yes
Essbase	Yes	Yes	Yes	Yes	Yes	No	Yes	SmartView (Excel-AddIn), WebAnalysis, Financial Reports	?	?
IBM Cognos TM1	Yes	Yes	Yes	Yes	Yes	No	Yes	TM1 Web/TM1 Contributor, IBM Cognos Insight, IBM Performance Modeler, IBM Cognos Cafe for Excel, Cognos BI, TM1 Perspectives for Excel	Yes	Yes
icCube	Yes	Yes	Yes	Java,^[15] R^[16]	Yes	In the reporting	Yes	icCube reporting and all XMLA complaint visualization tools like Excel, etc	Yes	Yes
Infor BI OLAP Server	Yes	Yes	Yes	OLAP Rules, Push Rules, Application Engine	Yes	Yes	No	Application Studio	?	?
Jedox OLAP Server	Yes	Yes	Yes	Cube Rules, SVS Triggers	Yes	No	Yes	Microsoft Excel, Qlik, Tableau, Jedox Web, Power BI	No	Yes
Kyvos BI on Big Data	Yes	Yes	Yes	No	Yes	Yes	No	Kyvos Insights, Microsoft Excel, Qlik, Tableau, Power BI, MicroStrategy, IBM Cognos, Business Objects	??	Yes
Microsoft Analysis Services	Yes	Yes	Yes	.NET^[17]	Yes^[18]	Yes^[19]	Yes	Microsoft Excel, SharePoint, Microsoft Power BI, and 70+ other visualization tools	?	?
MicroStrategy Intelligence Server	Yes	No	Yes	Yes	Yes	Yes	Yes	?	?	?
Mondrian OLAP server	Yes	Yes^[20]	Yes	Yes	Yes^[21]	Yes	Yes	Yes ^[22]	?	?
Oracle Database OLAP Option	No	Yes^[23]	Yes^[23]	Java, PL/SQL, OLAP DML	Yes	Yes^[24]	No	?	?	?
SAP NetWeaver BW	Yes	Yes	Yes	No	Yes	No	Yes	?	?	?
SAS OLAP Server	Yes	Yes	Yes	No	No	No	Yes	Web Report Studio	?	?

OLAP distinctive features

A list of OLAP features that are not supported by all vendors. All vendors support features such as parent-child, multilevel hierarchy, drilldown.

Data processing, management and performance related features:

OLAP Server	Real Time	Write-back	Partitioning	Usage Based Optimizations	Load Balancing and Clustering
Druid	Yes	?	Yes	Yes	Yes
Essbase	Yes	Yes	Yes	Yes	Yes
IBM Cognos BI	Yes	No	Yes	Yes	?
IBM Cognos TM1	Yes	Yes	Yes	?	?
icCube	Yes^[25]	Yes^[26]	Yes^[27]	?	?
Infor BI OLAP Server	Yes	Yes	Yes	?	?
Jedox OLAP Server	Yes	Yes	Yes	?	?
Kyvos BI on Big Data	No	No	Yes	Yes	Yes
Microsoft Analysis Services	Yes	Yes	Yes	Yes	Yes
MicroStrategy Intelligence Server	?	Yes^[28]	Yes	?	?
Mondrian OLAP server	Yes	Planned	Yes	?	?
Oracle Database OLAP Option	?	Yes	Yes	No	?
SAP NetWeaver BW	?	Yes	Yes	?	?
SAS OLAP Server	?	Yes	Yes	?	?

Data modeling features:

OLAP Server	Semi-additive measures	Many-to-Many	Multi-Cube Model	Perspectives	KPI	Multilingual	Named Sets	Multi-attribute Hierarchies	Actions
Druid	Yes	Yes	Yes	?	No	Yes	?	Yes	Yes
Essbase	Yes	?	?	?	Yes	Yes	Yes	Yes	?
IBM Cognos BI	Yes	Yes	?	?	?	?	Yes	Yes	?
IBM Cognos TM1	Yes	Yes	Yes	?	?	?	?	?	?
icCube	Yes^[29]	Yes^[30]	Yes	Yes	?	Yes	Yes	?	?
Infor BI OLAP Server	Yes	?	Yes	?	Yes	?	?	?	?
Jedox OLAP Server	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	?
Kyvos BI on Big Data	Yes	Yes	Yes	No	Yes	Yes	Yes	Yes	No
Microsoft Analysis Services	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes
MicroStrategy Intelligence Server	Yes	?	?	?	?	?	?	?	?
Mondrian OLAP server	Yes^[31]	?	?	?	?	?	?	?	?
Oracle Database OLAP Option	Yes	?	?	?	?	?	?	?	?
SAP NetWeaver BW	Yes	?	?	?	?	?	?	?	?
SAS OLAP Server	Yes	?	?	?	?	?	?	?	?

System limits

OLAP Server	# cubes	# measures	# dimensions	# dimensions in cube	# hierarchies in dimension	# levels in hierarchy	# dimension members
Druid	Unrestricted^{[lower-alpha 1]}	Unrestricted	Unrestricted	Unrestricted	Unrestricted	Unrestricted	Unrestricted
Essbase^[32]	?	?	?	255	255	?	20,000,000 (ASO), 1,000,000 (BSO)
IBM Cognos TM1	Unrestricted^{[lower-alpha 1]}	Unrestricted	Unrestricted^{[lower-alpha 1]}	256	Unrestricted^{[lower-alpha 1]}	Unrestricted	Unrestricted
icCube	2,147,483,647	2,147,483,647	2,147,483,647	2,147,483,647	2,147,483,647	2,147,483,647	2,147,483,647
Infor BI OLAP Server	?	10,000,000	?	30	?	?	10,000,000
Jedox OLAP Server	$2^{32}$ (32 bits)	$2^{32}$	$2^{32}$ (32 bits)	250	$2^{32}$	$2^{32}$	$2^{32}$
Kyvos BI on Big Data	Unrestricted	Unrestricted	Unrestricted	Unrestricted	1	Unrestricted	Unrestricted
Microsoft Analysis Services^[33]	2,147,483,647	2,147,483,647	2,147,483,647	2,147,483,647 (max. number of dimensions in a database)	2,147,483,647	2,147,483,647	2,147,483,647 (xOLAP) Unrestricted (In-memory)
MicroStrategy Intelligence Server	Unrestricted^{[lower-alpha 1]}	Unrestricted^{[lower-alpha 1]}	Unrestricted^{[lower-alpha 1]}	?	Unrestricted^{[lower-alpha 1]}	Unrestricted^{[lower-alpha 1]}	Unrestricted^{[lower-alpha 1]}
SAS OLAP Server^[34]	Unrestricted^{[lower-alpha 1]}	1024	128	?	128	19	4,294,967,296

1 2 3 4 5 6 7 8 9 10 11 Please update as 'unrestricted', is just not possible

Security

OLAP Server	Authentication	Network encryption	On-the-Fly^{[lower-alpha 1]}	Data access
OLAP Server	Authentication	Network encryption	On-the-Fly^{[lower-alpha 1]}	Cell security	Dimension security	Visual totals
Druid	Druid Database authentication	SSL	Yes	No	Yes	No
Essbase	Essbase authentication, LDAP authentication, Microsoft Active Directory	SSL	Yes	Yes	Yes	No
IBM Cognos TM1	Builtin, LDAP, Microsoft Active Directory, NTLM, IBM Cognos BI authentication	SSL	Yes	Yes	Yes	Yes
icCube	HTTP Basic/Form Authentication, Windows SSO (NTLM,Kerberos)	SSL	Yes	Yes	Yes	Yes
Infor BI OLAP Server	OLAP authentication, Infor Federation Services, LDAP, Microsoft Active Directory	Yes	Yes	Yes	Yes	?
Jedox OLAP Server	Jedox authentication, LDAP, Microsoft Active Directory	SSL	Yes	Yes	Yes	?
Kyvos BI on Big Data	Built-in, LDAP, Microsoft Active Directory, Windows SSO (NTLM, Kerberos)	SSL	Yes	Yes	Yes	?
Microsoft Analysis Services	NTLM, Kerberos	SSL and SSPI	Yes	Yes	Yes	Yes
MicroStrategy Intelligence Server	Host authentication, database authentication, LDAP, Microsoft Active Directory, NTLM, SiteMinder, Tivoli, SAP, Kerberos	SSL, AES^[35]	?	Yes	Yes	Yes
Oracle Database OLAP Option	Oracle Database authentication	SSL	?	Yes	Yes	No
SAS OLAP Server^[36]	Host authentication,SAS token authentication, LDAP, Microsoft Active Directory	Yes^[37]	?	Yes	Yes	Yes

↑ On-the-Fly : The ability to define authentication dynamically via programmatic interfaces. New users do not require restarting the server or redefining the security.

Operating systems

The OLAP servers can run on the following operating systems:

OLAP Server	Windows	Linux	UNIX	z/OS	AIX
Druid	No	Yes	Yes
Essbase	Yes	Yes	Yes	No
IBM Cognos TM1	Yes	Yes	Yes	No	Yes
icCube	Yes	Yes	Yes	Yes	Yes
Infor BI OLAP Server	Yes	No	No	No
Jedox OLAP Server	Yes	Yes	Yes	No
Kyvos BI on Big Data	No	Yes	Yes		No	Yes
Microsoft Analysis Services	Yes	No	No	No
MicroStrategy Intelligence Server	Yes	Yes	Yes	No
Mondrian OLAP server	Yes	Yes	Yes	Yes
Oracle Database OLAP Option	Yes	Yes	Yes	Yes
SAP NetWeaver BW	Yes	Yes	Yes	Yes
SAS OLAP Server	Yes	Yes	Yes	Yes

Note (1):The server availability depends on Java Virtual Machine not on the operating system

Support information

OLAP Server	Issue Tracking System	Forum/Blog	Roadmap	Source code
Druid	Druid – Github Issues	^[38]		Open
Essbase	myOracle Support			Closed
IBM Cognos TM1	IBM Service Request			Closed
icCube	YouTrack			Closed
Infor BI OLAP Server	Infor Xtreme		Available upon request	Closed
Jedox OLAP Server	Mantis		Available upon request	Open
Kyvos BI on Big Data	Zendesk		Available upon request	Open
Microsoft Analysis Services	Connect		-	Closed
MicroStrategy Intelligence Server	MicroStrategy Resource Center		-	Closed
Mondrian OLAP server	Jira			Open
Oracle Database OLAP Option	myOracle Support			Closed
SAP NetWeaver BW	OSS			Closed
SAS OLAP Server	Support			Closed

References

This article is issued from Wikipedia. The text is licensed under Creative Commons - Attribution - Sharealike. Additional terms may apply for the media files.

[fn0-32] 1 2 3 4 5 6 7 8 9 10 11 Please update as 'unrestricted', is just not possible

[fn1-36] On-the-Fly : The ability to define authentication dynamically via programmatic interfaces. New users do not require restarting the server or redefining the security.

[1] ruid. "Druid | Interactive Analytics at Scale". druid.io. Retrieved 2017-09-01.

[2] "Oracle Essbase".

[3] "Cognos Business Intelligence and Financial Performance Management".

[4] "icCube OLAP Server".

[5] "Infor".

[6] "Jedox".

[7] "Kyvos".

[8] "Microsoft SQL Server 2008 Analysis Services".

[9] "MicroStrategy Intelligence Server".

[10] "Pentaho Analysis Services: Mondrian Project".

[11] "Oracle OLAP Documentation".

[12] "Components & Tools".

[13] "SAS OLAP Server".

[linq-14] "SSAS Entity Framework Provider".

[15] "icCube Java integration documentation". icCube.

[16] "icCube R language integration documentation". icCube.

[17] "SQL Server 2008 Books Online (October 2009)Defining Stored Procedures". MSDN.

[18] "SQL Server 2008 Books Online (October 2009)Using Stored Procedures". MSDN.

[19] "How to perform a SQL Server distributed query with OLAP Server". MSDN.

[20] "Pentaho and Simba Technologies Partner to Bring World's Most Popular Open Source OLAP Project to Microsoft Excel Users".

[21] "How to Define a Mondrian Schema". Pentaho.

[22] "Pentaho Business Analytics Visualization".

[oraclemdx-23] 1 2 "Oracle and Simba Technologies Introduce MDX Provider for Oracle OLAP".

[24] "Querying Oracle OLAP Cubes: Fast Answers to Tough Questions Using Simple SQL".

[25] "icCube Real Time walkthrough".

[26] "icCube Writeback/Update Cube".

[27] "icCube Partitioning".

[28] "Common Extensions of the MicroStrategy Platform".

[29] "icCube Aggregatin types".

[30] "icCube Many-to-Many".

[31] "Support for Non-Additive and Semi-Additive Measures".

[33] "Essbase Server Limits". Oracle.

[34] "SQL Server 2008 Books Online (October 2009)Maximum Capacity Specifications (Analysis Services - Multidimensional Data)". Microsoft.

[35] "SAS OLAP Cube Size Specifications".

[37] MicroStrategy Intelligence Server Features

[38] "SAS OLAP Security Totals and Permission Conditions".

[39] "How to Change Over-the-Wire Encryption Settings for SAS Servers".

[40] "Google Groups". groups.google.com. Retrieved 2017-09-01.