Creating the calculated object

Finally, we will create new calculated measures or dimensions in our dataset using formulas that are based on the existing measures. In this example, we'll create a calculated measure for revenue based on the prognosis of sales analytics that the revenue in the next month will be 10 percent less than in both previous months together.

Perform the following steps:

1. Click on the options menu for measure and select Create Calculated Measure.

2. The New Calculated Measure window will appear.

3. Enter the new formula in the formula editor:

   

   SAP Lumira provides us with many functions that can help us calculate complex measures. You can learn more about these functions in the functions tab by choosing any function from the list in order to get detailed help about this function.

In addition, we can create new dimensions in the same way.