SAP BW/4HANA: My fantastic journey!

Categories: Blog Posts,News

Getting to know BW/4HANA

Read in 4 minutes

A wise comic character once said, “With great power comes great responsibility”. I recently received the responsibility to research SAP’s next-gen data warehousing product, BW/4HANA, through my company Just-BI. I would like to share with you how I learned more about BW/4HANA and became a member of the Fantastic 5 (you read that right: 5, not 4) in the process.

My first proper introduction to SAP BW/4HANA was its product-release, which I watched online. The event surprised me: it had all the makings of an Apple gathering minus Steve Jobs. There was talk of the future; there was optimism and excitement galore. Even the usually stoic German SAP presenters seemed more energetic than otherwise. I watched a very excited SAP spokesperson with a strong British accent exclaim that BW/4HANA was the next big thing in Data Warehousing. That made me curious: is it that revolutionary? I set out to find out.

 

The Fantastic 5 Team

Being a junior BI consultant the idea of getting to work closely with several senior consultants on a new product excited me. On the first day of the project we gave a name to our project team: The Fantastic 4. The reason: Our product owner Glenn is a big Marvel fan and our team consisted of 4 people. Also, because we aspired to do fantastically well like the Fantastic 4 comic book franchise (not like the movie franchise, which has received mixed to very negative reviews). There were some striking similarities. Our product owner Glenn is knowledgeable like Mister Fantastic, our Scrum Master, Hassan, has a bouncer-like presence and our team member Anisha can project force fields with her sharp remarks just like Sue Storm. Also, during the project we received a 5th member, our BO expert Shweta, causing us to start a new franchise: the Fantastic 5!

This is what our team looks like:

BW/4HANA Fantastic 5 Team
I’m the guy whose arm is on fire. The real-life resemblance is uncanny.

My first assignment was to find a suitable dataset for our research. After I found 2 suitable and entertaining datasets, we divided the tasks. My task was to check out all the BW/4HANA object types and compare them with the classic BW object types.

 

All about the ADSO

I spent most of my time investigating ADSOs. I was pleasantly surprised by the ADSO model templates, which simplify the modeling process.  For a detailed read on ADSO functionality, you can have a look at my article here.

Modeling Properties Screen with Model Templates for BW/4HANA
ADSO modeling properties, the keyword is flexibility

The first thing that I noticed when I started working with BW/4HANA was the Eclipse layout. Compared to the BW RSA1 transaction in SAP GUI, there’s remarkably less clutter. It would have been even better if they had replaced the old SAP GUI, but it’s an improvement nonetheless. Secondly, I saw that the Graphical Data Flow Modeler has become the central place to model data flows. No more modeling in RSA1!

 

What’s next with BW/4HANA?

So what did we conclude after all our hard work and research? Alas, we did not make any epic discoveries. For the most part BW/4HANA is functionally the same as in BW 7.5. I would therefore advice customers to hold off investing in BW/4HANA until SAP has released a few feature packs and the product has matured.

However, the future of BW/4HANA looks interesting. On the horizon we can see further integration with the SAP HANA native platform and Hadoop. This means that it will be easier to expose data models to native HANA so that they can be used by SQL-based front-end tools. It will soon be easier for data scientists to extract large volumes of unstructured data from Hadoop and run their algorithms on them.

Secondly, our BPC consultants will be happy to hear that BPC is planned for the end of the year (although they wished it was here yesterday already). Thirdly, life will also probably become easier for BW administrators as Automated Data Lifecycle support and Web based administration are expected to come in later this year.

 

Time to Develop

At the beginning of the project I thought I would just be learning about Advanced DSO’s and Graphical Data Flow Modeling. In the end I learned much more, including what it means to be responsible for a PoC project. I feel proud to work at a company where freshly starting consultants such as me can get the opportunity to work with the latest technology. BW/4HANA is full of ambition and promise on the one hand, but still needs time to develop to its full potential. I wouldn’t use the word fantastic just yet. However, I expect BW/4HANA to become better and better as it is SAP’s BW development platform of the future. I look forward to researching it when it does, and getting better myself in the meantime. In the words of Johnny Storm: Flame on!

Michael Hendrik Bussink
Author: Michael Hendrik Bussink

6 Responses to "SAP BW/4HANA: My fantastic journey!"

  1. Mwitwa Posted on February 21, 2017 at 3:11 pm

    Great Article… well presented and easy to follow even though you lost me on some of the techy stuff… SQL was not my strong point…. I am aware of it beyond that I am blank….. don’t suppose I could use this data warehousing app to store my music and photos?? LOL .. no seriously engaging article! Well Done You!

    • Michael Hendrik Bussink Posted on February 21, 2017 at 6:03 pm

      Thanks for your feedback! I’m glad you enjoyed my article! I do not know of any data warehousing apps that focus on music & foto’s yet (unless having an iPod counts), you might have found a new business opportunity there. If I come across any I’ll definitely let you know and perhaps write an article on their functionality 🙂

  2. Samantha Daisy Posted on February 25, 2017 at 1:11 pm

    Well written article Michael..impressive! i must admit tech has never been my strongest point. Nevertheless this article grabbed my attention and i read it from beginning till the end. Keeping up the good work. This is just the beginning. Anxiously waiting for future articles.

    • Michael Hendrik Bussink Posted on February 27, 2017 at 9:05 am

      Thanks for your comment and for reading my article Samantha! I’m happy to hear you liked it, despite the high techiness factor of the article at times. I’m looking forward to writing more in the future!

  3. Sankar Kumar Posted on March 21, 2017 at 1:06 pm

    Nice Article Michael. Have a great work ahead. I will move on to your ADSO article. Thank you.

    • Michael Hendrik Bussink Posted on March 23, 2017 at 4:08 pm

      Hi Sankar,

      Thank you too for reading my articles and for taking the time to comment! I’m glad you enjoyed my blog.

Leave a Reply

Reload Image