This is part of the SAP Lumira Discovery blog series.

SAP Lumira Discovery is an integrating data visualization software that consolidates all the granular details in a simple single view from multiple data sources. This allows insertion of calculated measures and dimensions in the form of formulas. Those formulas support 5 different functions,

  1. Character
  2. Date and Time
  3. Misc
  4. Numeric
  5. Operator

These functions will help you to create calculated measures and dimensions during the design time. For example, if you want to display variance and variance % of cost and the data source doesn’t have the variance measure, the query does not demand an alteration, instead this can be achieved during the design time in SAP Lumira Discovery.
 

How do we achieve this?

 
Let’s assume to have a data source Sales, and consider Material, Sales and Cost
 
Simple Use of Formulas in SAP Lumira Discovery - 1
 
Click create calculation.
 
Simple Use of Formulas in SAP Lumira Discovery - 2
 
Calculations pop up will appear and select measure. Enter name of the calculated measure.
 
Simple Use of Formulas in SAP Lumira Discovery - 3
 
Enter the formula for variance. Click the Measures drop down menu located below the formula area and we will get list of the measures which we have in the data source.
 
Simple Use of Formulas in SAP Lumira Discovery - 4
 
Now, double click on the required measure to use in formula.

Here the formula for variance is (Sales – Cost). Use this formula and click ok.
 
Simple Use of Formulas in SAP Lumira Discovery - 5
 
You can find the calculated measure under measures list,
 
Simple Use of Formulas in SAP Lumira Discovery - 6
 
An important feature to note is the small tutorial which guides us on how to use each formula,
 
Simple Use of Formulas in SAP Lumira Discovery - 7
 
We can use this measure in visuals to analyze the variance.
 
Simple Use of Formulas in SAP Lumira Discovery - 8
 
This is a simple use case for formulas. Also refer to the blog on Custom Dimensions and Measures

More details on the individual features can be found by clicking on the hyperlinks/title. This information is based on the current product and road map and is bound to change.

Interested to learn how to leverage SAP Lumira for your enterprise (or) train your business users in SAP Lumira Discovery? Reach out to us today.

Subscribe to our Newsletter

5920 Windhaven Pkwy
Plano TX 75093.

+1 888-227-2794

+1 972-232-2233

+1 888-227-7192

solutions@visualbi.com