Skip to Content
Author's profile photo Tammy Powlas

Empowered Self-Service BI with SAP HANA and Lumira with Honeywell – ASUG Webcast

We had a great ASUG webcast today with Dennis Scoville of Honeywell Aerospace.  My notes are below.  Thank you to Dennis for sharing his story with ASUG and agreeing to this to go on SCN.  Also meet Dennis here Meet the ASUG TechEd Speaker Dennis Scoville – Empowered Self-Service BI with SAP HANA and SAP Lumira

/wp-content/uploads/2014/01/1fig_363409.png

Figure 1: Source: Honeywell

Figure 1 shows what Honeywell did in the past for self-service BI.

Their environment was vanilla-based columnar based SAP BusinessObjects Web Intelligence reports

They gave their users personalized reports and allowed them to publish to a group folder or favorites.

They were not allowed to report to enterprise report folders.

The data was an Oracle database without real-time

They extracted data from SAP using Data Services and other sources.

The process took 13 hours from 6:00 pm to 7:00 am following morning.

/wp-content/uploads/2014/01/2fig_363425.png

Figure 2: Source: Honeywell

Figure 2 shows the “before system” look.  SAP source systems include ECC, GTS and non-SAP

They had transformations that were put into staging tables that went into Rapid Marts.

That data went into a data mart to SQL Server Analysis Services.

Then they used Web Intelligence against the Rapid Marts.

What was wrong in Figure 2? They had several sources of failure, job-wise, several transformations.

It took a host of skill sets to maintain this, he said.

The end user had to go to different places and there was no drill-down from SQL Server to the Web Intelligence.

/wp-content/uploads/2014/01/3fig_363426.png

Figure 3: Source: Honeywell

Figure 3 shows what Honeywell has done since Figures 1 & 2

They acquired HANA and the BI4 tools and are now on BI4.1

They started using the other tools

They are determining use cases for newer solutions to them

Lumira Server is not out yet.

They are also looking at Predictive Analysis.

/wp-content/uploads/2014/01/4fig_363427.png

Figure 4: Source: Honeywell

Figure 4 shows what their architecture looks like today.

They no longer use flat file interfaces into their data warehouse

All SAP applications use SLT to replicate tables “as-is” – such as MARA tables – MARA tables in ECC look the same in HANA.  There is no ETL process.

They use Data Services to pull in non-SAP data to harmonize data.

SAP and non-SAP data is used to create analytic views.  Some reports go against HANA views and the others go against the UNX universe.

It is a better architecture as they have fewer ETL tools and fewer transformations and a common skill set.

/wp-content/uploads/2014/01/5fig_363428.png

Figure 5: Source: Honeywell

Figure 5 shows what Self-Service BI

They want to provide enterprise wise governed data.  He emphasized governed so they get the same answers.

They want no IT involvement after the initial data delivery.

The business then handles it themselves and they don’t have to create a request for a report.

A governed data set provides a single set of truth and allows decisions being made on information.

/wp-content/uploads/2014/01/6fig_363429.png

Figure 6: Source: Honeywell

Figure 6 shows IT responsibilities – they will do ETL, any data modeling in HANA, information spaces for Explorer, and universes.

Figure 6 shows Honeywell’s tool decision construct.  Key performance indicators are included in Dashboards and Design Studio

The middle layer of the pyramid is the “pealing back” including Analysis, Lumira and Explorer.

The details are for the individual contributor includes focused details of where there might be issues.

/wp-content/uploads/2014/01/7fig_363430.png

Figure 7: Source: Honeywell

Figure 7 shows Business Users tasks at Honeywell, which are lower in complexity.

Business users create Explorer View sets to create dashboards

They use Analysis OLAP and Lumira.

Web Intelligence is used against universes.

/wp-content/uploads/2014/01/8fig_363431.png

Figure 8: Source: Honeywell

Figure 8 shows their first business case, working with Finance on a predictability model.

Some of this is custom.

All this data was acquired and created in 30 minutes!

/wp-content/uploads/2014/01/9fig_363432.png

Figure 9: Source: Honeywell

Figure 9 shows their anticipated revenue in a few years and by quarter.

It says what could but not by business segments or classifications

/wp-content/uploads/2014/01/10fig_363433.png

Figure 10: Source: SAP

They dropped in business segment and now they have a stacked bar.

Segment 1 in blue has the most revenue.

Segments 2 and 3 are more linear, while segment 1 is cyclical.

/wp-content/uploads/2014/01/11fig_363434.png

Figure 11: Source: Honeywell

Figure 11 shows dropping in region

/wp-content/uploads/2014/01/12fig_363435.png

Figure 12: Source: Honeywell

Figure 12 shows contributions by business segment in a pie chart

/wp-content/uploads/2014/01/13fig_363436.png

Figure 13: Source: Honeywell

One region, the Americas has the greatest cost every year

APAC has the best margins

Americas is next with the best margin

/wp-content/uploads/2014/01/14fig_363437.png

Figure 14: Source: Honeywell

Each business segment shows the “heat”

He said you can’t format legend on bubble chart

/wp-content/uploads/2014/01/15fig_363438.png

Figure 15: Source: Honeywell

Figure 15 shows the keys to success.  You need to define roles and responsibilities.  You create models with business in mind; they decide on the key metrics.

They found JAD to be an iterative process and the end user has “skin in the game”.

/wp-content/uploads/2014/01/16fig_363439.png

Figure 16: Source: SAP

He said there was very little training for “data junkies” with a 30 minute session with Lumira – the data junkies “ran with it”.

Custom hierarchies cannot be used in Lumira

Universes should have pre-defined prompts.  You cannot filter in Lumira until after you acquire it.

You can use built in hierarchies such as time and region

With BusinessObjects Explorer, he said 12-15 facets are recommended

They have used up to 25 facets in Lumira

/wp-content/uploads/2014/01/17fig_363440.png

Figure 17: Source: Honeywell

He has 16 GB memory without too many problems

Freehand SQL has some difficulties – you have to login for each query and serial refresh fashion

Our thanks again to Dennis for his time and sharing his company’s story.

Assigned Tags

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

      Tammy,

      Thanks for the recap!

      The picture right after the following sentence is dead (Figure 8)

      They use Analysis OLAP and Lumira.  --> others go against the UNX universe.

      Honeywell was an early adopter of HANA, and their use of it and Lumira were great to hear.

      We enjoyed how he described the adoption process, and when he didn't have to "hold their hands", but just look over their shoulders as they started with Lumira and they got it on their own!

      Thank you Dennis!

      Cheers,

      Bijan

      Author's profile photo Tammy Powlas
      Tammy Powlas
      Blog Post Author

      Fixed using my iPad.

      Thank you for catching it.

      Author's profile photo Antoine CHABERT
      Antoine CHABERT

      Thanks for the blog post Tammy. This is very useful.

      Best,

      Antoine