Legal Notice
MicroStrategy does not guarantee the accuracy of any information presented in this document, and there is no commitment, express or implied, on the part of MicroStrategy to update or otherwise amend this document. The furnishing of this document does not provide any license to patents, trademarks, copyrights or other intellectual property rights owned or held by MicroStrategy.
Copyright Information
All Contents Copyright © 2010 MicroStrategy Incorporated.
All Rights Reserved.
Please click the link to agree to the above terms and continue with the QuickTour. AGREE »
Deep Insight through Superior Analytics
Flexible and Powerful OLAP Interactivity
MicroStrategy 9
- Automatic Drill Anywhere: Users can seamlessly drill anywhere for boundary-free investigative analysis across multiple data sources.
- Complex On-the-Fly Calculations and Groupings: Users can instantly create new derived metrics, derived attribute element groups, filters, and subtotals using existing report metrics and attributes. This functionality makes it possible for users to perform new calculations, custom groupings, and filtering directly on the report.
IBM Cognos 8.4
- Lack of Automatic Drill Anywhere: Cognos does not have automatic drill anywhere capabilities across reports. All drill paths across cubes and across reports have to be manually defined by IT or report developers.
- Two Overlapping Interfaces; Two Different MOLAP Strategies: Unlike MicroStrategy, Cognos requires two different products to perform similar ad hoc and OLAP tasks: Query Studio and Analysis Studio. Cognos’ acquisition of OLAP database vendor Applix TM1 also overlaps with its longtime Power Play database, which has experienced a drastic decline in market share.
Multi-Source ROLAP Allows Users to Seamlessly Traverse Multiple Databases
Efficiently Answer Complex Questions
MicroStrategy 9
- Iterative Multi-Pass SQL Capabilities: MicroStrategy’s ability to generate multi-pass SQL allows it to answer analytical questions that require several steps and cannot be answered with a single SQL query block.
- Compound Banded Reporting: MicroStrategy’s analysis objects can be defined with a high degree of complexity. For example, a custom group can be based on a mix of metric qualifications and multiple attributes at different levels. The reusability of these analysis objects allows business users to answer sophisticated questions without requiring IT coding and promotes more efficient application development.
IBM Cognos 8.4
- Limited Multi-Pass SQL Capabilities: Cognos does not generate multi-pass SQL query blocks. Therefore it cannot answer complex questions in an efficient way by leveraging the database and analytical engine in the middle tier when appropriate and in an iterative way.
- Inadequate Compound Banded Reporting: During competitive sales cycles, Cognos has been unable to perform reports necessitating many distinct layers of custom groups or grouping bands dictated by comprehensive formulas.
MicroStrategy Delivers Easy-to-Consume Comprehensive Analytics
Sophisticated Predictive Analytics
MicroStrategy 9
- Import Predictive Models: MicroStrategy Data Mining Services enables organizations to maximize their investment in data mining products by importing existing Predictive Model Markup Language (PMML) and seamlessly encapsulating the model as a predictive metric for use with any report or document.
- Predictive Analytics for All Users: Report designers and analysts can view and build predictive analytics using MicroStrategy and then distribute them via dashboards and reports to relevant decision makers and stakeholders.
IBM Cognos 8.4
- Insufficient Predictive Analytics: Cognos does not offer data mining and sophisticated predictive analytic capabilities. Cognos BI is unable to import PMML models from other data mining vendors.
All Users Can Leverage MicroStrategy’s Data Mining and Predictive Analytics
