- This is the Brightwork Research & Analysis software rating series.
- We rate both the software and estimate the risk of implementing each application.
MUFI Rating & Risk for SAP BI/BW
MUFI: Maintainability, Usability, Functionality, Implement ability
Vendor: SAP (Select For Vendor Profile)
SAP BI/BW is the only BI solution that SAP owns that was developed by SAP, and it is easily the worst BI solution that SAP has in its stable. The problems with BI were a significant motivator for the purchase of Business Objects, which was beating BI in too many head to head proposals. The idea was that Business Objects – particular, its data modeling functionality would be ported to BI, but this never occurred.
The term “best in class” is often thrown around, however what about the term worst in class? We ask because SAP BI/BW meets the definition of a “worst in class” application. Among the areas that we measure, SAP BI/BW is last in all of them, and we question BI/BW’s ability to exist as a product independent. In BI/BW, there is no bright light to be found. The user interface is inferior; the engineering of the data cubes and overall backend is the worst that we have ever seen (unfortunately, this same solution is replicated in the SAP APO DP product). At every customer that we evaluate, SAP BI/BW, as well as SAP APO DP, can do the least of any of the applications in its category. Both have the highest TCO in their respective software categories. Companies that use BI have bad reports and companies that use DP have high forecast error. However, because the significant consulting companies can bill for their SAP DP and SAP BI/BW resources, and do not have resources trained on more efficient applications, they continue to be recommended to clients.
If you are a buyer that had a major consulting company recommend SAP BI/BW or DP to you, and you have observed the lack of productivity in these applications, you now know why these products were recommended to you. It had absolutely nothing to do with the quality of these applications. BI/BW has atrocious report development productivity. This means that BI/BW reports are universally late; companies that purchase BI/BW are not able to meet their reporting needs. We have occasionally heard BI/BW referee to as a Roach Motel for reporting requirements. That is “requirements go in, but reports don’t come out.”
The entire slow motion and problematic BI and DP product is what happens when a company like SAP, that had no previous experience in advanced data structures creates products in a software category and uses its marketing muscle and partnerships with influencers like consulting companies and IT analysts to present the notion that SAP has competitive applications in these categories.
The Poor Product Productivity of SAP BI/BW (and the related product SAP DP)
Buyer after buyer complains to us about reports that are late or never appear, and this should not be surprising to anyone when we use SAP DP (which uses the same data backend as SAP BI), things that take us days to do, take hours in other applications. The application Demand Works Smoothie has a very efficient approach to building relationships versus SAP DP (Demand Works is profiled in our section in our Software Selection Package for Demand Planning). When we were testing the application, we at first thought Demand Works had developed some new database technology. However, it uses a star schema the same as SAP DP (and the same as BI/BW), yet how Demand Works configured the star schema made the application almost maintenance-free. At the same time, SAP BI/BW makes setting up data structures too similar to a root canal. SAP BI/BW is the prototypical application that comes with a lot of bells and whistles (and is now being promoted to run on “HANA” – an in-memory database technology).
However, HANA will still not address the productivity problems with the application. Other vendors such as Teradata have been using solid-state drives (SSDs) combined with hard drives to improve performance for some time; they don’t make a big marketing push related to offering upgraded hardware to their clients. (SAP proponents would argue that HANA is much more than SSDs, and it is, but because SAP is so grandiose regarding HANA and so much of their statements regarding what HANA includes – it’s a lengthy conversation as to what HANA is, and many of SAP’s comments relating to HANA are also not reliable.) In fact, SAP’s constant harping on HANA is a distraction, as it is intended to be by SAP sales. The sap is attempting to distract customers from looking at the reality of SAP’s dated, expensive and inefficient applications by adding the marketing zest of a further technology promise in the embodied in HANA so that buyers will not notice that its’ previous technology predictions and guarantees have not worked out.
Naturally, buyers can choose any other BI application other than SAP BI/BW and be sure of making a better decision than selecting SAP BI/BW. SAP BI/BW does not even make sense for companies that already own a large number of other SAP applications. Getting a few limited adapters will not make up for purchasing the worst BI/BW application currently sold.
All scores out of a possible 10.
- Ma. = Maintainability
- Us. = Usability
- Fu. = Functionality
- Im. = Implementability
|Average Score for Big ERP||5.1||4.8||5.2||5.4||Big ERP|
|Average Score for CRM||6.2||6.2||5.1||5.9||CRM|
|Average Score for Small and Medium ERP||8.3||8||6.7||8.5||Small and Medium ERP|
|Average Score for Finance||8.8||8.8||8||8.8||Finance|
|Average Score for Demand Planning||7.6||7.2||7||7.1||Demand Planning|
|Average Score for Supply Planning||6.7||6.9||7||6.8||Supply Planning|
|Average Score for Production Planning||6.8||6.9||7||6.9||Production Planning|
|Average Score for BI Heavy||5.5||5.3||6.9||5.3||BI Heavy|
|Average Score for PLM||7||7.2||6.8||7.3||PLM|
|Average Score for BI Light||7.7||8.7||9||8.3||BI Light|
|Arena Solutions Arena PLM||10||10||10||10||PLM|
|AspenTech AspenOne||4||8||10||7||Production Planning|
|ERPNext||10||10||7.5||10||Small and Medium ERP|
|Delfoi Planner||8||6||6.5||7||Production Planning|
|Demand Works Smoothie SP||9||10||7||10||Supply Planning|
|Hamilton Grant RM||10||9||8.5||9||PLM|
|IBM Cognos||2.7||3||1.5||3||BI Heavy|
|Infor Lawson||8||7||6||7||Big ERP|
|Intuit QuickBooks Enterprise Solutions||9||9||5||9||Finance|
|JDA DM||9||7.5||8||8||Demand Planning|
|Microsoft Dynamics CRM||2||3||2||2||CRM|
|Netsuite OneWorld||7||7||8||8||Big ERP|
|Oracle BI||4||4||3||6||BI Heavy|
|Oracle CRM On Demand||4||5||3||5||CRM|
|Oracle Demantra||5||3||3.5||4.5||Demand Planning|
|Oracle JD Edwards World||4||1||3||6||Big ERP|
|PlanetTogether Galaxy APS||10||10||10||10||Production Planning|
|QlikTech QlikView||9||9||10||9||BI Light|
|Rootstock||9||8||9||9||Small and Medium ERP|
|Sage X3||8||8||7||8||Big ERP|
|SAP APO DP||3||4||3||2||Demand Planning|
|SAP APO PP/DS||2||2||4||3||Production Planning|
|SAP APO SNP||3||4||8||4||Supply Planning|
|SAP BI/BW||1.5||2||4||2||BI Heavy|
|SAP Business Objects||3||2.5||7||3||BI Heavy|
|SAP ECC||3||3||6.5||3||Big ERP|
|SAP SmartOps||4||4||7||5.5||Supply Planning|
|SAS BI||6.5||7||9||6||BI Heavy|
|SAS Demand Driven Forecasting||7||8||9||7||Demand Planning|
|Tableau (BI)||9||10||10||10||BI Light|
|Tableau (Forecasting)||10||8||5||9||Demand Planning|
|ToolsGroup SO99 (Forecasting)||7||8||9||7||Demand Planning|
|ToolsGroup SO99 (Supply)||5||6||10||7||Supply Planning|
Vendor and Application Risk
SAP BI/BW implementations are some of the toughest in IT. The building of data structures is so antiquated and difficult that it will require gobs of time from some of the most expensive resources that work in business intelligence. Users will complain mightily regarding the reporting interface, and the project will have major user adoption issues. When report changes are requested, they will take a very long period. The project team will have to constantly fight the business users to migrate them away from whatever personal or parochial data tools/reports that they rely upon to redirect them back to SAP BI/BW so that the buyer can get some financial payback on SAP BI/BW.
Likelihood of Implementation Success
This accounts for both the application and the vendor-specific risk. In our formula, the total implementation risk is application + vendor + buyer risk. The buyer specific risk could increase or decrease this overall likelihood and adjust the values that you see below.
Likelihood of Application Implementation Success and Failure
Search for the application in this table using the search bar in the upper right of the table.
|Application||Prob of Implementation Success||Prob of Implementation Failure|
|SAP Crystal Reports||0.46||0.54|
|Microsoft Dynamics CRM||0.26||0.74|
|Oracle RightNow CRM||0.41||0.59|
|Oracle CRM On Demand||0.36||0.64|
|SAP Business Objects||0.32||0.68|
|Hamilton Grant RM||0.89||0.11|
|PlanetTogether Galaxy APS||0.96||0.04|
|SAP APO PP/DS||0.27||0.73|
|Demand Works Smoothie SP||0.93||0.07|
|ToolsGroup SO99 (Supply)||0.82||0.18|
|Demand Works Smoothie||0.96||0.04|
|SAS Demand Driven Forecasting||0.82||0.18|
|ToolsGroup SO99 (Forecasting)||0.86||0.14|
|SAP APO DP||0.28||0.72|
|Intuit QB Enterprise||0.8||0.2|
|Microsoft Dynamics AX||0.4||0.6|
|SAP Business One||0.49||0.51|
|Oracle JD Edwards World||0.31||0.69|
|Oracle JD Edwards EnterpriseOne||0.36||0.64|
|SAP ERP ECC/R/3||0.32||0.68|
Risk Management Approach
SAP BI/BW has extraordinarily low productivity, and so reports should be kept to an absolute minimum. It is better to let the business users know how few reports they will get upfront rather than stringing them out, only to disappoint them. Unfortunately, none of this will be communicated by SAP or by their partners, the major consulting companies. BI/BW is known only to be able to deliver a minimum number of the promised reports at the company after company. We typically recommend hiring an independent consultant – and they can be found readily for SAP BI/BW. However, don’t expect objectivity from this consultant and they will tow the line proposed by SAP and the major consulting company, and a buyer will have a difficult time finding one that will tell them the truth.
Finished With Your Analysis?
Once complete, go to this link to see other analytical products for SAP BI/BW.