SAP Business Warehouse has now been integrated with HANA. So, earlier, the SAP Business Warehouse's working speed was slow. It would call for the data from the hard disk to the RAM and then RAM to the front end. 

But now, because of the HANA integration, the hard disk and RAM are together, and because of that, the output is very quick and very fast actually. So, within a fraction of a second, you will get the output when you hit the required query. So, the integration of HANA is very powerful right now.

Out-of-the-box reports are very useful. The product provides a seamless connection between the SAP operation system and the data warehouse. It also moves the data from the operating system to the data warehouse in a 3D format. The report generation is easy. It’s a drag-and-drop process.

People who want to do a project need not reinvent the wheel. Everything is designed, built, and delivered out of the box. All we have to do is interact with the customers to understand the kind of reports they need and check whether they are already available in the out-of-the-box report. If they are available, we just have to enable them and give the URLs to the customers. The Integration between the SAP operating system and data warehouse is excellent. The UI is good.

The most valuable feature of SAP Business Warehouse is its hybrid functionality, allowing users to leverage both SQL-based data warehouse capabilities from HANA and feature-based data warehousing from BW. This flexibility offers the best of both worlds, combining the power of SQL with the user-friendliness of BW for optimal performance based on specific requirements.

Having the integration with the reporting tool which is provided by SAP is great.

SAP Business Warehouse is one of the best data warehousing solutions that I've seen. I have hands-on on Azure and AWS, however, being an SAP Pro. 

The setup is pretty simple. 

What I like most about SAP Business Warehouse is that it's a seamless integration platform. A valuable feature in the tool is the monitoring alert that makes you aware of what process chain has failed. There's no manual monitoring required if you have configured an alert system, so the process chain can run in the background, and you can get alerts about it. The functionalities I find good in SAP Business Warehouse are alerting and monitoring. If you have configured the tool and have integrated it with SAP Solution Manager, then it's a good product to use.

Feature-wise, there are some hiccups with SAP Business Warehouse, especially its integration with various systems, including SAP and others. Populating data onto one screen does not happen in real time, which is one of the areas that our business is concerned about.

What I like most about SAP Business Warehouse is its ability to feed data into new, multiple systems in various formats. It can open its data to any system over gateway services or a portal or application that needs to consume and analyze data.

The most valuable feature of SAP Business Warehouse is transformation, where I extract data from different sources, particularly the raw data. Then I do some transformations and store that in a format that allows me to do reporting easily. The transformation feature in SAP Business Warehouse is the most useful.

I also like that the solution has some reporting features.

The most useful feature has been he ability to feed data into multiple systems in various formats. SAP BW can open its data to any kind of system over the gateway services including to portals or applications that need to consume and complete data analysis. 

The product is very stable. It has a straightforward maintenance process with essential support services.

The most valuable feature is the new version of Business Explorer Analyzer. That is a very good version because there are a lot of analytical features of Excel also. Additionally, in the SAP BW cockpit, there are features for real-time data acquisition, so RDA. That is a good feature.

The business warehouse solutions are not SAP solutions, which means that data is already connected to the IP network connectors making the configuration of the BW system quite simple. It's more simple than other solutions available on the market. I think it's the best quality of BW.

The real-time information is great. Many reports take a long time, and we can save the data if we have a backlog of information to assess. The Real-time InfoCube is quite useful in terms of getting information fast when we need it. 

The preparation is basically useful. We are using it via integrated BI, BWIP, Business Warehouse, and Integrated Planning. Based on that, we are able to get good information on plans. 

We can integrate analysis into our planning. 

It has good integration with the Analysis Office.

We're able to create different queries and get reports based on what we specifically need. 

BW is our bread and butter. We use it every day for reporting, for analysis, data consolidation and aggregation, drag and drop queries, etc.

The features that I have found most valuable are its capabilities to connect to Excel and to slice and dice. But the reporting is not that interactive because of its reliance to Tableau. We have something called Excel Analysis, which we connect to the cube and do the slice and dice - so that is the best part.

The other best part, and why we moved from Microsoft to SAP BW, are the ready-made connectors where we can extract the data from, which was something that was a challenge for us to pull in SQL Microsoft Warehouse. So the delta features and Excel features are some of its advantages, which we've found. And with SAP it was easier for us to directly get the data immediately, rather than purchasing licenses and all. So although we have an additional connector for SQL extraction for the data from SAP to SQL, that connector doesn't provide us the feature of extracting delta data.

All the reports were already depending on SAP data. But anything in which we needed to combine data to their applications we were trying to pull with Microsoft Data Warehouse to those different users.

We are currently in a basic stage of analytics and the first goal we have is to make sure the numbers are correct. BW has some features that help you to build factors and ETL in such a way that it's easy to get to correct responses. That's the number one condition that you have to have in an analytic solution.

The most useful feature is definitely the speed.

I think it's natural that we have BW on HANA because the developer has SAP systems. At the end of the day, it provides the integration we need out of the box. You don't have to reinvent the wheel.

The fact that it can integrate with Microsoft Excel is the solution's most valuable feature.

The solution has functionality that makes it easy for end-users to readily extract data directly from Business Warehouse into Excel and carry on their analysis on their own.

Note: My opinion here is NOT specifically focused on SAP BW. It is based on overall experience I have on SAP software. As we know BW user always involve in different SAP modules for data extraction, transformation and load process for analytical reports. From this I have learned so much on how SAP software is being used in my organization and hopping that it's worth sharing with thers.

Some of the most valuable features are:

SAP ECC Finance – AP module

• Payroll and Procurement
• Human Capital – Organizational Management
• PA and Benefits
• BW/BO – SAP Webi

Finance and Human Capital modules are the core departments that support the overall organization and we run SAP ECC system in this area.

HR module – Starting from the process of hiring the employees and their benefits, all of this happens within the SAP system.

FI module – All the budgeting, fund management and payroll functions take place in the SAP Finance module.

SRM – The procurement process such as to create a purchase order for schools and departments, also takes place in this system.

I like that it integrates to open-source.

The most valuable aspect of the solution is the integration with SAP ERP.

The initial setup is very easy.

The solution scales well.

The stability is good.

The most valuable feature of this solution is the advanced structuring of data capabilities. You can get different structures of data to suit your needs.

Getting high volume data is most valuable for us. It is really fast and it has great integration with SAP ERP or a non-sap system.

The warehouse is the solution's most valuable feature.