Create Custom Analytical Queries With Calculated Measures
This tutorial teaches you the creation of a Custom Analytical Query and the addition of a Calculated Measures. You will also be able to edit your calculated Measures and define an Exception Aggregation.
The Business user requires the Role
SAP_CA_BC_ANA_AQD_PC to access the Query Designer.
ABAP Custom Analytical Queries as a tutorial reveals another Prerequisite.
- Step 1
Start the Custom Analytical Queries Application by selecting the corresponding tile in the SAP Fiori Launchpad.
- Step 2
To edit your analytical query you have to search for it and select it.
Furthermore you have to click on the Edit button to continue.
- Step 3
Now you have to switch to the Display Tab to add a calculated measure.
- Step 4
Press the Add button to add further calculated measures like:
- Gross Profit
- Gross Revenue
- and Counter.
- Step 5
Select the measure
marginand click on Edit to open the expression editor in a
- Step 6
You can choose different measures, supported functions and you have content assistance by pressing
"Gross Profit" / "Gross Revenue"as an Expression.
- Step 7
The new expression for the calculated measure is shown in the text field.
- Step 8
For a calculated measure, you can define exception aggregation. Check Exception Aggregation and press the value help to add a function. The
popupshows you the supported functions. One or more dimensions can be added to the exception aggregation via the + button.
a further Dimension.
- Step 9
If a field supports hierarchies, then the hierarchy checkbox is shown in the properties.
Checkmarkthe hierarchy checkbox to enable displaying hierarchy for
Furthermore select values for
Cost Center Hierarchy.
- Step 10
Click on Save Draft to save the query and click afterwards on Preview to test the query.
- Step 11
Click on publish to publish the query. Published queries are available to be consumed by Key Performance Indicators and Reports.
After publishing the status will be updated to published on the top right corner.
- Step 12
Where can you add calculated measures?