Symptom
Call API method SAPSetPlanParameter with Application.Run, the return code is 0 - execution failed.
For example:
Dim lResult as long
lResult= Application.Run("SAPSetPlanParameter", "PS_1", "PLAN1", "2013", "INPUT_STRING")
lResult is 0.
Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.
Environment
- SAP BusinessObjects Analysis 2.2, edition for Microsoft Office
- SAP BusinessObjects Analysis 2.3, edition for Microsoft Office
Reproducing the Issue
Call API method SAPSetPlanParameter with Application.
For example:
Dim lResult as long
lResult= Application.Run("SAPSetPlanParameter", "PS_1", "PLAN1", "2013", "INPUT_STRING")
Cause
The SAPSetPlanParameter only works when variable Source is set as "Members" not "Cell" reference.
Resolution
- Change the type from "Cell" to "Members".
- Due to the bug in SAP Note 2351956, before the correction is applied, just changing the type from "Cell" to "Members" will not work. You must delete and re-insert the Planing sequence or Planing function, change the type from "Cell" to "Members" as a workaround.
Keywords
SAPSetPlanParameter, AO, Analysis for Excel, Analysis for Office, Planing sequence, Planing function, Members, Cell, execution failed , KBA , BI-RA-AO-XLA , Excel Addin , BI-RA-AO , SAP Analysis for Microsoft Office , Problem