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:
Procedure
-
Do one of the following to create a calculated dimension:
-
From a Table:
In Builder, under Rows or
Columns, select .
-
From a Chart:
In Builder, under
Dimensions, select .
-
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.
-
Provide a Name for the dimension.
-
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.
-
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.
-
Provide a member name: for example, high, medium, or low.
-
Set the Measure Values.
-
From the Dimension Context, select one or more versions.
Note
For hierarchical dimensions, you also need to specify the level. For example,
Date.Year
-
(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.
-
(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.
-
(Optional) In Filter Context, add a Calculation Input
Control.
-
Select a dimension.
-
From Values or Input Controls, select
Create a New Calculation Input Control.
-
Provide a name for the input control.
-
In the Input Values area, select your
values.
-
When finished, select OK.
-
When finished, select OK.
Results
The calculated dimension is ready to be used in your chart
or table.