SetPlanningFunctionFilter
Applies to: SAP BW (INA Provider) connections.
This API enables you to define a planning function filter for a specified dimension.
| Parameter | Description |
|---|---|
| PlanningFunctionAlias as string | Planning function alias. Mandatory. The alias of a planning function is displayed selecting a planning function in the Planning Objects tab of the EPM pane. Mandatory. |
| dimensionName as string | Caption or unique name of the dimension. Mandatory. |
| members as string | Use the manual entry syntax. Mandatory. Note use the syntax described here: BW Queries with Variables.
|
| MemberFormat as string | Optional. Relevant in a next version. |
Example
Sub test()
Dim cofCom As Object
Dim api As Object
Set cofCom = Application.COMAddIns("SapExcelAddIn").Object
Set api = cofCom.GetPlugin("com.sap.epm.FPMXLClient")
api.SetPlanningFunctionFilter “PF_1”,”Country”, “DE;FR”, “”
End Sub