Comparison of OLAP servers
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.
Data storage modes
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 [ 19] Visualization
JSON
REST API
Apache Doris
No
No
No
No
Yes[ 20]
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[ 21]
Yes
No
Superset, Zeppelin, Tableau, Qlik, Redash, DataLens[ 22]
Yes
Yes
Essbase
Yes
Yes
Yes
Yes
Yes
No
Yes
SmartView (Excel-AddIn), Oracle Analytics Cloud, Narrative Reporting, Tableau, IBM Cognos
?
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
Java ,[ 23] R [ 24] Yes
In the reporting
Yes
icCube reporting and all XMLA compliant visualization tools like Excel, etc
Yes
Yes
Jedox OLAP Server
Yes
Yes
Yes
Cube Rules, SVS Triggers
Yes
No
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
.NET [ 25] Yes[ 26]
Yes[ 27]
Yes
Microsoft Excel, SharePoint, Microsoft Power BI, and 70+ other visualization tools
No
No
MicroStrategy Intelligence Server
Yes
No
Yes
Yes
Yes
Yes
Yes
Dossier, Dashboard, Reports
Yes
Yes
Mondrian OLAP server
Yes
Yes[ 28]
Yes
Yes
Yes[ 29]
No
Yes
Yes[ 30]
?
?
Oracle Database OLAP Option
No
Yes[ 31]
Yes[ 31]
Java , PL/SQL, OLAP DML
Yes
Yes[ 32]
No
?
?
?
SAP NetWeaver BW
Yes
Yes
Yes
No
Yes
No
Yes
?
?
?
SAS OLAP Server
Yes
Yes
Yes
No
No
No
Yes
Web Report Studio
?
?
StarRocks
No
No
No
No
Yes[ 33]
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.
System limits
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[ a]
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 [ 40] Unrestricted
Unrestricted
Unrestricted
255
255
?
20,000,000 (ASO), 1,000,000 (BSO)
IBM Cognos TM1
Unrestricted[ a]
Unrestricted
Unrestricted[ a]
256
Unrestricted[ a]
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
{\displaystyle 2^{32}}
2
32
{\displaystyle 2^{32}}
2
32
{\displaystyle 2^{32}}
250
2
32
{\displaystyle 2^{32}}
2
32
{\displaystyle 2^{32}}
2
32
{\displaystyle 2^{32}}
Kyvos
Unrestricted
Unrestricted
Unrestricted
Unrestricted
Unrestricted
Unrestricted
Unrestricted
Microsoft Analysis Services [ 41] 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[ a]
Unrestricted[ a]
Unrestricted[ a]
?
Unrestricted[ a]
Unrestricted[ a]
Unrestricted[ a]
SAS OLAP Server [ 42] Unrestricted[ a]
1024
128
?
128
19
4,294,967,296
StarRocks
Unrestricted
Unrestricted
Unrestricted
Unrestricted
Unrestricted
Unrestricted
Unrestricted
^ a b c d e f g h i j k Please update as 'unrestricted', is just not possible
Security
OLAP server
Authentication
Network encryption
On-the-Fly[ a]
Data access
Cell security
Dimension security
Visual totals
Apache Doris
Built-in, LDAP, Kerberos
SSL
Yes
Yes
Yes
Yes
Apache Druid
Druid Database authentication
SSL
Yes
No
Yes
No
Apache Kylin
LDAP, SAML, Kerboros, Microsoft Active Directory
SSL
Yes
No
No
?
Apache Pinot
HTTP basic authentication
SSL
?
No
No
No
ClickHouse
Built-in, LDAP , Microsoft Active Directory , Kerberos
SSL
Yes
Yes
Yes
Yes
Essbase
Essbase authentication, LDAP authentication, Microsoft Active Directory
SSL
Yes
Yes
Yes
No
IBM Cognos TM1
Builtin, LDAP , Microsoft Active Directory , NTLM , IBM Cognos BI authentication
SSL
Yes
Yes
Yes
Yes
icCube
HTTP Basic/Form Authentication, Windows SSO (NTLM, Kerberos), Plugin Based for Embedded Usage
SSL
Yes
Yes
Yes
Yes
Jedox OLAP Server
Jedox authentication, LDAP , Microsoft Active Directory
SSL
Yes
Yes
Yes
?
Kyvos
Built-in, LDAP , Microsoft Active Directory , SAML, Windows SSO (NTLM, Kerberos)
SSL
Yes
Yes
Yes
Yes
Microsoft Analysis Services
NTLM , Kerberos
SSL and SSPI
Yes
Yes
Yes
Yes
MicroStrategy Intelligence Server
Host authentication, database authentication, LDAP , Microsoft Active Directory , NTLM , SiteMinder, Tivoli, SAP, Kerberos
SSL , AES[ 43] ?
Yes
Yes
Yes
Oracle Database OLAP Option
Oracle Database authentication
SSL
?
Yes
Yes
No
SAS OLAP Server [ 44] Host authentication, SAS token authentication, LDAP , Microsoft Active Directory
Yes[ 45]
?
Yes
Yes
Yes
^ 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 :
Note (1):The server availability depends on Java Virtual Machine not on the operating system
See also
References
Creating a data warehouse
Concepts Variants Elements Fact Dimension Filling
