If you were talking to someone whose organization is considering SAP Business Warehouse, what would you say?
How would you rate it and why? Any other tips or advice?
Our solution is strictly on-premises due to our company policy to not place anything on the cloud. Consultants with technical experience are helpful. They need to understand the processes, as well, however, because designing is the key. Designing right from the start is the very important if you want the product to work for you. There are multiple teams within our company. In my team, we are only concerned with BW and BO. With other teams, there are probably many other instances where someone that is using the solution is connected to other data sources and may be providing the data to the suppliers outside SAP using the portal. I don't know much about it because I'm not involved in this process. I'd rate the solution six out of ten.
SAP Business Warehouse is really good. I had already used it in four prior organizations and this will be my fifth organization using it. It is pretty good as far as SAP Data is concerned. So right now, our licenses are only limited to SAP Data because it is for external data, then we need to purchase additional licenses, which we have now gone ahead with. So that's where one of the challenges is. They have ready-made connectors for the SAP, data transfers, extractions, cube production, and all the applications. We build the data and the reports. They are trying to deliver the data as compared to extracting the data from SAP to SQL Tables and then building the same logic and producing the report. We prefer that when it comes to SAP Data. My advice would be if you have a data block and if you really want a big solution on the reporting side of it with slicing and dicing, definitely go ahead with BW when it comes to SAP related data. On a scale of one to ten, I would rate SAP Business Warehouse an eight. As I said, a few things which are missing include the visualization of reports. That's where your costs and licensing become heavy. When it comes to this database compared to Microsoft Warehouse, it's an expensive solution. Because if I already have an SQL Server, my licensing fees and the server licensing cost for installation all go drastically down. They also give us a free reporting tool. For the data view, we need to have user-licensing and every cost gets increased, as I said. For example, we have a license for SAP Data, and for external data, we also have to purchase one more license, and again for a visualization tool. So that way, licensing costs keep increasing with BW.
We are a manufacturing company, also running a factory and we implemented it in the ERP. I think BW is one of the best products at the moment. There are a lot of competitors that are adding features. Specialty Suites or the FETA Gartner and Logic requirement. It's important to check all options. A company needs to take into account what business or industry they have. Most are probably considering different solutions and for banks or insurance companies, it's possible that Microsoft solutions are better. I would rate this product an eight out of 10.
We don't use any Data Quality or Identity Manager. Our company doesn't deal with customers directly as it is not open to the public. Our clients are mainly insurance companies. We will normally limit the amounts of data, so we don't have those components but we do have Business Warehouse where we pull in reports of incidents. Recently, we were upgrading versions. We were on SAP BW version 4.7, and we have moved on to BW 6.0. Right now, we access Business Warehouse through an Excel add-on called BEx Analyzer which is also a product of SAP. At this time, I wouldn't recommend the solution as the product support will be phased out by SAP. If others are interested in an SAP solution I would go for SAP Analytics Cloud. I'd rate the solution eight out of ten.
We use the on-premises deployment model. We're an SAP partner. I'd recommend the solution. I'd rate it eight out of ten.
My advice regarding this solution would be to invest in professional training for future users. I would rate this solution a seven out of ten.