SAP Knowledge Base Article - Public

3421099 - How to exclude/filter out members using SAPSetFilter command

Symptom

This document describes how to exclude/filter out members of a dimension using SAPSetFilter command in Analysis for Office.

Environment

  • SAP Analysis for Microsoft Office

Resolution

It is possible to exclude/filter out members of a dimension using SAPSetFilter VBA command, by adding "!" to the member parameter.

For example:

Before excluding.png

The button "Exclude Product PDS01" will run the VBA command below:
---------------------------------------
Dim lResult As Long
lResult = Application.Run("SAPSetFilter", "DS_1", "0D_NWI_PH2", "!PDS01", "INPUT_STRING")
---------------------------------------

After excluding.png

See Also

Keywords

SAPSetFilter, command, VBA, filtering, filter, excluding , KBA , BI-RA-AO-XLA , Excel Addin , How To

Product

SAP Analysis for Microsoft Office all versions