SAP BusinessObjects Lumira (a.k.a. Lumira) is a business intelligence tool focused on analytics and datavisualisation, it provides the ability for business analysts to alter data structures and the correlation in the way they need without help of a professional designer or IT specialist.
Applications created with Lumira are really impressive and they provide the perfect user experience allowing you to construct powerful dashboards with different kinds of visualisation based on charts, tables, and even maps.
After some time focusing on SAPUI5, ABAP CDS and exploring the SAP Analytics world I had the opportunity to try out this marvelous tool and implement some functionalities provided out-of-the-box.
The purpose of this post is to share my experiences and discoveries in the last couple of months and provide a quick user guide for developers who want to enrich User Experience with some simple techniques.
Starting now a short series of two articles I’m going to discuss two different developments I had implemented using SAP Lumira Designer and ABAP CDS views.
In this first article, I’m going to explore a little bit about the architecture, some of the predefined templates and explain how simple it’s to connect a Lumira application with an analytical data model constructed with ABAP CDS views.
Hope you enjoy the content.
At the moment, Lumira is delivered in two different versions:
While Lumira Discovery is focused on the business user providing intuitive interfaces, flexibility to connect data from multiple data sources and a good set of options to manipulate the data and generate different kinds of visualization, Lumira Designer is ideal for professional designers and developers who need to create corporate analysis applications and reports, expanding and enriching applications with custom functionalities.
Since this article is directed to IT consultants, it’s totally focused on the Lumira Designer edition. Here it goes some interesting facts about the tool:
This is just a brief introduction but if you want to acquire more knowledge about the subject I advise to have a look in the SAP Help Portal documentation:
Now that you have a basic understanding of the tool it’s time to proceed and check the available templates.
Lumira Designer offers you a set of standard and ready-to-run templates that serve various design and business needs. When you choose a template, the system automatically creates a copy of it and you can change this copy according to your needs.
The following Standard templates are available:
Basic Analysis Layout
The following Ready-To-Run template is available:
Before you proceed check-in details the official documentation and understand the purpose of each one of these templates, since our main goal is to generate a self-service BI application we’ll focus on the Basic Analysis Layout and Generic Analysis.
Both templates provide similar functionalities, the main difference is the Basic Analysis doesn’t allow the user to change the data source during the runtime while the Generic Analysis allows the selection of a different data source based on the back-end connections configured in the BI platform.
The layout of both templates are pretty similar, let’s have a look:
The application is composed of the following sections:
Measures & Dimensions
Columns & Rows
Now that you’re familiar with the self-service template we can start the development of our demo, I’m going to split this content in two parts, back-end, and front-end development.
Analytical data models constructed with ABAP CDS views are really powerful, you have the advantage to consume the data in real-time avoiding the work with extractors and possible replication issues. Also, with the power of CDS annotations all the SAP BW objects are generated automatically, based on simple analytical annotations placed in your CDS views the system generates automatically BEX queries and all the dependent BW objects through the Analytical Engine.
I already published an article explaining how to Create an analytical model based on ABAP CDS views and this will be the base of the back-end in this exercise, if you still didn’t check this content previously, take a break and read everything carefully before you proceed in this current post.
The business scenario is based on the Flights data model provided in the previous article, the query Flight Bookings is going to be reused in this exercise, check the details below:
With the definition of our business case and back-end data model, we can proceed straight to the front-end development and configuration.
Start by logging into your SAP BusinessObjects BI platform.
Create a new document with the name Flights and create a new application under this document with the name ZDEMO_SS_FLIGHTS, select the Basic Analysis Layout and confirm.
This should be the structure of document and application after you complete this step, you can visualize it through the Documents pane in the left section.
In the Outline pane, search the folder Data Sources and select the <unassigned>– DS_1, after one click over this object the Properties pane will show up with all the details about the data source, open the search help for name/connection to open a new pop-up with a configuration screen.
Select the connection of your back-end server and the query Flights Bookings created in the previous post. Remember the name convention for the data source is not based on the CDS view name but in the SQL view name. This is the expected pattern:
2C + <SQl_VIEW_NAME>
And this should be the name of the Flight Bookings query:
Check the configuration below:
After you press OK the application will update automatically the Navigation Pane and Content including the measures, dimensions, columns, and rows exactly as configured in your CDS view.
Save and run the application by pressing. Check the result below:
In this quick demo I tried to explore a few of the functionalities available with the self-service template:
After concluding your Lumira application you can synchronize the document with the BI Platform and deploy through the BI Launchpad, I would like just to show another option exposing the application via Fiori Launchpad. There is a really interesting blog explaining all the steps to achieve this configuration and it helped me to achieve the same functionality in one of my previous projects.
In the next post, I’ll discuss more features from Lumira Designer like charts and map components, the ESRI API and the Script Editor. Hope you liked this content and see you next time. ?