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 Apache Doris Apache Software Foundation 1.2.3 Apache 2.0 free Apache Druid Apache Software Foundation 29.0.0 Apache 2.0 freeApache KylinApache Software Foundation3.1.0Apache 2.0freeApache PinotApache Software Foundation1.1.0Apache 2.0freeAtotiActiveViam6.0.5 ProprietarycommunityClickHouseClickhouse Inc24.5Apache 2.0free Essbase Oracle Proprietary IBM Cognos TM1 IBM 10.2.2 FP7 Proprietary - icCubeicCube SARL 9.0.1 Proprietary community / Jedox OLAP Server Jedox 2019.3 Proprietary Microsoft Analysis Services Microsoft 2022 Proprietary Mondrian OLAP server Pentaho 3.7 EPL free Oracle Database OLAP Option Oracle 11g R2 Proprietary SAP NetWeaver BW SAP 7.30 Proprietary - SAS OLAP Server SAS Institute 9.4 Proprietary -StarRocksLinux Foundation3.5Apache 2.0free

Data storage modes OLAP server MOLAP ROLAP HOLAP OfflineApache Doris Apache Druid Apache Kylin Apache Pinot ClickHouse Essbase IBM Cognos BI IBM Cognos TM1 icCube Jedox OLAP Server Microsoft Analysis Services MicroStrategy Intelligence Server Mondrian OLAP server Oracle Database OLAP Option SAP NetWeaver BW SAS OLAP Server StarRocks

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 Visualization JSON REST APIApache Doris Superset, Redash, Metabase, Tableau, Qlik, Pivot, PowerBI Apache Druid Druid SQL Superset, Pivot, Redash Apache Kylin Superset, Zeppelin, Tableau, Qlik, Redash, Microsoft Excel Apache Pinot Superset, Pivot, Redash ClickHouse Superset, Zeppelin, Tableau, Qlik, Redash, DataLens Essbase SmartView (Excel-AddIn), Oracle Analytics Cloud, Narrative Reporting, Tableau, IBM Cognos IBM Cognos TM1 TM1 Web/TM1 Contributor, IBM Cognos Insight, IBM Performance Modeler, IBM Cognos Cafe for Excel, Cognos BI, TM1 Perspectives for Excel icCube Jedox OLAP Server Microsoft Analysis Services MicroStrategy Intelligence Server Mondrian OLAP server Oracle Database OLAP Option SAP NetWeaver BW SAS OLAP Server StarRocks 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 featuresOLAP serverReal TimeWrite-backPartitioningUsage Based OptimizationsLoad Balancing and ClusteringApache Doris Apache Druid Apache Kylin Apache Pinot ClickHouse Essbase IBM Cognos BI IBM Cognos TM1 icCube Jedox OLAP Server Microsoft Analysis Services MicroStrategy Intelligence Server Mondrian OLAP server Oracle Database OLAP Option SAP NetWeaver BW SAS OLAP Server StarRocks

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

System limits OLAP server# cubes# measures# dimensions# dimensions in cube# hierarchies in dimension# levels in hierarchy# dimension membersApache DorisUnrestrictedUnrestrictedUnrestrictedUnrestrictedUnrestrictedUnrestrictedUnrestricted Apache Druid Unrestricted Unrestricted Unrestricted Unrestricted Unrestricted Unrestricted UnrestrictedApache KylinUnrestrictedUnrestrictedUnrestrictedUnrestrictedUnrestrictedUnrestrictedUnrestrictedApache PinotUnrestrictedUnrestrictedUnrestrictedUnrestrictedUnrestrictedUnrestrictedUnrestrictedClickHouseUnrestrictedUnrestrictedUnrestrictedUnrestrictedUnrestrictedUnrestrictedUnrestricted Essbase Unrestricted Unrestricted Unrestricted 255 255 ? 20,000,000 (ASO), 1,000,000 (BSO) IBM Cognos TM1 Unrestricted Unrestricted Unrestricted 256 Unrestricted 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,647Jedox OLAP Server (32 bits) (32 bits) 250 Microsoft Analysis Services 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 Unrestricted Unrestricted ? Unrestricted Unrestricted Unrestricted SAS OLAP Server Unrestricted 1024 128 ? 128 19 4,294,967,296StarRocksUnrestrictedUnrestrictedUnrestrictedUnrestrictedUnrestrictedUnrestrictedUnrestricted

Security

OLAP server Authentication Network encryption On-the-Fly Data accessCell securityDimension securityVisual totalsApache Doris Apache Druid Apache Kylin Apache Pinot ClickHouse Essbase IBM Cognos TM1 icCube Jedox OLAP Server Microsoft Analysis Services MicroStrategy Intelligence Server Oracle Database OLAP Option SAS OLAP Server

Operating systems The OLAP servers can run on the following operating systems: OLAP server Windows Linux UNIX z/OS AIXApache Doris Apache Druid Apache Kylin Apache Pinot ClickHouse Essbase IBM Cognos TM1 icCube Jedox OLAP Server Microsoft Analysis Services MicroStrategy Intelligence Server Mondrian OLAP server Oracle Database OLAP Option SAP NetWeaver BW SAS OLAP Server StarRocks Note (1):The server availability depends on Java Virtual Machine not on the operating system

Support information OLAP server Issue Tracking System Roadmap Source codeApache Doris Apache Doris– Github Issues Apache Doris Roadmap Apache Druid Druid – Github Issues Apache Kylin JiraApache Kylin Roadmap Apache Pinot Apache Pinot – Github Issues ClickHouse ClickHouse – Github Issues ClickHouse Roadmap Essbase myOracle Support IBM Cognos TM1 IBM Service Request icCube Stackoverflow Jedox OLAP Server Available upon request Microsoft Analysis Services Connect - MicroStrategy Intelligence Server MicroStrategy Resource Center - Mondrian OLAP serverJira Oracle Database OLAP Option myOracle Support SAP NetWeaver BW OSS SAS OLAP Server Support StarRocks StarRocks– Github Issues StarRocks Roadmap

See also Cubes (light-weight open-source OLAP server) ClickHouse Apache Pinot Apache Druid Apache Doris Oracle Essbase Oracle Retail Predictive Application Server (RPAS), a retail specific MOLAP/OLAP server using Berkeley DB for persistence Palo (OLAP database) StarRocks

References