Prophix vs. SAP Business Warehouse

Overview
ProductRatingMost Used ByProduct SummaryStarting Price
Prophix
Score 8.0 out of 10
Enterprise companies (1,001+ employees)
Prophix One, a Financial Performance Platform, is used to improve the speed and accuracy of decision-making within a harmonized user experience. To reduce complexity and uncertainty, the software offers automated insights and planning, budgeting, forecasting, reporting, and consolidation functionalities.N/A
SAP BW
Score 8.1 out of 10
N/A
SAP Business Warehouse, or SAP BW (formerly SAP NetWeaver Business Warehouse) is SAP's legacy data warehouse solution, now superseded by SAP BW/4HANA, and the SAP Data Warehouse Cloud which was launched in 2019. SAP BW versions up to 7.4 have reached end of maintenance. SAP BW 7.5 support is extended to align with SAP Business Suite with NetWeaver components. For existing customers maintenance is scheduled to continue through 2027, with extended support available through 2030.N/A
Pricing
ProphixSAP Business Warehouse
Editions & Modules
No answers on this topic
No answers on this topic
Offerings
Pricing Offerings
ProphixSAP BW
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
ProphixSAP Business Warehouse
Considered Both Products
Prophix
Chose Prophix
Prophix is much more user-friendly, significantly cheaper, and has better looking reports. It had the Cloud-based platform, has opportunities for training, and the consultants are very knowledgeable.
SAP BW

No answer on this topic

Features
ProphixSAP Business Warehouse
BI Standard Reporting
Comparison of BI Standard Reporting features of Product A and Product B
Prophix
6.0
25 Ratings
23% below category average
SAP Business Warehouse
-
Ratings
Pixel Perfect reports5.28 Ratings00 Ratings
Customizable dashboards6.324 Ratings00 Ratings
Report Formatting Templates6.624 Ratings00 Ratings
Ad-hoc Reporting
Comparison of Ad-hoc Reporting features of Product A and Product B
Prophix
9.4
117 Ratings
16% above category average
SAP Business Warehouse
-
Ratings
Drill-down analysis9.8116 Ratings00 Ratings
Formatting capabilities8.8112 Ratings00 Ratings
Report sharing and collaboration9.7110 Ratings00 Ratings
Report Output and Scheduling
Comparison of Report Output and Scheduling features of Product A and Product B
Prophix
9.1
106 Ratings
11% above category average
SAP Business Warehouse
-
Ratings
Publish to PDF9.8101 Ratings00 Ratings
Report Versioning7.979 Ratings00 Ratings
Report Delivery Scheduling9.893 Ratings00 Ratings
Data Discovery and Visualization
Comparison of Data Discovery and Visualization features of Product A and Product B
Prophix
8.5
47 Ratings
10% above category average
SAP Business Warehouse
-
Ratings
Predictive Analytics8.547 Ratings00 Ratings
Access Control and Security
Comparison of Access Control and Security features of Product A and Product B
Prophix
9.5
112 Ratings
11% above category average
SAP Business Warehouse
8.7
4 Ratings
1% below category average
Multi-User Support (named login)9.8109 Ratings8.14 Ratings
Role-Based Security Model9.8108 Ratings00 Ratings
Multiple Access Permission Levels (Create, Read, Delete)9.8112 Ratings9.44 Ratings
Report-Level Access Control8.553 Ratings00 Ratings
Single Sign-On (SSO)00 Ratings9.24 Ratings
Location-Based Data Governance00 Ratings7.94 Ratings
Mobile Capabilities
Comparison of Mobile Capabilities features of Product A and Product B
Prophix
9.5
59 Ratings
22% above category average
SAP Business Warehouse
-
Ratings
Responsive Design for Web Access9.559 Ratings00 Ratings
Budgeting, Planning, and Forecasting
Comparison of Budgeting, Planning, and Forecasting features of Product A and Product B
Prophix
9.6
215 Ratings
16% above category average
SAP Business Warehouse
-
Ratings
Long-term financial planning9.8181 Ratings00 Ratings
Financial budgeting9.8210 Ratings00 Ratings
Forecasting9.4202 Ratings00 Ratings
Scenario modeling9.4166 Ratings00 Ratings
Management reporting9.8205 Ratings00 Ratings
Consolidation and Close
Comparison of Consolidation and Close features of Product A and Product B
Prophix
8.5
173 Ratings
7% above category average
SAP Business Warehouse
-
Ratings
Financial data consolidation9.7139 Ratings00 Ratings
Journal entries and reports9.785 Ratings00 Ratings
Multi-currency management7.070 Ratings00 Ratings
Intercompany Eliminations7.384 Ratings00 Ratings
Minority Ownership7.035 Ratings00 Ratings
Local and consolidated reporting9.8122 Ratings00 Ratings
Detailed Audit Trails8.8104 Ratings00 Ratings
Financial Reporting and Compliance
Comparison of Financial Reporting and Compliance features of Product A and Product B
Prophix
8.8
204 Ratings
9% above category average
SAP Business Warehouse
-
Ratings
Financial Statement Reporting9.8186 Ratings00 Ratings
Management Reporting9.8197 Ratings00 Ratings
Excel-based Reporting9.0180 Ratings00 Ratings
Automated board and financial reporting9.8157 Ratings00 Ratings
XBRL support for regulatory filing5.710 Ratings00 Ratings
Analytics and Reporting
Comparison of Analytics and Reporting features of Product A and Product B
Prophix
8.9
181 Ratings
10% above category average
SAP Business Warehouse
-
Ratings
Personalized dashboards8.8168 Ratings00 Ratings
Color-coded scorecards8.8123 Ratings00 Ratings
KPIs8.6134 Ratings00 Ratings
Cost and profitability analysis9.5132 Ratings00 Ratings
Key Performance Indicator setting8.8108 Ratings00 Ratings
Benchmarking with external data8.773 Ratings00 Ratings
Integration
Comparison of Integration features of Product A and Product B
Prophix
9.7
201 Ratings
16% above category average
SAP Business Warehouse
-
Ratings
Flat file integration9.8162 Ratings00 Ratings
Excel data integration9.8177 Ratings00 Ratings
Direct links to 3rd-party data sources9.6153 Ratings00 Ratings
Data Modeling
Comparison of Data Modeling features of Product A and Product B
Prophix
-
Ratings
SAP Business Warehouse
8.8
3 Ratings
11% above category average
Data model creation00 Ratings8.83 Ratings
Data Exploration
Comparison of Data Exploration features of Product A and Product B
Prophix
-
Ratings
SAP Business Warehouse
4.7
4 Ratings
7% below category average
Visualization00 Ratings4.74 Ratings
Data Warehouse
Comparison of Data Warehouse features of Product A and Product B
Prophix
-
Ratings
SAP Business Warehouse
7.9
4 Ratings
2% above category average
High-Volume Data Processing00 Ratings8.04 Ratings
Data Warehouse Management00 Ratings8.54 Ratings
Administrative Automation00 Ratings7.84 Ratings
Self-Optimization00 Ratings7.54 Ratings
Best Alternatives
ProphixSAP Business Warehouse
Small Businesses

No answers on this topic

Google BigQuery
Google BigQuery
Score 8.7 out of 10
Medium-sized Companies
Centage
Centage
Score 9.5 out of 10
Cloudera Enterprise Data Hub
Cloudera Enterprise Data Hub
Score 9.0 out of 10
Enterprises
OneStream
OneStream
Score 8.9 out of 10
Oracle Exadata
Oracle Exadata
Score 9.9 out of 10
All AlternativesView all alternativesView all alternatives
User Ratings
ProphixSAP Business Warehouse
Likelihood to Recommend
9.0
(234 ratings)
7.6
(15 ratings)
Likelihood to Renew
10.0
(16 ratings)
-
(0 ratings)
Usability
7.7
(49 ratings)
9.0
(1 ratings)
Availability
9.8
(29 ratings)
-
(0 ratings)
Performance
7.9
(28 ratings)
-
(0 ratings)
Support Rating
8.2
(121 ratings)
-
(0 ratings)
In-Person Training
8.2
(10 ratings)
-
(0 ratings)
Online Training
9.0
(12 ratings)
-
(0 ratings)
Implementation Rating
9.0
(19 ratings)
-
(0 ratings)
Configurability
9.0
(11 ratings)
-
(0 ratings)
Ease of integration
8.9
(29 ratings)
-
(0 ratings)
Product Scalability
8.8
(26 ratings)
-
(0 ratings)
Vendor post-sale
8.5
(23 ratings)
-
(0 ratings)
Vendor pre-sale
7.6
(21 ratings)
-
(0 ratings)
User Testimonials
ProphixSAP Business Warehouse
Likelihood to Recommend
Prophix Software
If the budgeting is done with Excel spreadsheets, and your company is small to medium in size, Prophix is the system for you! Additionally, if your company is also doing monthly forecasting in Excel, Prophix will save you time and reduce errors. There are also many other worthwhile features, such as Account Reconciliation and consolidations.
Read full review
SAP
SAP BW is best for: 1. Large enterprises 2. Enterprises with 3+ legacy systems with entrenched users (politically difficult to merge) 3. Enterprises with employees who can understand both the technical capabilities of SAP BW and the needs of the business users - ability to speak both languages, otherwise the program could be unwieldy and potentially underutilized (it's not particularly inexpensive) SAP BW is less appropriate for: 1. Small enterprises 2. Enterprises who have well established, same location, CRM and UFS - the integration of data analysis will be easier and less expensive with other solutions 3. HANA
Read full review
Pros
Prophix Software
  • Reporting - single report that can be opened by multiple users, each will see only aspect specific to them based on their security access.
  • Budgeting - workflow driven budget data collection, visibility of its current status, ability to take action to ensure timely completion. Ability to snapshot budget data at a point in time. Ability to perform what-if scenarios.
  • Forecasting - as above with added benefit of either reusing budget level of grain or forecasting at high level.
  • Granular planning - ability to create unlimited number of subsidiary models to assist with the planning process. Non-financial data collected during budget/forecast process help with operation planning and variance analysis.
Read full review
SAP
  • It tracks bin locations for parts which can be really helpful.
  • SAP Business Warehouse tells you who has a part checked out so you can find it.
  • It shows current parts shortages so buyers are flagged to get parts on order based on current demand.
Read full review
Cons
Prophix Software
  • Prophix could improve on its dashboarding capability - it is very basic and we always present our graphs/visuals in Excel.
  • We would love it if Prophix could improve its line item detail reports. They are not great right after downloading and require a lot of manipulation in Excel.
  • It would be awesome if we could fully integrate our invoicing software with Prophix. This would allow us to view invoices within Prophix rather than having to go into another tool.
Read full review
SAP
  • Age of software is showing as it struggles with very large data modules, which were not as prevalent in its early years
  • Querying performance at times can be very slow
  • Support and development for BEx has been discontinued or hard to find.
Read full review
Likelihood to Renew
Prophix Software
The system works well for us, and meets all of our needs. All of our future plans can and will be achieved within Prophix, so there is no need to pursue another product. Prophix has continuously proven to improve their product over the years, which provides an even higher level of confidence in this tool, and future developments
Read full review
SAP
No answers on this topic
Usability
Prophix Software
I have used other reporting software over the years and so far this has been the simplest to set up, the most flexible to use and we have not yet used Prophix to its full capacity. Over the next year or so I can see us extending our use of Prophix to include any number of other functions.
Read full review
SAP
It needs minimal trainings and can perform tasks of data management and reporting.
Read full review
Reliability and Availability
Prophix Software
The availability in Prophix is relatively good. We have occurred random outages in different versions that wipe out data, which can be brought back. Or we have ran into system wide slowness that impacts all users in the system, but we have been able to get more capacity to supply our performance.
Read full review
SAP
No answers on this topic
Performance
Prophix Software
Prophix has always performed consistently. We are using on-premise so many factors can contribute to slower than desired performance, most having nothing to do with Prophix itself. If we move to the web-client cloud based solution I believe performance will even be better.
Read full review
SAP
No answers on this topic
Support Rating
Prophix Software
The Prophix staff is very helpful and quick to respond. I like that they teach me instead of doing it for me when possible, so I don't have to contact them as often! Never talked to anyone at Prophix that I didn't respect or think highly of! Very professional, great customer service!
Read full review
SAP
No answers on this topic
In-Person Training
Prophix Software
We worked with a consultant provided by the vendor for implementation. Training involved online and in person. The in person training was done throughout the implementation. It was very hands on training. As we worked through sections of the set-up, we were training on how to use various features within the product. It made learning the system very easy.
Read full review
SAP
No answers on this topic
Online Training
Prophix Software
We used our system and created a test cube to work with our own data. We ran through the different functions of Prophix and covered alot of material. We did two sessions a week, with homework tasks assigned. We were able to ask questions and cover any questions during the followup sessions.
Read full review
SAP
No answers on this topic
Implementation Rating
Prophix Software
Prophix Consulting should bring, in house, chargeable expertise in Oracle EBS table access for Drill Across and provide reasonable limits on dimension member combinations so there are no unreasonable expectations about the application of multi dimensional cubes to detail, such as revenue by product and customer.
Read full review
SAP
No answers on this topic
Alternatives Considered
Prophix Software
We felt Prophix was much more flexible than Briq and offered a more solid financial reporting and budgeting package. Briq is more custom built solution-focused. They build solutions to fit your specific needs. The primary reason we went with Prophix is that we wanted something we could tweak and design on our own after the initial build-out of the solution.
Read full review
SAP
SAP Business Warehouse scores higher in data warehouse functionalities for integration to SAP ERP and other SAP solutions such as SAP CRM, SAP APO, and SAP SRM. Standard SAP data source extractors which are available in SAP ERP can be used immediately for full or delta replication into SAP Business Warehouse. System governance in SAP Business Warehouse is top-notch with change management support for migration between system landscape from the development system to production system.
Read full review
Scalability
Prophix Software
I gave Prophix a 10 on scalability because we currently deploy the solution to department heads across our entire organization and never have any issues with those individuals using or accessing the system to look at their financial information within premade templates . They currently enter budgets and review reports within the system currently. The only issue is they cannot typically use the ad hoc functionality because that would require higher level licenses that cost more and it is not worth it to give them more costly licenses since they really aren't working in the system quite like the robust finance users
Read full review
SAP
No answers on this topic
Return on Investment
Prophix Software
  • Prophix has made it possible to move away from some Excel reporting we were doing, which allows for 50% quicker reporting on a monthly basis.
  • Although it has saved us time, an improved PowerPoint feature that automatically updates our decks would save an additional 75% on top of what we already do.
  • Our Board Reporting has improved by 10 hours by moving our reports fully into Prophix.
Read full review
SAP
  • Positive - This tool report output is in Excel so it's a good tool if your users are familiar with Excel.
  • Positive: this tool has rich BI content so developing extractors for standard processes from SAP ECC can be done in minutes.
  • Negative: It lacks lot of features which are available in other newer tools today. For ex. - rich charts, rich filtering, exporting capabilities, user interface.
  • Negative: Its not a plug and play tool like Qlikview, Lumira, or Tableau. Even a single report development in this tool takes a lot of time compared to others.
Read full review
ScreenShots

Prophix Screenshots

Screenshot of Prophix One Portal: One single point of entry into Prophix One through its portal simplifies access and authentication but also allows seamless movement between applications.Screenshot of Chart Insights, one of the AI Insights capabilities that utilizes Artificial Intelligence and Natural Language Processing to provide enhanced business awareness.  Chart Insights extends the important details contained within dashboards, and analyzes the complete dataset behind the dashboard, automatically surfacing the data relationships not obvious in dashboard visualizations alone. It then provides a summary of key performance metrics found buried within Prophix charts.  It also summarizes the important insights in plain English.Screenshot of Prophix One Financial Planning & Analysis: Prophix's self-serve dashboards and visualizations are directly integrated with data, workflow tasks, announcements, and external URLs and databases. Dashboard Studio helps users to be informed and make better business decisions.Screenshot of Detailed interactive charts and graphs that Prophix offers to uncover insights. Prophix’s visual analytics are linked directly to data with transaction details.  There is no need to input the numbers.  Prophix does this tedious work, automatically.Screenshot of Prophix’s Workflow Manager, used to assign tasks to users and facilitate approvals across the business.  Stakeholder input can be captured directly with the ability to add comments and notes in a single unified database.Screenshot of Cell Comments, that allow users to add supporting details like notes and attachments to data.  Since comments are stored with the data, they can be viewed in any template along with their trailing history. Cell Comment Reports can also be generated to show all comments from any data view in one convenient report.