Business Intelligence software comparison

 

Project	Mstr	Bo	Oracle biee	Cognos 8
Features
Installation and deployment	The client does not have any installation; the installation of the server is automated throughout the process, and there is no dedicated parameter input, which is easier to install. Supports mainstream OS platforms such as windows and Unix	Before installation, you must change the region settings and local security policies, which are easy to install and are not supported. Supports mainstream OS platforms such as windows and Unix	The installation process is similar to installing the Oracle database, and the configuration file nqsconfig. ini needs to be set. It is easier to install it in the installation wizard. Supports mainstream OS platforms such as windows and Unix	The installation requires guidance. The configuration after installation is cumbersome and may fail to be installed. Supports mainstream OS platforms such as windows and Unix
Compatibility	Mstr cannot connect to the analysis model data generated by a third-party olapserver. It cannot be accessed by third-party tools. Supports major OS database systems: Mainstream RDBMS	The Chinese version of bo5 cannot perform drill-down on the workbook in B/S mode.	Supports ad-hoc queries, OLAP analysis, dashboards, and other analysis using a shared enterprise semantic model, and provides open interfaces to other analysis tools. It supports the following, Mainstream technical databases.	Cognos has version restrictions for connecting to the user-defined system (corner stone) in Unix. Versions later than the user-defined system (corner stone) 6.2 and later versions are not supported; Cognos does not support Composite data or multi-to-many Association.
Data capacity	The unique ROLAP engine is specially optimized for data models larger than 1 GB. It supports analysis of data models larger than GB. It also supports TB-level data analysis and optimizes SQL statements with large data volumes. Query of large data volumes is inefficient.	60-60 Data Models ~ Based on the performance of the OLAP Server, essbass supports a data model of about 10 Gb. If there is no OLAP Server, the display efficiency is low.	Molap has no limit on a single data model (corner stone). As the volume of the cube increases, the performance will not decrease significantly; The ROLAP data model supports more than GB of data and has no restrictions. query efficiency is greatly affected.	Single Data Model ROLAP 50 GB ~ 80 GB or above, but the query efficiency is slow; It is difficult for molap to support a large amount of data. It is difficult to support models with too many dimension levels and members. The value exceeds 2 GB ~ Cubes of. MDC above 4 GB can be divided into small. MDP files.
Product Line completeness	Lack of ETL and data mining tools	Lack of data mining tools and ETL Tool di	Biee does not have ETL tools. However, Oracle BI has a wide range of product lines and can provide ETL jobs.	Has a comprehensive BI product line, rich functions, ETL workers, Cognos data manager
Product integration	Highly integrated, provides integrated interfaces for data connection, model creation, report publishing, and permission management.	Moderate Integration, and the gap between web functions and traditional C/S models	High Integration and unified technical architecture platform	Versions earlier than c8.3 are generally integrated. A variety of applications correspond to separate user interfaces, such as transformer and powerplay have independent interfaces. c8.4 has some changes.
SDK openness	A high degree of openness, providing a comprehensive SDK.	Relatively small, the function is encapsulated in ocx, and secondary development functions such as latitude parameter input are supported. In particular, the permission interface is not provided, and the command line mode for simple operations such as data update and startup service is provided.	Highly open applications and rich APIs	Few functions, which cannot be implemented by secondary development of many features, and provide functions with initial User Function permissions; The provided Web APIs are very limited and cannot be embedded into existing application systems without real Web customization capabilities.
Quick Development	A quick development template is available, and the template developed by the customer can be reused. You can create a new report based on the template and create a new report suitable for you on the existing report.	There are a wide range of reference models for rapid development, which makes it easier to achieve general requirements. Because of the patented "semantic layer ", users can quickly write out powerful financial, sales, and other reports containing tables, charts, super connections, and images.	Supports object-based report design and production, and direct copy and paste of objects between different semantic models.	No development template is provided. You can add a report header to form a report based on the analysis, and save the analysis result as a report under B/S.
Secondary Development	The workload is large, but theoretically, you can re-develop any functions except the server and some functional permissions. The Development Volume mainly focuses on the application of basic functions.	Mainly focused on the appearance of the interface	If development involves model changes, modify the report requirements accordingly.	Focuses on the appearance of the interface; If development involves model changes, modify the report requirements accordingly.
Model or report data source	Supports multiple data sources. However, only one data source can be used in one project.	Businessobjects allows you to merge data from different sources in the same report. For example, a single excle table supports hybrid display and is powerful.	Supports multiple data sources, such as xmla, MS analysis, and sap bw.	Partially supported (only a single data source is supported in the Model)
Supported databases and OLAP	Mainstream databases; only use your own OLAP Server	Mainstream databases and mainstream OLAP servers (Cognos and mstr are not supported ); It does not have a real OLAP Server and requires a third-party OLAP server.	Only use your own OLAP Server	Mainstream databases and mainstream OLAP servers
Metadata Management	Has a unified metadatabase. Metadata is managed through the desktop integration interface to facilitate metadata migration and replication.	Metadata inventory user information is available, but the UNV file and REP (repository) report file must be created in C/S mode, and can be edited if the file is saved as wqy in Web mode, however, the function is weak.	Provides Bi metadata management models, allowing you to flexibly query, analyze reports, and publish dashboards without the need of professional IT technicians;	You can back up data using file and content store tools.
Modeling Tools	Enable terraect as a modeling tool, and provide smart cubes in the Application Server intelligence server.	No. Purchase OLAP separately	Provides an administration tool for modeling physical layer-logical layer-presentation layer.	Transform is provided as a tool for modeling and generating analytic cubes. the OLAP Server is an enterprise server, which produces highly efficient cubes. The data in the analytical cubes is compressed and the capacity is 4 ~ ~ of the data in the same conditions ~ One of 20 points; Framework modeling is slightly complicated.
Permission management	The secondary integration of function permissions and data permissions is high, but the development volume is large.	Provides function permissions and data permissions, but only provides secondary integration capabilities for simple user permission operations.	Provides function and data permissions; Data permission: grant permissions to users by row or column, and control the access time of user queries.	Provides function permissions and data permissions. Secondary Development of permissions is small.
Ease of use	Easy report presentation, but poor OLAP operations	Because the OCX plug-in is used, the OLAP display mode is more like excel, the operation is more intuitive, give the user a better impression, but the report feeling is poor A single interface can be used for query, report, and analysis. with a single entry point through the infoview Bi interface, businessobjects allows users to quickly and easily access reports.	Flexible and convenient operations, supporting drag and drop Design	OLAP features are powerful, and the operation response speed is fast. It supports drag and drop design. However, it is difficult to get started for the first time, The operation is inconvenient when you query reports using web page access conditions.
Rotating, slicing, and drilling	Provides OLAP analysis such as rotation, slicing, drilling, and customized subtotal.	All supported	Supports drilling, rotating, and slicing.	All of them are supported. The most powerful analysis function is in the Web mode, and many analysis tasks can be performed after you are skilled in using them. This function supports analysis operations from any angle.
Drill-through to details	ROLAP can drill into detailed data, and the query speed is slow.	Bo's desktop-based Cube approach is limited by the amount of data contained in the cube and the Analysis on a limited number of datasets. After a user's drilling operation, no corresponding data restrictions are provided. Therefore, when querying a detailed ticket, the data volume is explosively increasing.	Query of detailed data based on ROLAP is slow.	ROLAP can drill into detailed data, and the query speed is slow; Molap can also drill into detailed data with limited data volume.
Refresh data	Provides tools for Scheduled Update and SDK Function Control update. Provides a scheduling mechanism. Data can be refreshed based on flexible time settings or event-triggered reports.	Command Line Update (Scheduling with a third-party Scheduler)		Provides timed update tools and corresponding command line program updates; When the cube is large, it takes a long time to refresh the data, but incremental data refresh is supported.
Export multiple file formats	Common formats are supported (PDF, Excel, etc)	Same as mstr	Common formats are supported (PDF, Excel, etc.	Same as mstr
Report display	Supports beautiful list, cross tabulation, and charts (more than 90 types). The charts are mostly Flash and have a strong dynamic and three-dimensional effect.	Provides regular application charts with fewer chart styles	Provides regular application charts, which provide beautiful charts	Provides regular application charts, but the chart style is small, and the reports and charts are not beautiful.
Flexible query parameter settings	Parameter settings are cumbersome and are filter-based, and the query interface is unfriendly.	Complex SQL statements can be constructed during query in the new 6.x version and can contain dynamic query functions. However, the Chinese version of 6.x has not yet been released.	Biee has session and database variables in terms of variables, and prompts that database variables can be introduced. Therefore, it is very useful to set window time, default yesterday, and other applications in page initialization.	You can only filter simple conditions. complex queries require JavaScript scripts.
Calculation column Design	It provides powerful statistical computing functions. Computing columns are designed at the report layer. Computing between dimension members is difficult to design.	Provides a wide range of computing functions	Biee is completed in the administrationtool. After the star relationship is established, a calculation column is added to the logic layer and a function (timeline function) can be added.	Molap computing columns can be designed at the model layer and report layer respectively, with rich functions. For ROLAP report net, it is difficult to add computing columns at the report layer, such as period-over-period comparison, for computing such as year-on-year comparison, you need to create multiple levels of small queries.
Product performance
Load Balancing	Supports multiple levels of load balancing, including the intelligence Server Service and broad cast distributed load balancing, and provides corresponding optimization tools (additional payment), supporting a large number of concurrent user requests, the processing efficiency of concurrency is high.	Similar to Cognos	Supports cluster functions,	Provides Load Balancing for application servers and supports clusters.
Report refresh speed (10 million data records)	Provides a report cache mechanism (reports, objects, elements, and XML) to improve efficiency. When cache is available, the access speed is less than 1 minute. When no cache is available, the access speed is increased by 10 to 10 Based on the SQL query time ~ 30 seconds	15 seconds ~ Within 2 minutes	Provides a report cache mechanism to improve efficiency. When cache is available, the access speed is less than 1 minute. If no cache is available, the access speed is slower. When accessing eassbase, the performance is better.	Report net does not provide a report cache mechanism; ROLAP more than 30 seconds Molap 6 seconds ~ 30 seconds
Concurrent access	A single CPU can support 50 concurrent operation users	A single CPU supports up to 25 concurrent operation users		A single CPU supports up to 50 concurrent operation users
System maintainability	Metadata and permissions are centrally managed. It is easier to manage and maintain, but the creation of new entities requires dedicated personnel		Metadata management tools are available for centralized permission management and easy management. You need to modify the corresponding configuration file during migration.	Metadata Management tools facilitate management.
Price and service
Price	The quotation is based on the number of users and components, with the minimum user data limit. The overall price is 100		$2,000/user, $295,000/processor.	IBM Cognos performs Task-based pricing on IBM Cognos 8 bi. Different task Prices vary depending on whether authorization is required for the user or whether the Administrator's task authorization is required. There is a discount on the number of licenses, so the product will be fixed because of the customer's installation scale and all the differences. The overall price is similar to that of microstrategy.