Comparison of OLAP Servers
From Infogalactic: the planetary knowledge core
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.
Contents
General information
OLAP Server | Company | Website | Latest stable version | Software license | License Pricing |
---|---|---|---|---|---|
IBM Cognos TM1 | IBM | [1] | 10.2.2 FP4 | Proprietary | - |
Essbase | Oracle | [2] | 11.1.2.4 | Proprietary | [1] |
icCube | icCube | [3] | 5.1.4 | Proprietary | community/[2] |
Jedox OLAP Server | Jedox | [4] | 5.1 SR4 | GPL v2 or EULA, Proprietary | - |
Infor BI OLAP Server | Infor | [5] | 10.6.0 | Proprietary | - |
Microsoft Analysis Services | Microsoft | [6] | 2014 | Proprietary | [3] |
MicroStrategy Intelligence Server | MicroStrategy | [7] | 9 | Proprietary | - |
Mondrian OLAP server | Pentaho | [8] | 3.7 | EPL | free |
Oracle Database OLAP Option | Oracle | [9] | 11g R2 | Proprietary | [4] |
SAS OLAP Server | SAS Institute | [10] | 9.4 | Proprietary | - |
SAP NetWeaver BW | SAP | [11] | 7.30 | Proprietary | - |
Cubes | Open source community | [12] | 1.0.1 | MIT | - |
Data storage modes
OLAP Server | MOLAP | ROLAP | HOLAP | Offline |
---|---|---|---|---|
IBM Cognos TM1 | Yes | No | No | Cognos Insight Distributed mode |
Essbase | Yes | Yes | Yes | |
icCube | Yes | No | No | Offline Cubes |
Infor BI OLAP Server | Yes | No | No | Local cubes |
Jedox OLAP Server | Yes | Yes | Yes | No |
Microsoft Analysis Services | Yes | Yes | Yes | Local cubes, PowerPivot for Excel |
MicroStrategy Intelligence Server | Yes | Yes | Yes | MicroStrategy Office, Dynamic Dashboards |
Mondrian OLAP server | No | Yes | No | |
Oracle Database OLAP Option | Yes | Yes | Yes | |
SAS OLAP Server | Yes | Yes | Yes | |
IBM Cognos BI | Yes | Yes | Yes | |
SAP NetWeaver BW | Yes | Yes | No | |
Cubes (OLAP server) | No | Yes | No |
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[13] | Visualization | JSON | REST API |
---|---|---|---|---|---|---|---|---|---|---|
Essbase | Yes | Yes | Yes | Yes | Yes | No | Yes | SmartView (Excel-AddIn), WebAnalysis, Financial Reports | ? | ? |
icCube | Yes | Yes | Yes | Java,[14] R[15] | Yes | No | Yes | Java, Javascript | ? | ? |
Infor BI OLAP Server | Yes | Yes | Yes | OLAP Rules, Push Rules, Application Engine | Yes | Yes | No | Application Studio | ? | ? |
Jedox OLAP Server | Yes | Yes | Yes | Cube Rules, SVS Triggers | Yes | No | Yes | ? | ? | ? |
Microsoft Analysis Services | Yes | Yes | Yes | .NET[16] | Yes[17] | Yes[18] | Yes | Microsoft Excel, SharePoint, Microsoft Power BI, and 70+ other visualization tools[19] | ? | ? |
MicroStrategy Intelligence Server | Yes | No | Yes | Yes | Yes | Yes | Yes | ? | ? | ? |
Mondrian OLAP server | Yes | Yes[20] | Yes | Yes | Yes[21] | Yes | Yes | No | ? | ? |
Oracle Database OLAP Option | No | Yes[22] | Yes[22] | Java, PL/SQL, OLAP DML | Yes | Yes[23] | No | ? | ? | ? |
SAS OLAP Server | Yes | Yes | Yes | No | No | No | Yes | Web Report Studio | ? | ? |
SAP NetWeaver BW | Yes | Yes | Yes | No | Yes | No | Yes | ? | ? | ? |
Cognos TM1 | Yes | Yes | Yes | Yes | Yes | No | Yes | TM1 Web/TM1 Contributor, IBM Cognos Insight, IBM Cognos Cafe for Excel, Cognos BI, TM1 Perspectives for Excel | ? | Yes |
Cubes | No | No | No | No | Yes | No | No | Cubes Viewer[24] | 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.
OLAP Server | Real Time | Semi-additive measures | Write-back | Many-to-Many | Partitioning | In Memory | Multi-Cube Model |
---|---|---|---|---|---|---|---|
Essbase | ? | Yes | Yes | ? | Yes | ||
icCube | Yes[25] | Yes[26] | Yes[27] | Yes[28] | Yes[29] | Yes | Yes |
Infor BI OLAP Server | ? | Yes | Yes | ? | Yes | ||
Jedox OLAP Server | ? | ? | Yes | ? | ? | ||
Microsoft Analysis Services | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
MicroStrategy Intelligence Server | ? | Yes | Yes[30] | ? | Yes | ||
Mondrian OLAP server | Yes | Yes[31] | Planned | ? | Yes | ||
Oracle Database OLAP Option | ? | Yes | Yes | ? | Yes | ||
IBM Cognos TM1 | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
IBM Cognos BI | Yes | Yes | No | Yes | Yes | Yes | |
SAS OLAP Server | ? | Yes | Yes | ? | Yes | ||
SAP NetWeaver BW | ? | Yes | Yes | ? | Yes | ||
Cubes | ? | ? | ? | Yes | ? |
System limits
OLAP Server | # cubes | # measures | # dimensions | # dimensions in cube | # hierarchies in dimension | # levels in hierarchy | # dimension members |
---|---|---|---|---|---|---|---|
Essbase[32] | ? | ? | ? | 255 | 255 | ? | 20,000,000 (ASO), 1,000,000 (BSO) |
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 |
Infor BI OLAP Server | ? | 10,000,000 | ? | 30 | ? | ? | 10,000,000 |
Jedox OLAP Server | 2^32 (32 bits) / 2^64 (64 bits) | ? | 2^32 (32 bits) / 2^64 (64 bits) | 250 | 2^32 | 2^32 | 2^32 |
Microsoft Analysis Services[33] | 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 |
MicroStrategy Intelligence Server | Unrestricted[lower-alpha 1] | Unrestricted[lower-alpha 1] | Unrestricted[lower-alpha 1] | ? | Unrestricted[lower-alpha 1] | Unrestricted[lower-alpha 1] | Unrestricted[lower-alpha 1] |
SAS OLAP Server[34] | Unrestricted[lower-alpha 1] | 1024 | 128 | ? | 128 | 19 | 4,294,967,296 |
IBM Cognos TM1 | Unrestricted[lower-alpha 1] | Unrestricted | Unrestricted[lower-alpha 1] | 256 | Unrestricted[lower-alpha 1] | Unrestricted | Unrestricted |
Security
OLAP Server | Authentication | Network encryption | On-the-Fly[lower-alpha 1] | Data access | ||
---|---|---|---|---|---|---|
Cell security | Dimension security | Visual totals | ||||
Essbase | Essbase authentication, LDAP authentication, Microsoft Active Directory | SSL | Yes | Yes | Yes | Yes |
icCube | HTTP Basic/Form Authentication, Windows SSO (NTLM,Kerberos) | SSL | Yes | Yes | Yes | Yes |
Infor BI OLAP Server | OLAP authentication, Infor Federation Services, LDAP, Microsoft Active Directory | Yes | Yes | Yes | Yes | ? |
Jedox OLAP Server | Jedox authentication, LDAP, Microsoft Active Directory | SSL | 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[35] | ? | Yes | Yes | Yes |
Oracle Database OLAP Option | Oracle Database authentication | SSL | ? | Yes | Yes | ? |
SAS OLAP Server[36] | Host authentication,SAS token authentication, LDAP, Microsoft Active Directory | Yes[37] | ? | Yes | Yes | Yes |
IBM Cognos TM1 | Builtin, LDAP, Microsoft Active Directory, NTLM, IBM Cognos BI authentication | SSL | Yes | 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:
OLAP Server | Windows | Linux | UNIX | z/OS | AIX |
---|---|---|---|---|---|
Essbase | Yes | Yes | Yes | No | |
icCube | Yes | Yes | Yes | Yes | Yes |
Infor BI OLAP Server | Yes | No | No | No | |
Jedox OLAP Server | Yes | Yes | Yes | No | |
Microsoft Analysis Services | Yes | No | No | No | |
MicroStrategy Intelligence Server | Yes | Yes | Yes | No | |
Mondrian OLAP server | Yes | Yes | Yes | Yes | |
Oracle Database OLAP Option | Yes | Yes | Yes | Yes | |
SAS OLAP Server | Yes | Yes | Yes | Yes | |
SAP NetWeaver BW | Yes | Yes | Yes | Yes | |
IBM Cognos TM1 | Yes | Yes | Yes | No | Yes |
Cubes | Yes | Yes | Yes | No |
Note (1):The server availability depends on Java Virtual Machine not on the operating system
Support information
OLAP Server | Issue Tracking System | Forum/Blog | Roadmap | Source code |
---|---|---|---|---|
Essbase | myOracle Support | [5] | [6] | Closed |
icCube | YouTrack | [7] | Open | |
Infor BI OLAP Server | Infor Xtreme | Available upon request | Closed | |
Jedox OLAP Server | Mantis | [8] | Open | |
Microsoft Analysis Services | Connect | [9] | - | Closed |
MicroStrategy Intelligence Server | MicroStrategy Resource Center | [10] | - | Closed |
Mondrian OLAP server | Jira | [11] | [12] | Open |
Oracle Database OLAP Option | myOracle Support | [13] | Closed | |
SAS OLAP Server | Support | [14] | Closed | |
SAP NetWeaver BW | OSS | [15] | [16] | Closed |
IBM Cognos TM1 | IBM Service Request | [17] | Closed | |
Cubes | Cubes – Github Issues | [18] | [19] | Open |
See also
- Cubes (light-weight open-source OLAP server)
- icCube
- Palo (OLAP database)
References
- ↑ Lua error in package.lua at line 80: module 'strict' not found.
- ↑ Lua error in package.lua at line 80: module 'strict' not found.
- ↑ Lua error in package.lua at line 80: module 'strict' not found.
- ↑ Lua error in package.lua at line 80: module 'strict' not found.
- ↑ Lua error in package.lua at line 80: module 'strict' not found.
- ↑ Lua error in package.lua at line 80: module 'strict' not found.
- ↑ Lua error in package.lua at line 80: module 'strict' not found.
- ↑ Lua error in package.lua at line 80: module 'strict' not found.
- ↑ Lua error in package.lua at line 80: module 'strict' not found.
- ↑ Lua error in package.lua at line 80: module 'strict' not found.
- ↑ Lua error in package.lua at line 80: module 'strict' not found.
- ↑ Lua error in package.lua at line 80: module 'strict' not found.
- ↑ Lua error in package.lua at line 80: module 'strict' not found.
- ↑ Lua error in package.lua at line 80: module 'strict' not found.
- ↑ Lua error in package.lua at line 80: module 'strict' not found.
- ↑ Lua error in package.lua at line 80: module 'strict' not found.
- ↑ Lua error in package.lua at line 80: module 'strict' not found.
- ↑ Lua error in package.lua at line 80: module 'strict' not found.
- ↑ Lua error in package.lua at line 80: module 'strict' not found.
- ↑ Lua error in package.lua at line 80: module 'strict' not found.
- ↑ Lua error in package.lua at line 80: module 'strict' not found.
- ↑ 22.0 22.1 Lua error in package.lua at line 80: module 'strict' not found.
- ↑ Lua error in package.lua at line 80: module 'strict' not found.
- ↑ Lua error in package.lua at line 80: module 'strict' not found.
- ↑ Lua error in package.lua at line 80: module 'strict' not found.
- ↑ Lua error in package.lua at line 80: module 'strict' not found.
- ↑ Lua error in package.lua at line 80: module 'strict' not found.
- ↑ Lua error in package.lua at line 80: module 'strict' not found.
- ↑ Lua error in package.lua at line 80: module 'strict' not found.
- ↑ Lua error in package.lua at line 80: module 'strict' not found.
- ↑ Lua error in package.lua at line 80: module 'strict' not found.
- ↑ Lua error in package.lua at line 80: module 'strict' not found.
- ↑ Lua error in package.lua at line 80: module 'strict' not found.
- ↑ Lua error in package.lua at line 80: module 'strict' not found.
- ↑ MicroStrategy Intelligence Server Features
- ↑ Lua error in package.lua at line 80: module 'strict' not found.
- ↑ Lua error in package.lua at line 80: module 'strict' not found.