Create a Restricted Measure

With a restricted measure, you can restrict available dimensions.

Procedure

  1. You are in the editor of your analytic model. You can create a new restricted measure by clicking the background of the canvas and choosing Add Measure in the properties panel. Choose Restricted Measure.
  2. Edit the following properties:

    Property

    Description

    Business Name

    Enter a descriptive name to help users identify the object. This name can be changed at any time.

    Technical Name

    Displays the name used in scripts and code, synchronized by default with the Business Name.

    To override the default technical name, enter a new one in the field. Technical names can contain only alphanumeric characters and underscores.
  3. Define the properties of your restricted measure:

    Property

    Description

    Source Measure

    Select the source measure.

    Aggregation Type

    When the source measure is a fact source measure the standard aggregation can be overridden by changing the Aggregation Type.

    Expression

    Enter your expression in the formula editor. An atomic expression usually has the format <dimension> <operator> <value> (e.g. Country = 'Germany').

    Exception Aggregation

    The exception aggregation determines how a measure aggregated with regard to one or more dimensions.A dimension is needed for exception aggregation in order to define the granularity with which the aggregation rule is applied. For more information, see Aggregation and Exception Aggregation.Exception aggregation is only supported for restricted measures if the source measure is a fact source measure. You can use the exception aggregation to calculate the stock for a given time. You can also define no restrictions for the restricted measure, and just use it for the exception aggregation.

    Formatting

    You can change the format of a measure in an analytic model. You can change the scale (Thousand, Million, Billion, Percent) and the number of decimal places.

    Constant Selection

    You can choose to set constant selection for all dimensions or just for selected dimensions. A measure with constant selection will not be impacted by filters or drill-downs on the constant dimensions.Enabling constant selection is useful for comparing a single value with several different values. For example, you could create a restricted measure for sales in 2022, and then compare sales in 2022 with sales for all other years in the same table. See also the blog post Restricted Measures with Constant Selection in SAP Analytics CloudInformation published on SAP site (published February 2, 2021) for examples.

    Settings

    Decide whether your measure should be an Auxiliary Measure. An auxiliary measure can be used for further calculation but it will be hidden in the story in SAP Analytics Cloud.