View source for Comparison of OLAP servers

{{short description|None}}

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==
{| class="wikitable sortable"  style="font-size: 100%; text-align: center; width: auto;"
|+
|-
! OLAP server
! Company
! Website
! Latest stable version
! [[Software license]]
! License pricing
|-
! Apache Doris
| [[The Apache Software Foundation|Apache Software Foundation]]
| <ref>{{cite web |title=Apache Doris |url=https://doris.apache.org/ |website=Github |access-date=6 April 2023}}</ref>
| 1.2.3
| [[Apache License|Apache 2.0]]
| free
|-
! [[Apache Druid]]
| [[The Apache Software Foundation|Apache Software Foundation]]
| <ref>{{Cite web|url=http://druid.io/|title=Druid {{!}} Interactive Analytics at Scale|last=druid|website=druid.io|language=en|access-date=2017-09-01}}</ref>
| 29.0.0<ref>{{Cite web|url=https://druid.apache.org/downloads/|title=Latest Release}}</ref>
| [[Apache License|Apache 2.0]]
| free
|-
![[Apache Kylin]]
|[[The Apache Software Foundation|Apache Software Foundation]]
|<ref>{{Cite web|url=http://kylin.apache.org/|title=Apache Kylin {{!}} Home|last=Kylin|first=Apache|website=kylin.apache.org|access-date=2018-11-08}}</ref>
|3.1.0
|[[Apache License|Apache 2.0]]
|free
|-
![[Apache Pinot]]
|[[The Apache Software Foundation|Apache Software Foundation]]
|<ref>{{Cite web|url=http://pinot.apache.org/|title=Apache Pinot {{!}} Home|last=Pinot|first=Apache|website=pinot.apache.org|access-date=2021-07-14}}</ref>
|1.1.0
|[[Apache License|Apache 2.0]]
|free
|-
![[Atoti]]
|[[ActiveViam]]
|<ref>{{Cite web|url=https://atoti.io/|title=Atoti}}</ref>
|6.0.5
| [[Proprietary software|Proprietary]]
|community
|-
![[ClickHouse]]
|[https://clickhouse.com/ Clickhouse Inc]
|<ref>{{Cite web|url=https://clickhouse.tech/|title=ClickHouse}}</ref>
|24.5
|[[Apache License|Apache 2.0]]
|free
|-
! [[Essbase]]
| [[Oracle Corporation|Oracle]]
|<ref>{{cite web|url=https://www.oracle.com/business-analytics/essbase.html|title=Oracle Essbase}}</ref>
| 21.6
| [[Proprietary software|Proprietary]]
| [http://www.oracle.com/us/corporate/pricing/index.htm]
|-
! [[TM1|IBM Cognos TM1]]
| [[IBM]]
|<ref>{{cite web|url=http://www-01.ibm.com/software/data/cognos/index.html|title=Cognos Business Intelligence and Financial Performance Management|date=9 November 2020 }}</ref>
| 10.2.2 FP7
| [[Proprietary software|Proprietary]]
| -
|-
! icCube
|[https://icCube.com/ icCube SARL]
|<ref>{{cite web|url=http://www.icCube.com|title=icCube OLAP Server}}</ref>
| 8.4.14
| [[Proprietary software|Proprietary]]
| community / [https://www.iccube.com/pricing]
|-
! [[Jedox|Jedox OLAP Server]]
| [[Jedox]]
|<ref>{{cite web|url=http://www.jedox.com |title=Jedox}}</ref>
| 2019.3
| [[Proprietary software|Proprietary]]
| {{usurped|1=[https://web.archive.org/web/20170203080718/http://www.jedox.com/en/product/license-model/]}}
|-
! [[Kyvos]]
| [[Kyvos Insights]]
|<ref>{{cite web|url=http://www.kyvosinsights.com/product/kyvos-architecture/ |title=Kyvos}}</ref>
| 2024.3
| [[Proprietary software|Proprietary]]
| [https://www.kyvosinsights.com/pricing/ Pricing]-
|-
|-
! [[Microsoft Analysis Services]]
| [[Microsoft]]
|<ref>{{cite web |title=Microsoft SQL Server 2022 Analysis Services |url=https://learn.microsoft.com/en-us/analysis-services/ssas-overview?view=sql-analysis-services-2022 |website=[[Microsoft]]}}</ref>
| 2022
| [[Proprietary software|Proprietary]]
| [http://www.microsoft.com/sqlserver/2008/en/us/pricing.aspx]
|-
! [[Mondrian OLAP server]]
| [[Pentaho]]
|<ref>{{cite web|url=http://mondrian.pentaho.org|title=Pentaho Analysis Services: Mondrian Project}}</ref>
| 3.7
| [[Eclipse Public License|EPL]]
| free
|-
! [[Oracle OLAP|Oracle Database OLAP Option]]
| [[Oracle Corporation|Oracle]]
|<ref>{{cite web|url=http://www.oracle.com/technetwork/database/options/olap/index.html|title=Oracle OLAP Documentation}}</ref>
| 11g R2
| [[Proprietary software|Proprietary]]
| [http://www.oracle.com/us/corporate/pricing/index.htm]
|-
! [[SAP NetWeaver Business Intelligence|SAP NetWeaver BW]]
| [[SAP AG|SAP]]
|<ref>{{cite web|url=http://www.sap.com/usa/platform/netweaver/components/businesswarehouse/index.epx |title=Components & Tools}}</ref>
| 7.30
| [[Proprietary software|Proprietary]]
| -
|-
! [[SAS System|SAS OLAP Server]]
| [[SAS Institute]]
|<ref>{{cite web|url=http://www.sas.com/technologies/dw/storage/mddb/index.html|title=SAS OLAP Server}}</ref>
| 9.4
| [[Proprietary software|Proprietary]]
| -
|-
![http://starrocks.io StarRocks]
|Linux Foundation
|<ref>{{Cite web |title=StarRocks {{!}} A High-Performance Analytical Database |url=https://www.starrocks.io/ |access-date=2023-10-24 |website=www.starrocks.io |language=en}}</ref>
|3.1
|[[Apache License|Apache 2.0]]
|free
|}

==Data storage modes==
{| class="wikitable sortable"  style="font-size: 100%; text-align: center; width: auto;"
|-
! OLAP server
! [[MOLAP]]
! [[ROLAP]]
! [[HOLAP]]
! Offline
|-
!Apache Doris
| {{Yes}}
| {{Yes}}
| {{Yes}}
| {{Yes}}
|-
![[Apache Druid]]
| {{Yes}}
| {{Yes}}
| {{Yes}}
| {{Yes}}
|-
![[Apache Kylin]]
| {{Yes}}
| {{No}}
| {{No}}
| {{Yes}}
|-
![[Apache Pinot]]
| {{Yes}}
| {{Yes}}
| {{Yes}}
| {{Yes}}
|-
![[ClickHouse]]
| {{Yes}}
| {{Yes}}
| {{Yes}}
| {{Yes}}
|-
! [[Essbase]]
| {{Yes}}
| {{No}}
| {{No}}
|
|-
! [[IBM Cognos BI]]
| {{Yes}}
| {{Yes}}
| {{Yes}}
|
|-
! [[TM1|IBM Cognos TM1]]
| {{Yes}}
| {{No}}
| {{No}}
| {{Yes| [http://www-01.ibm.com/support/knowledgecenter/SSVJ22_10.2.2/com.ibm.swg.ba.cognos.dsk_ug.10.2.2.doc/t_dsk_maintain_offline.html%23t_dsk_maintain_offline Cognos Insight Distributed mode]}}
|-
! icCube
| {{Yes}}
| {{No}}
| {{No}}
| {{Yes | [https://doc.iccube.com/?ic3topic=server.user_guide.using.schema_snapshots]}}
|-
! [[Jedox|Jedox OLAP Server]]
| {{Yes}}
| {{No}}
| {{No}}
| {{No}}
|-
![[Kyvos]] 
| {{Yes}}
| {{Yes}}
| {{Yes}}
| {{Yes}}
|-
! [[Microsoft Analysis Services]]
| {{Yes}}
| {{Yes}}
| {{Yes}}
| {{Yes|Local cubes,<br /> [[PowerPivot|PowerPivot for Excel]],<br />[[Power BI|Power BI Desktop]]}}
|-
! [[MicroStrategy|MicroStrategy Intelligence Server]]
| {{Yes}}
| {{Yes}}
| {{Yes}}
| {{Yes|[http://www.microstrategy.com/Software/Products/User_Interfaces/Office/ MicroStrategy Office],<br /> [http://www.microstrategy.com/Software/Products/Service_Modules/Report_Services/ Dynamic Dashboards]}}
|-
! [[Mondrian OLAP server]]
| {{No}}
| {{Yes}}
| {{No}}
|
|-
! [[Oracle OLAP|Oracle Database OLAP Option]]
| {{Yes}}
| {{No}}
| {{No}}
|
|-
! [[SAP NetWeaver Business Intelligence|SAP NetWeaver BW]]
| {{Yes}}
| {{Yes}}
| {{No}}
|
|-
! [[SAS System|SAS OLAP Server]]
| {{Yes}}
| {{Yes}}
| {{Yes}}
|
|-
! StarRocks
| {{Yes}}
| {{Yes}}
| {{Yes}}
| {{Yes}}
|-
|}

==APIs and query languages==
APIs and query languages OLAP servers support.
{{sort-under}}
{| class="wikitable sortable sort-under"  style="font-size: 100%; text-align: center; width: auto;"
|-
! OLAP server
! [[XML for Analysis]]
! [[OLE DB for OLAP]]
! [[Multidimensional Expressions|MDX]]
! [[Stored procedures]]
! Custom functions
! [[SQL]]
! [[LINQ]]<ref name="linq">{{cite web|url=http://agiledesignllc.com/products|archive-url=https://web.archive.org/web/20110929151255/http://www.agiledesignllc.com/Products|url-status=usurped|archive-date=September 29, 2011|title=SSAS Entity Framework Provider}}</ref>
! Visualization
! [[JSON]]
! [[REST API]]
|-
!Apache Doris
| {{No}}
| {{No}}
| {{No}}
| {{No}}
| {{Yes}}<ref>{{cite web |title=Apache Doris UDF |url=https://doris.apache.org/docs/dev/ecosystem/udf/contribute-udf |access-date=6 April 2023}}</ref>
| {{Yes}}
| {{No}}
| Superset, Redash, Metabase, Tableau, Qlik, Pivot, PowerBI
| {{Yes}}
| {{Yes}}
|-
! [[Apache Druid]]
| {{No}}
| {{No}}
| {{No}}
| {{No}}
| {{Yes}}
| Druid SQL
| {{No}}
| Superset, '''Pivot''', Redash
| {{Yes}}
| {{Yes}}
|-
![[Apache Kylin]]
| {{Yes}}
| {{No}}
| {{Yes}}
| {{No}}
| {{Yes}}
| {{Yes}}
|
|Superset, Zeppelin, Tableau, Qlik, Redash, Microsoft Excel
| {{Yes}}
| {{Yes}}
|-
! [[Apache Pinot]]
| {{No}}
| {{No}}
| {{No}}
| {{No}}
| {{Yes}}
| {{Yes}}
| {{No}}
| Superset, '''Pivot''', Redash
| {{Yes}}
| {{Yes}}
|-
![[ClickHouse]]
| {{No}}
| {{No}}
| {{No}}
| {{No}}
| {{Yes}}<ref>{{cite web|url=https://clickhouse.tech/docs/en/sql-reference/|title=ClickHouse SQL Reference|publisher=[[Yandex]]}}</ref>
| {{Yes}}
| {{No}}
| Superset, Zeppelin, Tableau, Qlik, Redash, DataLens<ref>{{cite web|url=https://clickhouse.tech/docs/en/interfaces/third-party/gui/|title=ClickHouse Visual Interfaces|publisher=[[Yandex]]}}</ref>
| {{Yes}}
| {{Yes}}
|-
! [[Essbase]]
| {{Yes}}
| {{Yes}}
| {{Yes}}
| {{Yes}}
| {{Yes}}
| {{No}}
| {{Yes}}
| SmartView (Excel-AddIn), Oracle Analytics Cloud, Narrative Reporting, Tableau, IBM Cognos 
| {{dunno}}
| {{Yes}}
|-
! [[TM1|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}}
| {{Yes|[[Java (programming language)|Java]],<ref>{{cite web|url=http://www.iccube.com/support/documentation/mdx_integration/java_integration.html|title=icCube Java integration documentation|publisher=icCube}}</ref> [[R (programming language)|R]]<ref>{{cite web|url=http://www.iccube.com/support/documentation/mdx_integration/r_integration.html|title=icCube R language integration documentation|publisher=icCube}}</ref>}}
| {{Yes}}
| {{Maybe|In the reporting}}
| {{Yes}}
| {{Yes| icCube reporting and all [[XML for Analysis|XMLA]] compliant visualization tools like Excel, etc}}
| {{Yes}}
| {{Yes}}
|-
! [[Jedox|Jedox OLAP Server]]
| {{Yes}}
| {{Yes}}
| {{Yes}}
| {{Yes|Cube Rules, SVS Triggers}}
| {{Yes}}
| {{No}}
| {{Yes}}
| {{Yes|Microsoft Excel, Qlik, Tableau, Jedox Web, Power BI}}
| {{No}}
| {{Yes}}
|-
![[Kyvos]] 
| {{Yes}}
| {{Yes}}
| {{Yes}}
| {{No}}
| {{Yes}}
| {{Yes}}
| {{No}}
| Kyvos Viz, Microsoft Excel, Qlik, Tableau, Power BI, MicroStrategy, IBM Cognos, Business Objects, XLCubed, Looker, Altryx, and more
| {{Yes}}
| {{Yes}}
|-
! [[Microsoft Analysis Services]]
| {{Yes}}
| {{Yes}}
| {{Yes}}
| {{Yes|[[.NET Framework|.NET]]}}<ref>{{cite web|url=http://msdn.microsoft.com/en-us/library/ms176113.aspx|title=SQL Server 2008 Books Online (October 2009)Defining Stored Procedures|date=9 December 2022 |publisher=[[MSDN]]}}</ref>
| {{Yes}}<ref>{{cite web|url=http://msdn.microsoft.com/en-us/library/ms145486.aspx|title=SQL Server 2008 Books Online (October 2009)Using Stored Procedures|date=28 February 2023 |publisher=[[MSDN]]}}</ref>
| {{Yes}}<ref>{{cite web|url=http://support.microsoft.com/kb/218592/en-gb|title=How to perform a SQL Server distributed query with OLAP Server|date=7 March 2023 |publisher=[[MSDN]]}}</ref>
| {{Yes}}
| {{Yes|Microsoft Excel, SharePoint, Microsoft Power BI, and 70+ other visualization tools}}
| {{No}}
| {{No}}
|-
! [[MicroStrategy|MicroStrategy Intelligence Server]]
| {{Yes}}
| {{No}}
| {{Yes}}
| {{Yes}}
| {{Yes}}
| {{Yes}}
| {{Yes}}
| {{Yes|Dossier, Dashboard, Reports}}
| {{Yes}}
| {{Yes}}
|-
! [[Mondrian OLAP server]]
| {{Yes}}
| {{Yes}}<ref>{{cite web|url=http://www.simba.com/news/Pentaho-Simba-Partner-for-Excel-Connectivity.htm|title=Pentaho and Simba Technologies Partner to Bring World's Most Popular Open Source OLAP Project to Microsoft Excel Users}}</ref>
| {{Yes}}
| {{Yes}}
| {{Yes}}<ref>{{cite web|url=http://mondrian.pentaho.org/documentation/schema.php#User-defined_function|title=How to Define a Mondrian Schema|publisher=Pentaho}}</ref>
| {{No}}
| {{Yes}}
| {{Yes}}<ref>{{cite web|url=http://www.pentaho.com/product/business-visualization-analytics|title=Pentaho Business Analytics Visualization}}</ref>
| {{dunno}}
| {{dunno}}
|-
! [[Oracle OLAP|Oracle Database OLAP Option]]
| {{No}}
| {{Yes}}<ref name="oraclemdx">{{cite web|url=http://www.oracle.com/us/corporate/press/036550|title=Oracle and Simba Technologies Introduce MDX Provider for Oracle OLAP}}</ref>
| {{Yes}}<ref name="oraclemdx"/>
| {{Yes|[[Java (programming language)|Java]], PL/SQL, [[OLAP DML]]}}
| {{Yes}}
| {{Yes}}<ref>{{cite web|url=http://www.oracle.com/technology/products/bi/olap/11g/demos/olap_sql_demo.html|title=Querying Oracle OLAP Cubes: Fast Answers to Tough Questions Using Simple SQL}}</ref>
| {{No}}
| {{dunno}}
| {{dunno}}
| {{dunno}}
|-
! [[SAP NetWeaver Business Intelligence|SAP NetWeaver BW]]
| {{Yes}}
| {{Yes}}
| {{Yes}}
| {{No}}
| {{Yes}}
| {{No}}
| {{Yes}}
| {{dunno}}
| {{dunno}}
| {{dunno}}
|-
! [[SAS System|SAS OLAP Server]]
| {{Yes}}
| {{Yes}}
| {{Yes}}
| {{No}}
| {{No}}
| {{No}}
| {{Yes}}
| {{Yes|Web Report Studio}}
| {{dunno}}
| {{dunno}}
|-
!StarRocks
| {{No}}
| {{No}}
| {{No}}
| {{No}}
| {{Yes}}<ref>{{cite web |title=StarRocks UDF |url=https://docs.starrocks.io/en-us/latest/sql-reference/sql-statements/data-definition/create-function |access-date=6 April 2023}}</ref>
| {{Yes}}
| {{No}}
| Superset, Redash, Metabase, Tableau, Qlik, Pivot, PowerBI
| {{Yes}}
| {{Yes}}
|-
|}

==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.

{{sort-under}}
{| class="wikitable sortable sort-under"  style="font-size: 100%; text-align: center; width: auto;"
|+ Data processing, management and performance related features
|-
!OLAP server
!Real Time
!Write-back
!Partitioning
!Usage Based Optimizations
!Load Balancing and Clustering
|-
!Apache Doris
| {{Yes}}
| {{Yes}}
| {{Yes}}
| {{Yes}}
| {{Yes}}
|-
! [[Apache Druid]]
| {{Yes}}
| {{dunno}}
| {{Yes}}
| {{Yes}}
| {{Yes}}
|-
![[Apache Kylin]]
| {{Yes}}<ref>{{cite web|url=http://kylin.apache.org/docs30/tutorial/realtime_olap.html|title = Real-time OLAP}}</ref>
| {{No}}
| {{Yes}}
| {{Yes}}
| {{Yes}}
|-
! [[Apache Pinot]]
| {{Yes}}
| {{Yes}}
| {{Yes}}
| {{Yes}}
| {{Yes}}
|-
![[ClickHouse]]
| {{Yes}}
| {{Yes}}
| {{Yes}}
| {{Yes}}
| {{Yes}}
|-
! [[Essbase]]
| {{Yes}}
| {{Yes}}
| {{Yes}}
| {{Yes}}
| {{Yes}}
|-
! [[IBM Cognos BI]]
| {{Yes}}
| {{No}}
| {{Yes}}
| {{Yes}}
| {{dunno}}
|-
! [[IBM Cognos TM1]]
| {{Yes}}
| {{Yes}}
| {{Yes}}
| {{dunno}}
| {{dunno}}
|-
! icCube
| {{Yes}}<ref>{{cite web|url=http://www.iccube.com/support/documentation/user_guide/walkthrough/walkthrough_rt.html|title=icCube Real Time walkthrough}}</ref>
| {{No}}
| {{Yes}}<ref>{{cite web|url=http://www.iccube.com/support/documentation/user_guide/reference/partitioning_edition.html|title=icCube Partitioning}}</ref>
| {{dunno}}
| {{dunno}}
|-
! [[Jedox|Jedox OLAP Server]]
| {{Yes}}
| {{Yes}}
| {{Yes}}
| {{dunno}}
| {{dunno}}
|-
![[Kyvos]]
| {{Yes}}
| {{Yes}}
| {{Yes}}
| {{Yes}}
| {{Yes}}
|-
! [[Microsoft Analysis Services]]
| {{Yes}}
| {{Yes}}
| {{Yes}}
| {{Yes}}
| {{Yes}}
|-
! [[MicroStrategy|MicroStrategy Intelligence Server]]
| {{dunno}}
| {{Yes}}<ref>{{cite web|url=http://www.microstrategy.com/Software/Products/Dev_Tools/SDK/extensions.asp|title=Common Extensions of the MicroStrategy Platform|access-date=2010-11-10|archive-url=https://web.archive.org/web/20101128210220/http://microstrategy.com/Software/Products/Dev_Tools/SDK/extensions.asp|archive-date=2010-11-28|url-status=dead}}</ref>
| {{Yes}}
| {{Yes}}
| {{Yes}}
|-
! [[Mondrian OLAP server]]
| {{Yes}}
| {{Yes2 | Planned}}
| {{Yes}}
| {{dunno}}
| {{dunno}}
|-
! [[Oracle OLAP|Oracle Database OLAP Option]]
| {{dunno}}
| {{Yes}}
| {{Yes}}
| {{No}}
| {{dunno}}
|-
! [[SAP NetWeaver Business Intelligence|SAP NetWeaver BW]]
| {{dunno}}
| {{Yes}}
| {{Yes}}
| {{dunno}}
| {{dunno}}
|-
! [[SAS System|SAS OLAP Server]]
| {{dunno}}
| {{Yes}}
| {{Yes}}
| {{dunno}}
| {{dunno}}
|-
!StarRocks
| {{Yes}}
| {{Yes}}
| {{Yes}}
| {{Yes}}
| {{Yes}}
|-
|}

{| class="wikitable sortable sort-under"  style="font-size: 100%; text-align: center; width: auto;"
|+ Data modeling features
|-
!OLAP server
!Semi-additive measures
!Many-to-Many 
!Multi-Cube Model
!Perspectives
!KPI
!Multilingual
!Named Sets
!Multi-attribute Hierarchies
!Actions
|-
!Apache Doris
| {{Yes}}
| {{Yes}}
| {{Yes}}
| {{Yes}}
| {{Yes}}
| {{Yes}}
| {{Yes}}
| {{Yes}}
| {{No}}
|-
! [[Apache Druid]]
| {{Yes}}
| {{Yes}}
| {{Yes}}
| {{dunno}}
| {{No}}
| {{Yes}}
| {{dunno}}
| {{Yes}}
| {{Yes}}
|-
![[Apache Kylin]]
| {{No}}
| {{No}}
| {{Yes}}
| {{No}}
| {{Yes}}
| {{Yes}}
| {{No}}
| {{Yes}}
| {{Yes}}
|-
! [[Apache Pinot]]
| {{Yes}}
| {{Yes}}
| {{dunno}}
| {{dunno}}
| {{No}}
| {{Yes}}
| {{dunno}}
| {{Yes}}
| {{Yes}}
|-
![[ClickHouse]]
| {{Yes}}
| {{Yes}}
| {{Yes}}
| {{Yes}}
| {{Yes}}
| {{Yes}}
| {{Yes}}
| {{Yes}}
| {{No}}
|-
! [[Essbase]]
| {{Yes}}
| {{dunno}}
| {{dunno}}
| {{dunno}}
| {{Yes}}
| {{Yes}}
| {{Yes}}
| {{Yes}}
| {{dunno}}
|-
! [[IBM Cognos BI]]
| {{Yes}}
| {{Yes}}
| {{dunno}}
| {{dunno}}
| {{dunno}}
| {{dunno}}
| {{Yes}}
| {{Yes}}
| {{dunno}}
|-
! [[IBM Cognos TM1]]
| {{Yes}}
| {{Yes}}
| {{Yes}}
| {{dunno}}
| {{dunno}}
| {{dunno}}
| {{dunno}}
| {{dunno}}
| {{dunno}}
|-
! icCube
| {{Yes}}<ref>{{cite web|url=http://www.iccube.com/support/documentation/user_guide/schemas_cubes/facts_aggregation.html|title=icCube Aggregatin types}}</ref>
| {{Yes}}
| {{Yes}}
| {{Yes}}
| {{Yes}}
| {{Yes}}
| {{Yes}}
| {{Yes}}
| {{dunno}}
|-
! [[Jedox|Jedox OLAP Server]]
| {{Yes}}
| {{Yes}}
| {{Yes}}
| {{Yes}}
| {{Yes}}
| {{Yes}}
| {{Yes}}
| {{Yes}}
| {{dunno}}
|-
![[Kyvos]] 
| {{Yes}}
| {{Yes}}
| {{Yes}}
| {{No}}
| {{Yes}}
| {{Yes}}
| {{Yes}}
| {{Yes}}
| {{No}}
|-
! [[Microsoft Analysis Services]]
| {{Yes}}
| {{Yes}}
| {{Yes}}
| {{Yes}}
| {{Yes}}
| {{Yes}}
| {{Yes}}
| {{Yes}}
| {{Yes}}
|-
! [[MicroStrategy|MicroStrategy Intelligence Server]]
| {{Yes}}
| {{Yes}}
| {{Yes}}
| {{Yes}}
| {{Yes}}
| {{Yes}}
| {{Yes}}
| {{Yes}}
| {{Yes}}
|-
! [[Mondrian OLAP server]]
| {{Yes}}<ref>{{cite web|url=http://jira.pentaho.com/browse/MONDRIAN-962|title=Support for Non-Additive and Semi-Additive Measures}}</ref>
| {{dunno}}
| {{dunno}}
| {{dunno}}
| {{dunno}}
| {{dunno}}
| {{dunno}}
| {{dunno}}
| {{dunno}}
|-
! [[Oracle OLAP|Oracle Database OLAP Option]]
| {{Yes}}
| {{dunno}}
| {{dunno}}
| {{dunno}}
| {{dunno}}
| {{dunno}}
| {{dunno}}
| {{dunno}}
| {{dunno}}
|-
! [[SAP NetWeaver Business Intelligence|SAP NetWeaver BW]]
| {{Yes}}
| {{dunno}}
| {{dunno}}
| {{dunno}}
| {{dunno}}
| {{dunno}}
| {{dunno}}
| {{dunno}}
| {{dunno}}
|-
! [[SAS System|SAS OLAP Server]]
| {{Yes}}
| {{dunno}}
| {{dunno}}
| {{dunno}}
| {{dunno}}
| {{dunno}}
| {{dunno}}
| {{dunno}}
| {{dunno}}
|-
!StarRocks
| {{Yes}}
| {{Yes}}
| {{Yes}}
| {{Yes}}
| {{Yes}}
| {{Yes}}
| {{Yes}}
| {{Yes}}
| {{No}}
|}

==System limits==
{| class="wikitable sortable"  style="font-size: 100%; text-align: center; width: auto;"
|-
!OLAP server
!# cubes
!# measures
!# dimensions
!# dimensions in cube
!# hierarchies in dimension
!# levels in hierarchy
!# dimension members
|-
!Apache Doris
|Unrestricted
|Unrestricted
|Unrestricted
|Unrestricted
|Unrestricted
|Unrestricted
|Unrestricted
|-
! [[Apache Druid]]
| Unrestricted{{efn|name=fn0}}
| Unrestricted
| Unrestricted
| Unrestricted
| Unrestricted
| Unrestricted
| Unrestricted
|-
![[Apache Kylin]]
|Unrestricted
|Unrestricted
|Unrestricted
|Unrestricted
|Unrestricted
|Unrestricted
|Unrestricted
|-
![[Apache Pinot]]
|Unrestricted
|Unrestricted
|Unrestricted
|Unrestricted
|Unrestricted
|Unrestricted
|Unrestricted
|-
![[ClickHouse]]
|Unrestricted
|Unrestricted
|Unrestricted
|Unrestricted
|Unrestricted
|Unrestricted
|Unrestricted
|-
! [[Essbase]]<ref>{{cite web|url=http://docs.oracle.com/cd/E57185_01/epm.1112/essbase_db/frameset.htm?limits.html|title=Essbase Server Limits|publisher=Oracle|access-date=2015-06-25|archive-url=https://web.archive.org/web/20150626101348/http://docs.oracle.com/cd/E57185_01/epm.1112/essbase_db/frameset.htm?limits.html|archive-date=2015-06-26|url-status=dead}}</ref>
| Unrestricted
| Unrestricted
| Unrestricted
| 255
| 255
| ?
| 20,000,000 (ASO), 1,000,000 (BSO)
|-
! [[IBM Cognos TM1]]
| Unrestricted{{efn|name=fn0}}
| Unrestricted
| Unrestricted{{efn|name=fn0}}
| 256
| Unrestricted{{efn|name=fn0}}
| Unrestricted
| Unrestricted
|-
! icCube<!-- Java Integer, 32 bits -->
| 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
|-
![[Jedox|Jedox OLAP Server]]
|<math>2^{32}</math> (32 bits)
|<math>2^{32}</math>
|<math>2^{32}</math> (32 bits)
| 250
|<math>2^{32}</math>
|<math>2^{32}</math>
|<math>2^{32}</math>
|-
![[Kyvos]]
|Unrestricted
|Unrestricted
|Unrestricted
|Unrestricted
|Unrestricted
|Unrestricted
|Unrestricted
|-
! [[Microsoft Analysis Services]]<ref>{{cite web|url=https://technet.microsoft.com/en-us/library/ms365363.aspx|title=SQL Server 2008 Books Online (October 2009)Maximum Capacity Specifications (Analysis Services - Multidimensional Data)|date=9 December 2022 |publisher=Microsoft}}</ref>
| 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|MicroStrategy Intelligence Server]]<!-- Unrestricted by server - based on hardware limits, infinite it's not possible ;-) -->
| Unrestricted{{efn|name=fn0}}
| Unrestricted{{efn|name=fn0}}
| Unrestricted{{efn|name=fn0}}
| ?
| Unrestricted{{efn|name=fn0}}
| Unrestricted{{efn|name=fn0}}
| Unrestricted{{efn|name=fn0}}
|-
! [[SAS System|SAS OLAP Server]]<ref>{{cite web|url=http://support.sas.com/documentation/cdl/en/olapug/63148/HTML/default/viewer.htm#p0m66bhcbgqwjen1jyfhf6woysu3.htm|title=SAS OLAP Cube Size Specifications}}</ref>
| Unrestricted{{efn|name=fn0}}
| 1024
| 128
| ?
| 128
| 19
| 4,294,967,296
|-
!StarRocks
|Unrestricted
|Unrestricted
|Unrestricted
|Unrestricted
|Unrestricted
|Unrestricted
|Unrestricted
|}
{{notelist|notes=
{{efn|name=fn0|Please update as 'unrestricted', is just not possible}}
}}

==Security==
{{sort under}}
{| class="wikitable sortable sort-under"  style="font-size: 100%; text-align: center; width: auto;"
|-
!rowspan="2"| OLAP server
!rowspan="2"| Authentication
!rowspan="2"| Network encryption
!rowspan="2"| On-the-Fly{{efn|name=fn1}}
!colspan="3"| Data access
|-
!Cell security
!Dimension security
!Visual totals
|-
!Apache Doris
| {{Yes|Built-in, LDAP, Kerberos}}
| {{Yes|[[Transport Layer Security|SSL]]}}
| {{Yes}}
| {{Yes}}
| {{Yes}}
| {{Yes}}
|-
! [[Apache Druid]]
| {{Yes|Druid Database authentication}}
| {{Yes|[[Transport Layer Security|SSL]]}}
| {{Yes}}
| {{No}}
| {{Yes}}
| {{No}}
|-
![[Apache Kylin]]
|  {{Yes|LDAP, SAML, Kerboros, Microsoft Active Directory}}
|  {{Yes|SSL}}
| {{Yes}}
| {{No}}
| {{No}}
| {{dunno}}
|-
! [[Apache Pinot]]
| {{Yes|[https://docs.pinot.apache.org/operators/tutorials/authentication-authorization-and-acls HTTP basic authentication]}}
| {{Yes|[[Transport Layer Security|SSL]]}}
| {{dunno}}
| {{No}}
| {{No}}
| {{No}}
|-
![[ClickHouse]]
| {{Yes|Built-in, [[LDAP]], [[Microsoft Active Directory]], [[Kerberos (protocol)|Kerberos]]}}
| {{Yes|[[Transport Layer Security|SSL]]}}
| {{Yes}}
| {{Yes}}
| {{Yes}}
| {{Yes}}
|-
! [[Essbase]]
| {{Yes|Essbase authentication, [[LDAP]] authentication, [[Microsoft Active Directory]]}}
| {{Yes|[[Transport Layer Security|SSL]]}}
| {{Yes}}
| {{Yes}}
| {{Yes}}
| {{No}}
|-
! [[IBM Cognos TM1]]
| {{Yes|Builtin, [[LDAP]], [[Microsoft Active Directory]], [[NTLM]], IBM Cognos BI authentication}}
| {{Yes|[[Transport Layer Security|SSL]]}}
| {{Yes}}
| {{Yes}}
| {{Yes}}
| {{Yes}}
|-
! icCube
| {{Yes|HTTP Basic/Form Authentication, Windows SSO (NTLM, Kerberos), Plugin Based for Embedded Usage}}
| {{Yes|[[Transport Layer Security|SSL]]}}
| {{Yes}}
| {{Yes}}
| {{Yes}}
| {{Yes}}
|-
! [[Jedox|Jedox OLAP Server]]
| {{Yes|Jedox authentication, [[LDAP]], [[Microsoft Active Directory]]}}
| {{Yes|[[Transport Layer Security|SSL]]}}
| {{Yes}}
| {{Yes}}
| {{Yes}}
| {{dunno}}
|-
![[Kyvos]]
| {{Yes|Built-in, [[LDAP]], [[Microsoft Active Directory]], SAML, Windows SSO (NTLM, Kerberos)}}
| {{Yes|[[Transport Layer Security|SSL]]}}
| {{Yes}}
| {{Yes}}
| {{Yes}}
| {{Yes}}
|-
! [[Microsoft Analysis Services]]
| {{Yes|[[NTLM]], [[Kerberos (protocol)|Kerberos]]}}
| {{Yes|[[Transport Layer Security|SSL]] and [[SSPI]]}}
| {{Yes}}
| {{Yes}}
| {{Yes}}
| {{Yes}}
|-
! [[MicroStrategy|MicroStrategy Intelligence Server]]
| {{Yes|Host authentication, database authentication, [[LDAP]], <br />[[Microsoft Active Directory]], [[NTLM]], SiteMinder, Tivoli, SAP, [[Kerberos (protocol)|Kerberos]]}}
| {{Yes|[[Transport Layer Security|SSL]], AES<ref>{{Cite web |url=http://latam.microstrategy.com/Software/Products/Intelligence_Server/features.asp |title=MicroStrategy Intelligence Server Features |access-date=2010-11-10 |archive-url=https://archive.today/20120710203458/http://latam.microstrategy.com/Software/Products/Intelligence_Server/features.asp |archive-date=2012-07-10 |url-status=dead }}</ref>}}
| {{dunno}}
| {{Yes}}
| {{Yes}}
| {{Yes}}
|-
! [[Oracle OLAP|Oracle Database OLAP Option]]
| {{Yes|Oracle Database authentication}}
| {{Yes|[[Transport Layer Security|SSL]]}}
| {{dunno}}
| {{Yes}}
| {{Yes}}
| {{No}}
|-
! [[SAS System|SAS OLAP Server]]<ref>{{cite web|url=http://support.sas.com/documentation/cdl/en/mdxag/59575/HTML/default/a003230130.htm|title=SAS OLAP Security Totals and Permission Conditions}}</ref>
| {{Yes|Host authentication, SAS token authentication, [[LDAP]], [[Microsoft Active Directory]]}}
| {{Yes}}<ref>{{cite web|url=http://support.sas.com/documentation/cdl/en/bisecag/61133/HTML/default/a003275910.htm|title=How to Change Over-the-Wire Encryption Settings for SAS Servers}}</ref>
| {{dunno}}
| {{Yes}}
| {{Yes}}
| {{Yes}}
|}
{{notelist|notes=
{{efn|name=fn1|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 system]]s:
{| class="wikitable sortable"  style="font-size: 100%; text-align: center; width: auto;"
|-
! OLAP server
! Windows
! Linux
! UNIX
! z/OS
! AIX
|-
!Apache Doris
| {{No}}
| {{Yes}}
| {{Yes}}
| {{No}}
| {{No}}
|-
! [[Apache Druid]]
| {{No}}
| {{Yes}}
| {{Yes}}
|
|
|-
![[Apache Kylin]]
| {{No}}
| {{Yes}}
| {{Yes}}
| {{No}}
| {{No}}
|-
! [[Apache Pinot]]
| {{Yes}}
| {{Yes}}
| {{Yes}}
| {{Yes}}
| {{Yes}}
|-
![[ClickHouse]]
| {{No}}
| {{Yes}}
| {{Yes}}
| {{No}}
| {{No}}
|-
! [[Essbase]]
| {{Yes}}
| {{Yes}}
| {{Yes}}
| {{No}}
| {{Yes}}
|-
! [[IBM Cognos TM1]]
| {{Yes}}
| {{Yes}}
| {{Yes}}
| {{No}}
| {{Yes}}
|-
! icCube
| {{Yes}}
| {{Yes}}
| {{Yes}}
| {{Yes}}
| {{Yes}}
|-
! [[Jedox|Jedox OLAP Server]]
| {{Yes}}
| {{Yes}}
| {{Yes}}
| {{No}}
|
|-
![[Kyvos]]
| {{No}}
| {{Yes}}
| {{Yes}}
| {{No}}
| {{No}}
|-
! [[Microsoft Analysis Services]]
| {{Yes}}
| {{No}}
| {{No}}
| {{No}}
|
|-
! [[MicroStrategy|MicroStrategy Intelligence Server]]
| {{Yes}}
| {{Yes}}
| {{Yes}}
| {{No}}
| {{Yes}}
|-
! [[Mondrian OLAP server]]
| {{Yes}}
| {{Yes}}
| {{Yes}}
| {{Yes}}
|
|-
! [[Oracle OLAP|Oracle Database OLAP Option]]
| {{Yes}}
| {{Yes}}
| {{Yes}}
| {{Yes}}
|
|-
! [[SAP NetWeaver Business Intelligence|SAP NetWeaver BW]]
| {{Yes}}
| {{Yes}}
| {{Yes}}
| {{Yes}}
|
|-
! [[SAS System|SAS OLAP Server]]
| {{Yes}}
| {{Yes}}
| {{Yes}}
| {{Yes}}
|
|-
!StarRocks
| {{No}}
| {{Yes}}
| {{Yes}}
| {{No}}
| {{No}}
|}
Note (1):The server availability depends on [[JVM|Java Virtual Machine]] not on the [[operating system]]

==Support information==
{| class="wikitable sortable"  style="font-size: 100%; text-align: center; width: auto;"
|-
! OLAP server
! Issue Tracking System
! Roadmap
! Source code
|-
!Apache Doris
| [https://github.com/apache/doris/issues Apache Doris– Github Issues]
| [https://github.com/apache/doris/issues/30669 Apache Doris Roadmap]
| {{Yes|Open}}
|-
! [[Apache Druid]]
| [https://github.com/druid-io/druid/issues Druid – Github Issues]
|
| {{Yes|Open}}
|-
! [[Apache Kylin]]
| [https://issues.apache.org/jira/projects/KYLIN/issues Jira]
|[http://kylin.apache.org/development/ Apache Kylin Roadmap]
| {{Yes|Open}}
|-
! [[Apache Pinot]]
| [https://github.com/apache/incubator-pinot/issues Apache Pinot – Github Issues]
|
| {{Yes|Open}}
|-
![[ClickHouse]]
| [https://github.com/ClickHouse/ClickHouse/issues ClickHouse – Github Issues]
| [https://clickhouse.tech/docs/en/whats-new/roadmap/ ClickHouse Roadmap]
| {{Yes|Open}}
|-
![[Essbase]]
| [http://support.oracle.com myOracle Support]
|{{usurped|1=[https://web.archive.org/web/20100705081200/http://communities.ioug.org/Portals/2/Oracle_Essbase_Roadmap_Sep_09.pdf]}}
| {{No|Closed}}
|-
! [[IBM Cognos TM1]]
| [http://ibm.com/support/servicerequest/ IBM Service Request]
|
| {{No|Closed}}
|-
! icCube
| [https://stackoverflow.com/questions/tagged/iccube Stackoverflow]
| 
| {{No|Closed}}
|-
![[Jedox|Jedox OLAP Server]]
| {{usurped|1=[https://web.archive.org/web/20110812224712/http://bugs.palo.net/mantis/main_page.php Mantis]}}
| Available upon request
| {{Yes|Open}}
|-
![[Kyvos]]
| Zendesk
| Available upon request
| {{No|Closed}}
|-
![[Microsoft Analysis Services]]
| [https://connect.microsoft.com/SQLServer Connect]
|  -
| {{No|Closed}}
|-
![[MicroStrategy|MicroStrategy Intelligence Server]]
| [https://resource.microstrategy.com/Support/MainSearch.aspx MicroStrategy Resource Center]
|  -
| {{No|Closed}}
|-
! [[Mondrian OLAP server]]
|[http://jira.pentaho.com/browse/MONDRIAN Jira]
|[http://mondrian.pentaho.org/documentation/roadmap.php]
| {{Yes|Open}}
|-
![[Oracle OLAP|Oracle Database OLAP Option]]
| [http://support.oracle.com myOracle Support]
|
| {{No|Closed}}
|-
! [[SAP NetWeaver Business Intelligence|SAP NetWeaver BW]]
| [http://service.sap.com/ OSS]
| {{usurped|1=[https://web.archive.org/web/20110716004633/http://esworkplace.sap.com/socoview(bD1lbiZjPTAwMSZkPW1pbg==)/render.asp?id=2270EAD629814D05A7ECECECECC8D002&fragID=&packageid=DEE98D07DF9FA9F1B3C7001A64D3F462]}}
| {{No|Closed}}
|-
![[SAS System|SAS OLAP Server]]
| [http://support.sas.com/forums/index.jspa Support]
|
| {{No|Closed}}
|-
!StarRocks
| [https://github.com/StarRocks/starrocks/issues StarRocks– Github Issues]
| [https://github.com/StarRocks/starrocks/issues/16445 StarRocks Roadmap]
| {{Yes|Open}}
|}

==See also==
* [[Cubes (OLAP server)|Cubes]] (light-weight open-source OLAP server)
* [[ClickHouse]]
* [[Apache Pinot]]
* [[Apache Druid]]
* [https://doris.apache.org/docs/summary/basic-summary Apache Doris]
* [[Essbase|Oracle Essbase]]
* [[Oracle Retail Predictive Application Server (RPAS)]], a retail specific MOLAP/OLAP server using Berkeley DB for persistence
* [[Palo (OLAP database)]]
* [https://starrocks.io StarRocks]

==References==
{{reflist}}

{{Data warehouse}}

{{DEFAULTSORT:Comparison Of Olap Servers}}
[[Category:Online analytical processing| ]]
[[Category:Network software comparisons|OLAP Servers]]
[[Category:Data management]]
[[Category:Data warehousing products]]