Comparison of OLAP servers explained

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 serverCompanyWebsiteLatest stable versionSoftware licenseLicense pricing
Apache DorisApache Software Foundation[1] 1.2.3Apache 2.0free
Apache DruidApache Software Foundation[2] 29.0.0[3] Apache 2.0free
Apache KylinApache Software Foundation[4] 3.1.0Apache 2.0free
Apache PinotApache Software Foundation[5] 1.1.0Apache 2.0free
AtotiActiveViam[6] 6.0.5Proprietarycommunity
ClickHouseClickhouse Inc[7] 24.5Apache 2.0free
EssbaseOracle[8] 21.6Proprietaryhttp://www.oracle.com/us/corporate/pricing/index.htm
IBM Cognos TM1IBM[9] 10.2.2 FP7Proprietary-
icCubeicCube[10] 8.4.6Proprietarycommunity / https://www.iccube.com/pricing
Jedox OLAP ServerJedox[11] 2019.3Proprietaryhttps://web.archive.org/web/20170203080718/http://www.jedox.com/en/product/license-model/
KyvosKyvos Insights[12] 2022.3Proprietary-
Microsoft Analysis ServicesMicrosoft[13] 2016Proprietaryhttp://www.microsoft.com/sqlserver/2008/en/us/pricing.aspx
Mondrian OLAP serverPentaho[14] 3.7EPLfree
Oracle Database OLAP OptionOracle[15] 11g R2Proprietaryhttp://www.oracle.com/us/corporate/pricing/index.htm
SAP NetWeaver BWSAP[16] 7.30Proprietary-
SAS OLAP ServerSAS Institute[17] 9.4Proprietary-
StarRocksLinux Foundation[18] 3.1Apache 2.0free

APIs and query languages

APIs and query languages OLAP servers support.

OLAP serverXML for AnalysisOLE DB for OLAPMDXStored proceduresCustom functionsSQLLINQ[19] VisualizationJSONREST API
Apache Doris[20] Superset, Redash, Metabase, Tableau, Qlik, Pivot, PowerBI
Apache DruidDruid SQLSuperset, Pivot, Redash
Apache KylinSuperset, Zeppelin, Tableau, Qlik, Redash, Microsoft Excel
Apache PinotSuperset, Pivot, Redash
ClickHouse[21] Superset, Zeppelin, Tableau, Qlik, Redash, DataLens[22]
EssbaseSmartView (Excel-AddIn), Oracle Analytics Cloud, Narrative Reporting, Tableau, IBM Cognos
IBM Cognos TM1TM1 Web/TM1 Contributor, IBM Cognos Insight, IBM Performance Modeler, IBM Cognos Cafe for Excel, Cognos BI, TM1 Perspectives for Excel
icCube
Jedox OLAP Server
Kyvos Insights, Microsoft Excel, Qlik, Tableau, Power BI, MicroStrategy, IBM Cognos, Business Objects, XLCubed, Looker, Altryx, and more
Microsoft Analysis Services[23] [24] [25]
MicroStrategy Intelligence Server
Mondrian OLAP server[26] [27] [28]
Oracle Database OLAP Option[29] [30]
SAP NetWeaver BW
SAS OLAP Server
StarRocks[31] Superset, Redash, Metabase, Tableau, Qlik, Pivot, PowerBI

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 serverReal TimeWrite-backPartitioningUsage Based OptimizationsLoad Balancing and Clustering
Apache Doris
Apache Druid
Apache Kylin[32]
Apache Pinot
ClickHouse
Essbase
IBM Cognos BI
IBM Cognos TM1
icCube[33] [34]
Jedox OLAP Server
Kyvos
Microsoft Analysis Services
MicroStrategy Intelligence Server[35]
Mondrian OLAP server
Oracle Database OLAP Option
SAP NetWeaver BW
SAS OLAP Server
StarRocks

Data modeling features:

OLAP serverSemi-additive measuresMany-to-Many Multi-Cube ModelPerspectivesKPIMultilingualNamed SetsMulti-attribute HierarchiesActions
Apache Doris
Apache Druid
Apache Kylin
Apache Pinot
ClickHouse
Essbase
IBM Cognos BI
IBM Cognos TM1
icCube[36]
Jedox OLAP Server
Microsoft Analysis Services
MicroStrategy Intelligence Server
Mondrian OLAP server[37]
Oracle Database OLAP Option
SAP NetWeaver BW
SAS OLAP Server
StarRocks

System limits

OLAP server
  1. cubes
  1. measures
  1. dimensions
  1. dimensions in cube
  1. hierarchies in dimension
  1. levels in hierarchy
  1. dimension members
Apache DorisUnrestrictedUnrestrictedUnrestrictedUnrestrictedUnrestrictedUnrestrictedUnrestricted
Apache DruidUnrestrictedUnrestrictedUnrestrictedUnrestrictedUnrestrictedUnrestrictedUnrestricted
Apache KylinUnrestrictedUnrestrictedUnrestrictedUnrestrictedUnrestrictedUnrestrictedUnrestricted
Apache PinotUnrestrictedUnrestrictedUnrestrictedUnrestrictedUnrestrictedUnrestrictedUnrestricted
ClickHouseUnrestrictedUnrestrictedUnrestrictedUnrestrictedUnrestrictedUnrestrictedUnrestricted
Essbase[38] UnrestrictedUnrestrictedUnrestricted255255?20,000,000 (ASO), 1,000,000 (BSO)
IBM Cognos TM1UnrestrictedUnrestrictedUnrestricted256UnrestrictedUnrestrictedUnrestricted
icCube2,147,483,6472,147,483,6472,147,483,6472,147,483,6472,147,483,6472,147,483,6472,147,483,647
Jedox OLAP Server

232

(32 bits)

232

232

(32 bits)		250

232

232

232

KyvosUnrestrictedUnrestrictedUnrestrictedUnrestrictedUnrestrictedUnrestrictedUnrestricted
Microsoft Analysis Services[39] 2,147,483,6472,147,483,6472,147,483,6472,147,483,647 (max. number of dimensions in a database)2,147,483,6472,147,483,6472,147,483,647 (xOLAP)Unrestricted (In-memory)
MicroStrategy Intelligence ServerUnrestrictedUnrestrictedUnrestricted?UnrestrictedUnrestrictedUnrestricted
SAS OLAP Server[40] Unrestricted1024128?128194,294,967,296
StarRocksUnrestrictedUnrestrictedUnrestrictedUnrestrictedUnrestrictedUnrestrictedUnrestricted

Operating systems

The OLAP servers can run on the following operating systems:

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

Support information

OLAP serverIssue Tracking SystemRoadmapSource code
Apache DorisApache Doris– Github IssuesApache Doris Roadmap
Apache DruidDruid – Github Issues
Apache KylinJiraApache Kylin Roadmap
Apache PinotApache Pinot – Github Issues
ClickHouseClickHouse – Github IssuesClickHouse Roadmap
EssbasemyOracle Supporthttps://web.archive.org/web/20100705081200/http://communities.ioug.org/Portals/2/Oracle_Essbase_Roadmap_Sep_09.pdf
IBM Cognos TM1IBM Service Request
icCubeStackoverflow
Jedox OLAP ServerMantisAvailable upon request
KyvosZendeskAvailable upon request
Microsoft Analysis ServicesConnect-
MicroStrategy Intelligence ServerMicroStrategy Resource Center-
Mondrian OLAP serverJirahttp://mondrian.pentaho.org/documentation/roadmap.php
Oracle Database OLAP OptionmyOracle Support
SAP NetWeaver BWOSShttps://web.archive.org/web/20110716004633/http://esworkplace.sap.com/socoview(bD1lbiZjPTAwMSZkPW1pbg==)/render.asp?id=2270EAD629814D05A7ECECECECC8D002&fragID=&packageid=DEE98D07DF9FA9F1B3C7001A64D3F462
SAS OLAP ServerSupport
StarRocksStarRocks– Github IssuesStarRocks Roadmap

See also

Notes and References

  1. Web site: Apache Doris . Github . 6 April 2023.
  2. Web site: Druid Interactive Analytics at Scale. druid. druid.io. en. 2017-09-01.
  3. Web site: Latest Release.
  4. Web site: Apache Kylin Home. Kylin. Apache. kylin.apache.org. 2018-11-08.
  5. Web site: Apache Pinot Home. Pinot. Apache. pinot.apache.org. 2021-07-14.
  6. Web site: Atoti.
  7. Web site: ClickHouse.
  8. Web site: Oracle Essbase.
  9. Web site: Cognos Business Intelligence and Financial Performance Management. 9 November 2020 .
  10. Web site: icCube OLAP Server.
  11. Web site: Jedox.
  12. Web site: Kyvos.
  13. Web site: Microsoft SQL Server 2008 Analysis Services. .
  14. Web site: Pentaho Analysis Services: Mondrian Project.
  15. Web site: Oracle OLAP Documentation.
  16. Web site: Components & Tools.
  17. Web site: SAS OLAP Server.
  18. Web site: StarRocks A High-Performance Analytical Database . 2023-10-24 . www.starrocks.io . en.
  19. Web site: SSAS Entity Framework Provider.
  20. Web site: Apache Doris UDF . 6 April 2023.
  21. Web site: ClickHouse SQL Reference. Yandex.
  22. Web site: ClickHouse Visual Interfaces. Yandex.
  23. Web site: SQL Server 2008 Books Online (October 2009)Defining Stored Procedures. 9 December 2022 . MSDN.
  24. Web site: SQL Server 2008 Books Online (October 2009)Using Stored Procedures. 28 February 2023 . MSDN.
  25. Web site: How to perform a SQL Server distributed query with OLAP Server. 7 March 2023 . MSDN.
  26. Web site: Pentaho and Simba Technologies Partner to Bring World's Most Popular Open Source OLAP Project to Microsoft Excel Users.
  27. Web site: How to Define a Mondrian Schema. Pentaho.
  28. Web site: Pentaho Business Analytics Visualization.
  29. Web site: Oracle and Simba Technologies Introduce MDX Provider for Oracle OLAP.
  30. Web site: Querying Oracle OLAP Cubes: Fast Answers to Tough Questions Using Simple SQL.
  31. Web site: StarRocks UDF . 6 April 2023.
  32. Web site: Real-time OLAP.
  33. Web site: icCube Real Time walkthrough.
  34. Web site: icCube Partitioning.
  35. Web site: Common Extensions of the MicroStrategy Platform. 2010-11-10. https://web.archive.org/web/20101128210220/http://microstrategy.com/Software/Products/Dev_Tools/SDK/extensions.asp. 2010-11-28. dead.
  36. Web site: icCube Aggregatin types.
  37. Web site: Support for Non-Additive and Semi-Additive Measures.
  38. Web site: Essbase Server Limits. Oracle. 2015-06-25. https://web.archive.org/web/20150626101348/http://docs.oracle.com/cd/E57185_01/epm.1112/essbase_db/frameset.htm?limits.html. 2015-06-26. dead.
  39. Web site: SQL Server 2008 Books Online (October 2009)Maximum Capacity Specifications (Analysis Services - Multidimensional Data). 9 December 2022 . Microsoft.
  40. Web site: SAS OLAP Cube Size Specifications.
  41. Web site: SAS OLAP Security Totals and Permission Conditions.
  42. Web site: How to Change Over-the-Wire Encryption Settings for SAS Servers.

This article is licensed under the GNU Free Documentation License. It uses material from the Wikipedia article "Comparison of OLAP servers".

Except where otherwise indicated, Everything.Explained.Today is © Copyright 2009-2024, A B Cryer, All Rights Reserved. Cookie policy.