Blogs / SAP / SAP BusinessObjects / SAP Lumira / Simple Use of Formulas in SAP Lumira Discovery

Simple Use of Formulas in SAP Lumira Discovery

Sep 15, 2017

SHARE

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

Click create calculation.

Simple Use of Formulas in SAP Lumira Discovery

Calculations pop up will appear and select measure. Enter name of the calculated measure.

Simple Use of Formulas in SAP Lumira Discovery

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

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

You can find the calculated measure under measures list,

Simple Use of Formulas in SAP Lumira Discovery

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

We can use this measure in visuals to analyze the variance.

Simple Use of Formulas in SAP Lumira Discovery

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.


Corporate HQ:
5920 Windhaven Pkwy, Plano, TX 75093

+1 888-227-2794

+1 972-232-2233

+1 888-227-7192

solutions@visualbi.com


Copyright © Visual BI Solutions Inc.

Subscribe To Our Newsletter

Subscribe To Our Newsletter

Join our mailing list to receive the latest news and updates from our team.

You have Successfully Subscribed!

Share This!

Share this with your friends and colleagues!