TrustRadius: an HG Insights company

Save this comparison

Save this comparison

Add Product

Recommended Comparisons

    Overview
    ProductRatingMost Used ByProduct SummaryStarting Price

    IBM Cognos Analytics

    Score7.7 out of 10
    N/AIBM Cognos is a full-featured business intelligence suite by IBM, designed for larger deployments. It comprises Query Studio, Reporting Studio, Analysis Studio and Event Studio, and Cognos Administration along with tools for Microsoft Office integration, full-text search, and dashboards.

    $11.25

    per month per user

    Microsoft Dynamics SL

    Score5.1 out of 10
    N/AMicrosoft Dynamics SL is one of the ERP products in the Dynamics family. This product was acquired from Solomon 2000. The product is typically used by SMBs, particularly in project-based businesses (e.g. construction). It has strong accounting and project management capabilities.N/A
    Pricing
    IBM Cognos AnalyticsMicrosoft Dynamics SL
    Editions & Modules
    On Demand - Standard
    USD 11.25
    per month per user
    On Demand - Premium
    USD 44.90
    per month per user
    No answers on this topic
    Offerings
    Pricing Offerings
    IBM Cognos AnalyticsMicrosoft Dynamics SL
    Free Trial
    YesNo
    Free/Freemium Version
    NoNo
    Premium Consulting/Integration Services
    YesNo
    Entry-level Setup FeeOptionalNo setup fee
    Additional Details——
    More Pricing Information
    Community Pulse
    IBM Cognos AnalyticsMicrosoft Dynamics SL
    Considered Both Products
    IBM
    No answer on this topic
    Microsoft
    No answer on this topic
    Key User Insights
    Would buy again
    97%
    Would buy again
    92 Answers
    No answers on this topic
    Delivers good value for the price
    94%
    Delivers good value for the price
    79 Answers
    No answers on this topic
    Happy with the feature set
    96%
    Happy with the feature set
    91 Answers
    No answers on this topic
    Lived up to sales and marketing promises
    93%
    Lived up to sales and marketing promises
    55 Answers
    No answers on this topic
    Implementation went as expected
    96%
    Implementation went as expected
    64 Answers
    No answers on this topic
    Features
    IBM Cognos AnalyticsMicrosoft Dynamics SL
    BI Standard Reporting
    Comparison of BI Standard Reporting features of IBM Cognos Analytics and Microsoft Dynamics SL
    Feature
    IBM Cognos Analytics
    7.7
    138 Ratings
    6% below category average
    Microsoft Dynamics SL
    -
    Ratings
    Pixel Perfect reports7.6129 Ratings00 Ratings
    Customizable dashboards8.0136 Ratings00 Ratings
    Report Formatting Templates7.5131 Ratings00 Ratings
    Ad-hoc Reporting
    Comparison of Ad-hoc Reporting features of IBM Cognos Analytics and Microsoft Dynamics SL
    Feature
    IBM Cognos Analytics
    7.9
    138 Ratings
    1% below category average
    Microsoft Dynamics SL
    -
    Ratings
    Drill-down analysis7.4136 Ratings00 Ratings
    Formatting capabilities8.3139 Ratings00 Ratings
    Integration with R or other statistical packages7.397 Ratings00 Ratings
    Report sharing and collaboration8.6133 Ratings00 Ratings
    Report Output and Scheduling
    Comparison of Report Output and Scheduling features of IBM Cognos Analytics and Microsoft Dynamics SL
    Feature
    IBM Cognos Analytics
    9.2
    136 Ratings
    11% above category average
    Microsoft Dynamics SL
    -
    Ratings
    Publish to Web9.836 Ratings00 Ratings
    Publish to PDF8.2132 Ratings00 Ratings
    Report Versioning9.833 Ratings00 Ratings
    Report Delivery Scheduling8.2134 Ratings00 Ratings
    Delivery to Remote Servers9.918 Ratings00 Ratings
    Data Discovery and Visualization
    Comparison of Data Discovery and Visualization features of IBM Cognos Analytics and Microsoft Dynamics SL
    Feature
    IBM Cognos Analytics
    7.4
    124 Ratings
    8% below category average
    Microsoft Dynamics SL
    -
    Ratings
    Pre-built visualization formats (heatmaps, scatter plots etc.)7.9121 Ratings00 Ratings
    Location Analytics / Geographic Visualization8.0114 Ratings00 Ratings
    Predictive Analytics6.7110 Ratings00 Ratings
    Pattern Recognition and Data Mining6.947 Ratings00 Ratings
    Access Control and Security
    Comparison of Access Control and Security features of IBM Cognos Analytics and Microsoft Dynamics SL
    Feature
    IBM Cognos Analytics
    7.8
    130 Ratings
    8% below category average
    Microsoft Dynamics SL
    -
    Ratings
    Multi-User Support (named login)7.5129 Ratings00 Ratings
    Role-Based Security Model7.5127 Ratings00 Ratings
    Multiple Access Permission Levels (Create, Read, Delete)7.4127 Ratings00 Ratings
    Report-Level Access Control8.257 Ratings00 Ratings
    Single Sign-On (SSO)8.6111 Ratings00 Ratings
    Mobile Capabilities
    Comparison of Mobile Capabilities features of IBM Cognos Analytics and Microsoft Dynamics SL
    Feature
    IBM Cognos Analytics
    6.3
    109 Ratings
    20% below category average
    Microsoft Dynamics SL
    -
    Ratings
    Responsive Design for Web Access6.8104 Ratings00 Ratings
    Mobile Application6.390 Ratings00 Ratings
    Dashboard / Report / Visualization Interactivity on Mobile6.696 Ratings00 Ratings
    Application Program Interfaces (APIs) / Embedding
    Comparison of Application Program Interfaces (APIs) / Embedding features of IBM Cognos Analytics and Microsoft Dynamics SL
    Feature
    IBM Cognos Analytics
    9.2
    87 Ratings
    17% above category average
    Microsoft Dynamics SL
    -
    Ratings
    REST API7.683 Ratings00 Ratings
    Javascript API7.779 Ratings00 Ratings
    iFrames9.912 Ratings00 Ratings
    Java API10.013 Ratings00 Ratings
    Themeable User Interface (UI)9.915 Ratings00 Ratings
    Customizable Platform (Open Source)9.99 Ratings00 Ratings
    Payroll Management
    Comparison of Payroll Management features of IBM Cognos Analytics and Microsoft Dynamics SL
    Feature
    IBM Cognos Analytics
    -
    Ratings
    Microsoft Dynamics SL
    8.5
    2 Ratings
    12% above category average
    Pay calculation00 Ratings9.62 Ratings
    Direct deposit files00 Ratings9.01 Ratings
    Customization
    Comparison of Customization features of IBM Cognos Analytics and Microsoft Dynamics SL
    Feature
    IBM Cognos Analytics
    -
    Ratings
    Microsoft Dynamics SL
    6.0
    6 Ratings
    23% below category average
    API for custom integration00 Ratings6.06 Ratings
    Plug-ins00 Ratings6.04 Ratings
    Security
    Comparison of Security features of IBM Cognos Analytics and Microsoft Dynamics SL
    Feature
    IBM Cognos Analytics
    -
    Ratings
    Microsoft Dynamics SL
    8.7
    10 Ratings
    3% above category average
    Single sign-on capability00 Ratings7.49 Ratings
    Role-based user permissions00 Ratings10.09 Ratings
    Reporting & Analytics
    Comparison of Reporting & Analytics features of IBM Cognos Analytics and Microsoft Dynamics SL
    Feature
    IBM Cognos Analytics
    -
    Ratings
    Microsoft Dynamics SL
    8.0
    10 Ratings
    6% above category average
    Dashboards00 Ratings8.06 Ratings
    Standard reports00 Ratings8.010 Ratings
    Custom reports00 Ratings8.010 Ratings
    General Ledger and Configurable Accounting
    Comparison of General Ledger and Configurable Accounting features of IBM Cognos Analytics and Microsoft Dynamics SL
    Feature
    IBM Cognos Analytics
    -
    Ratings
    Microsoft Dynamics SL
    7.1
    11 Ratings
    8% below category average
    Accounts payable00 Ratings6.011 Ratings
    Accounts receivable00 Ratings6.08 Ratings
    Global Financial Support00 Ratings6.02 Ratings
    Primary and Secondary Ledgers00 Ratings6.63 Ratings
    Journals and Reconciliations00 Ratings3.04 Ratings
    Configurable Accounting00 Ratings8.03 Ratings
    Standardized Processes00 Ratings6.03 Ratings
    Inventory Management
    Comparison of Inventory Management features of IBM Cognos Analytics and Microsoft Dynamics SL
    Feature
    IBM Cognos Analytics
    -
    Ratings
    Microsoft Dynamics SL
    5.7
    6 Ratings
    33% below category average
    Inventory tracking00 Ratings5.06 Ratings
    Location management00 Ratings6.03 Ratings
    Order Management
    Comparison of Order Management features of IBM Cognos Analytics and Microsoft Dynamics SL
    Feature
    IBM Cognos Analytics
    -
    Ratings
    Microsoft Dynamics SL
    6.2
    4 Ratings
    25% below category average
    Pricing00 Ratings6.03 Ratings
    Order entry00 Ratings3.04 Ratings
    Credit card processing00 Ratings7.02 Ratings
    Cost of goods sold00 Ratings7.03 Ratings
    Subledger and Financial Process
    Comparison of Subledger and Financial Process features of IBM Cognos Analytics and Microsoft Dynamics SL
    Feature
    IBM Cognos Analytics
    -
    Ratings
    Microsoft Dynamics SL
    5.7
    4 Ratings
    28% below category average
    Billing Management00 Ratings6.02 Ratings
    Cash and Asset Management00 Ratings7.33 Ratings
    Travel & Expense Management00 Ratings5.01 Ratings
    Budgetary Control & Encumbrance Accounting00 Ratings6.32 Ratings
    Period Close00 Ratings6.04 Ratings
    Project Financial Management
    Comparison of Project Financial Management features of IBM Cognos Analytics and Microsoft Dynamics SL
    Feature
    IBM Cognos Analytics
    -
    Ratings
    Microsoft Dynamics SL
    4.7
    3 Ratings
    47% below category average
    Budgeting and Forecasting00 Ratings7.33 Ratings
    Project Costing00 Ratings6.33 Ratings
    Cost Capture00 Ratings2.12 Ratings
    Capital Project Management00 Ratings8.01 Ratings
    Project Revenue Recognition00 Ratings2.01 Ratings
    Grants Management
    Comparison of Grants Management features of IBM Cognos Analytics and Microsoft Dynamics SL
    Feature
    IBM Cognos Analytics
    -
    Ratings
    Microsoft Dynamics SL
    6.3
    1 Ratings
    17% below category average
    Award Lifecycle Management00 Ratings6.01 Ratings
    Manufacturing
    Comparison of Manufacturing features of IBM Cognos Analytics and Microsoft Dynamics SL
    Feature
    IBM Cognos Analytics
    -
    Ratings
    Microsoft Dynamics SL
    6.0
    1 Ratings
    22% below category average
    Production Management00 Ratings6.01 Ratings
    Supply Chain
    Comparison of Supply Chain features of IBM Cognos Analytics and Microsoft Dynamics SL
    Feature
    IBM Cognos Analytics
    -
    Ratings
    Microsoft Dynamics SL
    6.0
    1 Ratings
    20% below category average
    Inventory Planning00 Ratings6.01 Ratings
    Best Alternatives
    IBM Cognos AnalyticsMicrosoft Dynamics SL
    Small Businesses
    Cyfe
    Score4 out of 10
    Zoho One
    Score9.2 out of 10
    Medium-sized Companies
    Qlik Cloud Analytics (Qlik Sense)
    Score8.1 out of 10
    Zoho One
    Score9.2 out of 10
    Enterprises
    Jaspersoft Community Edition
    Score7 out of 10
    Microsoft Dynamics AX (discontinued)
    Score4.8 out of 10
    All AlternativesView all alternativesView all alternatives
    User Ratings
    IBM Cognos AnalyticsMicrosoft Dynamics SL
    Likelihood to Recommend
    8.0
    (158 ratings)
    5.0
    (18 ratings)
    Likelihood to Renew
    8.4
    (31 ratings)
    5.4
    (8 ratings)
    Usability
    7.3
    (10 ratings)
    3.0
    (7 ratings)
    Availability
    8.6
    (4 ratings)
    9.9
    (2 ratings)
    Performance
    9.0
    (5 ratings)
    1.0
    (1 ratings)
    Support Rating
    1.0
    (9 ratings)
    9.5
    (4 ratings)
    In-Person Training
    8.7
    (4 ratings)
    -
    (0 ratings)
    Online Training
    8.0
    (4 ratings)
    1.0
    (1 ratings)
    Implementation Rating
    7.0
    (7 ratings)
    9.0
    (4 ratings)
    Configurability
    7.0
    (3 ratings)
    -
    (0 ratings)
    Data Sharing and Collaboration
    8.6
    (40 ratings)
    -
    (0 ratings)
    Data Sources
    8.3
    (40 ratings)
    -
    (0 ratings)
    Ease of integration
    5.5
    (6 ratings)
    -
    (0 ratings)
    Product Scalability
    6.4
    (5 ratings)
    1.4
    (2 ratings)
    Vendor post-sale
    7.0
    (1 ratings)
    -
    (0 ratings)
    Vendor pre-sale
    7.0
    (1 ratings)
    -
    (0 ratings)
    User Testimonials
    IBM Cognos AnalyticsMicrosoft Dynamics SL
    Likelihood to Recommend
    IBM
    For Transaction monitoring, we build reports for executive management, providing insights into the number of alerts, the types or categories of detection scenarios, the risk profile, and a snapshot of high- or urgent-priority cases to be reported to AUSTRAC. Congos helps to build the report by ingesting alert data exported from SAS datasets. It joins with other data from Teradata and Customer Hub (Oracle).
    Incentivized
    Read full review
    Microsoft
    For a small to mid-size business, MS Dynamics SL is effective. We are capable of managing our finances with a very low risk of error. We have worked with MS Dynamics for almost 15 years and have more than doubled the size of our business in that time with very few issues from the program. We have exponentially increased our revenue and reporting demands and have found SL to be very dependable and stable. The program does have the occasional glitch and those are sometimes outside of the realm of expertise of our IT department. SL support is excellent, but their timeliness is not as urgent as ours.
    Incentivized
    Read full review
    Pros
    IBM
    • Enterprise reporting - Create, customise, and run reports on sales trends, consumer sentiment, etc.
    • Dashboard creation and data exploration & analysis - Using drag and drop feature to create ad-hoc visualisation. Additionally, using AI powered natural language query feature for data analysis and dashboard input (formation of pie, bar, line charts). It's useful for no-technical person to put queries around the spreadsheet data to get quick answers.
    • Building insights for accurate decision making - Package reports with data backed insights for stakeholders in pdf, and Excel format to support business ad-hoc cases, forecasting and strategic recommendations on relevant asks.
    Incentivized
    Read full review
    Microsoft
    • Provides flexibility for complex project based cost accounting
    • Strong and flexible allocation processer for cost allocations, markups, and pricing
    • A "Flexible Billing" module under the project controller series that allows for multiple billing formats ranging from fixed price schedule of values, T&M or Cost Plus, and scheduled billing.
    • Flexible reporting with options using Crystal Reports, SSRS, a Quick Query tool, and ability to tie into MS Office tools such as MS Access and MS Excel
    • Tight integration with Financials, but also the ability to integrate with modules such as Sales Order, Inventory, and Field Service
    • Customization abilities ranging from a VBA (visual basic for application) foundation to allow customizing existing forms to the ability to use the SDK (Software Development Kit) to build more complex customizations that integrate with Dynamics SL.
    Incentivized
    Read full review
    Cons
    IBM
    • IBM Cognos Analytics enables customer data segmentation, which is essential for marketing, improving and streamlining purchasing behavior and preferences. This helps companies create more targeted and effective marketing campaigns.
    • Our clients Through data analysis, we can identify and observe trends in the behavior of other clients, allowing us to anticipate needs and adjust strategies to avoid consequences.
    Incentivized
    Read full review
    Microsoft
    • Reporting in the Project module is lacking functionality. I understand that most companies have specific needs when it comes to tracking project information but the standard reports are not good.
    • I would recommend a product like Management Reporter that is for Projects only. Project Reporter should allow users to pull in all Project related data into reports.
    • Fixing suspended batches. Obviously all of us users have experienced this mess. SL knows what needs to be corrected and there could be some step by step fixes in a separate repair module to do the steps we do in Query Analyzer.
    Incentivized
    Read full review
    Likelihood to Renew
    IBM
    For an existing solution, renewing licenses does provide a good return on investment. Additionally, while rolling out scorecards and dashboards with little adhoc capabilities, to end users, cognos is very easily scalable. It also allows to create a solution that has a mix of OLAP and relational data-sources, which is a limitation with other tools. Synchronizing with existing security setup is easy too.
    Read full review
    Microsoft
    Unfortunately, Dynamics' lack of ability to smoothly integrate with our CRM system is causing us to look at other solutions. The efficiencies that we gain by using Dynamics for our day to day accounting are lost in the constant headaches of getting sales quotes to import properly into the system for invoicing. Another major issue for us has been budgeting and reporting. We currently do all of our budgeting and board reporting in Excel, which is too time consuming and inefficient, especially when a system as robust as Dynamics should easily be able to handle this relatively simple task.
    Incentivized
    Read full review
    Usability
    IBM
    We have a strong user base (3500 users) that are highly utilizing this tool. Basic users are able to consume content within the applied security model. We have a set of advanced users that really push the limits of Cognos with Report and Query Studio. These users have created a lot of personal content and stored it in 'My Reports'. Users enjoy this flexibility.
    Read full review
    Microsoft
    I rate it a 10 because we have removed the fields we don't need so users can really crank the data into the system. The software was designed for the professional services firm in mind but does a tremendous job for construction firms and "blended" companies that are both distribution firms but project centric as well. Perhaps they drop ship inventory to a project where their employees or subs need to work on a project for example.
    Incentivized
    Read full review
    Reliability and Availability
    IBM
    Reports can typically be viewed through any browser that can access the server, so the availability is ultimately up to what the company utilizing it is comfortable with allowing, though report development tends to be more picky about browsers and settings as mentioned above. It also has an optional iPad app and general mobile browsing support, but dashboards lack the mobile compatibility. What keeps it from getting a higher score is the desktop tools that are vital to the development process. The compatibility with only Windows when the server has a wide range of compatibility can be a real sore point for a company that outfits its employees exclusively with Mac or Linux machines. Of course, if they are planning on outsourcing the development anyways, it's a rather moot point
    Read full review
    Microsoft
    We have had only one unplanned outage for 2 hours in the last 30 months. We shut down for 30 min to 1 hour once a month, but that is for Microsoft OS updates to the servers. Being a 24/7 world wide operation, the reliability is really important. We do get an 8 hour window on the weekend that we can be down for a short period to install Microsoft Dynamics SL updates, but we do not have many of those. On our last version upgrade, we shut the users out at 9:30 am and were fully operational in less than 6 hours. The upgrade was New SQL server, New SL server and 2 new Citrix servers.
    Incentivized
    Read full review
    Performance
    IBM
    Overall no major complaints but it doesn't handle DMR (Dimensionally Modeled for Relational) very well. DMR modelling is a capability that IBM Cognos Framework Manager provides allowing you to specify dimensional information for relational metadata and allows for OLAP-style queries. However, the capability is not very efficient and, for example, if I'm using only 2 columns on a 20-column model, the software is not smart enough to exclude 18 columns and the query side gets progressively larger and larger until it's effectively unusable.
    Read full review
    Microsoft
    No answers on this topic
    Support Rating
    IBM
    Why is their web application not working as fast as you think it should? They never know, and it is always a a bunch of shots in the dark to find out. Trying to download software from them is like trying to find a book at the library before computers were invented.
    Incentivized
    Read full review
    Microsoft
    Support is only used when needed, so unfortunately ,they get all the odd issues. It's a difficult business, but Microsoft and our firm do a great job of meeting customer needs. We get routine feedback that our support services are very good.
    Incentivized
    Read full review
    In-Person Training
    IBM
    Onsite training provided by IBM Cognos was effective and as expected. They did not perform training with our data which was a bit difficult for our end-users.
    Read full review
    Microsoft
    No answers on this topic
    Online Training
    IBM
    The online courses they offer are thorough and presented in such a way that someone who isn't already familiar with the general design methodologies used in this field will be capable of making a good design. The training environments are provided as a fully self contained virtual machine with everything needed already to create the environments. We've had some persisting issues with the environments becoming unavailable, but support has been responsive when these issues arise and straightening them out for us
    Read full review
    Microsoft
    No answers on this topic
    Implementation Rating
    IBM
    Make sure that any custom tables that you have, are built into your metadata packages. You can still access them via SQL queries in Cognos, but it is much easier to have them as a part of the available metadata packages.
    Read full review
    Microsoft
    Just to let it take its course. The implementation for me once I became a part of my former organization was pretty seamless. Just get to know the basics and call the support team to ask questions if you need help on an issue, should they arise. They are ready, willing, and able to help!
    Incentivized
    Read full review
    Alternatives Considered
    IBM
    Power BI is stronger for quick ad-hoc analysis and dashboards, but IBM Cognos Analytics is better when consistency, precision, and mass distribution matter. Tableau is best for interactive analysis, while IBM Cognos Analytics is better for standardized, repeatable enterprise reporting. Sigma shines for customizable dashboards and drill-down analysis while IBM Cognos Analytics holds an edge in data discovery and visualization.
    Incentivized
    Read full review
    Microsoft
    Of the comparable mid-range ERP systems, Dynamics SL competes at the lower end based on price, but also above the high-end based on flexibility, data, and reporting. Being able to stay with the same core accounting from a $100 million dollar company to a $3 billion dollar company shows the range of capabilities.
    Incentivized
    Read full review
    Scalability
    IBM
    We rate IBM Cognos Analytics a 9 out of 10 for overall scalability. The platform handles large numbers of users, reports, and analytical workloads very reliably. We have experienced strong performance even in demanding enterprise environments with substantial data volumes. Its architecture provides sufficient flexibility to scale resources according to demand, making it well suited for large, business-critical deployments.
    Incentivized
    Read full review
    Microsoft
    Since the backbone of the database is MS SQLServer, the database can be easily scaled.
    Incentivized
    Read full review
    Return on Investment
    IBM
    • The platform can be pretty pricey.
    • Convoluted contracts and they fine you for any breach during audits.
    • Things are changed between releases without any warning and break.
    • It is second to none at being able to customize list and crosstab type reports.
    • You can easily set up a report to be emailed out every day and even have it export the report to a shared folder.
    • On-prem environments can be scaled up pretty much as much as you would like.
    Incentivized
    Read full review
    Microsoft
    • More time is spent on manipulating reports which can and should be automated.
    • Lack of electronic invoicing process and other green technology features creates more cost on printing and storage costs.
    • The lack of a user friendly interface requires more training and a bigger learning curve for staff.
    Incentivized
    Read full review
    ScreenShots

    IBM Cognos Analytics Screenshots

    Product screenshotProduct screenshotProduct screenshotProduct screenshotProduct screenshotProduct screenshot