BO Design Studio variable prompt prefilled when using planning function

[former_member194547]

Dear all,

We are using Planning Function within BO as described in the following scenario:

• One simple query with variable popup
• One simple planning function, which is executed by clicking a button
• Planning Function and Query share two variables (Year, Delivery Center)
• Both variables are manual input variables and have no default value set

When executing the Design Studio template, the variables are prefilled and the value help will not show the list of all available values, but only the ones which have been preselected (e.g. Year 2011). If you want to select a different year or delivery center than the preselected one, you have to enter the technical ID manually.

As described, the variables do neither have coding nor default values set.

When removing the planning function from the design studio template, the variable popup is empty (as expected) and the value help works accordingly. So it seems to be related to the planning function. However, I could not find any place for the planning function where default values would be maintained. When executing the planing function directly from within RSPLAN, no prefilling has taken place.

Does anyone know where to check for these preselections and how to disable this in Design Studio?

We already tried to set the query to load in script but the same happens.

[former_member194547 · Accepted solution]

We managed to work around this. Actually, the problem consisted of two issues:

• Default values for Design Studio Template including Planning functions: It would always select the first available record of for a variable which is used in planning function and query. To resolve this, we manually set the variable values to empty in the application on startup event: DS_1.loadDataSource(); DS_1.setVariableValueExt("0P_FYEAR", "");
• Value help only shows the preselected value instead of all available values: This issue was fixed with note 2107060 on BW side.
  

[TammyPowlas]

Hi Peter -

I am not using planning so I am not sure how much help I can provide.

Would you please provide more details - version of Design Studio, and if it is 1.5, are you using patch 1?

What do the prompt properties look like (at the application level)?  See below

Another thought is to try this with Analysis Office, if you are using that, and see if you experience the same results.

[former_member194547]

Hi Tammy,

Thanks for your reply and sorry for forgetting this information. We are using BO Design Studio Release 1.5 (Version: 15.0.6) on top of SAP BW 7.4.

The prompts settings are as in your screenshot. We tried different combinations of merge/force, but always with the same result.

[TammyPowlas]

Hi Peter - one quick suggestion is to apply patch 1 from 1.5 to see if you experience the same results; my version is 15.0.7 (1.5)