SAP Business Warehouse could have been better. There is room for improvement from a technical perspective. So, from a technical perspective, when we are upgrading a Business Warehouse server or we are migrating from one place to another, the capability required for this upgradation has many manual activities. It took us around a month to streamline our server.

Let’s say there are some transaction codes. Transaction code is a set of programs, and when you want to run a program from the backend, you need to hit the transaction code. It is called a T-code. So during the upgrade, many transaction codes get affected, and as a security consultant, it is my responsibility to recheck those transaction codes which are affected. Sometimes more than 100 codes may get affected, sometimes 500, and sometimes more as well. So, it takes a hell lot of time to integrate them again. That is a limitation or defect within the SAP Business Warehouse.

SAP Business Warehouse should come up with proper solutions. Upgradation is an automatic activity. It should happen by itself. We just need to initiate it, and the backend SAP server is automatically upgraded. But it should handle the transactional code as well. They should not get absolutely, and any authorization object should not get deleted from the transaction codes. So, that functionality SAP Business Warehouse should come up with.

Over a period, we realized that the license and maintenance costs were quite expensive. Every day, we had to run the background job ODS. Eventually, we moved away from SAP Business Warehouse and bought a different tool. The job ran overnight. If I run the report at 5 PM on Friday, I won't get Friday’s data. I would get only the data of what was done up until Thursday. I get all the information quickly, but it is one day old. Though the responses are good, I cannot use them effectively for making decisions.

Areas for improvement in SAP Business Warehouse include enhancing scheduling and monitoring tools, as well as improving communication about hidden features to make them more accessible to users. Simplifying feature discovery could prevent clients from seeking alternative solutions unnecessarily.

Additionally, I would like to see the reintroduction of Business Explorer capabilities in SAP Business Warehouse. These features provided ad-hoc reporting capabilities that are currently missing in the latest versions. Having this functionality directly within BW would enhance reporting options for users.

The solution should be more open to the cloud. The only thing that's lacking is the cloud-centricity of it for Azure or any other cloud solution.

What I'd like improved in SAP Business Warehouse is its setup. It could be more flexible, and it could be a configuration-based setup.

Improving SAP Business Warehouse's user-friendliness and real-time capabilities would be beneficial. The improvement would enable users to make decisions and understand their current standing quickly. Also, if there are any issues or fallbacks, we can quickly correct them.

What I'd like to improve in SAP Business Warehouse is its data structure, that's a little bit rigid. It could be a bit more flexible, so you can design your data structure and improve performance when creating a solution. Currently, the way data is stored in SAP Business Warehouse is rigid.

SAP has released BW/4HANA, and the database has changed. Still, in the next release of SAP Business Warehouse, I'd like to see the capability to run big data solutions and integration with other databases, such as Hadoop, which is currently not there.

SAP Business Warehouse has a few areas for improvement. One is that it takes more work to get the data, including reporting on that data, because some coding is required, and a significant level of transformation is needed.

I also find the performance reporting function of SAP Business Warehouse challenging, so that's another area for improvement.

What I want to see in SAP Business Warehouse in the future is for it to be more user-friendly than Microsoft Power BI. I also found Microsoft Power BI more flexible and quicker to learn than SAP Business Warehouse. Making some developments on Microsoft Power BI also requires less effort and no technical expertise. In contrast, SAP Business Warehouse requires some technical expertise, so I want that improved in the future.

The way the data is stored is kind of rigid in SAP BW as a product. It could be more flexible so that when we are designing a solution, we can design our own data structures and try to improve performance. 

In a future release, we would like to have the capability of running big data solutions and integration with the other databases, like Hadoop.

They should reduce the product’s installation package size for easier downloading.

One area that could be improved is the Business Explorer still needs to be developer-friendly also.

Another improvement would be to develop certain connectors to get hold of the external data. That aspect also needs to be strengthened. It needs to be reinforced because there were issues when we were integrating the SAP BW system with a source system, which is other than the SAP R3 system. The dependency that is currently there between SAP R3 and SAP BW, needs to be enhanced, augmented.

In the next release, my suggestion would be to have user-friendly interfaces and performance issues be addressed.

On the existing release, I'm unsure about improvements. For sure the functionality is available in the new release. I don't know what competitors' systems of data warehousing provide. I would for sure like to see a different end solution in order to read the data and attract internal users. I'd like to see the flexibility to create reports. Having the back-end data set with the right information is the best qualification for this solution.

I'm considering migrating to the BW/4HANA solution because the language in terms of settings is very similar to the one I am currently using. We are starting to configure the BW old version solution so I don't need to invest in data analysis in order to understand the difference or to connect to a different data warehouse with this system.

Additional features that could be included would be for SAP to provide different layers of solutions. One for data warehousing, another for different end solutions on the data warehouse. 

I'm not sure if our issue is related to BW or the Analysis Office. However, we're having performance issues in terms of time. It takes a long time to generate the report. Maybe it's the queries that have been developed in-house. I'm not sure. 

People are getting frustrated as they have to spend lots of time - 10 minutes to 15 minutes - generating the report. Maybe they are getting real-time data. However, it is time-consuming in the generation of the report.

They should allow for power users. If SAP really wants to have some insights related to their software's applicability, adaptability, and some areas of let's say, future expansion or future new development, then they should think of taking the opinion of the actual end users.

They should offer up smaller components for smaller companies to make it more affordable and accessible for more companies.

There are a lot of things that could be improved especially in terms of data cleansing, data management, data lineage, etc. The solution needs to offer more flexibility in terms of formulas and the query designer. 

The solution has very limited options, so we have to mix and match some functionality formulas we create in Business Warehouse. The rest of the formulas and functionality we try to deliver on the front end via direct objects. Therefore, there's a lot of improvement needed. 

My understanding is that they are going to discontinue Business Warehouse so that they can push HANA, including Native HANA, S4 HANA, and BW/4HANA.

This platform has reached its limitation. In order for SAP to improve it, they have to provide a new product, which they have: BW/4HANA. 

BW/HANA is much better than the native standard Business Warehouse. It has new options, new functionality, is faster, has pre-built processes, etc. It has all the data processes from a different company's best practices, and they give it to you by default, just out of the box. This is what Business Warehouse should have been, and it's good they are pushing HANA instead of BW.

In terms of what can be improved, they already improved the features of SAP HANA, and since we are not migrated now, we are using SAP VPC and consolidation where they provide those VW's for HANA. Once we go there, we will be able to understand that differentiation point and what could be improved or could have been provided more. But as of right now we're in a very early stage so I don't see anything else that is required.

In the next release, I would like to see BW integrate the visualization with the reports which are in SAP HANA. If that gets into BW in the next release we would be happy rather than having to purchase different business objects, like for the front end, or Tableau, or other SAP products. Instead, of buying that, BW could provide us better visualization. Then we don't have to put data into other tools and build things out there.

One of our requirements is the ability to easily get answers regarding trends and exceptions. In BW, it is not that easy to get such information. I expect better trend and exception detection, better pattern detection. When I think about the next generation of analytics solutions, I think of a powerful data mining solution with the data that we have now.

The problem with BW, and the factor that differentiated it from the original BW, is that you only get limited functionality with your runtime license. So, you have to pay extra for extracting data.

I would like to see a more comprehensive package in the future. SAP did that, but when you go to BW on HANA, and then you want to go to BW4HANA, that's basically two migrations. BW4HANA does offer everything that we're lacking in BW on HANA, but two million migrations in five years isn't really salable to the business.

The solution is also very pricey. 

I think that there should definitely be more integration. Whatever they make available in BW4, they should make it available in BW on HANA. But SAP has clearly stated that they are not doing any development on this. They are concentrating on BW4 and the DWC.

SAP Business Warehouse could improve by having more out-of-the-box use cases to cover more business types or operations.

It would be helpful if we could interface with BW itself, instead of piggybacking on Excel. If it could have its own interface where you can build dashboards and reports and where high-level power users can start building things, that would be helpful. Right now, only developers can build reports on BW. They need to begin to open it up to power users. The solution needs a broad-based interface.

More integration with Microsoft Office products (not just Excel) would be helpful.

Our system is old. After the system upgrade, it will open opportunities to explore so many new functions in the FI and HCM modules that could be very valuable to our organization.

The upgrade will allow improvement in the below-mentioned three areas and there are many more that we have yet to discover.

• Business Functionality
  • Implementing the SRM’s procurement function for the public sector such as the supplier registration, strategic sourcing, contract management, plant maintenance and MRP. The key features that we would like to achieve are a simple interface for the user and supplier, support on both the supplier and buyer-end solutions, future enhancement capabilities and cost saving benefits.
  • Travel Management - To support travel-related functions and lower the travel costs.
  • Human Capital - To allow integration between SuccessFactors and SAP ECC. It needs to allow reporting capabilities using BI/BOBJ modules.

• Technical support
  • It will maximize the system performance and allow continuous support and enhancement of new functions. Hence, there will be reductions in the overall support cost.
  • Take advantage of updated Solution Manager functionalities.

• UX - demand (Screen Personas and SAP Fiori)
  • The current SAP ECC version does not support SAP Screen Personas or SAP Fiori.
  • With the help of these UX capabilities, we would like to simplify the user experience, increase user performance and reduce the manual process/errors.

SAP Business Warehouse could integrate better with other ETL tools.

There is some complexity to the setup. It would be helpful if the setup could be simplified.

I would like to see more MLOps capabilities included.

It's a product that is at the end of life so they will not improve it anymore.

It's a product that needs experience and needs knowledgeable users. You don't typically find experienced consultants, especially in Brazil. While it's not hard to maintain, it's hard to find people that could help you with it.

The advanced structuring can be complicated and the interface is not very intuitive.

I know this is already available, but what I would have wanted to see in the next release is the Time-Dependent Hierarchies.

I would like to have the interface improved and made to be more intuitive.

The big minuses are its not being user friendly. The user interface and it’s reporting tool called BEx have room for improvement. SAP Global always promotes Business Objects for visualizing.

The visualization should be improved, as well as the dashboards and advanced analytics. It needs to have a better interface.

The solution could offer better connectivity with other databases.