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

| Apache Software Foundation

| {{cite web |title=Apache Doris |url=https://doris.apache.org/ |website=Github |access-date=6 April 2023}}

| 1.2.3

| Apache 2.0

| free

Apache Druid

| Apache Software Foundation

| {{Cite web|url=http://druid.io/|title=Druid {{!}} Interactive Analytics at Scale|last=druid|website=druid.io|language=en|access-date=2017-09-01}}

| 29.0.0{{Cite web|url=https://druid.apache.org/downloads/|title=Latest Release}}

| Apache 2.0

| free

Apache Kylin

|Apache Software Foundation

|{{Cite web|url=http://kylin.apache.org/|title=Apache Kylin {{!}} Home|last=Kylin|first=Apache|website=kylin.apache.org|access-date=2018-11-08}}

|3.1.0

|Apache 2.0

|free

Apache Pinot

|Apache Software Foundation

|{{Cite web|url=http://pinot.apache.org/|title=Apache Pinot {{!}} Home|last=Pinot|first=Apache|website=pinot.apache.org|access-date=2021-07-14}}

|1.1.0

|Apache 2.0

|free

Atoti

|ActiveViam

|{{Cite web|url=https://atoti.io/|title=Atoti}}

|6.0.5

| Proprietary

|community

ClickHouse

|[https://clickhouse.com/ Clickhouse Inc]

|{{Cite web|url=https://clickhouse.tech/|title=ClickHouse}}

|24.5

|Apache 2.0

|free

Essbase

| Oracle

|{{cite web|url=https://www.oracle.com/business-analytics/essbase.html|title=Oracle Essbase}}

| 21.6

| Proprietary

| [http://www.oracle.com/us/corporate/pricing/index.htm]

IBM Cognos TM1

| IBM

|{{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 }}

| 10.2.2 FP7

| Proprietary

| -

icCube

|[https://icCube.com/ icCube SARL]

|{{cite web|url=http://www.icCube.com|title=icCube OLAP Server}}

| 8.4.14

| Proprietary

| community / [https://www.iccube.com/pricing]

Jedox OLAP Server

| Jedox

|{{cite web|url=http://www.jedox.com |title=Jedox}}

| 2019.3

| Proprietary

| {{usurped|1=[https://web.archive.org/web/20170203080718/http://www.jedox.com/en/product/license-model/]}}

Kyvos

| Kyvos Insights

|{{cite web|url=http://www.kyvosinsights.com/product/kyvos-architecture/ |title=Kyvos}}

| 2024.3

| Proprietary

| [https://www.kyvosinsights.com/pricing/ Pricing]-

Microsoft Analysis Services

| Microsoft

|{{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}}

| 2022

| Proprietary

| [http://www.microsoft.com/sqlserver/2008/en/us/pricing.aspx]

Mondrian OLAP server

| Pentaho

|{{cite web|url=http://mondrian.pentaho.org|title=Pentaho Analysis Services: Mondrian Project}}

| 3.7

| EPL

| free

Oracle Database OLAP Option

| Oracle

|{{cite web|url=http://www.oracle.com/technetwork/database/options/olap/index.html|title=Oracle OLAP Documentation}}

| 11g R2

| Proprietary

| [http://www.oracle.com/us/corporate/pricing/index.htm]

SAP NetWeaver BW

| SAP

|{{cite web|url=http://www.sap.com/usa/platform/netweaver/components/businesswarehouse/index.epx |title=Components & Tools}}

| 7.30

| Proprietary

| -

SAS OLAP Server

| SAS Institute

|{{cite web|url=http://www.sas.com/technologies/dw/storage/mddb/index.html|title=SAS OLAP Server}}

| 9.4

| Proprietary

| -

[http://starrocks.io StarRocks]

|Linux Foundation

|{{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}}

|3.1

|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}}

|

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 OLAP Server

| {{Yes}}

| {{No}}

| {{No}}

| {{No}}

Kyvos

| {{Yes}}

| {{Yes}}

| {{Yes}}

| {{Yes}}

Microsoft Analysis Services

| {{Yes}}

| {{Yes}}

| {{Yes}}

| {{Yes|Local cubes,
PowerPivot for Excel,
Power BI Desktop}}

MicroStrategy Intelligence Server

| {{Yes}}

| {{Yes}}

| {{Yes}}

| {{Yes|[http://www.microstrategy.com/Software/Products/User_Interfaces/Office/ MicroStrategy Office],
[http://www.microstrategy.com/Software/Products/Service_Modules/Report_Services/ Dynamic Dashboards]}}

Mondrian OLAP server

| {{No}}

| {{Yes}}

| {{No}}

|

Oracle Database OLAP Option

| {{Yes}}

| {{No}}

| {{No}}

|

SAP NetWeaver BW

| {{Yes}}

| {{Yes}}

| {{No}}

|

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

! MDX

! Stored procedures

! Custom functions

! SQL

! 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}}

! Visualization

! JSON

! REST API

Apache Doris

| {{No}}

| {{No}}

| {{No}}

| {{No}}

| {{Yes}}{{cite web |title=Apache Doris UDF |url=https://doris.apache.org/docs/dev/ecosystem/udf/contribute-udf |access-date=6 April 2023}}

| {{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}}{{cite web|url=https://clickhouse.tech/docs/en/sql-reference/|title=ClickHouse SQL Reference|publisher=Yandex}}

| {{Yes}}

| {{No}}

| Superset, Zeppelin, Tableau, Qlik, Redash, DataLens{{cite web|url=https://clickhouse.tech/docs/en/interfaces/third-party/gui/|title=ClickHouse Visual Interfaces|publisher=Yandex}}

| {{Yes}}

| {{Yes}}

Essbase

| {{Yes}}

| {{Yes}}

| {{Yes}}

| {{Yes}}

| {{Yes}}

| {{No}}

| {{Yes}}

| SmartView (Excel-AddIn), Oracle Analytics Cloud, Narrative Reporting, Tableau, IBM Cognos

| {{dunno}}

| {{Yes}}

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,{{cite web|url=http://www.iccube.com/support/documentation/mdx_integration/java_integration.html|title=icCube Java integration documentation|publisher=icCube}} R{{cite web|url=http://www.iccube.com/support/documentation/mdx_integration/r_integration.html|title=icCube R language integration documentation|publisher=icCube}}}}

| {{Yes}}

| {{Maybe|In the reporting}}

| {{Yes}}

| {{Yes| icCube reporting and all XMLA compliant visualization tools like Excel, etc}}

| {{Yes}}

| {{Yes}}

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}}{{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}}

| {{Yes}}{{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}}

| {{Yes}}{{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}}

| {{Yes}}

| {{Yes|Microsoft Excel, SharePoint, Microsoft Power BI, and 70+ other visualization tools}}

| {{No}}

| {{No}}

MicroStrategy Intelligence Server

| {{Yes}}

| {{No}}

| {{Yes}}

| {{Yes}}

| {{Yes}}

| {{Yes}}

| {{Yes}}

| {{Yes|Dossier, Dashboard, Reports}}

| {{Yes}}

| {{Yes}}

Mondrian OLAP server

| {{Yes}}

| {{Yes}}{{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}}

| {{Yes}}

| {{Yes}}

| {{Yes}}{{cite web|url=http://mondrian.pentaho.org/documentation/schema.php#User-defined_function|title=How to Define a Mondrian Schema|publisher=Pentaho}}

| {{No}}

| {{Yes}}

| {{Yes}}{{cite web|url=http://www.pentaho.com/product/business-visualization-analytics|title=Pentaho Business Analytics Visualization}}

| {{dunno}}

| {{dunno}}

Oracle Database OLAP Option

| {{No}}

| {{Yes}}{{cite web|url=http://www.oracle.com/us/corporate/press/036550|title=Oracle and Simba Technologies Introduce MDX Provider for Oracle OLAP}}

| {{Yes}}

| {{Yes|Java, PL/SQL, OLAP DML}}

| {{Yes}}

| {{Yes}}{{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}}

| {{No}}

| {{dunno}}

| {{dunno}}

| {{dunno}}

SAP NetWeaver BW

| {{Yes}}

| {{Yes}}

| {{Yes}}

| {{No}}

| {{Yes}}

| {{No}}

| {{Yes}}

| {{dunno}}

| {{dunno}}

| {{dunno}}

SAS OLAP Server

| {{Yes}}

| {{Yes}}

| {{Yes}}

| {{No}}

| {{No}}

| {{No}}

| {{Yes}}

| {{Yes|Web Report Studio}}

| {{dunno}}

| {{dunno}}

StarRocks

| {{No}}

| {{No}}

| {{No}}

| {{No}}

| {{Yes}}{{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}}

| {{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}}{{cite web|url=http://kylin.apache.org/docs30/tutorial/realtime_olap.html|title = Real-time OLAP}}

| {{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}}{{cite web|url=http://www.iccube.com/support/documentation/user_guide/walkthrough/walkthrough_rt.html|title=icCube Real Time walkthrough}}

| {{No}}

| {{Yes}}{{cite web|url=http://www.iccube.com/support/documentation/user_guide/reference/partitioning_edition.html|title=icCube Partitioning}}

| {{dunno}}

| {{dunno}}

Jedox OLAP Server

| {{Yes}}

| {{Yes}}

| {{Yes}}

| {{dunno}}

| {{dunno}}

Kyvos

| {{Yes}}

| {{Yes}}

| {{Yes}}

| {{Yes}}

| {{Yes}}

Microsoft Analysis Services

| {{Yes}}

| {{Yes}}

| {{Yes}}

| {{Yes}}

| {{Yes}}

MicroStrategy Intelligence Server

| {{dunno}}

| {{Yes}}{{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}}

| {{Yes}}

| {{Yes}}

| {{Yes}}

Mondrian OLAP server

| {{Yes}}

| {{Yes2 | Planned}}

| {{Yes}}

| {{dunno}}

| {{dunno}}

Oracle Database OLAP Option

| {{dunno}}

| {{Yes}}

| {{Yes}}

| {{No}}

| {{dunno}}

SAP NetWeaver BW

| {{dunno}}

| {{Yes}}

| {{Yes}}

| {{dunno}}

| {{dunno}}

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}}{{cite web|url=http://www.iccube.com/support/documentation/user_guide/schemas_cubes/facts_aggregation.html|title=icCube Aggregatin types}}

| {{Yes}}

| {{Yes}}

| {{Yes}}

| {{Yes}}

| {{Yes}}

| {{Yes}}

| {{Yes}}

| {{dunno}}

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 Intelligence Server

| {{Yes}}

| {{Yes}}

| {{Yes}}

| {{Yes}}

| {{Yes}}

| {{Yes}}

| {{Yes}}

| {{Yes}}

| {{Yes}}

Mondrian OLAP server

| {{Yes}}{{cite web|url=http://jira.pentaho.com/browse/MONDRIAN-962|title=Support for Non-Additive and Semi-Additive Measures}}

| {{dunno}}

| {{dunno}}

| {{dunno}}

| {{dunno}}

| {{dunno}}

| {{dunno}}

| {{dunno}}

| {{dunno}}

Oracle Database OLAP Option

| {{Yes}}

| {{dunno}}

| {{dunno}}

| {{dunno}}

| {{dunno}}

| {{dunno}}

| {{dunno}}

| {{dunno}}

| {{dunno}}

SAP NetWeaver BW

| {{Yes}}

| {{dunno}}

| {{dunno}}

| {{dunno}}

| {{dunno}}

| {{dunno}}

| {{dunno}}

| {{dunno}}

| {{dunno}}

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{{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}}

| 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

| 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 OLAP Server

|2^{32} (32 bits)

|2^{32}

|2^{32} (32 bits)

| 250

|2^{32}

|2^{32}

|2^{32}

Kyvos

|Unrestricted

|Unrestricted

|Unrestricted

|Unrestricted

|Unrestricted

|Unrestricted

|Unrestricted

Microsoft Analysis Services{{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}}

| 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{{efn|name=fn0}}

| Unrestricted{{efn|name=fn0}}

| Unrestricted{{efn|name=fn0}}

| ?

| Unrestricted{{efn|name=fn0}}

| Unrestricted{{efn|name=fn0}}

| Unrestricted{{efn|name=fn0}}

SAS OLAP Server{{cite web|url=http://support.sas.com/documentation/cdl/en/olapug/63148/HTML/default/viewer.htm#p0m66bhcbgqwjen1jyfhf6woysu3.htm|title=SAS OLAP Cube Size Specifications}}

| 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|SSL}}

| {{Yes}}

| {{Yes}}

| {{Yes}}

| {{Yes}}

Apache Druid

| {{Yes|Druid Database authentication}}

| {{Yes|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|SSL}}

| {{dunno}}

| {{No}}

| {{No}}

| {{No}}

ClickHouse

| {{Yes|Built-in, LDAP, Microsoft Active Directory, Kerberos}}

| {{Yes|SSL}}

| {{Yes}}

| {{Yes}}

| {{Yes}}

| {{Yes}}

Essbase

| {{Yes|Essbase authentication, LDAP authentication, Microsoft Active Directory}}

| {{Yes|SSL}}

| {{Yes}}

| {{Yes}}

| {{Yes}}

| {{No}}

IBM Cognos TM1

| {{Yes|Builtin, LDAP, Microsoft Active Directory, NTLM, IBM Cognos BI authentication}}

| {{Yes|SSL}}

| {{Yes}}

| {{Yes}}

| {{Yes}}

| {{Yes}}

icCube

| {{Yes|HTTP Basic/Form Authentication, Windows SSO (NTLM, Kerberos), Plugin Based for Embedded Usage}}

| {{Yes|SSL}}

| {{Yes}}

| {{Yes}}

| {{Yes}}

| {{Yes}}

Jedox OLAP Server

| {{Yes|Jedox authentication, LDAP, Microsoft Active Directory}}

| {{Yes|SSL}}

| {{Yes}}

| {{Yes}}

| {{Yes}}

| {{dunno}}

Kyvos

| {{Yes|Built-in, LDAP, Microsoft Active Directory, SAML, Windows SSO (NTLM, Kerberos)}}

| {{Yes|SSL}}

| {{Yes}}

| {{Yes}}

| {{Yes}}

| {{Yes}}

Microsoft Analysis Services

| {{Yes|NTLM, Kerberos}}

| {{Yes|SSL and SSPI}}

| {{Yes}}

| {{Yes}}

| {{Yes}}

| {{Yes}}

MicroStrategy Intelligence Server

| {{Yes|Host authentication, database authentication, LDAP,
Microsoft Active Directory, NTLM, SiteMinder, Tivoli, SAP, Kerberos}}

| {{Yes|SSL, AES{{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 }}}}

| {{dunno}}

| {{Yes}}

| {{Yes}}

| {{Yes}}

Oracle Database OLAP Option

| {{Yes|Oracle Database authentication}}

| {{Yes|SSL}}

| {{dunno}}

| {{Yes}}

| {{Yes}}

| {{No}}

SAS OLAP Server{{cite web|url=http://support.sas.com/documentation/cdl/en/mdxag/59575/HTML/default/a003230130.htm|title=SAS OLAP Security Totals and Permission Conditions}}

| {{Yes|Host authentication, SAS token authentication, LDAP, Microsoft Active Directory}}

| {{Yes}}{{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}}

| {{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 systems:

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 OLAP Server

| {{Yes}}

| {{Yes}}

| {{Yes}}

| {{No}}

|

Kyvos

| {{No}}

| {{Yes}}

| {{Yes}}

| {{No}}

| {{No}}

Microsoft Analysis Services

| {{Yes}}

| {{No}}

| {{No}}

| {{No}}

|

MicroStrategy Intelligence Server

| {{Yes}}

| {{Yes}}

| {{Yes}}

| {{No}}

| {{Yes}}

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}}

|

StarRocks

| {{No}}

| {{Yes}}

| {{Yes}}

| {{No}}

| {{No}}

Note (1):The server availability depends on 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 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 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 Database OLAP Option

| [http://support.oracle.com myOracle Support]

|

| {{No|Closed}}

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

References

{{reflist}}

{{Data warehouse}}

{{DEFAULTSORT:Comparison Of Olap Servers}}

OLAP Servers

Category:Data management

Category:Data warehousing products