SLICEADDAXISFILTERS

This function modifies an existing slice axis by the addition of one or more filters. A filter is defined in an MDX variable, created with the SETPROPERTY function. Use the modified axis when you create a slice definition.

Value, Attribute, and MDX are the three supported types of filter. The type is defined by the FilterType property.

Syntax

=SLICEADDAXISFILTERS(axis,xml_filter_definition).

Example

In this example, the axis to be modified is in cell B7 and the definition of the filter is held in a report variable:

=SLICEADDAXISFILTERS(B7,ReportVariables.rv_filterxml.Text)