Comparison of OLAP servers
The following tables compare general and technical information for a number of online analytical processing servers. Please see the individual products articles for further information.
General 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 | Visualization | JSON | REST API |
| Apache Kylin | Superset, Zeppelin, Tableau, Qlik, Redash | |||||||||
| ClickHouse | Superset, Zeppelin, Tableau, Qlik, Redash, DataLens | |||||||||
| Druid | Druid SQL | Superset, Pivot, Redash | ||||||||
| Essbase | SmartView, Oracle Analytics Cloud, Narrative Reporting | |||||||||
| 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 | ||||||||||
| Kyvos | Kyvos Insights, Microsoft Excel, Qlik, Tableau, Power BI, MicroStrategy, IBM Cognos, Business Objects | |||||||||
| Microsoft Analysis Services | ||||||||||
| MicroStrategy Intelligence Server | ||||||||||
| Mondrian OLAP server | ||||||||||
| Oracle Database OLAP Option | ||||||||||
| SAP NetWeaver BW | ||||||||||
| SAS OLAP Server |
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 server | Real Time | Write-back | Partitioning | Usage Based Optimizations | Load Balancing and Clustering |
| Apache Kylin | Developing | ||||
| ClickHouse | |||||
| Druid | |||||
| Essbase | |||||
| IBM Cognos BI | |||||
| IBM Cognos TM1 | |||||
| icCube | |||||
| Jedox OLAP Server | |||||
| Kyvos | |||||
| Microsoft Analysis Services | |||||
| MicroStrategy Intelligence Server | |||||
| Mondrian OLAP server | |||||
| Oracle Database OLAP Option | |||||
| SAP NetWeaver BW | |||||
| SAS OLAP Server |
Data modeling features:
| OLAP server | Semi-additive measures | Many-to-Many | Multi-Cube Model | Perspectives | KPI | Multilingual | Named Sets | Multi-attribute Hierarchies | Actions |
| Apache Kylin | |||||||||
| ClickHouse | |||||||||
| Druid | |||||||||
| Essbase | |||||||||
| IBM Cognos BI | |||||||||
| IBM Cognos TM1 | |||||||||
| icCube | |||||||||
| Jedox OLAP Server | |||||||||
| Kyvos | |||||||||
| Microsoft Analysis Services | |||||||||
| MicroStrategy Intelligence Server | |||||||||
| Mondrian OLAP server | |||||||||
| Oracle Database OLAP Option | |||||||||
| SAP NetWeaver BW | |||||||||
| SAS OLAP Server |
System limits
Security
Operating systems
The OLAP servers can run on the following operating systems:| OLAP server | Windows | Linux | UNIX | z/OS | AIX |
| Apache Kylin | |||||
| ClickHouse | |||||
| Druid | |||||
| Essbase | |||||
| IBM Cognos TM1 | |||||
| icCube | |||||
| Jedox OLAP Server | |||||
| Kyvos | |||||
| Microsoft Analysis Services | |||||
| MicroStrategy Intelligence Server | |||||
| Mondrian OLAP server | |||||
| Oracle Database OLAP Option | |||||
| SAP NetWeaver BW | |||||
| SAS OLAP Server |
Note :The server availability depends on Java Virtual Machine not on the operating system