SetPlanningFunctionVariable
Applies to: SAP BW (INA Provider) connections.
This API enables you to define the values for a planning function variable.
| Parameter | Description |
|---|---|
| PlanningFunctionAlias as string | Planning function alias. Mandatory. The alias of a planning function is displayed and can be changed when selecting a planning function in the Planning Objects tab of the EPM pane. Mandatory. |
| VariableName as string | Name or technical name of the variable. Mandatory. |
| VariableValue as string | String that represents the value for the variable, as it will appear in the
Members/Values column of the Planning
Objects tab of the EPM pane. 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.SetPlanningFunctionVariable "PF_1", "0TARGET_YEAR", "2013"
End Sub