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 Foundation1.2.3Apache 2.0free
Apache DruidApache Software Foundation29.0.0Apache 2.0free
Apache KylinApache Software Foundation3.1.0Apache 2.0free
Apache PinotApache Software Foundation1.1.0Apache 2.0free
AtotiActiveViam6.0.5Proprietarycommunity
ClickHouse24.5Apache 2.0free
EssbaseOracle21.8Proprietary
IBM Cognos TM1IBM10.2.2 FP7Proprietary-
icCube9.0.1Proprietarycommunity /
Jedox OLAP ServerJedox2019.3Proprietary
Microsoft Analysis ServicesMicrosoft2022Proprietary
Mondrian OLAP serverPentaho3.7EPLfree
Oracle Database OLAP OptionOracle11g R2Proprietary
SAP NetWeaver BWSAP7.30Proprietary-
SAS OLAP ServerSAS Institute9.4Proprietary-
Linux Foundation3.5Apache 2.0free

Data storage modes

OLAP serverMOLAPROLAPHOLAPOffline
Apache DorisYesYesYesYes
Apache DruidYesYesYesYes
Apache KylinYesNoNoYes
Apache PinotYesYesYesYes
ClickHouseYesYesYesYes
EssbaseYesNoNo
IBM Cognos BIYesYesYes
IBM Cognos TM1YesNoNo
icCubeYesNoNoYes
Jedox OLAP ServerYesNoNoNo
Microsoft Analysis ServicesYesYesYesLocal cubes, PowerPivot for Excel, Power BI Desktop
MicroStrategy Intelligence ServerYesYesYes,
Mondrian OLAP serverNoYesNo
Oracle Database OLAP OptionYesNoNo
SAP NetWeaver BWYesYesNo
SAS OLAP ServerYesYesYes
StarRocksYesYesYesYes

APIs and query languages

APIs and query languages OLAP servers support.

OLAP serverXML for AnalysisOLE DB for OLAPMDXStored proceduresCustom functionsSQLLINQVisualizationJSONREST API
Apache DorisNoNoNoNoYesYesNoSuperset, Redash, Metabase, Tableau, Qlik, Pivot, PowerBIYesYes
Apache DruidNoNoNoNoYesDruid SQLNoSuperset, Pivot, RedashYesYes
Apache KylinYesNoYesNoYesYesSuperset, Zeppelin, Tableau, Qlik, Redash, Microsoft ExcelYesYes
Apache PinotNoNoNoNoYesYesNoSuperset, Pivot, RedashYesYes
ClickHouseNoNoNoNoYesYesNoSuperset, Zeppelin, Tableau, Qlik, Redash, DataLensYesYes
EssbaseYesYesYesYesYesNoYesSmartView (Excel-AddIn), Oracle Analytics Cloud, Narrative Reporting, Tableau, IBM Cognos?Yes
IBM Cognos TM1YesYesYesYesYesNoYesTM1 Web/TM1 Contributor, IBM Cognos Insight, IBM Performance Modeler, IBM Cognos Cafe for Excel, Cognos BI, TM1 Perspectives for ExcelYesYes
icCubeYesYesYesJava, RYesIn the reportingYesicCube reporting and all XMLA compliant visualization tools like Excel, etcYesYes
Jedox OLAP ServerYesYesYesCube Rules, SVS TriggersYesNoYesMicrosoft Excel, Qlik, Tableau, Jedox Web, Power BINoYes
Microsoft Analysis ServicesYesYesYes.NETYesYesYesMicrosoft Excel, SharePoint, Microsoft Power BI, and 70+ other visualization toolsNoNo
MicroStrategy Intelligence ServerYesNoYesYesYesYesYesDossier, Dashboard, ReportsYesYes
Mondrian OLAP serverYesYesYesYesYesNoYesYes??
Oracle Database OLAP OptionNoYesYesJava, PL/SQL, OLAP DMLYesYesNo???
SAP NetWeaver BWYesYesYesNoYesNoYes???
SAS OLAP ServerYesYesYesNoNoNoYesWeb Report Studio??
StarRocksNoNoNoNoYesYesNoSuperset, Redash, Metabase, Tableau, Qlik, Pivot, PowerBIYesYes

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 DorisYesYesYesYesYes
Apache DruidYes?YesYesYes
Apache KylinYesNoYesYesYes
Apache PinotYesYesYesYesYes
ClickHouseYesYesYesYesYes
EssbaseYesYesYesYesYes
IBM Cognos BIYesNoYesYes?
IBM Cognos TM1YesYesYes??
icCubeYesNoYes??
Jedox OLAP ServerYesYesYes??
Microsoft Analysis ServicesYesYesYesYesYes
MicroStrategy Intelligence Server?YesYesYesYes
Mondrian OLAP serverYesPlannedYes??
Oracle Database OLAP Option?YesYesNo?
SAP NetWeaver BW?YesYes??
SAS OLAP Server?YesYes??
StarRocksYesYesYesYesYes
Data modeling features
OLAP serverSemi-additive measuresMany-to-ManyMulti-Cube ModelPerspectivesKPIMultilingualNamed SetsMulti-attribute HierarchiesActions
Apache DorisYesYesYesYesYesYesYesYesNo
Apache DruidYesYesYes?NoYes?YesYes
Apache KylinNoNoYesNoYesYesNoYesYes
Apache PinotYesYes??NoYes?YesYes
ClickHouseYesYesYesYesYesYesYesYesNo
EssbaseYes???YesYesYesYes?
IBM Cognos BIYesYes????YesYes?
IBM Cognos TM1YesYesYes??????
icCubeYesYesYesYesYesYesYesYes?
Jedox OLAP ServerYesYesYesYesYesYesYesYes?
Microsoft Analysis ServicesYesYesYesYesYesYesYesYesYes
MicroStrategy Intelligence ServerYesYesYesYesYesYesYesYesYes
Mondrian OLAP serverYes????????
Oracle Database OLAP OptionYes????????
SAP NetWeaver BWYes????????
SAS OLAP ServerYes????????
StarRocksYesYesYesYesYesYesYesYesNo

System limits

OLAP server# cubes# measures# dimensions# dimensions in cube# hierarchies in dimension# levels in hierarchy# dimension members
Apache DorisUnrestrictedUnrestrictedUnrestrictedUnrestrictedUnrestrictedUnrestrictedUnrestricted
Apache DruidUnrestrictedUnrestrictedUnrestrictedUnrestrictedUnrestrictedUnrestrictedUnrestricted
Apache KylinUnrestrictedUnrestrictedUnrestrictedUnrestrictedUnrestrictedUnrestrictedUnrestricted
Apache PinotUnrestrictedUnrestrictedUnrestrictedUnrestrictedUnrestrictedUnrestrictedUnrestricted
ClickHouseUnrestrictedUnrestrictedUnrestrictedUnrestrictedUnrestrictedUnrestrictedUnrestricted
EssbaseUnrestrictedUnrestrictedUnrestricted255255?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 Server2 32 {\displaystyle 2^{32}} (32 bits)2 32 {\displaystyle 2^{32}}2 32 {\displaystyle 2^{32}} (32 bits)2502 32 {\displaystyle 2^{32}}2 32 {\displaystyle 2^{32}}2 32 {\displaystyle 2^{32}}
Microsoft Analysis Services2,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 ServerUnrestricted1024128?128194,294,967,296
StarRocksUnrestrictedUnrestrictedUnrestrictedUnrestrictedUnrestrictedUnrestrictedUnrestricted

Security

OLAP serverAuthenticationNetwork encryptionOn-the-FlyData access
Cell securityDimension securityVisual totals
Apache DorisBuilt-in, LDAP, KerberosSSLYesYesYesYes
Apache DruidDruid Database authenticationSSLYesNoYesNo
Apache KylinLDAP, SAML, Kerboros, Microsoft Active DirectorySSLYesNoNo?
Apache PinotSSL?NoNoNo
ClickHouseBuilt-in, LDAP, Microsoft Active Directory, KerberosSSLYesYesYesYes
EssbaseEssbase authentication, LDAP authentication, Microsoft Active DirectorySSLYesYesYesNo
IBM Cognos TM1Builtin, LDAP, Microsoft Active Directory, NTLM, IBM Cognos BI authenticationSSLYesYesYesYes
icCubeHTTP Basic/Form Authentication, Windows SSO (NTLM, Kerberos), Plugin Based for Embedded UsageSSLYesYesYesYes
Jedox OLAP ServerJedox authentication, LDAP, Microsoft Active DirectorySSLYesYesYes?
Microsoft Analysis ServicesNTLM, KerberosSSL and SSPIYesYesYesYes
MicroStrategy Intelligence ServerHost authentication, database authentication, LDAP, Microsoft Active Directory, NTLM, SiteMinder, Tivoli, SAP, KerberosSSL, AES?YesYesYes
Oracle Database OLAP OptionOracle Database authenticationSSL?YesYesNo
SAS OLAP ServerHost authentication, SAS token authentication, LDAP, Microsoft Active DirectoryYes?YesYesYes

Operating systems

The OLAP servers can run on the following operating systems:

OLAP serverWindowsLinuxUNIXz/OSAIX
Apache DorisNoYesYesNoNo
Apache DruidNoYesYes
Apache KylinNoYesYesNoNo
Apache PinotYesYesYesYesYes
ClickHouseNoYesYesNoNo
EssbaseYesYesYesNoYes
IBM Cognos TM1YesYesYesNoYes
icCubeYesYesYesYesYes
Jedox OLAP ServerYesYesYesNo
Microsoft Analysis ServicesYesNoNoNo
MicroStrategy Intelligence ServerYesYesYesNoYes
Mondrian OLAP serverYesYesYesYes
Oracle Database OLAP OptionYesYesYesYes
SAP NetWeaver BWYesYesYesYes
SAS OLAP ServerYesYesYesYes
StarRocksNoYesYesNoNo

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

Support information

OLAP serverIssue Tracking SystemRoadmapSource code
Apache DorisOpen
Apache DruidOpen
Apache KylinOpen
Apache PinotOpen
ClickHouseOpen
EssbaseClosed
IBM Cognos TM1Closed
icCubeClosed
Jedox OLAP ServerAvailable upon requestOpen
Microsoft Analysis Services-Closed
MicroStrategy Intelligence Server-Closed
Mondrian OLAP serverOpen
Oracle Database OLAP OptionClosed
SAP NetWeaver BWClosed
SAS OLAP ServerClosed
StarRocksOpen

See also