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,
- Character
- Date and Time
- Misc
- Numeric
- 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
Click create calculation.
Calculations pop up will appear and select measure. Enter name of the calculated measure.
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.
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.
You can find the calculated measure under measures list,
An important feature to note is the small tutorial which guides us on how to use each formula,
We can use this measure in visuals to analyze the variance.
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. Write to us by clicking here.
