Hopefully you have enjoyed the SAP HANA Career Guide so far. This piece focusses in on the SAP HANA BW Consultant. These guys are responsible for upgrading, migrating and HANA-enabling existing information on the SAP BW Enterprise Data Warehouse, as well as the creation of new Data Warehouse solutions.
Where do SAP HANA BW Consultants come from?
Well this one is easy! Any existing SAP BW Consultants – especially those who are more business focussed and don’t have the heavy hitting SQL skills that would make them great SAP HANA Performance Consultants – can make excellent SAP HANA BW Consultants.
This is largely because running SAP BW on HANA is broadly similar to running SAP BW on any other database. The modelling principles, business object principles and key considerations for things like stock or currency conversions remain exactly the same. So if you’re an existing SAP BW consultant then look no further.
What does HANA Thinking mean with BW on HANA?
There are a few important changes worth thinking about. The first are architectural. BW on HANA requires fewer objects – you lose Indexes, Aggregates and some of InfoCubes as well as being able to lose certain types of DSO and Master Data objects.
This means simplification of both the number of objects and with that, data loads and query management. And that brings with it a simplification of project design, methodology, reduction in load times and testing times. It completely changes the way that BW projects are run – reducing project timelines and increasing time-to-value.
How do I cross-train to SAP BW on HANA?
The SAP Customer Solutions Adoption team have produced an excellent course for experienced BW people called “LSA++ – THE LAYERED SCALABLE ARCHITECTURE FOR BW ON HANA“. As is the CSA style, this is designed for those who already have great BW skills and need the HANA specific stuff.
Here, they explain the difference in thinking between HANA and any other RDBMS, and what that means to architecture, design and the practicalities of Enterprise Data Warehouses.
What Classroom Education is available for SAP BW on HANA?
The classroom training is really limited in this example. SAP Education have a course called TZBWHA: SAP BW on SAP HANA - but it is twice the price and contains half the content of the SAP course. I understand that a new course is being written as we speak – hopefully it will contain the right content. In the meantime, I don’t recommend this course.
Where can I go to ask questions?
As before, here are two great places for this. First there are the SCN SAP HANA and in-Memory forums, where you can ask technical questions about all things SAP HANA. Response times are excellent.
Second, you can go to the Experience SAP HANA Discussion area, where there is a similar focus on assistance.