Skip to Content

Intro:

On Saturday July the 30th at 1pm the first InnoJam in Sydney was kicked off at the UTS Business school in Sydney. Nothing prepared, the only thing we knew was that we had 30 hours to create a solution for a business case, and present it within 6 minutes to a jury…

More information around the event can be found here: http://wiki.sdn.sap.com/wiki/display/events/SAP+InnoJam+Sydney+2011

This blog is to outline the details of our solution. First the business case (BizFire) and after that we’ll dive into the dirty details of the solution (Tech Fire). At the end some final words and experiences.

 

Biz Fire:

The idea originated from one of our colleagues (Tom Hallett) who was rudely awoken by an earth quake while on a project in Christchurch, New Zealand.  Not an experience he’ll quickly forget but it fuelled an excellent business case for our InnoJam solution. The idea was born to build a Disaster Alert & Response Management System. A system which will provide a trigger for a (retail) company in case of a disaster and respond to it quickly and effectively.

The high level process that it needs to support is the following.

 

 

In short the solution provides continuous real time retrieval of external data and processing of this data. As soon as a new quake occurs the solution needs to notify the stakeholders to take action. This is done by creating a ‘virtual’ collaboration room where the stakeholders can create and follow up actions. Secondly the solution needs to provide the managers sufficient information through reporting to be able to act and understand what the effect is of the quake on the business. More specifically the following data needs to be provided:

  • Show locations      (stores, DC’s, offices) affected by the natural disaster
  • Alert regional      management to contact staff in stores, DC’s & offices to ensure      everybody is safe and accounted for
  • Show stock in      affected locations and provide assessment on potential stock loss (derived      from the impact of the natural disaster) as well as impact on future total      forecasted sales 
  • Show      outstanding sales orders to customers from affected locations and trigger      follow-on actions such as changing the fulfilment to another location      unaffected by the natural disaster
  • Show vendors      and PO’s that have been placed for affected locations – put plan into      action to either cancel PO’s or deliver them to another location
  • Create a      Collaboration room within SAP StreamWork and automatically invite      respective members of the management team 

With that in mind we started looking at a solution to support it.

 

Tech Fire:

We started by looking at what type of architecture we would need on the basis of the available new technology SAP provided to us during the InnoJam.

Below a screenshot of the SAP StreamWork / Gravity solution diagram we drew up during the InnoJam.

The solution combined several data sources together which were processed by BusinessObjects Data Services and then fed into HANA. HANA provided the real time reporting capabilities to a BI Mobile iPad app and a BusinessObjects Dashboard. Parallel to this an alert, in case of a new quake, needed to be created in HANA so that an emergency Streamwork collaboration room would be created.

The solution when originally drawn up included (of course) more components but with limited amount of time you quickly revert back to the basics. In the next paragraphs the different components will be described in more detail.

 

Data sources

– External Source – Geonet.org.nz   

The quake data is provided by geonet.org.nz which provides a service to retrieve near real time quake information. We were quite amazed to learn that for New Zealand there were 5000+ quakes recorded for 2010 with a magnitude larger than 3. See http://geonet.org.nz/for more information.

– External Source – Twitter

The twitter information was to further understand the intensity and effect of the earthquake on the basis of the tweets. This was to understand the public sentiment around the earthquake as a factor in the impact analysis.

 

– ERP (SAP ECC)

This provided us the Employee/Store/Vendor/Purchase and Sales order information.

 

Data processing

– BusinessObjects Data Services

Data Services is the best practice solution for importing data into HANA. It also provides functionality to do Text Analysis for the Twitter information and cleanse the data where necessary. Unfortunately BusinessObjects Data Services was not available in the provided SAP Landscape so we resorted to some custom development to get the data into HANA, which in itself was an interesting exercise and left the sentiment analysis for what it was.

– HANA

The In-Memory capability of HANA provides real-time analysis of high-volumes of data.  It calculates which stores were impacted the most on the basis of the distance from the quake centre and the depth of the quake. HANA will also trigger an alert when a new disaster has occurred.

Our tables in HANA:

Creating the views for reporting:

 

Reporting/Collaboration

– BI Mobile iPad app

The mobile app provides a solution for managers which are on the move to have all the data readily available at their fingertips.

Using a map with visual appealing icons (red for high, orange for medium and grey for low impact) the store locations and the location of the quake centre is provided. The quake center depicted in the screenshots is the actual quake that occurred in September 2010.

 

The mobile app provides the functionality to do further analysis on the affected stock and the number of employees that are affected.

 

– BusinessObjects Dashboard 4.0

The dashboard provides consolidated disaster management & recovery information

The affected stock levels:

The affected employees per store:

The affected customers that need to be contacted since their delivery will be delayed:

 

The affected vendors which need to be contacted since the delivery needs to be cancelled or deferred to another location:

 

– SAP StreamWork

SAP StreamWork is a collaboration platform. One of the tools we used ourselves is the Gravity BPM tool which allows you to model business processes collaboratively. Hence the unorthodox system landscape screenshot from the Gravity tool at the beginning of this blog.   SAP StreamWork is an excellent platform to share information in a distributed team setting, but also to provide a centralized collaboration room for managers when a disaster hits their company. HANA triggered the creation of a collaboration room in SAP StreamWork and the respective managers were notified of this via email through SAP StreamWork automatically.

The automatically created activity:

The collaboration room is ready to use with the stakeholders invited:

 

Final Words:

It was a great event and it provided great insight in some of the new technology provided by SAP. Even though we didn’t incorporate all technologies in our solution the event provides the ability to talk to the SAP experts in a relaxed setting which gives you ample time (30 hours) to get better insight in also the technologies you are not using. 

Unfortunately the systems provided weren’t fully integrated and some key pieces of software were missing to make it a fully integrated solution, but this did not affect the learning curve and the result in any way shape or form.

Last but not least I would like to thank my team for their hard work and dedication:

– Ian Hall

– Tom Hallett

– Vlad Mily

– Michael Niestroy

– Martin Voros

To report this post you need to login first.

7 Comments

You must be Logged on to comment or reply to a post.

  1. Michelle Crapo
    Any chance I could talk you into creating a WIKI page?  Then we could have everything in one place your complete blogs.  Yes, I know – blogs are better at highlighting things.  But you could point your blogs back to the WIKI page.  Even having the information in both places would be good.

    How about your code?  Is it on code exchange?  I’d love to see it or code snippets.

    Michelle

    (0) 
    1. Ronald Kleijn Post author
      Thanks Michelle,

      I think if we will expand on this topic you are definitely right, having a WIKI page is a good alternative for providing a central location with all the information.

      About the code. It is not on the code exchange at this stage. It is not 1 application but it is constituted of several SAP technology components so just having the code would only provide a small part of the solution.

      The interesting/difficult part for us in this solution was getting those “new” components working together. 

      (0) 
      1. Michelle Crapo
        MMMmmmm…  I thought you could put several technologies in code exchange.  But you probably are right.  It’s been awhile since I went there.

        Yes – getting things talking together.  That seems to always be the hardest thing for me to do!

        (0) 
  2. Joern FRANKE
    Hi,

    very impressive what you achieved and congratulations. We work on a similar topic, for example, we created a system in Google Wave to support the coordination of dynamic ad-hoc processes in a disaster response (cf. also Making the Case for Humanitarian Supply Chain Management). Our work seems to fit also to the area of case management process modeling (Case Management Process Modeling (CMPM) – What Constitutes a Case?).

    I hope to hear more about this great work in the future.

    Cheers,

    Joern

    (0) 
    1. Ronald Kleijn Post author
      Thanks Joern,

      I liked the Google Wave service but unfortunately that has been suspended, but SAP StreamWork is really quite similar, so have you ported the system to there or another platform? I liked your disaster response blog. This is really the next step in our solution as part of the Collaborate/Act step. Due to time constrains we left it for what it was and focused on the technical issues of the solution.

      We are looking at enabling this within our own demo environment, but getting HANA is the tricky (read expensive) part.

      (0) 
  3. Roel van den Berge
    Hi Ronald,

    That is an impressive solution you created! Especially in such short amount of time! I really hated not being able to attend the InnoJam in the Netherlands. Hopefully next year or anytime soon.

    Cheers, Roel

    P.S.: Come home! 😛

    (0) 

Leave a Reply