Limitations When Specifying the Scope of Summary Filters with Dimensional Data Sources
When you specify the scope for a summary filter, consider
the following limitations. The scope of a summary filter
- must refer to a grouped data item for list
reports. Otherwise, you encounter the following error:
OP-ERR-0212 The summary filter scope (Scope1) found in the query (Query1) is not valid. It must refer to a grouped query item.
- can refer to multiple data items, but it can refer to only one
data item per edge of the crosstab. Otherwise, you encounter the
following error:
OP-ERR-0213 The summary filter scope (Scope1) found in the query (Query1) is not valid. Referencing more than one query item from the same edge is not supported.
- must refer to a level and cannot refer to a measure. Otherwise,
you encounter the following error:
OP-ERR-0209 The summary filter scope (Scope1) found in the query (Query1) is not valid. It must refer to a level.
- must refer to a data item that is projected on an edge of the
crosstab. If the scope of a summary filter refers to a data item
that was deleted from the report layout, you may encounter unexpected
results. Otherwise, you encounter the following error:
OP-ERR-0213 The summary filter scope (Scope1) found in the query (Query1) is not valid. Referencing more than one query item from the same edge is not supported.
- must refer to unique data items. For example, the summary filter cannot refer to the same data item more than once.