Regarding SAP Business Warehouse, there was nearly no internal knowledge and at the same time the responsiveness of the technology-oriented SAP BW partner was slow and passive.The solution also did not take into account the historical correctness of the data in case of changes in master data (which is typically being dealt with in a DW environment using the correct slowly changing dimensions types). All in all, the end user acceptance was quite low, leading to custom-built stovepipe & undocumented solutions done by the business in Excel. While the business requirements as always were not a given fact, the as-is solution was too inflexible in adding new functionality or new fields for that matter. Conclusion: an unstable and overly complex architecture. Next to this, a too long-running nightly copy of the complete SAP instance was taken and moved to a separate server on which complex queries were executed for reporting purposes. The BI architecture consisted of a partial roll out of SAP BW with a focus on sales reporting using a standard business content deployment approach.
#SAP ECC BI MANUAL#
As a consequence, the manual handling of data often resulted into questionable quality of data, due to errors and underestimated data characteristics. As such a lot of valuable business time was spent and lost in the pre-work instead of actively using the produced information. Vandeputte Group in the past encountered a number of problems related to the process of creating and distributing management information :Ī lot of manual data gathering & complex calculation work was performed by individuals within the business. Approximately 200 employees realized a turnover of nearly 80 million Euros in 2011.
The entire group has offices in 3 European countries: Belgium, where the headquarters are located, The Netherlands and France. Equipped with the relevant knowledge of the market segment, and socially committed to the promotion of safety awareness Vandeputte Group started up a specific service for trade, wholesale distributors and retailers. The skills and tools concern three complementary areas of knowledge, namely vision and strategy, internal dynamic (personnel and organisation) and well-being in the workplace in all its aspects.Īrtelli-Busters supports resellers, wholesale distributors and retailers. The Vandeputte Safety division focuses on the development and distribution of a complete range of high-quality personal protective actively works on the improvement of man's well-being in the workplace. The organization consists of specialized divisions, each focusing on a very specific market segment. As such the organization is specialized in products and services that limit and prevent work accidents and discomfort. Starting out as a family business at the end of the 1940s, it has now grown into a fully-fledged company group, concentrating on all aspects of well-being and industrial safety. Vandeputte Group is one of the leading European experts in safety and well-being. It is quite important to note that - while the Vandeputte Group executed a successful implementation of SAP ERP in 2008-2009 in an enterprise-wide fashion, for all major business processes and for all entities - in the end in terms of their reporting and analysis needs, the logical choice of SAP BW as their preferred BI platform was not made, but instead an alternative approach was taken. This case study will discuss the implementation of a Data Warehouse & Business Intelligence solution at Vandeputte Group.
0 kommentar(er)
