SAP Business Warehouse Reviews

I am using SAP Business Warehouse in my organization for data warehousing as well as an ETL tool. Integration with SAP Business Warehouse's ETL tools is not straightforward. Integration with SAP ERP is out-of-the-box, but integration with other tools is not that great.

The best features of SAP Business Warehouse that I am fond of are how this technology handles navigational attributes and the hierarchy; these are two interesting features. It's a straightforward solution which is a low-code solution, wherein there are quite good drag-and-drop facilities available. The transformational aspects use a language called ABAP, which is complex; people find it harder to deal with that because it's a programming language that needs skills in SQL.

The advanced reporting features in SAP Business Warehouse help support strategic planning because reporting is generally used for decision support, and it depends on the role of the end-user. For example, if you are a financial controller or a marketing and sales person, it depends on the kind of data you want to have. SAP Business Warehouse has quite a good data warehouse when it comes to providing reports. Before HANA, it was necessary to build something called aggregates to prepare these reports, and then came accelerators. However, post-HANA, the data loads are very quick compared to the earlier days, meaning data latency has reduced. There is not real-time reporting possibility with BW because there are transformational capabilities that are missing, meaning they take longer time compared to other tools such as Spark or Snowflake; the ability to get to near-real-time reporting in BW is slower, and this is one of the reasons people consider moving out.

The role of SAP BW's data governance capabilities is very important, as it involves maintaining templates and making sure that the right data reaches the right person at the right time. These are some of the governance and security aspects that come into the picture. There is a very good authorization model available in BW, which is very robust. I have not seen in any technology such an authorization model, which has a unique feature of restricting data towards certain users, even though the data is contained in the same table. There are multiple features with authorization in SAP, that's about authorization and security which I appreciate.

The only complexity I find with the product is the programming language; people find it harder, but once you know the language, it's not that difficult.

Regarding the future of SAP Business Warehouse, I would to see added features that simplify the product very well now. They are coming up with a terminology called SAP BDC where they are consolidating their tools, SAP Data Sphere for integration and SAP BW for the ETL and warehousing parts, and SAP Analytics Cloud. They are packaging these three features and calling it Business Data Cloud; they are fully coming on the cloud. We have to wait and watch; they have been speaking about BW/4HANA for quite some time now, but the customers or clients I work with are not finding great interest and it was seen as a candidate for evaluation. I have seen people looking at the latest technologies who are already on cloud who started building from scratch on cloud, such as Snowflake or Databricks, which can process very huge amounts of data and also address unstructured data, where SAP lags behind in cases where there is a need to bring in unstructured data. I have worked with SAP Data Intelligence, which earlier used to be called SAP Data Hub. The unstructured data is not greatly handled in SAP at this point in time.

I have been familiar with this solution for approximately 14 years.

I would rate the support of SAP as very established and responsive.

Positive

The installation of SAP Business Warehouse is straightforward and not complex.

The pricing for SAP Business Warehouse is on the expensive side. I am not sure about the current costing model as such. In my experience on cloud, I did not use BW HANA Cloud. I used the cloud products of Data Intelligence and SAP Analytics Cloud. When I was working on pricing things, a bit of transparency was lacking, meaning when to have your instance up and when to shut down when it is not in use. The metering was not stopping automatically, even though they say that auto-stopping was there; I complained to SAP, and they recognized this issue and said they would continue.

I'm an architect and I design data platforms. I continue working with Snowflake and SAP. For SAP Business Warehouse, I have used everything; on-premise, on cloud, it was in-memory, and before that, it was on a database.

I use SAP Business Warehouse's data visualization feature. The advanced reporting features help support strategic planning because reporting is generally used for decision support, and it depends on the role of the end-user. For example, if you are a financial controller or a marketing and sales person, it depends on the kind of data you want to have.

Near-real-time analytics was made possible post the advent of HANA. However, that's not real-time analytics. Real-time analytics is not something that was requested by the senior group who makes decisions. They are more interested in consolidating the data, which is where the tool BW helps. When it comes to real-time analytics, I have never worked on situations where the stock market wherein real-time analytics are used in fewer industries to make decisions. The decisions are always made on consolidated data, where real-time analytics is not seen as a huge impactful feature. Near real-time, which has a latency of 15-20 minutes is not a big deal as I found among my users.

I rate SAP Business Warehouse a seven out of ten. It's my personal favorite, but at this point in time, the world is going in a different direction. However, from where we started our analytics, I still will go into that tool; it is convenient and comfortable.

SAP Business Warehouse (BW) integrates data from different sources, transforms and consolidates the data, does data cleansing, and storing of data as well. It also includes data modeling, administration, and staging area.

Actually, this is something analytical. Earlier, SAP was purely a GUI-based product. But now SAP is being moved out to the URL-based product. I would say the web pages and the front end.

They have converted their output in an analogical way. You might have seen this in the share market and for stocks. They are live all over the tracking system; their output gets changed in a fraction of a second. So for that type and kind of certain data, it has been used. From the back end, from a technical perspective, I have end-to-end knowledge. For example, for how to mitigate risk while assigning additional access to the user, there might be possibilities of the risk.

As an example, we have assigned a role to a user who is working in a bank and there may be a hierarchy in the bank. One user might be the cashier, one user might be the bank manager, and one the accountant, so if you compare all these three users, the bank manager will have more privileges than the other two users. The cashier may have access to withdraw and deposit the money. The accountant may have access to just pick the documents and compare the documents.

I am a backend guy, and I am handling the server. From the backend, we have to segregate the duties. So, we use it to segregate the manager, cashier, and accountant roles.

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.

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.

I have been using SAP Business Warehouse for approximately eight years.

The product is stable. Most of the things are live 24x7. So the stability is good, and I would rate it a nine out of ten for stability.

Considering upgrade and migration issues, I would rate the scalability of Business Warehouse a seven out of ten.

Business Warehouse product is not suggested for small-scale enterprises. It is suggested for big organizations like those that are Fortune 500 companies or have mass data in their servers for that kind of company.

For small-scale enterprises, it is too costly. Small-scale companies cannot bear it. They cannot pay the price for this. For companies that have a turnover of more than 100 crores or then more than that for them, it is advisable to purchase Business Warehouse. I would not recommend it to small-scale companies.

The SAP team provides solutions and is good in the technical areas. Every other day I face technical issues, and when I myself cannot resolve them, I reach out to the technical team. So, technical support is good, but they take time to respond on a priority basis. 

They are not responding quickly. Sometimes they take two, three, and sometimes five days. Considering live server operations, we sometimes need a quick response within one hour or thirty minutes. SAP could have been better in that area. They should have a rapid-fire team and quickly jump in and troubleshoot that technical issue and should resolve it quickly. They should have done that better.

Neutral

The best functionality that SAP has is that it can integrate with any other third-party services. Whether SAP or non-SAP. It can integrate, and you can do the data exchange. But Odoo does not have that functionality. The reference ERP that Oracle has also does not have that functionality. So, SAP is good compared to other tools.

The initial setup is very complex. It required multiple implementations. It took months to implement SAP Business Warehouse.

We implemented another tool called BPC, which is cloud-based and integrated with Business Warehouse. So, we created all the roles and profiles in the Business Warehouse. But the front-end visibility and the tool used is BPC, which is cloud-based only. So, the latest also they are coming up with cloud only.

I would not recommend it to small-scale companies. The price is too much. If you consider all the ERP products, Microsoft and Oracle are also selling their ERP products. Their pricing is very less as compared to SAP Business Warehouse. SAP is very costly. If you compare it to Odoo, it is free of cost, while SAP is too costly.

Compared to Oracle ERP, PeopleSoft, and Odoo, Business Warehouse is more stable.

Overall, I would rate Business Warehouse a seven out of ten.

We used all the standard components. We did not customize it.

We used the standard content activation features. It generated reports. The reports accessed from the browser were also standard. We did not use any bespoke report creation. My organization used the product mostly for procurement, sales and delivery, finance, and CO-PA. All these components were implemented, and all the reports were based on them.

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.

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.

I used the solution a year back.

The tool is very stable.

The tool is scalable. We had around 50 users.

The initial setup is very straightforward. There'll be some hiccups, but the deployment doesn’t take more than two days.

The deployment was done with the help of third-party vendors. We did not need many people for the deployment because we wanted the standard features.

The solution is quite expensive. We paid a yearly subscription fee.

If all the products are from SAP, I can rate SAP Business Warehouse a ten out of ten. It becomes very complex if the customer wants to integrate a SAP product into a non-SAP solution. In that case, I rate SAP Business Warehouse a six out of ten. I recommend the tool to a small or medium company with SAP solutions and no third-party products. If the organization is big and has multiple solutions, I wouldn’t recommend the tool to them. Our customers do not use the tool effectively. Overall, I rate the solution a six out of ten.

In my experience, there are typically two types of clients for SAP Business Warehouse: IT-driven and business-driven. Business-driven clients tend to have clearer objectives and achieve greater success because they understand their business needs well. 

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.

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.

I have been working with SAP Business Warehouse since 2003.

I would rate the stability of SAP Business Warehouse as an eight out of ten.

I would rate the scalability of SAP Business Warehouse as a ten out of ten.

The initial deployment of SAP Business Warehouse is straightforward. SAP has made significant improvements in deployment processes, making it much easier compared to ten years ago when it required expert assistance to get it up and running.

Using SAP Business Warehouse can bring significant returns on investment. Many projects have delivered returns that far outweigh the initial investment, often paying for themselves multiple times over.

I find the pricing of SAP Business Warehouse, especially with the transition to RISE with SAP, somewhat opaque. As a partner, the shift to a software-as-a-service model has changed the licensing structure, which makes it less transparent for me to assess the pricing accurately.

SAP Business Warehouse excels as a corporate data warehouse, providing integrated ETL, warehousing, and reporting capabilities. While other solutions may offer more flexibility, SAP BW stands out as an all-in-one solution, especially for clients using SAP's backend systems like ERP and CRM. It is a logical choice for organizations seeking a comprehensive data warehousing solution tailored to their SAP ecosystem.

Before HANA, SAP Business Warehouse's ETL functions were basic compared to competitors, fulfilling their job but lacking sophistication. However, with HANA technology, there has been a significant improvement. Now, we can work with real-time data warehousing, breaking the traditional paradigm of nightly data updates. HANA enables real-time data integration, a substantial advancement in SAP's data warehousing capabilities.

By using online database replication, SAP Business Warehouse provides real-time integration of data from multiple sources into the data warehouse. With BW's modeling and transformation features, raw data becomes actionable insights, presented in user-friendly formats, aiding informed decision-making.

SAP Business Warehouse's data modeling capabilities have significantly improved our decision-making processes. By leveraging features like Core Data Services and HANA graphical calculation views, we can model data closely to SQL standards and transform it effectively for reporting needs. This enables us to have real-time data in a structured environment optimized for reporting, providing insights that were previously difficult to obtain from transactional systems.

If you are considering using SAP Business Warehouse, my advice would be to let the business lead the project, not IT.

Overall, I would rate SAP Business Warehouse as an eight out of ten.

We have several reports that run on SAP Business Warehouse for various modules. We have some sales, finance, and supply chain reports. These are mainly the reports we work on, plus a couple of dashboards under layered development.

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.

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.

I've been working with SAP Business Warehouse for almost seventeen years now.

SAP Business Warehouse is a stable product.

SAP Business Warehouse is easy to scale. My company has several licenses, so the product is scalable.

Regarding SAP Business Warehouse technical support, if your system is live and it's been running for a long time, the support team should have processes in place and good background knowledge on how to fix issues.

If it's a new implementation, then it's understandable that the support team needed more time to understand and fix the system. Still, if it's an old system, then the SAP Business Warehouse technical team should have much knowledge of it.

You can't hire support staff with insufficient experience or just two to three years of experience because that would be difficult for him. Still, it would be easy to fix issues for support staff with a good experience with SAP Business Warehouse.

I started my career with SAP Business Warehouse and didn't use any other product.

In the earlier days of my career, I implemented SAP Business Warehouse. I did one in Australia, one in South Africa, and three in India. Whether the implementation was easy or complex depends. If you have complex requirements, then your implementation will be complicated. Otherwise, implementation would be simple.

One implementation was a bit complex, and the process took almost nine months, but that was for an implementation where you didn't use all features simultaneously. Instead, you implemented the features one by one. Going live completely took nine months.

My team went phase by phase with the SAP Business Warehouse deployment. The first step was going live with the sales module that contained different sales reports. Next was the material management, and the final stage was the core modules going live. However, for any module that needed complex modeling, that went last. Initially, my team gave the basic reports to users, but the customized reports would take some time.

An in-house team implemented SAP Business Warehouse.

I was never involved in the pricing of SAP Business Warehouse because the sales team handles that. Still, as far as the information I have, SAP licensing is a bit expensive compared to other products in the market.

I work with SAP, so I have experience with SAP Business Warehouse.

I'm using version 7.5 of SAP Business Warehouse.

My company has approximately two hundred fifty users of SAP Business Warehouse. Three people maintain the solution.

I recommend SAP Business Warehouse to people and companies using SAP ERP systems. Still, if your company has more presence in other databases, such as SQL, Azure, and other ERP systems, I would not suggest SAP Business Warehouse because the solution is friendlier when connected to SAP systems. For non-SAP systems, you'll need to exert more effort to bring the data in when you use SAP Business Warehouse.

My rating for the solution is seven out of ten.

My company is a customer of SAP.

We use it mainly for financial reporting in any organization and also for cross-functional reporting.

Over the course of the year, it has been made really simple. The development time has significantly reduced due to the number of objects going down, and overall, the TCO to the company has reduced a lot. Therefore, the implementation time has come down a lot because of the new solution, and a lot of integration is available with the reporting tool as well, such as Analytics Cloud, and Power BI.

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. 

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.

I've been using the solution for 15 years. 

It's a stable solution. It takes some time to set up, yet, once it's done, it's very stable and reliable. 

The solution is scalable. I'd rate the scalability seven or eight out of ten. It will get more scalable as it moves toward the cloud. We have about 100 to 200 users right now.

You would always raise a P1 when you need a quick response. If it's not P1, then there is a delay in response. So if it is a P1, they are pretty quick.

Neutral

The initial setup is pretty simple. You just have to complete the step-by-step book from SAP. It's very simple. I'd rate the ease of setup eight out of ten. 

The deployments are manageable every week, so if it's for the simple change, it's weekly. We divide our changes into minor, medium, and major. Minor deployments go every week, major ones go biweekly, and then the major change is monthly or once every two months.

How long it takes depends upon the objects that you're sending and the number of objects that you're sending, and the changes that you're sending. There is a max of six hours of downtime when you have a big change going in, however, when you have a minor change every week, it's under an hour.

You only need one resource to handle deployment. 

There is regular maintenance required. On the BW side, an average team size of ten is good. Depending upon the complexity, it might increase. It depends client to client. You can't put a number on that since it all depends on the number of modules implemented and the number of reports available. 

On the support range, it's a medium-scale. If there is only BW support, a minimum of three and a maximum of five resources are necessary. It's only for BW, not any other integration reporting tool. Just for BW, about three resources is enough, however, for BW. 

ROI takes its own time. The one drawback is the cost; however, on the maintenance side, the cost is less. That is what the client needs to consider. 

If you take any other data warehousing technology like Azure, Google Cloud, or AWS, the resourcing cost is too high on that side because to do something, you will always need ten or 15 resources. Yet, with SAP, the product cost is higher, yet you save a lot on resourcing. That's why everybody is moving from SAP. 

The pricing depends on how much TB or space is required.

I'm an implementer and end-user and handle a bit of sales.

It can be on the cloud on Azure or AWS. A new product has come up from SAP, which is called SAP Data Warehousing Cloud. Slowly, there will be a shift from the existing BW4HANA to Data Warehousing Cloud in, I would say, three to four, maybe five years. They are working on moving to the cloud. It is pretty new in the market, so it will take time to settle down.

It's the best data warehousing tool in the market. It's got tight integration with SAP. If you have SAP as your source, then you should not look outside for any other data warehousing tool and go ahead with SAP BW due to the integration with SAP, and it's very tightly integrated with any SAP source, as well as any SAP reporting.

I'd rate the solution nine out of ten. 

My organization uses SAP Business Warehouse as its primary data storage platform, so all transactional systems feed data into the business warehouse system. That's the central part. Every department has some information or analytical service running into SAP Business Warehouse.

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.

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.

My organization has been using SAP Business Warehouse since 2006. As for me, I've been using it since 2012, so I have ten years of experience with it. I'm still using the product.

SAP Business Warehouse is quite stable, and its stability is one of its USPs.

SAP Business Warehouse is a very scalable product. Scalability is one of its USPs; it can hold vast amounts of data.

I've contacted the technical support for SAP Business Warehouse, which was wonderful. Once you buy the SAP Business Warehouse license, it comes with a bundle of services such as "Speak to an Expert," so if your technical team is stuck somewhere, the technical support team for SAP Business Warehouse is there to help.

When I assumed my role in the organization, I hadn't seen any other system apart from SAP Business Warehouse, but I heard that the organization used Oracle Database for reporting.

The initial setup for SAP Business Warehouse is not as straightforward because it's not an out-of-the-box product. You need to brainstorm with other business users and find out what you need to build department-specific or user-specific configurations before you can start using SAP Business Warehouse.

The licensing cost for SAP Business Warehouse depends on your revenue. Its licensing structure is a little bit complicated. The more your revenue is, the higher the price, but SAP does have different pricing structures for various companies. For small businesses, licensing isn't based on revenue, but for big companies, it's revenue-based. There's some agreement regarding pricing for huge companies, so it's different, and SAP Business Warehouse pricing isn't fixed.

On a scale of one to ten, I'm rating the licensing cost for SAP Business Warehouse as five because it's very high. As your revenue grows, your licensing cost also increases, so you have to factor that in when calculating your cost.

My company is an SAP Business Warehouse customer.

The initial deployment of SAP Business Warehouse requires between twenty to thirty people, but two to three people for maintenance would suffice.

Right now, everyone in the organization is using SAP Business Warehouse in one way or the other. The core or power users would be around three hundred people from finance, reinsurance, IT, etc., but mostly from finance.

I wouldn't recommend SAP Business Warehouse to startup organizations or people just starting out because the product demands many people to run and maintain it. SAP Business Warehouse would be a good product for medium-sized organizations where the data is becoming bigger and bigger. It'll be wonderful to use because if you have many systems, then SAP Business Warehouse can feed data into your systems, so it's perfect for a medium-sized organization, at least.

I'm rating SAP Business Warehouse as eight out of ten.

AP BW is our main data storing platform that houses all transactional systems data. Every department has some or the other analytical service running on to our business warehouse.

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 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.

We have been using this solution since 2006. 

This is a stable solution. 

This is a scalable solution. 

The customer support is wonderful. If your technical team is stuck somewhere, they are there to help.

Positive

This is not a straight out of the box product. It is a product that needs a lot of brainstorming along with the business users to find out what they need so that the build is department specific.

SAP's licensing structure is a little bit complicated and is linked to your revenue. This does not apply to smaller business. Overall, the pricing is not fixed and is expensive. As your revenue grows, so does your operational licensing cost. This needs to be factored in when calculating cost. 

I would not recommend it to organizations that are starting out because it demands a huge number of people to run and maintain it. I would recommend it for medium organizations with a lot of data. 

I would rate this solution an eight out of ten. 

It's a customized solution for the company's reporting needs.

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. 

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.

I've been using the solution since 2017.

The solution is stable. There are no bugs or glitches and it doesn't crash or freeze. It is reliable. 

I'd rate the stability eight out of ten. 

We have lots of users using the BW-based reports. That's around 500 people. However, we don't have many actual users on the solution itself. 

Technical support from SAP is being provided by our technical teams. There have been issues that our own team has dealt with directly.

We are using the SAP Business Warehouse as well as the Commercial Project Management model of SAP. 

We are also using Analysis Office Integration with SAP.

I have worked with two systems related to BW. One that is an elegant JBA, which is all right. They have products that are BW related. It was also a nice product, actually.

The upside to working with this solution is that it is basically integrated with directly SAP.

I'm not involved in the initial setup.

It is very costly. I can't speak to the exact costs, however. Only larger companies can afford SAP.

The maintenance costs are very high as well. 

I am not the one who is using the different transaction codes of BW since rights are provided to a minimal amount of technical personnel. Those who are going to prepare the cubes or make some queries or something like that would use it. Based on that queries, we are getting reports.

I'd rate the solution eight out of ten. 

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

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

We have been working with SAP Business Warehouse for 20 years as a partner.

I rate the product’s stability a nine out of ten. There is room for improvement.

We have three customers and 1000 end users for SAP Business Warehouse. I rate its scalability an eight or nine.

The technical support services are good.

The product is straightforward to install and deploy. It takes two to three weeks to complete the process. I install it for the customers and forward it to application executives for data warehousing. The number of executives required for deployment depends on the organization’s size. It requires approximately one to ten people, depending on the project requirements.

I recommend SAP Business Warehouse to others and rate it an eight out of ten. It has a well-documented and straightforward installation process.