Data Exploration for the Operating Department

SAP Lumira is an addition to the SAP product portfolio in the area of data exploration and visualisation. With its ease of use and uncluttered user interface, SAP Lumira is aimed directly at endusers. Everything is geared towards the aim of allowing diverse data to be visualised and large data volumes to be analysed in order to inform decision-making. New from version 1.27: native support for the SAP BEx Query as data source. In addition to all the visualisations, you can also link the data of the BEx Query with other sources.

SAP Lumira guides the user along the path towards this aim in four steps: data import, data enrichment, visualisation and data analysis.  The results can then be shared with other users.

Step 1: Data Import

Before visualisation or analysis can be performed, the data needs to be uploaded to SAP Lumira in a first step. The data can come from a variety of sources: from local Excel or text files to SQL databases to SAP HANA, from which data is retrieved directly. Since very recently, data can also be retrieved through direct access to the SAP Business Warehouse, making use of BEx Queries as well as InfoProviders. Thanks to the great variety of supported data sources, the enduser can respond easily and speedily to all manner of questions.

Step 2: Data Preparation and Data Enrichment

Once the data has been imported into SAP Lumira, the next step involves the appropriate preparation of the data. Here, endusers can create additional measures (key figures) and characteristics of their own based on the data from the data sources. The tool incorporates a suitable editor for this purpose, which can be used to perform simple manipulations and calculations.

A further interesting function facilitates the merging of data sources. SAP Lumira makes a suitable dialogue available for this purpose as well, which assists the enduser in determining key fields and merging options. It is possible, for instance, to link the data from an SAP BEx Query with an Excel file or with data from an SQL server and use that combined data as a new data source. Of course, you can update the data at any time or change a variable value of the BEx Query.

Step 3: Visualisation

The prepared data can then be visualised in a third step. There are many different forms of visualisation available (charts, maps, tables, …). Using an SDK, these can be modified or complemented by user-specific visualisation types.

No doubt, the outstanding visualisation feature of SAP Lumira is the display of data in geographic distribution. It has never been easier to analyse data geographically using an SAP tool. The characteristics (e.g. country) and measures to be displayed are placed onto the map via drag & drop and the corresponding map is generated at runtime. A new feature in addition to the existing integrated map material is optional integration of the Esri GIS services.

Step 4: Generate Report

Once different visualisations have been created, these can be combined into a so-called ‘Story(board)’. There are a number of different templates available to allow the data to be analysed via the visualisations.

These Storyboards allow corresponding analyses to be performed in the final step, or they can serve as static reports, which can then be shared within the department or made available more widely via the BI Platform.

Our Offer

Interesting in theory, but what does it all mean in practice? Use the opportunity to find out about SAP Lumira in our free webinar on 30.10.2014. In addition to numerous practical examples and demonstrations directly in the tool, we will look more closely at the following topics/questions – directly with your data, if you wish:

  • Where does Lumira fit into the existing tool landscape?
  • Can any data be merged? What is possible, what are the limitations?
  • Visualisations compared: what is possible in the standard software and where can add-ons create added value?
  • Presentation of the different available versions:  from “freeware” to server-based to software in the cloud
  • Recommendations for use in IT and operating departments
  • What added value can data exploration provide to your company?


If so, please give us a call or send us an e-mail. We can then organise a date for a presentation and discuss your individual requirements.