Comparison of OLAP Servers

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.

Contents

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] 1.0 Proprietary free
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.2 Proprietary -
SAP NetWeaver BW SAP [9] 7.20 Proprietary -
TM1 IBM [10] 9.5 Proprietary -

Data storage modes

OLAP Server MOLAP ROLAP HOLAP Offline
Essbase Yes Yes Yes
icCube Yes No No GWT Offline Pivot
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

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 No

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
SAP NetWeaver BW Yes Yes Yes Yes ? Yes

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]  ? 1024 128 128 19 2,147,483,648

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

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

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

References

  1. ^ "Oracle Essbase". http://www.oracle.com/us/solutions/ent-performance-bi/business-intelligence/essbase/index.html. 
  2. ^ "icCube OLAP Server". http://www.icCube.com. 
  3. ^ "Microsoft SQL Server 2008 Analysis Services". http://www.microsoft.com/Sqlserver/2008/en/us/analysis-services.aspx. 
  4. ^ "MicroStrategy Intelligence Server". http://www.microstrategy.com/Software/Products/Intelligence_Server/. 
  5. ^ "Pentaho Analysis Services: Mondrian Project". http://mondrian.pentaho.org. 
  6. ^ "Oracle OLAP Documentation". http://www.oracle.com/technology/documentation/olap.html. 
  7. ^ "Jedox AG Business Intelligence". http://www.jedox.com/en/home/overview.html. 
  8. ^ "SAS OLAP Server". http://www.sas.com/technologies/dw/storage/mddb/index.html. 
  9. ^ "Components & Tools". http://www.sap.com/usa/platform/netweaver/components/businesswarehouse/index.epx. 
  10. ^ "Cognos Business Intelligence and Financial Performance Management". http://www-01.ibm.com/software/data/cognos/index.html. 
  11. ^ "SQL Server 2008 Books Online (October 2009)Defining Stored Procedures". MSDN. http://msdn.microsoft.com/en-us/library/ms176113.aspx. 
  12. ^ "SQL Server 2008 Books Online (October 2009)Using Stored Procedures". MSDN. http://msdn.microsoft.com/en-us/library/ms145486.aspx. 
  13. ^ "How to perform a SQL Server distributed query with OLAP Server". MSDN. http://support.microsoft.com/kb/218592/en-gb. 
  14. ^ "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. 
  15. ^ "How to Define a Mondrian Schema". Pentaho. http://mondrian.pentaho.org/documentation/schema.php#User-defined_function. 
  16. ^ a b "Oracle and Simba Technologies Introduce MDX Provider for Oracle OLAP". http://www.oracle.com/us/corporate/press/036550. 
  17. ^ "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. 
  18. ^ "Common Extensions of the MicroStrategy Platform". http://www.microstrategy.com/Software/Products/Dev_Tools/SDK/extensions.asp. 
  19. ^ "How to add Current Month and Current Year level into Time dimension". http://www.ibm.com/developerworks/forums/message.jspa?messageID=14495600. 
  20. ^ "Essbase Server Limits". Oracle. http://download.oracle.com/docs/cd/E12825_01/epm.111/esb_dbag/frameset.htm?limits.htm. 
  21. ^ "SQL Server 2008 Books Online (October 2009)Maximum Capacity Specifications (Analysis Services - Multidimensional Data)". Microsoft. http://technet.microsoft.com/en-us/library/ms365363.aspx. 
  22. ^ "SAS OLAP Cube Size Specifications". http://support.sas.com/documentation/cdl/en/olapug/59574/HTML/default/a003302815.htm. 
  23. ^ MicroStrategy Intelligence Server™ Features
  24. ^ "SAS OLAP Security Totals and Permission Conditions". http://support.sas.com/documentation/cdl/en/mdxag/59575/HTML/default/a003230130.htm. 
  25. ^ "How to Change Over-the-Wire Encryption Settings for SAS Servers". http://support.sas.com/documentation/cdl/en/bisecag/61133/HTML/default/a003275910.htm. 
v · d · eData warehouse
Creating the data warehouse
Concepts
Variants
Elements
Fact
Dimension
Filling
Using the data warehouse
Concepts
Languages
Tools
Related
People
Products
  • Comparison of OLAP Servers
  • Data warehousing products and their producers

Wikimedia Foundation. 2010.

Игры ⚽ Поможем написать реферат

Look at other dictionaries:

  • OLAP cube — An OLAP cube (for online analytical processing) is a data structure that allows fast analysis of data.[1] It can also be defined as the capability of manipulating and analyzing data from multiple perspectives. The arrangement of data into cubes… …   Wikipedia

  • Oracle OLAP — The Oracle Database OLAP Option implements On line Analytical Processing (OLAP) within an Oracle database environment. Oracle Corporation markets the Oracle Database OLAP Option as an extra cost option to supplement the Enterprise Edition of its… …   Wikipedia

  • Mondrian OLAP server — Developer(s) Pentaho Corporation Stable release 3.3.0.14703 / October 29, 2011; 3 days ago (2011 10 29) …   Wikipedia

  • Online analytical processing — In computing, online analytical processing, or OLAP (  /ˈoʊlæ …   Wikipedia

  • Data warehouse appliance — In computing, a data warehouse appliance consists of an integrated set of servers, storage, operating system(s), DBMS and software specifically pre installed and pre optimized for data warehousing (DW). Alternatively, the term can also apply to… …   Wikipedia

  • Metadata — For the page on metadata about Wikipedia, see Wikipedia:Metadata. The term metadata is an ambiguous term which is used for two fundamentally different concepts (types). Although the expression data about data is often used, it does not apply to… …   Wikipedia

  • Data mart — A data mart (DM) is the access layer of the data warehouse (DW) environment that is used to get data out to the users. The DM is a subset of the DW, usually oriented to a specific business line or team. Contents 1 Terminology 2 Design schemas 3… …   Wikipedia

  • Microsoft Analysis Services — Microsoft SQL Server Analysis Services (SSAS) Developer(s) Microsoft Stable release Analysis Services 2008 R2 / December 21, 2010; 10 months ago …   Wikipedia

  • Database — A database is an organized collection of data for one or more purposes, usually in digital form. The data are typically organized to model relevant aspects of reality (for example, the availability of rooms in hotels), in a way that supports… …   Wikipedia

  • MultiDimensional eXpressions — (MDX) is a query language for OLAP databases, much like SQL is a query language for relational databases. It is also a calculation language, with syntax similar to spreadsheet formulas. Contents 1 Background 2 History 2.1 mdXML …   Wikipedia

Share the article and excerpts

Direct link
… Do a right-click on the link above
and select “Copy Link”