Create Measure-Based Dimensions

In SAP Analytics Cloud, create a calculated dimension based on the aggregated value of a measure.

Context

You can create a calculated dimension based on measure or account values or thresholds. For example, you could create a high/medium/low chart dimension (or table row or column) based on your own criteria.

You can also create measure-based or value-based charts that include the following options:

  • Date dimension.

  • Static filter that ignores all other filters.

  • Dynamic filter or Input Control.

Procedure

  1. Do one of the following to create a calculated dimension:

    • From a Table:

      In Builder, under Rows or Columns, select Start of the navigation pathAdd Measures/Dimensions Next navigation step Calculated Dimensions Next navigation step Create Calculated DimensionEnd of the navigation path.

    • From a Chart:

      In Builder, under Dimensions, select Start of the navigation pathAdd Dimension Next navigation step Calculated Dimensions Next navigation step Click to Create a New Calculated DimensionEnd of the navigation path.

  2. In the Calculation Editor under Type, depending on whether you're working with an classic account model or a new model type, select Measure-Based Dimension or Value-Based Dimension.
  3. Provide a Name for the dimension.
  4. In the Properties section, select an account, a measure, or both using the dedicated fields:

    • If you’re working with a new model type, select the measure and the account using the dedicated field.

    • If you're working with a classic account model, select a measure.

  5. Select Use measure values as dimension members.

    This will replace the member name field. You can set the scale and the number of decimal places for the measure values that are converted to dimension members.

  6. Provide a member name: for example, high, medium, or low.
  7. Set the Measure Values.
  8. From the Dimension Context, select one or more versions.
    Note
    For hierarchical dimensions, you also need to specify the level. For example, Date.Year
  9. (Optional) In Filter Context, add story or page filters.

    Story and page filters are not automatically applied to measure-based dimensions, which means that some filtering results may not be as expected. This is easy to see when you use measure values as dimension members.

  10. (Optional) In Filter Context, add a specific static filter.

    For example, you can use the Date dimension and select a single value such as a year or quarter.

  11. (Optional) In Filter Context, add a Calculation Input Control.
    1. Select a dimension.
    2. From Values or Input Controls, select Create a New Calculation Input Control.
    3. Provide a name for the input control.
    4. In the Input Values area, select your values.
    5. When finished, select OK.
  12. When finished, select OK.

Results

The calculated dimension is ready to be used in your chart or table.