Measure dimension filters
In IBM® Cognos® Dynamic
Cubes, you can create measure dimension filters to restrict the fact
data available in a published dynamic cube when measures contains
more data than is required by the cube.
If a dimension is large, filtering dimension data can also improve the performance of a published dynamic cube.
The following table lists the properties that you can set when you define a measure dimension filter.
| Property | Description |
|---|---|
| Name | The name of the measure dimension filter. Filters are not visible in the IBM Cognos studios. |
| Expression | Defines the value of the filter by using attributes and measures from the dynamic cube. |
Measure dimension filters in in-database aggregates
If your project contains an in-database aggregate that references a measure dimension filter, there might be issues if the in-database aggregate does not include the same attributes or measures that are specified in the filter expression. You must ensure that the data is valid for the in-database aggregate.