TrustRadius: an HG Insights company

IBM Planning Analytics vs. OpenText Magellan vs. SAS Viya

Save this comparison

Save this comparison

Add Product

Recommended Comparisons

    Overview
    ProductRatingMost Used ByProduct SummaryStarting Price

    IBM Planning Analytics

    Score8.5 out of 10
    N/AIBM Planning Analytics, powered by IBM TM1®, is an integrated planning solution designed to promote collaboration across the organization and help keep pace with the speed of modern business. With its calculation engine, this enterprise performance management solution is designed to help users move beyond the limits of spreadsheets, automating the planning process to drive faster, more accurate results. Use it to unify data sources into one single repository, enabling users to build…

    $825

    per month 5 users

    OpenText Magellan

    Score9 out of 10
    N/AOpenText Magellan Analytics Suite leverages a comprehensive set of data analytics software to identify patterns, relationships and trends through data visualizations and interactive dashboards.N/A

    SAS Viya

    Score10 out of 10
    N/AAn end-to-end platform for AI, data science, and analytics, used for modeling, as well as management and deployment of AI models.N/A
    Pricing
    IBM Planning AnalyticsOpenText MagellanSAS Viya
    Editions & Modules
    Essentials
    $825
    per month 5 users
    Standard
    $1,650
    per month 10 users
    No answers on this topic
    No answers on this topic
    Offerings
    Pricing Offerings
    IBM Planning AnalyticsOpenText MagellanSAS Viya
    Free Trial
    YesNoYes
    Free/Freemium Version
    YesNoNo
    Premium Consulting/Integration Services
    YesNoNo
    Entry-level Setup FeeOptionalNo setup feeNo setup fee
    Additional Details
    More Pricing Information
    Community Pulse
    IBM Planning AnalyticsOpenText MagellanSAS Viya
    Considered Multiple Products
    IBM
    No answer on this topic
    OpenText
    No answer on this topic
    SAS
    No answer on this topic
    Key User Insights
    Would buy again
    99%
    Would buy again
    128 Answers
    No answers on this topic
    No answers on this topic
    Delivers good value for the price
    97%
    Delivers good value for the price
    114 Answers
    No answers on this topic
    No answers on this topic
    Happy with the feature set
    97%
    Happy with the feature set
    125 Answers
    No answers on this topic
    No answers on this topic
    Lived up to sales and marketing promises
    97%
    Lived up to sales and marketing promises
    89 Answers
    No answers on this topic
    No answers on this topic
    Implementation went as expected
    93%
    Implementation went as expected
    104 Answers
    No answers on this topic
    No answers on this topic
    Features
    IBM Planning AnalyticsOpenText MagellanSAS Viya
    BI Standard Reporting
    Comparison of BI Standard Reporting features of IBM Planning Analytics and OpenText Magellan and SAS Viya
    Feature
    IBM Planning Analytics
    7.6
    116 Ratings
    1% above category average
    OpenText Magellan
    7.0
    2 Ratings
    15% below category average
    SAS Viya
    -
    Ratings
    Pixel Perfect reports7.6102 Ratings00 Ratings00 Ratings
    Customizable dashboards7.7116 Ratings7.02 Ratings00 Ratings
    Report Formatting Templates7.5109 Ratings7.01 Ratings00 Ratings
    Ad-hoc Reporting
    Comparison of Ad-hoc Reporting features of IBM Planning Analytics and OpenText Magellan and SAS Viya
    Feature
    IBM Planning Analytics
    8.0
    122 Ratings
    3% above category average
    OpenText Magellan
    8.3
    3 Ratings
    4% above category average
    SAS Viya
    -
    Ratings
    Drill-down analysis8.5119 Ratings8.03 Ratings00 Ratings
    Formatting capabilities7.9120 Ratings8.03 Ratings00 Ratings
    Integration with R or other statistical packages7.992 Ratings9.01 Ratings00 Ratings
    Report sharing and collaboration7.8118 Ratings8.02 Ratings00 Ratings
    Report Output and Scheduling
    Comparison of Report Output and Scheduling features of IBM Planning Analytics and OpenText Magellan and SAS Viya
    Feature
    IBM Planning Analytics
    8.1
    116 Ratings
    2% above category average
    OpenText Magellan
    8.3
    2 Ratings
    1% above category average
    SAS Viya
    -
    Ratings
    Publish to Web7.9109 Ratings8.02 Ratings00 Ratings
    Publish to PDF8.2109 Ratings8.02 Ratings00 Ratings
    Report Versioning8.3106 Ratings9.02 Ratings00 Ratings
    Report Delivery Scheduling8.298 Ratings8.02 Ratings00 Ratings
    Data Discovery and Visualization
    Comparison of Data Discovery and Visualization features of IBM Planning Analytics and OpenText Magellan and SAS Viya
    Feature
    IBM Planning Analytics
    7.5
    117 Ratings
    2% above category average
    OpenText Magellan
    8.0
    1 Ratings
    0% above category average
    SAS Viya
    -
    Ratings
    Pre-built visualization formats (heatmaps, scatter plots etc.)8.1117 Ratings9.01 Ratings00 Ratings
    Location Analytics / Geographic Visualization7.7109 Ratings00 Ratings00 Ratings
    Predictive Analytics7.8107 Ratings7.01 Ratings00 Ratings
    Pattern Recognition and Data Mining6.638 Ratings00 Ratings00 Ratings
    Access Control and Security
    Comparison of Access Control and Security features of IBM Planning Analytics and OpenText Magellan and SAS Viya
    Feature
    IBM Planning Analytics
    8.0
    122 Ratings
    5% below category average
    OpenText Magellan
    9.0
    2 Ratings
    6% above category average
    SAS Viya
    -
    Ratings
    Multi-User Support (named login)8.1120 Ratings00 Ratings00 Ratings
    Role-Based Security Model7.7121 Ratings9.02 Ratings00 Ratings
    Multiple Access Permission Levels (Create, Read, Delete)8.0122 Ratings9.02 Ratings00 Ratings
    Report-Level Access Control7.549 Ratings00 Ratings00 Ratings
    Single Sign-On (SSO)8.4114 Ratings9.02 Ratings00 Ratings
    Mobile Capabilities
    Comparison of Mobile Capabilities features of IBM Planning Analytics and OpenText Magellan and SAS Viya
    Feature
    IBM Planning Analytics
    7.6
    105 Ratings
    4% above category average
    OpenText Magellan
    7.0
    2 Ratings
    10% below category average
    SAS Viya
    -
    Ratings
    Responsive Design for Web Access7.7102 Ratings7.02 Ratings00 Ratings
    Mobile Application7.666 Ratings00 Ratings00 Ratings
    Dashboard / Report / Visualization Interactivity on Mobile6.676 Ratings7.02 Ratings00 Ratings
    Budgeting, Planning, and Forecasting
    Comparison of Budgeting, Planning, and Forecasting features of IBM Planning Analytics and OpenText Magellan and SAS Viya
    Feature
    IBM Planning Analytics
    8.4
    131 Ratings
    4% above category average
    OpenText Magellan
    -
    Ratings
    SAS Viya
    -
    Ratings
    Long-term financial planning8.0127 Ratings00 Ratings00 Ratings
    Financial budgeting8.4130 Ratings00 Ratings00 Ratings
    Forecasting8.7130 Ratings00 Ratings00 Ratings
    Scenario modeling8.6129 Ratings00 Ratings00 Ratings
    Management reporting8.6129 Ratings00 Ratings00 Ratings
    Consolidation and Close
    Comparison of Consolidation and Close features of IBM Planning Analytics and OpenText Magellan and SAS Viya
    Feature
    IBM Planning Analytics
    8.5
    122 Ratings
    9% above category average
    OpenText Magellan
    -
    Ratings
    SAS Viya
    -
    Ratings
    Financial data consolidation9.1118 Ratings00 Ratings00 Ratings
    Journal entries and reports9.2108 Ratings00 Ratings00 Ratings
    Multi-currency management8.5110 Ratings00 Ratings00 Ratings
    Intercompany Eliminations8.4107 Ratings00 Ratings00 Ratings
    Minority Ownership8.6101 Ratings00 Ratings00 Ratings
    Local and consolidated reporting7.8114 Ratings00 Ratings00 Ratings
    Detailed Audit Trails8.1115 Ratings00 Ratings00 Ratings
    Financial Reporting and Compliance
    Comparison of Financial Reporting and Compliance features of IBM Planning Analytics and OpenText Magellan and SAS Viya
    Feature
    IBM Planning Analytics
    8.8
    123 Ratings
    8% above category average
    OpenText Magellan
    -
    Ratings
    SAS Viya
    -
    Ratings
    Financial Statement Reporting8.2119 Ratings00 Ratings00 Ratings
    Management Reporting8.7120 Ratings00 Ratings00 Ratings
    Excel-based Reporting9.4122 Ratings00 Ratings00 Ratings
    Automated board and financial reporting9.1111 Ratings00 Ratings00 Ratings
    XBRL support for regulatory filing8.680 Ratings00 Ratings00 Ratings
    Analytics and Reporting
    Comparison of Analytics and Reporting features of IBM Planning Analytics and OpenText Magellan and SAS Viya
    Feature
    IBM Planning Analytics
    8.4
    125 Ratings
    11% above category average
    OpenText Magellan
    -
    Ratings
    SAS Viya
    -
    Ratings
    Personalized dashboards8.7124 Ratings00 Ratings00 Ratings
    Color-coded scorecards8.4119 Ratings00 Ratings00 Ratings
    KPIs8.1122 Ratings00 Ratings00 Ratings
    Cost and profitability analysis8.2120 Ratings00 Ratings00 Ratings
    Key Performance Indicator setting8.5119 Ratings00 Ratings00 Ratings
    Benchmarking with external data8.590 Ratings00 Ratings00 Ratings
    Integration
    Comparison of Integration features of IBM Planning Analytics and OpenText Magellan and SAS Viya
    Feature
    IBM Planning Analytics
    8.7
    123 Ratings
    7% above category average
    OpenText Magellan
    -
    Ratings
    SAS Viya
    -
    Ratings
    Flat file integration8.7120 Ratings00 Ratings00 Ratings
    Excel data integration9.0120 Ratings00 Ratings00 Ratings
    Direct links to 3rd-party data sources8.6112 Ratings00 Ratings00 Ratings
    Application Program Interfaces (APIs) / Embedding
    Comparison of Application Program Interfaces (APIs) / Embedding features of IBM Planning Analytics and OpenText Magellan and SAS Viya
    Feature
    IBM Planning Analytics
    -
    Ratings
    OpenText Magellan
    6.2
    1 Ratings
    22% below category average
    SAS Viya
    -
    Ratings
    REST API00 Ratings5.01 Ratings00 Ratings
    Javascript API00 Ratings9.01 Ratings00 Ratings
    Java API00 Ratings5.01 Ratings00 Ratings
    Themeable User Interface (UI)00 Ratings7.01 Ratings00 Ratings
    Customizable Platform (Open Source)00 Ratings5.01 Ratings00 Ratings
    Best Alternatives
    IBM Planning AnalyticsOpenText MagellanSAS Viya
    Small Businesses
    No answers on this topic
    Cyfe
    Score4 out of 10
    IBM SPSS Statistics
    Score8 out of 10
    Medium-sized Companies
    Centage
    Score9.4 out of 10
    Qlik Cloud Analytics (Qlik Sense)
    Score8.2 out of 10
    Alteryx Platform
    Score9 out of 10
    Enterprises
    Oracle Fusion Cloud Enterprise Performance Management
    Score7.2 out of 10
    Jaspersoft Community Edition
    Score7 out of 10
    Alteryx Platform
    Score9 out of 10
    All AlternativesView all alternativesView all alternativesView all alternatives
    User Ratings
    IBM Planning AnalyticsOpenText MagellanSAS Viya
    Likelihood to Recommend
    8.0
    (132 ratings)
    9.0
    (11 ratings)
    9.1
    (12 ratings)
    Likelihood to Renew
    9.1
    (5 ratings)
    3.9
    (9 ratings)
    4.5
    (5 ratings)
    Usability
    7.8
    (69 ratings)
    9.0
    (1 ratings)
    8.2
    (3 ratings)
    Availability
    -
    (0 ratings)
    -
    (0 ratings)
    10.0
    (1 ratings)
    Performance
    -
    (0 ratings)
    -
    (0 ratings)
    9.0
    (1 ratings)
    Support Rating
    7.3
    (93 ratings)
    9.0
    (2 ratings)
    10.0
    (3 ratings)
    In-Person Training
    -
    (0 ratings)
    -
    (0 ratings)
    9.0
    (1 ratings)
    Online Training
    -
    (0 ratings)
    -
    (0 ratings)
    8.0
    (1 ratings)
    Implementation Rating
    -
    (0 ratings)
    -
    (0 ratings)
    9.0
    (1 ratings)
    Configurability
    -
    (0 ratings)
    -
    (0 ratings)
    10.0
    (1 ratings)
    Data Sharing and Collaboration
    9.0
    (3 ratings)
    9.0
    (8 ratings)
    -
    (0 ratings)
    Data Sources
    9.0
    (3 ratings)
    8.0
    (8 ratings)
    -
    (0 ratings)
    Ease of integration
    -
    (0 ratings)
    -
    (0 ratings)
    8.0
    (1 ratings)
    Product Scalability
    9.1
    (1 ratings)
    -
    (0 ratings)
    9.0
    (1 ratings)
    Vendor post-sale
    -
    (0 ratings)
    -
    (0 ratings)
    10.0
    (1 ratings)
    Vendor pre-sale
    -
    (0 ratings)
    -
    (0 ratings)
    10.0
    (1 ratings)
    User Testimonials
    IBM Planning AnalyticsOpenText MagellanSAS Viya
    Likelihood to Recommend
    IBM
    Ideal for large organization with complex multi-dimensional data, large budgets and dedicated administrator support. The performance of the TM1 data base is unmatched. The PAW and PAX options providing planners to work in both Excel and workspace environment. Higher Implementation efforts due to the greenfield implementations. Visualization features are not up to the mark.
    Incentivized
    Read full review
    OpenText
    If you do not have a large budget and are a large organization, I would steer clear of Actuate. If you are looking to do very complex washboarding, I would not use them. Your developers have to be very skilled to work with this. Plan to bring in consultants if necessary to help your process. Adhoc reporting is weak. If your pricing is user based and you expand, this could be very expensive.
    Read full review
    SAS
    SAS Advance Analytics is well suited for data that is visual. Data where you want to see multiple graphs and models are good for this software. However, if your data is more descriptive this may not be the best program. SAS is well suited for data where you need to make comparisons on the feasibility of two different programs. Data that can be compared is perfect for this software.
    Incentivized
    Read full review
    Pros
    IBM
    • Handle very large data volumes.
    • Scale to a large number of users.
    • Not having to compromise on business complexity.
    • It can be run by business users.
    • Availability of highly qualified consultants to support businesses.
    • REST API allows for an open eco system and a variety of solutions to extend the product.
    • Vast integration possibilities.
    • AI-infused engine with IBM Watson.
    Incentivized
    Read full review
    OpenText
    • The report outputs can vary across different types such as HTML, PDF, and Excel
    • Their open source offering is very sufficient
    • There are great boards and blogs for developers and engineers to expand and use their features.
    • The people from the company that I've worked with are professional and courteous.
    Incentivized
    Read full review
    SAS
    • SAS is can be used as query builder tool which can automate a lot of excel process.
    • There are variety of statistical options available that tie up good visual analytics.
    • There are inbuilt models available for different operations which doesn't require any coding and are easy to run.
    Incentivized
    Read full review
    Cons
    IBM
    • sometimes it is hard to produce pixel perfect reports from the Web UI. I know it is not made for this, but still, it'll be great
    • getting in e.g. an Excel file just by drag and drop, and the AI should "understand" what the data is all around
    Incentivized
    Read full review
    OpenText
    • The documentation on all the available features, but most importantly on the scripting side, can be improved
    • The standard look & feel of some basic options, like parameter selection or sorting and filtering, looks dated and can't be customized
    • The server portal needs to provide better tools
    • More integration is needed with other OpenText products
    Incentivized
    Read full review
    SAS
    • SAS Analytics does not have very good graphic capabilities. Their advanced graphics packages are expensive, and still not very appealing or intuitive to customize.
    • SAS Analytics is not as up-to-date when it comes to advanced analytical techniques as R or other open-source analytics packages.
    Incentivized
    Read full review
    Likelihood to Renew
    IBM
    Since IBM Cognos Express is suitable only for medium data warehouse environment, we are not sure if this tool solves the long term need as the business keeps growing rapidly. So its a 50/50 ratio to renew Express license. But having said that, the components of IBM Cognos Express are also available in other Cognos BI suites like Cognos 10.x version. So we will probably upgrade our environment to IBM Cognos 10.x which comes with more new features.
    Read full review
    OpenText
    I am no longer working for the company that was using Actuate but I believe they would continue to use it because the stitching costs would be to high. It would require a complete rewrite of the reports and the never version of Actuate (BIRT) even required an almost complete report rewrite
    Incentivized
    Read full review
    SAS
    Not only does SAS become easier to use as the user gets more familiar with its capabilities, but the customer service is excellent. Any issues with SAS and their technical team is either contacting the user via email, chat, text, WebEx, or phone. They have power users that have years of experience with SAS there to help with any issue.
    Read full review
    Usability
    IBM
    IBM Planning Analytics is generally good in terms of functionalities. It can be used reduce time for budget planning, resource planning, demand forecasting, etc. The performance of IBM Planning Analytics is acceptable, but user interface can be improved. It would be good to see new features that allow users to customise the dashboard.
    Incentivized
    Read full review
    OpenText
    It is quite intuitive to use. It is fit specifically for doing sentiment, emotion, and intention analysis as well as text classification and text summarization. I would have given 10 if it is fit for the purpose of doing image processing and analysis as well. There is a huge market to analyze video and image data.
    Incentivized
    Read full review
    SAS
    If SAS Enterprise Guide is utilized any beginning user will be able to shorten the learning curve. This is allow the user a plethora of basic capabilities until they can utilize coding to expand their needs in manipulating and presenting data. SAS is also dedicated to expanding this environment so it is ever growing.
    Read full review
    Reliability and Availability
    IBM
    No answers on this topic
    OpenText
    No answers on this topic
    SAS
    SAS probably has the most market saturation out of all of the analytics software worldwide. They are in every industry and they are knowledgable about every industry. They are always available to take questions, solve issues, and discuss a company's needs. A company that buys SAS software has a dedicated representative that is there for all of their needs.
    Read full review
    Performance
    IBM
    No answers on this topic
    OpenText
    No answers on this topic
    SAS
    Although nothing is perfect, SAS is almost there. The software can handle billions of rows of data without a glitch and runs at a quick pace regardless of what the user wants to perform. SAS products are made to handle data so performance is of their utmost important. The software is created to run things as efficiently as SAS software can to maximize performance.
    Read full review
    Support Rating
    IBM
    IBM support has been very quick to respond and handle the very few issues we've had. We've had a third-party who partners with IBM to be our consulting team which has helped greatly reduce the need for us to contact IBM directly. I highly recommend researching and selecting a well-respected partner to help with an implementation as well as ongoing support as needed.
    Incentivized
    Read full review
    OpenText
    Always there on the front and backend for us and the client.
    Read full review
    SAS
    SAS is generally known for good support that's one of the main reasons to justify the cost of having SAS licenses within our organization is knowing that customer support is just a quick phone call away. I've usually had good experiences with the SAS customer support team it's one of the ways in which the company stands out in my view.
    Incentivized
    Read full review
    In-Person Training
    IBM
    No answers on this topic
    OpenText
    No answers on this topic
    SAS
    SAS has regional and national conferences that are dedicated to expanding users' knowledge of the software and showing them what changes and additions they are making to the software. There are user groups in most of the major cities that also provide multi-day seminars that focus on specific topics for education. If online training isn't the best way for the user, there is ample in-person training available.
    Read full review
    Online Training
    IBM
    No answers on this topic
    OpenText
    No answers on this topic
    SAS
    There are online videos, live classes, and resource material which makes training very easy to access. However, nothing is circumstantial so applying your training can get tricky if the user is performing complex tasks. When purchasing software, SAS will also allocate education credits so the user(s) can access classes and material online to help expand their knowledge.
    Read full review
    Implementation Rating
    IBM
    No answers on this topic
    OpenText
    No answers on this topic
    SAS
    Ask as many questions you can before the install to understand the process. Since a third party does the installation your company is sort of a passanger and it is easy to get lost in the process. It also helps to have all users and IT support involved in the install to help increase the knowledge as to how SAS runs and what it needs to perform correctly.
    Read full review
    Alternatives Considered
    IBM
    For strong technical teams and flexibility IBM Planning Analytics is the way to go. For quicker adoption and less technical teams Anaplan is the best option. If consolidation, financials, and moving from legacy tools are main focus than OneStream will be a really good choice. If deeply invested into SAP already than the SAP BPC will be the best fit to maintain the investment.
    Incentivized
    Read full review
    OpenText
    It is vastly superior to these in many ways, for complex reporting it is a much more sophisticated solution. Visualizations are very good. Javascript extensibility is very powerful, others don't support this or as well. Pentaho and MS are both OLAP oriented. Pentaho is moving more toward big data, which was not our primary focus. Others are stuck in the Crystal Reports Band metaphor.
    Read full review
    SAS
    SAS was the incumbent tool, and what the team knew. We did look into using Revolution Analytics enterprise version of R, but the learning curve on that caused us to stick with SAS. In my current position, I've opted for WPS over SAS. I can still leverage my SAS experience, but the price is about 15% of what SAS charges, with extra functionality, such as direct database access. I can supplement WPS with free software, such R for anything that it might be missing.
    Incentivized
    Read full review
    Scalability
    IBM
    No answers on this topic
    OpenText
    No answers on this topic
    SAS
    It all depends on the type of SAS product the user has. Scaleability differs from product to product, and if the user has SAS Office Analytics the scaleability is quite robust. This software will satisfy the majority of the company's analytic needs for years to come. In addition, if SAS is not meeting the users needs the company can easily find SAS solutions that will.
    Read full review
    Return on Investment
    IBM
    • Automate direct data connections to multiple data sources
    • One secured version of the the truth (for data and formulas)
    • Ability to scale to much more detailed planning with option to create predictive forecasts at detail
    • Business user friendly with powerful Excel integration
    • Very flexible and powerful modeling, can handle custom modeling needs at scale
    • Can make the same data available across finance and ops, but at the level of details and timeline that makes sense for them
    Incentivized
    Read full review
    OpenText
    • Actuate can handle 50 to 60 sub reports inside a report very well.
    • Dynamically creating the datasource, chart, graph, reports are the main advantages. We can do any level of drilling, and can create a performance matrix dashboard efficiently.
    Read full review
    SAS
    • SAS is pretty expensive, so a company would need to take that into consideration before purchasing a license.
    • A lot of companies are now starting to use SAS Advance Analytics, it is great for sharing data between departments.
    • Presentations come out better when using SAS, and estimates are more precise to the confidence interval.
    Incentivized
    Read full review
    ScreenShots

    IBM Planning Analytics Screenshots

    Screenshot of Workflow managementScreenshot of Income statementScreenshot of Margin analysisScreenshot of Metrics managementScreenshot of Income statementScreenshot of Expense analysis

    OpenText Magellan Screenshots

    Screenshot of A Magellan BI & Reporting dashboard that an individual can interact with and personalize to their needs, such as changing chart types or computations.Screenshot of Magellan Data Discovery provides a Smart User Interface, designed to equip new users and users seeking a more streamlined set of features for insightsScreenshot of Magellan Data Discovery provides an Advanced User Interface that allows data analytics pros to leverage its breadth of sophisticated capabilities for insightsScreenshot of Magellan Text Mining insights can be displayed within easy-to-use dashboards.Screenshot of Data scientists can create visualizations within the Magellan Notebook and see it dynamically update as they write changes to it.