Jump to content
 







Main menu
    


Navigation  


●Main page
 ●Contents
 ●Current events
 ●Random article
 ●About Wikipedia
 ●Contact us
 ●Donate
  



Contribute  


●Help
 ●Learn to edit
 ●Community portal
 ●Recent changes
 ●Upload file
  







Search  

































●Create account

●Log in
 









●Create account
 ● Log in
  



Pages for logged out editors learn more  


●Contributions
 ●Talk
  


















Contents

   



(Top)
  


1 General information  




2 Data storage modes  




3 APIs and query languages  




4 OLAP features  




5 System limits  




6 Security  




7 Operating systems  




8 Support information  




9 References  













Comparison of OLAP servers: Difference between revisions






●Русский
  
Edit links
  








●Article
 ●Talk
  
















●Read
 ●Edit
 ●View history
  







Tools
    


Actions  


●Read
 ●Edit
 ●View history
  



General  


●What links here
 ●Related changes
 ●Upload file
 ●Special pages
 ●Permanent link
 ●Page information
 ●Cite this page
 ●Get shortened URL
 ●Download QR code
 ●Wikidata item
  



Print/export  


●Download as PDF
 ●Printable version
  



Print/export  


















Appearance
    

 




Help
  
From Wikipedia, the free encyclopedia
  

Browse history interactively
← Previous editNext edit →
Content deleted Content added
VisualWikitext
Line 14: Line 14:

| [[Oracle Corporation|Oracle]]

| [[Oracle Corporation|Oracle]]

| <ref>{{cite web|url=http://www.oracle.com/us/solutions/ent-performance-bi/business-intelligence/essbase/index.html|title=Oracle Essbase}}</ref>

| <ref>{{cite web|url=http://www.oracle.com/us/solutions/ent-performance-bi/business-intelligence/essbase/index.html|title=Oracle Essbase}}</ref>

| 11.1.2.0

| 11.1.2.1

| [[Proprietary software|Proprietary]]

| [[Proprietary software|Proprietary]]

| [http://www.oracle.com/us/corporate/pricing/index.htm]

| [http://www.oracle.com/us/corporate/pricing/index.htm]

Revision as of 13:51, 12 April 2012

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
Essbase Oracle [1] 11.1.2.1 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 -

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

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

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

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

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".
  • ^ "icCube OLAP Server".
  • ^ "Microsoft SQL Server 2008 Analysis Services".
  • ^ "MicroStrategy Intelligence Server".
  • ^ "Pentaho Analysis Services: Mondrian Project".
  • ^ "Oracle OLAP Documentation".
  • ^ "Jedox AG Business Intelligence".
  • ^ "SAS OLAP Server".
  • ^ "Components & Tools".
  • ^ "Cognos Business Intelligence and Financial Performance Management".
  • ^ "SQL Server 2008 Books Online (October 2009)Defining Stored Procedures". MSDN.
  • ^ "SQL Server 2008 Books Online (October 2009)Using Stored Procedures". MSDN.
  • ^ "How to perform a SQL Server distributed query with OLAP Server". MSDN.
  • ^ "Pentaho and Simba Technologies Partner to Bring World's Most Popular Open Source OLAP Project to Microsoft Excel Users".
  • ^ "How to Define a Mondrian Schema". Pentaho.
  • ^ a b "Oracle and Simba Technologies Introduce MDX Provider for Oracle OLAP".
  • ^ "Querying Oracle OLAP Cubes: Fast Answers to Tough Questions Using Simple SQL".
  • ^ "Common Extensions of the MicroStrategy Platform".
  • ^ "How to add Current Month and Current Year level into Time dimension".
  • ^ "Essbase Server Limits". Oracle.
  • ^ "SQL Server 2008 Books Online (October 2009)Maximum Capacity Specifications (Analysis Services - Multidimensional Data)". Microsoft.
  • ^ "SAS OLAP Cube Size Specifications".
  • ^ MicroStrategy Intelligence Server™ Features
  • ^ "SAS OLAP Security Totals and Permission Conditions".
  • ^ "How to Change Over-the-Wire Encryption Settings for SAS Servers".

    • Retrieved from "https://en.wikipedia.org/w/index.php?title=Comparison_of_OLAP_servers&oldid=487004500"
    Categories: 
    ●Online analytical processing
     ●Software comparisons
     ●Data management
     ●Data warehousing products
      


    ●This page was last edited on 12 April 2012, at 13:51 (UTC).
    ●This version of the page has been revised. Besides normal editing, the reason for revision may have been that this version contains factual inaccuracies, vandalism, or material not compatible with the Creative Commons Attribution-ShareAlike License.


    ●Privacy policy
    ●About Wikipedia
    ●Disclaimers
    ●Contact Wikipedia
    ●Code of Conduct
    ●Developers
    ●Statistics
    ●Cookie statement
    ●Mobile view


    Wikimedia Foundation
    Powered by MediaWiki