Suppressing null cells by using filters

You can also use filters to suppress null cells in your reports. Using filters ensures that calculations take suppression into account. You may also obtain better report performance because the filtering is done at the data source.

If your report includes more than one measure or fact expression, it is best to base the filter on only one underlying fact or measure.

Relational-style Reports

In relational-style reports, you can use detail and summary filters.

Dimensional-style Reports

In dimensional-style reports, you can use the filter function.

For example, insert a set expression in your crosstab and use the expression filter ( descendants ([Set]) is not null). If your crosstab includes three or more levels within the same dimension on an edge, use the expression filter ( descendants ( currentMember([Hierarchy] ) is not null).

If your crosstab includes nested sets, filter the sets using a cascading approach to improve performance. For example, first filter the outermost (or highest nested level) set, and then filter the remaining sets proceeding inward.