Comparison of OLAP Servers

From Infogalactic: the planetary knowledge core
Jump to: navigation, search

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
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
  1. ↑ 1.0 1.1 1.2 1.3 1.4 1.5 1.6 1.7 1.8 1.9 Please update as 'unrestricted', is just not possible

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
  1. ↑ 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

References

  1. ↑ Lua error in package.lua at line 80: module 'strict' not found.
  2. ↑ Lua error in package.lua at line 80: module 'strict' not found.
  3. ↑ Lua error in package.lua at line 80: module 'strict' not found.
  4. ↑ Lua error in package.lua at line 80: module 'strict' not found.
  5. ↑ Lua error in package.lua at line 80: module 'strict' not found.
  6. ↑ Lua error in package.lua at line 80: module 'strict' not found.
  7. ↑ Lua error in package.lua at line 80: module 'strict' not found.
  8. ↑ Lua error in package.lua at line 80: module 'strict' not found.
  9. ↑ Lua error in package.lua at line 80: module 'strict' not found.
  10. ↑ Lua error in package.lua at line 80: module 'strict' not found.
  11. ↑ Lua error in package.lua at line 80: module 'strict' not found.
  12. ↑ Lua error in package.lua at line 80: module 'strict' not found.
  13. ↑ Lua error in package.lua at line 80: module 'strict' not found.
  14. ↑ Lua error in package.lua at line 80: module 'strict' not found.
  15. ↑ Lua error in package.lua at line 80: module 'strict' not found.
  16. ↑ Lua error in package.lua at line 80: module 'strict' not found.
  17. ↑ Lua error in package.lua at line 80: module 'strict' not found.
  18. ↑ Lua error in package.lua at line 80: module 'strict' not found.
  19. ↑ Lua error in package.lua at line 80: module 'strict' not found.
  20. ↑ Lua error in package.lua at line 80: module 'strict' not found.
  21. ↑ Lua error in package.lua at line 80: module 'strict' not found.
  22. ↑ 22.0 22.1 Lua error in package.lua at line 80: module 'strict' not found.
  23. ↑ Lua error in package.lua at line 80: module 'strict' not found.
  24. ↑ Lua error in package.lua at line 80: module 'strict' not found.
  25. ↑ Lua error in package.lua at line 80: module 'strict' not found.
  26. ↑ Lua error in package.lua at line 80: module 'strict' not found.
  27. ↑ Lua error in package.lua at line 80: module 'strict' not found.
  28. ↑ Lua error in package.lua at line 80: module 'strict' not found.
  29. ↑ Lua error in package.lua at line 80: module 'strict' not found.
  30. ↑ Lua error in package.lua at line 80: module 'strict' not found.
  31. ↑ Lua error in package.lua at line 80: module 'strict' not found.
  32. ↑ Lua error in package.lua at line 80: module 'strict' not found.
  33. ↑ Lua error in package.lua at line 80: module 'strict' not found.
  34. ↑ Lua error in package.lua at line 80: module 'strict' not found.
  35. ↑ MicroStrategy Intelligence Server Features
  36. ↑ Lua error in package.lua at line 80: module 'strict' not found.
  37. ↑ Lua error in package.lua at line 80: module 'strict' not found.
Retrieved from "https://infogalactic.com/w/index.php?title=Comparison_of_OLAP_Servers&oldid=1765961"