this case, there will be gaps in the selected data. When you analyze such an aggregated number by drilling down
to lower levels, how should these gaps be handled, and what should be shown? Examples are provided in the
following subsection to show how these formulas handle this situation.
Note that the Lookup and Restrict formulas cannot be used in combination with other formulas.
Specifies an account member in the model.
[<Point of View>]
Optional. This is a list containing selected dimensions and their members:
[<dimension name>=<account member1>, <account member2>]
This is used to further restrict data in the account member (see following example 1).
For this parameter, the all keyword is available to select all members in the dimension: [<dimension
name>(all)] (see example 2).
Additionally, you can use time navigation syntax to identify specific periods (see example 3 and following
Optional. A dimension that will be ignored – see examples for Lookup() in the following subsection.
1. Restrict(;[sap.epm:Employee=e1, e2])
3. Restrict(;[sap.epm:Time.Year(previous, 1).Day(next, 5)])
An extensive set of keywords is available for time navigation. The following examples show how these are used:
22.214.171.124.1 Comparison of Restrict and Lookup
The functionality of the Restrict and Lookup formulas is very similar, they differ in the way the results are
displayed, showing a breakdown of aggregated numbers.
In the case where an aggregated number is based on a dimension where some members in the hierarchy have
been excluded by the filter, there will be gaps in the selected data. When you analyze such an aggregated number
by drilling down to lower levels, how should these gaps be handled and what should be shown? These formulas
provide two solutions:
● Restrict – shows no value for rows or columns where no data has been selected.
● Lookup – simply shows the aggregated value for all lines (including filtered out members).
Here are a number of examples that show how these two solutions can be implemented, firstly by comparing
Restrict and Lookup, and then showing how the additional IgnoreDimension parameter for Lookup can be used.
© 2016 SAP SE or an SAP affiliate company. All rights reserved.
SAP Cloud for Analytics User Guide