Skip to Content
Author's profile photo Former Member

Creating New Business Processes Based on Incredible Analytics Powered by SAP HANA

I’ve had quite a few HANA Moments since beginning to work with the product in late 2011, some bigger than others, but all very important.  For this fairly short engagement of just nine weeks, we were focused around Special Purpose Ledger data coming out of ECC.   The customer was focused on a few key metrics they use to drive their profitability, with sales, margin, and promotional mix being the three largest.  The customer had some reporting capabilities built around these metrics already in place in BW but they were terribly slow, highly aggregated, and not real time. 

The Customer Need:

·         One source of truth on sales, promotional mix, margin, and overall profitability

·         Analytics supporting all levels of the company, executive, store manager, product manager

·         Ad hoc analysis of real time data

·         Understanding of how product mix and promotions impact profitability

A Big Roadblock Threatens Success:

The first two main deliverables were accomplished fairly quickly, things were moving along great, and then we ran into a sticking point that threatened the overall satisfaction of the customer.  Exception Aggregation is a BW Functionality that is only possible in replicating using BW on HANA or by employing the use of a Universe and Web Intelligence.  The fact that this was an Agile Data Mart scenario and not BW on HANA coupled with the fact that the customer was only using Business Objects Explorer and Analysis for Office made this impossible and caused a fair amount of tension.  After three weeks of attempting to design a solution to meet this need at the customer’s request they pulled the plug.

In the End the Power of HANA Prevails:

On my last day, about an hour before I was set to head to the airport, still feeling like the customer was only partly happy with our results, the customers’ business sponsor came in our conference room.  He sat down with a big smile on his face and said that he had just gone through a demo with their business representatives and it went phenomenally well and that everyone was extremely excited.  He decided that he would show the technical team the demo he had just given.  This was the start of a great hour. 

The Business Impact:

He brought up a report he had built in Analysis for Office.  No charts or graphs, just rows of data in an excel spreadsheet.   You could tell he was excited.  We started high level, company codes, which countries were more profitable for them than others, and finally, the last addition he made to the report was at an individual purchase order level.  In about 5-10 minutes he had gone from a worldwide view of the business, down to an hourly view of each purchase order for each product at an individual store, explaining along the way what he was looking at.  When the report refreshed in a second or two on this final level of granularity he stopped and looked at us, and said something to the effect of, do you realize the power of this, we are now looking at an hourly snapshot of every product we sold today, do you know what we can do with this type of analytical capability?!?  For the final few minutes that I was in the room listening to him he was talking to the technical team about the limitless possibilities of having a reporting system that was built in real-time, that had the ability to go from the highest perspective of the business to the lowest, and how once they fully adjusted to having a tool this powerful how it would help them to craft their business processes around it, helping them to Run Like Never Before.

Think about that last statement, now, because of the power of HANA, instead of creating a report to track progress on a business process, the report is driving the creation of the business process itself as a result of analytical capabilities that were not possible before SAP HANA. 

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      SAP HANA looks to be very powerful tool for technical guys to build high end processes and reports for business. Nice article.

      Author's profile photo Former Member
      Former Member

      Hi Michael,

      what happened to their original desire to use something like exception aggregation? It seems that they switched from a real world requirement to a demo showcase favorable to HANA in order to make an internal business case. Good to establish HANA inside the company but a bit odd for my standards.



      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Hi Alistair,

      Since this was really a proof of technology for the customer and they were still attempting to identify their HANA roadmap based on the results of this project, it was communicated to the customer that in order to use Exception Aggregation that they would need to go with a BW on HANA approach to support this.  Or, they needed to employ a Universe and use Web Intelligence in order to get the roll-ups to work properly.  At the time WebI was not the BI tool that the customer was looking at. 

      So it's not that they dropped the requirement, its that they knew they had options which would allow them to do exception aggregation but they wanted to solidify their roadmap before spending more time/effort/money on this specific requirement for this engagement.

      Hope that helps to clarify,


      Author's profile photo Former Member
      Former Member

      Great article Mike; as you mentioned it is important to note that this limitation (i.e. not being able to push down the exception aggregation down to the HANA DB) can be addressed by using other tools and this is part of the PoC deliverables, helping the customer decide which tools to select and why.