Comparison of OLAP Servers
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.
s:
Note (1):The server availability depends on Java Virtual Machine not on the operating system
General information
| OLAP Server | Company | Website | Latest stable version | Software license | License Pricing |
|---|---|---|---|---|---|
| Essbase Essbase Essbase is a multidimensional database management system that provides a multidimensional database platform upon which to build analytic applications. Essbase, whose name derives from "Extended Spread Sheet dataBASE", began as a product of Arbor Software, which merged with Hyperion Software in 1998... |
Oracle Oracle Corporation Oracle Corporation is an American multinational computer technology corporation that specializes in developing and marketing hardware systems and enterprise software products – particularly database management systems... |
11.1.2.0 | Proprietary Proprietary software Proprietary software is computer software licensed under exclusive legal right of the copyright holder. The licensee is given the right to use the software under certain conditions, while restricted from other uses, such as modification, further distribution, or reverse engineering.Complementary... |
http://www.oracle.com/us/corporate/pricing/index.htm | |
| icCube | MISConsulting SA | 1.0 | Proprietary Proprietary software Proprietary software is computer software licensed under exclusive legal right of the copyright holder. The licensee is given the right to use the software under certain conditions, while restricted from other uses, such as modification, further distribution, or reverse engineering.Complementary... |
free | |
| Microsoft Analysis Services Microsoft Analysis Services Microsoft SQL Server Analysis Services is part of Microsoft SQL Server, a database management system. Microsoft has included a number of services in SQL Server related to business intelligence and data warehousing. These services include Integration Services and Analysis Services... |
Microsoft Microsoft Microsoft Corporation is an American public multinational corporation headquartered in Redmond, Washington, USA that develops, manufactures, licenses, and supports a wide range of products and services predominantly related to computing through its various product divisions... |
2008 R2 | Proprietary Proprietary software Proprietary software is computer software licensed under exclusive legal right of the copyright holder. The licensee is given the right to use the software under certain conditions, while restricted from other uses, such as modification, further distribution, or reverse engineering.Complementary... |
http://www.microsoft.com/sqlserver/2008/en/us/pricing.aspx | |
| MicroStrategy Intelligence Server | MicroStrategy MicroStrategy MicroStrategy, Inc. , is a business intelligence software vendor. MicroStrategy's software enables leading organizations worldwide to analyze the vast amounts of data stored across their enterprises to make more strategic business decisions... |
9 | Proprietary Proprietary software Proprietary software is computer software licensed under exclusive legal right of the copyright holder. The licensee is given the right to use the software under certain conditions, while restricted from other uses, such as modification, further distribution, or reverse engineering.Complementary... |
- | |
| Mondrian OLAP server Mondrian OLAP server Mondrian is an open source OLAP server,written in Java.It supports the MDX query languageand the XML for Analysis and interface specifications.It reads from SQL and other data sources... |
Pentaho Pentaho The Pentaho BI Suite is open source Business Intelligence suite with integrated reporting, dashboard, data mining, workflow and ETL capabilities. Pentaho is headquartered in Orlando, USA.- Overview :... |
3.2 | EPL Eclipse Public License The Eclipse Public License is an open source software license used by the Eclipse Foundation for its software. It replaces the Common Public License and removes certain terms relating to litigations related to patents.... |
free | |
| Oracle Database OLAP Option Oracle OLAP The Oracle Database OLAP Option implements On-line Analytical Processing 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 database... |
Oracle Oracle Corporation Oracle Corporation is an American multinational computer technology corporation that specializes in developing and marketing hardware systems and enterprise software products – particularly database management systems... |
11g R2 | Proprietary Proprietary software Proprietary software is computer software licensed under exclusive legal right of the copyright holder. The licensee is given the right to use the software under certain conditions, while restricted from other uses, such as modification, further distribution, or reverse engineering.Complementary... |
http://www.oracle.com/us/corporate/pricing/index.htm | |
| Palo Palo (OLAP database) Palo is a memory resident multidimensional database server and typically used as a Business Intelligence tool for Controlling and Budgeting purposes with Spreadsheet software acting as the user interface... |
Jedox | 3.2 SR3 | GPL GNU General Public License The GNU General Public License is the most widely used free software license, originally written by Richard Stallman for the GNU Project.... v2 or EULA |
- | |
| SAS OLAP Server SAS System SAS is an integrated system of software products provided by SAS Institute Inc. that enables programmers to perform:* retrieval, management, and mining* report writing and graphics* statistical analysis... |
SAS Institute SAS Institute SAS Institute Inc. , headquartered in Cary, North Carolina, USA, has been a major producer of software since it was founded in 1976 by Anthony Barr, James Goodnight, John Sall and Jane Helwig... |
9.2 | Proprietary Proprietary software Proprietary software is computer software licensed under exclusive legal right of the copyright holder. The licensee is given the right to use the software under certain conditions, while restricted from other uses, such as modification, further distribution, or reverse engineering.Complementary... |
- | |
| SAP NetWeaver BW | SAP SAP AG SAP AG is a German software corporation that makes enterprise software to manage business operations and customer relations. Headquartered in Walldorf, Baden-Württemberg, with regional offices around the world, SAP is the market leader in enterprise application software... |
7.20 | Proprietary Proprietary software Proprietary software is computer software licensed under exclusive legal right of the copyright holder. The licensee is given the right to use the software under certain conditions, while restricted from other uses, such as modification, further distribution, or reverse engineering.Complementary... |
- | |
| TM1 TM1 IBM Cognos TM1 is enterprise planning software used to implement collaborative planning, budgeting and forecasting solutions, as well as analytical and reporting applications. Data in IBM Cognos TM1 is stored and represented as multidimensional OLAP cubes, with data being stored at the "leaf" level... |
IBM IBM International Business Machines Corporation or IBM is an American multinational technology and consulting corporation headquartered in Armonk, New York, United States. IBM manufactures and sells computer hardware and software, and it offers infrastructure, hosting and consulting services in areas... |
9.5 | Proprietary Proprietary software Proprietary software is computer software licensed under exclusive legal right of the copyright holder. The licensee is given the right to use the software under certain conditions, while restricted from other uses, such as modification, further distribution, or reverse engineering.Complementary... |
- |
Data storage modes
| OLAP Server | MOLAP MOLAP MOLAP stands for Multidimensional Online Analytical Processing.MOLAP is an alternative to the ROLAP technology... |
ROLAP ROLAP ROLAP stands for Relational Online Analytical Processing.ROLAP is an alternative to the MOLAP technology... |
HOLAP HOLAP HOLAP is a combination of ROLAP and MOLAP which are other possible implementations of OLAP. HOLAP allows storing part of the data in a MOLAP store and another part of the data in a ROLAP store, allowing a tradeoff of the advantages of each... |
Offline |
|---|---|---|---|---|
| Essbase Essbase Essbase is a multidimensional database management system that provides a multidimensional database platform upon which to build analytic applications. Essbase, whose name derives from "Extended Spread Sheet dataBASE", began as a product of Arbor Software, which merged with Hyperion Software in 1998... |
||||
| icCube | ||||
| Microsoft Analysis Services Microsoft Analysis Services Microsoft SQL Server Analysis Services is part of Microsoft SQL Server, a database management system. Microsoft has included a number of services in SQL Server related to business intelligence and data warehousing. These services include Integration Services and Analysis Services... |
||||
| MicroStrategy Intelligence Server MicroStrategy MicroStrategy, Inc. , is a business intelligence software vendor. MicroStrategy's software enables leading organizations worldwide to analyze the vast amounts of data stored across their enterprises to make more strategic business decisions... |
||||
| Mondrian OLAP server Mondrian OLAP server Mondrian is an open source OLAP server,written in Java.It supports the MDX query languageand the XML for Analysis and interface specifications.It reads from SQL and other data sources... |
||||
| Oracle Database OLAP Option Oracle OLAP The Oracle Database OLAP Option implements On-line Analytical Processing 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 database... |
||||
| Palo Palo (OLAP database) Palo is a memory resident multidimensional database server and typically used as a Business Intelligence tool for Controlling and Budgeting purposes with Spreadsheet software acting as the user interface... |
||||
| SAS OLAP Server SAS System SAS is an integrated system of software products provided by SAS Institute Inc. that enables programmers to perform:* retrieval, management, and mining* report writing and graphics* statistical analysis... |
||||
| TM1 TM1 IBM Cognos TM1 is enterprise planning software used to implement collaborative planning, budgeting and forecasting solutions, as well as analytical and reporting applications. Data in IBM Cognos TM1 is stored and represented as multidimensional OLAP cubes, with data being stored at the "leaf" level... |
||||
| SAP NetWeaver BW |
APIs and query languages
APIs and query languages OLAP servers support.| OLAP Server | XML for Analysis XML for Analysis XML for Analysis is an industry standard for data access in analytical systems, such as OLAP and data mining. XMLA is based on other industry standards such as XML, SOAP and HTTP... |
OLE DB for OLAP | MDX Multidimensional Expressions Multidimensional Expressions 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.-Background:... |
Stored procedures | Custom functions | SQL SQL SQL is a programming language designed for managing data in relational database management systems .... |
|---|---|---|---|---|---|---|
| Essbase Essbase Essbase is a multidimensional database management system that provides a multidimensional database platform upon which to build analytic applications. Essbase, whose name derives from "Extended Spread Sheet dataBASE", began as a product of Arbor Software, which merged with Hyperion Software in 1998... |
||||||
| icCube | ||||||
| Microsoft Analysis Services Microsoft Analysis Services Microsoft SQL Server Analysis Services is part of Microsoft SQL Server, a database management system. Microsoft has included a number of services in SQL Server related to business intelligence and data warehousing. These services include Integration Services and Analysis Services... |
||||||
| MicroStrategy Intelligence Server MicroStrategy MicroStrategy, Inc. , is a business intelligence software vendor. MicroStrategy's software enables leading organizations worldwide to analyze the vast amounts of data stored across their enterprises to make more strategic business decisions... |
||||||
| Mondrian OLAP server Mondrian OLAP server Mondrian is an open source OLAP server,written in Java.It supports the MDX query languageand the XML for Analysis and interface specifications.It reads from SQL and other data sources... |
||||||
| Palo Palo (OLAP database) Palo is a memory resident multidimensional database server and typically used as a Business Intelligence tool for Controlling and Budgeting purposes with Spreadsheet software acting as the user interface... |
||||||
| Oracle Database OLAP Option Oracle OLAP The Oracle Database OLAP Option implements On-line Analytical Processing 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 database... |
||||||
| SAS OLAP Server SAS System SAS is an integrated system of software products provided by SAS Institute Inc. that enables programmers to perform:* retrieval, management, and mining* report writing and graphics* statistical analysis... |
||||||
| SAP NetWeaver BW | ||||||
| TM1 TM1 IBM Cognos TM1 is enterprise planning software used to implement collaborative planning, budgeting and forecasting solutions, as well as analytical and reporting applications. Data in IBM Cognos TM1 is stored and represented as multidimensional OLAP cubes, with data being stored at the "leaf" level... |
OLAP features
| OLAP Server | Parent-child hierarchies | Multiple time hierarchies | Semi-additive measures | Write-back | Measure Groups | Partitioning |
|---|---|---|---|---|---|---|
| Essbase Essbase Essbase is a multidimensional database management system that provides a multidimensional database platform upon which to build analytic applications. Essbase, whose name derives from "Extended Spread Sheet dataBASE", began as a product of Arbor Software, which merged with Hyperion Software in 1998... |
||||||
| icCube | ||||||
| Microsoft Analysis Services Microsoft Analysis Services Microsoft SQL Server Analysis Services is part of Microsoft SQL Server, a database management system. Microsoft has included a number of services in SQL Server related to business intelligence and data warehousing. These services include Integration Services and Analysis Services... |
||||||
| MicroStrategy Intelligence Server MicroStrategy MicroStrategy, Inc. , is a business intelligence software vendor. MicroStrategy's software enables leading organizations worldwide to analyze the vast amounts of data stored across their enterprises to make more strategic business decisions... |
||||||
| Mondrian OLAP server Mondrian OLAP server Mondrian is an open source OLAP server,written in Java.It supports the MDX query languageand the XML for Analysis and interface specifications.It reads from SQL and other data sources... |
||||||
| Oracle Database OLAP Option Oracle OLAP The Oracle Database OLAP Option implements On-line Analytical Processing 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 database... |
||||||
| Palo Palo (OLAP database) Palo is a memory resident multidimensional database server and typically used as a Business Intelligence tool for Controlling and Budgeting purposes with Spreadsheet software acting as the user interface... |
||||||
| TM1 TM1 IBM Cognos TM1 is enterprise planning software used to implement collaborative planning, budgeting and forecasting solutions, as well as analytical and reporting applications. Data in IBM Cognos TM1 is stored and represented as multidimensional OLAP cubes, with data being stored at the "leaf" level... |
||||||
| SAP NetWeaver BW |
System limits
| OLAP Server | # cubes | # measures | # dimensions | # hierarchies in dimension | # levels in hierarchy | # dimension members |
|---|---|---|---|---|---|---|
| Essbase Essbase Essbase is a multidimensional database management system that provides a multidimensional database platform upon which to build analytic applications. Essbase, whose name derives from "Extended Spread Sheet dataBASE", began as a product of Arbor Software, which merged with Hyperion Software in 1998... |
? | ? | ? | 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 Microsoft Analysis Services Microsoft SQL Server Analysis Services is part of Microsoft SQL Server, a database management system. Microsoft has included a number of services in SQL Server related to business intelligence and data warehousing. These services include Integration Services and Analysis Services... |
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 MicroStrategy MicroStrategy, Inc. , is a business intelligence software vendor. MicroStrategy's software enables leading organizations worldwide to analyze the vast amounts of data stored across their enterprises to make more strategic business decisions... |
Unrestricted | Unrestricted | Unrestricted | Unrestricted | Unrestricted | Unrestricted |
| SAS OLAP Server SAS System SAS is an integrated system of software products provided by SAS Institute Inc. that enables programmers to perform:* retrieval, management, and mining* report writing and graphics* statistical analysis... |
? | 1024 | 128 | 128 | 19 | 2,147,483,648 |
Security
| OLAP Server | Authentication | Network encryption | Data access | ||
|---|---|---|---|---|---|
| Cell security | Dimension security | Visual totals | |||
| Essbase Essbase Essbase is a multidimensional database management system that provides a multidimensional database platform upon which to build analytic applications. Essbase, whose name derives from "Extended Spread Sheet dataBASE", began as a product of Arbor Software, which merged with Hyperion Software in 1998... |
|||||
| Microsoft Analysis Services Microsoft Analysis Services Microsoft SQL Server Analysis Services is part of Microsoft SQL Server, a database management system. Microsoft has included a number of services in SQL Server related to business intelligence and data warehousing. These services include Integration Services and Analysis Services... |
|||||
| MicroStrategy Intelligence Server MicroStrategy MicroStrategy, Inc. , is a business intelligence software vendor. MicroStrategy's software enables leading organizations worldwide to analyze the vast amounts of data stored across their enterprises to make more strategic business decisions... |
|||||
| Oracle Database OLAP Option Oracle OLAP The Oracle Database OLAP Option implements On-line Analytical Processing 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 database... |
|||||
| Palo Palo (OLAP database) Palo is a memory resident multidimensional database server and typically used as a Business Intelligence tool for Controlling and Budgeting purposes with Spreadsheet software acting as the user interface... |
|||||
| SAS OLAP Server SAS System SAS is an integrated system of software products provided by SAS Institute Inc. that enables programmers to perform:* retrieval, management, and mining* report writing and graphics* statistical analysis... |
|||||
Operating systems
The OLAP servers can run on the following operating systemOperating system
An operating system is a set of programs that manage computer hardware resources and provide common services for application software. The operating system is the most important type of system software in a computer system...
s:
| OLAP Server | Windows | Linux | UNIX | z/OS |
|---|---|---|---|---|
| Essbase Essbase Essbase is a multidimensional database management system that provides a multidimensional database platform upon which to build analytic applications. Essbase, whose name derives from "Extended Spread Sheet dataBASE", began as a product of Arbor Software, which merged with Hyperion Software in 1998... |
||||
| icCube | ||||
| Microsoft Analysis Services Microsoft Analysis Services Microsoft SQL Server Analysis Services is part of Microsoft SQL Server, a database management system. Microsoft has included a number of services in SQL Server related to business intelligence and data warehousing. These services include Integration Services and Analysis Services... |
||||
| MicroStrategy Intelligence Server MicroStrategy MicroStrategy, Inc. , is a business intelligence software vendor. MicroStrategy's software enables leading organizations worldwide to analyze the vast amounts of data stored across their enterprises to make more strategic business decisions... |
||||
| Mondrian OLAP server Mondrian OLAP server Mondrian is an open source OLAP server,written in Java.It supports the MDX query languageand the XML for Analysis and interface specifications.It reads from SQL and other data sources... |
||||
| Oracle Database OLAP Option Oracle OLAP The Oracle Database OLAP Option implements On-line Analytical Processing 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 database... |
||||
| Palo Palo (OLAP database) Palo is a memory resident multidimensional database server and typically used as a Business Intelligence tool for Controlling and Budgeting purposes with Spreadsheet software acting as the user interface... |
||||
| SAS OLAP Server SAS System SAS is an integrated system of software products provided by SAS Institute Inc. that enables programmers to perform:* retrieval, management, and mining* report writing and graphics* statistical analysis... |
||||
| SAP NetWeaver BW | ||||
| TM1 TM1 IBM Cognos TM1 is enterprise planning software used to implement collaborative planning, budgeting and forecasting solutions, as well as analytical and reporting applications. Data in IBM Cognos TM1 is stored and represented as multidimensional OLAP cubes, with data being stored at the "leaf" level... |
Note (1):The server availability depends on Java Virtual Machine not on the operating system
Operating system
An operating system is a set of programs that manage computer hardware resources and provide common services for application software. The operating system is the most important type of system software in a computer system...
Support information
| OLAP Server | Issue Tracking System | Forum/Blog | Roadmap | Source code |
|---|---|---|---|---|
| Essbase Essbase Essbase is a multidimensional database management system that provides a multidimensional database platform upon which to build analytic applications. Essbase, whose name derives from "Extended Spread Sheet dataBASE", began as a product of Arbor Software, which merged with Hyperion Software in 1998... |
http://forums.oracle.com/forums/main.jspa?categoryID=84 | http://communities.ioug.org/Portals/2/Oracle_Essbase_Roadmap_Sep_09.pdf | Closed | |
| icCube | http://www.iccube.com/support/forum | http://www.iccube.com/support/qa/roadmap | Open | |
| Microsoft Analysis Services Microsoft Analysis Services Microsoft SQL Server Analysis Services is part of Microsoft SQL Server, a database management system. Microsoft has included a number of services in SQL Server related to business intelligence and data warehousing. These services include Integration Services and Analysis Services... |
http://social.msdn.microsoft.com/Forums/en-US/sqlanalysisservices/threads | - | Closed | |
| MicroStrategy Intelligence Server MicroStrategy MicroStrategy, Inc. , is a business intelligence software vendor. MicroStrategy's software enables leading organizations worldwide to analyze the vast amounts of data stored across their enterprises to make more strategic business decisions... |
https://resource.microstrategy.com/Forum/ | - | Closed | |
| Mondrian OLAP server Mondrian OLAP server Mondrian is an open source OLAP server,written in Java.It supports the MDX query languageand the XML for Analysis and interface specifications.It reads from SQL and other data sources... |
http://forums.pentaho.org/forumdisplay.php?f=79 | http://mondrian.pentaho.org/documentation/roadmap.php | Open | |
| Oracle Database OLAP Option Oracle OLAP The Oracle Database OLAP Option implements On-line Analytical Processing 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 database... |
http://forums.oracle.com/forums/main.jspa?categoryID=84 | Closed | ||
| Palo Palo (OLAP database) Palo is a memory resident multidimensional database server and typically used as a Business Intelligence tool for Controlling and Budgeting purposes with Spreadsheet software acting as the user interface... |
http://www.jedox.com/community/palo-forum/board.php?boardid=9 | Open | ||
| SAS OLAP Server SAS System SAS is an integrated system of software products provided by SAS Institute Inc. that enables programmers to perform:* retrieval, management, and mining* report writing and graphics* statistical analysis... |
Closed | |||
| SAP NetWeaver BW | http://forums.sdn.sap.com/index.jspa | http://esworkplace.sap.com/socoview(bD1lbiZjPTAwMSZkPW1pbg)/render.asp?id=2270EAD629814D05A7ECECECECC8D002&fragID=&packageid=DEE98D07DF9FA9F1B3C7001A64D3F462 | Closed | |
| TM1 TM1 IBM Cognos TM1 is enterprise planning software used to implement collaborative planning, budgeting and forecasting solutions, as well as analytical and reporting applications. Data in IBM Cognos TM1 is stored and represented as multidimensional OLAP cubes, with data being stored at the "leaf" level... |
http://forums.olapforums.com/ | Closed |