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 had a look at Open ODS Views and HANA CompositeProviders, but 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. 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 also 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

15 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.

  4. Jason Posted on May 19, 2017 at 7:58 am

    very good article.
    can you also supply your article regarding composite provider and Open ODS view? Many thanks

    • Michael Hendrik Bussink Posted on May 21, 2017 at 3:56 pm

      Thank you Jason for your feedback! I’m currently in the process of finalizing the Composite Provider & Open ODS View article. I’ll try and post it online asap (either the coming week or the week after that). You’ll then be able to find it on the Just-BI website. I’ll also provide a hyperlink at the end of my ADSO article for easy access.

  5. Moriinhek Posted on August 31, 2017 at 4:45 am

    Добрый день. Респект познавательную статью. Актуально.
    С уважением Красин Алексей
    Леонидович //

    • Michael Hendrik Bussink Posted on September 1, 2017 at 6:35 am

      Добрый день Красин, спасибо большое за ваш комментарий.

  6. Stevescure Posted on September 15, 2017 at 4:44 pm

    Find out what you need to improve in yourself to become more effective!

    • Michael Hendrik Bussink Posted on September 28, 2017 at 2:36 pm

      That’s definitely my goal, Steve! Luckily, working on this BW/4HANA project has brought me closer to achieving it!

  7. Omar hannoun Posted on March 7, 2018 at 3:06 pm

    Thank you Michael for all posts on BW/4HANA.
    I’am working also on a BW/4HANA project and your articles are helping me very well.

  8. Atish Posted on March 29, 2018 at 11:30 am

    Bravo Michael ……amazingly explained, I was looking for kind of details. Looking forward many more related to BW/4HANA . If any way to contact you please mention.Thanks a ton

  9. essayforme Posted on April 12, 2018 at 8:46 am

    write a essay for me //

    Thanks! I like it!

Leave a Reply

Reload Image