Challenge
Tableau is to be increasingly rolled out in the company as a reporting and analysis tool. The plan was to give the existing BW on HANA a greater role in the future and to optimise access for Tableau. Using the existing BW queries did not prove to be the right approach, as neither the performance was satisfactory nor the functional scope in Tableau was sufficient for the requirements.
Facts about the customer
Branche: Lebensmitteleinzelhandel
Company size: Corporation
Solution
In the course of several workshops, the BW system was prepared in such a way that reporting is also possible directly via HANA with Calculation Views. Questions regarding authorisations, development process, data modelling and performance were dealt with and answered in cooperation with the customer. Through an integrated coaching approach, it was possible to ensure that the customer could support the solution by himself and also develop it further.
Customer benefit
By providing a reporting and analysis layer directly on the HANA of the BW system, all requirements for performance and flexibility could be more than fulfilled. Thanks to the direct integration with the existing data and models in BW, major adaptations were not necessary, and the full range of Tableau functions could be used at the same time. Further expansion of the solution can now be driven forward by the customer's IT department without the need for any additional work.
