SAP Knowledge Base Article - Public

2350675 - SAPSetPlanParameter retuns 0 - execution failed

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.

11.png

Resolution

  • Change the type from "Cell" to "Members".

           12.png

  • 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

Product

SAP BusinessObjects Analysis 2.2, edition for Microsoft Office ; SAP BusinessObjects Analysis 2.3, edition for Microsoft Office