Comparison of OLAP Servers
From Wikipedia, the free encyclopedia
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 |
[edit] General information
| OLAP Server | Company | Website | Latest stable version | Software license | License Pricing |
|---|---|---|---|---|---|
| Essbase | Oracle | [1] | 11.1.2.0 | Proprietary | [1] |
| icCube | MISConsulting SA | [2] | 2.0.6 | Proprietary | community/enterprise |
| Microsoft Analysis Services | Microsoft | [3] | 2008 R2 | Proprietary | [2] |
| MicroStrategy Intelligence Server | MicroStrategy | [4] | 9 | Proprietary | - |
| Mondrian OLAP server | Pentaho | [5] | 3.2 | EPL | free |
| Oracle Database OLAP Option | Oracle | [6] | 11g R2 | Proprietary | [3] |
| Palo | Jedox | [7] | 3.2 SR3 | GPL v2 or EULA | - |
| SAS OLAP Server | SAS Institute | [8] | 9.3 | Proprietary | - |
| SAP NetWeaver BW | SAP | [9] | 7.20 | Proprietary | - |
| TM1 | IBM | [10] | 9.5.2 | Proprietary | - |
[edit] Data storage modes
| OLAP Server | MOLAP | ROLAP | HOLAP | Offline |
|---|---|---|---|---|
| Essbase | Yes | Yes | Yes | |
| icCube | Yes | No | No | Offline Cubes |
| 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 | |
| Palo | Yes | No | No | |
| SAS OLAP Server | Yes | Yes | Yes | |
| TM1 | Yes | No | No | |
| SAP NetWeaver BW | Yes | Yes | No |
[edit] 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 |
|---|---|---|---|---|---|---|
| Essbase | Yes | Yes | Yes | Java | Yes | No |
| icCube | Yes | Yes | Yes | Java | Yes | No |
| Microsoft Analysis Services | Yes | Yes | Yes | .NET[11] | Yes[12] | Yes[13] |
| MicroStrategy Intelligence Server | Yes | No | Yes | Yes | Yes | Yes |
| Mondrian OLAP server | Yes | Yes[14] | Yes | No | Yes[15] | No |
| Palo | Yes | Yes | Yes | Cube Rules, SVS Triggers | Yes | No |
| Oracle Database OLAP Option | No | Yes[16] | Yes[16] | Java, PL/SQL, OLAP DML | Yes | Yes[17] |
| SAS OLAP Server | Yes | Yes | Yes | No | No | No |
| SAP NetWeaver BW | Yes | Yes | Yes | No | Yes | No |
| TM1 | Yes | Yes | Yes | Yes | Yes | No |
[edit] OLAP features
| OLAP Server | Parent-child hierarchies | Multiple time hierarchies | Semi-additive measures | Write-back | Measure Groups | Partitioning |
|---|---|---|---|---|---|---|
| Essbase | Yes | Yes | Yes | Yes | Yes | Yes |
| icCube | Yes | Yes | Yes | Yes | Yes | Planned |
| Microsoft Analysis Services | Yes | Yes | Yes | Yes | Yes | Yes |
| MicroStrategy Intelligence Server | Yes | Yes | Yes | Yes[18] | ? | Yes |
| Mondrian OLAP server | Yes | No | Yes | Planned | ? | No |
| Oracle Database OLAP Option | Yes | ? | Yes | Yes | ? | Yes |
| Palo | Yes | ? | ? | Yes | ? | ? |
| TM1 | Yes | Yes[19] | Yes | Yes | ? | No |
| SAS OLAP Server | Yes | Yes | Yes | Yes | Yes | Yes |
| SAP NetWeaver BW | Yes | Yes | Yes | Yes | ? | Yes |
[edit] System limits
| OLAP Server | # cubes | # measures | # dimensions | # hierarchies in dimension | # levels in hierarchy | # dimension members |
|---|---|---|---|---|---|---|
| Essbase[20] | ? | ? | ? | 256 | ? | 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 |
| Microsoft Analysis Services[21] | 2,147,483,647 | 2,147,483,647 | 2,147,483,647 | 2,147,483,647 | 2,147,483,647 | 2,147,483,647 |
| MicroStrategy Intelligence Server | Unrestricted | Unrestricted | Unrestricted | Unrestricted | Unrestricted | Unrestricted |
| SAS OLAP Server[22] | Unrestricted | 1024 | 128 | 128 | 19 | 4,294,967,296 |
[edit] Security
| OLAP Server | Authentication | Network encryption | Data access | ||
|---|---|---|---|---|---|
| Cell security | Dimension security | Visual totals | |||
| Essbase | Essbase authentication, LDAP authentication | SSL | Yes | Yes | Yes |
| Microsoft Analysis Services | NTLM, Kerberos | SSL and SSPI | Yes | Yes | Yes |
| MicroStrategy Intelligence Server | Host authentication, database authentication, LDAP, Microsoft Active Directory, NTLM, SiteMinder, Tivoli, SAP, Kerberos |
SSL, AES[23] | Yes | Yes | Yes |
| Oracle Database OLAP Option | Oracle Database authentication | SSL | Yes | Yes | ? |
| Palo | Palo authentication, LDAP, Microsoft Active Directory | SSL | Yes | Yes | ? |
| SAS OLAP Server[24] | Host authentication,SAS token authentication, LDAP, Microsoft Active Directory | Yes[25] | Yes | Yes | Yes |
[edit] Operating systems
The OLAP servers can run on the following operating systems:
| OLAP Server | Windows | Linux | UNIX | z/OS |
|---|---|---|---|---|
| Essbase | Yes | Yes | Yes | No |
| icCube | Yes | Yes | Yes | Yes |
| Microsoft Analysis Services | Yes | No | No | No |
| MicroStrategy Intelligence Server | Yes | Yes | Yes | Yes |
| Mondrian OLAP server | Yes | Yes | Yes | Yes |
| Oracle Database OLAP Option | Yes | Yes | Yes | Yes |
| Palo | Yes | Yes | Yes | No |
| SAS OLAP Server | Yes | Yes | Yes | Yes |
| SAP NetWeaver BW | Yes | Yes | Yes | Yes |
| TM1 | Yes | Yes | Yes | No |
Note (1):The server availability depends on Java Virtual Machine not on the operating system
[edit] Support information
| OLAP Server | Issue Tracking System | Forum/Blog | Roadmap | Source code |
|---|---|---|---|---|
| Essbase | myOracle Support | [4] | [5] | Closed |
| icCube | Bugzilla | [6] | [7] | Open |
| Microsoft Analysis Services | Connect | [8] | - | Closed |
| MicroStrategy Intelligence Server | MicroStrategy Resource Center | [9] | - | Closed |
| Mondrian OLAP server | Jira | [10] | [11] | Open |
| Oracle Database OLAP Option | myOracle Support | [12] | Closed | |
| Palo | Mantis | [13] | Open | |
| SAS OLAP Server | Support | Closed | ||
| SAP NetWeaver BW | OSS | [14] | [15] | Closed |
| TM1 | no | [16] | Closed |
[edit] References
- ^ "Oracle Essbase". http://www.oracle.com/us/solutions/ent-performance-bi/business-intelligence/essbase/index.html.
- ^ "icCube OLAP Server". http://www.icCube.com.
- ^ "Microsoft SQL Server 2008 Analysis Services". http://www.microsoft.com/Sqlserver/2008/en/us/analysis-services.aspx.
- ^ "MicroStrategy Intelligence Server". http://www.microstrategy.com/Software/Products/Intelligence_Server/.
- ^ "Pentaho Analysis Services: Mondrian Project". http://mondrian.pentaho.org.
- ^ "Oracle OLAP Documentation". http://www.oracle.com/technology/documentation/olap.html.
- ^ "Jedox AG Business Intelligence". http://www.jedox.com/en/home/overview.html.
- ^ "SAS OLAP Server". http://www.sas.com/technologies/dw/storage/mddb/index.html.
- ^ "Components & Tools". http://www.sap.com/usa/platform/netweaver/components/businesswarehouse/index.epx.
- ^ "Cognos Business Intelligence and Financial Performance Management". http://www-01.ibm.com/software/data/cognos/index.html.
- ^ "SQL Server 2008 Books Online (October 2009)Defining Stored Procedures". MSDN. http://msdn.microsoft.com/en-us/library/ms176113.aspx.
- ^ "SQL Server 2008 Books Online (October 2009)Using Stored Procedures". MSDN. http://msdn.microsoft.com/en-us/library/ms145486.aspx.
- ^ "How to perform a SQL Server distributed query with OLAP Server". MSDN. http://support.microsoft.com/kb/218592/en-gb.
- ^ "Pentaho and Simba Technologies Partner to Bring World's Most Popular Open Source OLAP Project to Microsoft Excel Users". http://www.simba.com/news/Pentaho-Simba-Partner-for-Excel-Connectivity.htm.
- ^ "How to Define a Mondrian Schema". Pentaho. http://mondrian.pentaho.org/documentation/schema.php#User-defined_function.
- ^ a b "Oracle and Simba Technologies Introduce MDX Provider for Oracle OLAP". http://www.oracle.com/us/corporate/press/036550.
- ^ "Querying Oracle OLAP Cubes: Fast Answers to Tough Questions Using Simple SQL". http://www.oracle.com/technology/products/bi/olap/11g/demos/olap_sql_demo.html.
- ^ "Common Extensions of the MicroStrategy Platform". http://www.microstrategy.com/Software/Products/Dev_Tools/SDK/extensions.asp.
- ^ "How to add Current Month and Current Year level into Time dimension". http://www.ibm.com/developerworks/forums/message.jspa?messageID=14495600.
- ^ "Essbase Server Limits". Oracle. http://download.oracle.com/docs/cd/E12825_01/epm.111/esb_dbag/frameset.htm?limits.htm.
- ^ "SQL Server 2008 Books Online (October 2009)Maximum Capacity Specifications (Analysis Services - Multidimensional Data)". Microsoft. http://technet.microsoft.com/en-us/library/ms365363.aspx.
- ^ "SAS OLAP Cube Size Specifications". http://support.sas.com/documentation/cdl/en/olapug/63148/HTML/default/viewer.htm#p0m66bhcbgqwjen1jyfhf6woysu3.htm.
- ^ MicroStrategy Intelligence Server™ Features
- ^ "SAS OLAP Security Totals and Permission Conditions". http://support.sas.com/documentation/cdl/en/mdxag/59575/HTML/default/a003230130.htm.
- ^ "How to Change Over-the-Wire Encryption Settings for SAS Servers". http://support.sas.com/documentation/cdl/en/bisecag/61133/HTML/default/a003275910.htm.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||
