SAP Lumira - Preparing Data in Prepare Tab
Once data set is acquired, it appears in Prepare tab. This data needs to be formatted before charting and visualizations. Different types of formatting can be done on acquired data set −
- Data Cleansing
- Create New Measures
- Create Formula
- Add New Dataset
Prepare tab has different panels that can be used to perform these functions −
Dimension and Measure Panel
It contains a list of all the dimensions and measures acquired in the data set. The number in front of each object represents its data type.
You can use different tools in this panel to edit the data objects and to add hierarchies.
Dataset Selector
You can select between multiple datasets or you can also acquire a new dataset using this option.
Filter Bar
This represents a filter applied to any dimension in dataset. To add a filter, click the icon in front of the dataset and select the option Filter.
How to add new Calculated Measure?
Step 1 − To add a new Calculated Measure, Select New Calculated Measure.
Step 2 − new Measure name.
Step 3 − Enter the formula.
Step 4 − Use a function if required and click OK.
A new Calculated Measure will be added under the measures tab in dimension and measure panel.