One Stop Solution for All Modeling Needs of company for Operational & MIS Reporting
January 04, 2024
One Stop Solution for All Modeling Needs of company for Operational & MIS Reporting
Score 7 out of 10
Vetted Review
Overall Satisfaction with SAP Business Warehouse
For Regular Operation & Analytical Purpose We use SAP BW. It has capability to provide Formatted Reports for business uses using Bex Analysis which is Front end Designing tool. Business Modelling takes time but once done properly it provides very robust integration in terms master data & hierarchy access for reporting flexibility. Accessing attributes & grand attributes also comes handy with proper handling and with minimal effort at reporting levels. With the Onset of Composite Provider implementing Joins has become very easy. We can always create Calculated & restricted Measures & Dimension at Composite provider level with out consuming any permanent memory along with a great performance when HANA is backend
- Integrations with SAP Source Systems
- Complex Hierarchies can be handled easily in BW with help of BW
- Master data attributes/ text once configured properly can be looked up in easiest way with least effort in any report.
- Efficient Delta Loading mechanism and easy reconciliation of data
- Connections to other Third Part Systems & File Systems
- Taking data out from BW is also easy.
- Advance Analytics like Regression & Classification Problems Use Cases not possible as of now in BW
- Dashboarding Capabilities are not that great in BW Front End Tool
- Self Ad-hoc reporting is not very flexible as its complex tool in design
- Single Tool to Cater Reporting Need
- High Integration enable real time data extraction along with reporting helps in fast decision making.
- Customers where I have used this tool improved the functioning & it helped to identify bottlenecks for Debtor Days/ High overhead costs.
Its good for data modelling and ease of reporting capabilities. Even designing base master data models is complex but once done it makes life very easy for any reporting that involves hierarchies/ text & direct/indirect attributes even. It does not have capabilities for Unstructured Data Analytics but it was never designed for that perspective. A single tool which can do ETL, Modelling & Reporting as well. As no other tool has all 3 capabilities. With help of Bex very highly formatted reporting can also be achieved in easy way.
Do you think SAP Business Warehouse delivers good value for the price?
Yes
Are you happy with SAP Business Warehouse's feature set?
Yes
Did SAP Business Warehouse live up to sales and marketing promises?
Yes
Did implementation of SAP Business Warehouse go as expected?
Yes
Would you buy SAP Business Warehouse again?
Yes