Skip mandatory BEx prompts in Design studio

[Former Member]

Hi I have a BEx query with about 10 prompts 4 of which are mandatory and I want to bypass them. I tried 2 ways

1. created global variables for 4 mandatory prompts as On variable initialization, added on variable initialization code and included DS_1.loadDataSource() on startup code then set 'load in script' fro Data source to true

2. created global variables for 4 mandatory prompts as On variable initialization, added on variable initialization code and set 'load in script' for Datasource to false

But none of these seem to be working and still see the prompts

Any help would be appreciated

Krishna

[hs1]

Hi Krishna,

in your Screen are Dimmension and Value changed

This is not correct,. First Dimension and last the Value

Application.setVariableValue("Variablename", "Value");

or

Application.setVariableValueExt("Variablename","Value");

BR Harry

[Former Member]

Thanks Ingo/Carlos/Harald,

what should i have in value then or do not need any global variable? I have global variables created which is why I followed this syntax APPLICATION.setVariableValue("XCURR","0CURRENCY")

Please confirm that I do not have to use global variables and directly code as below as per your suggestion and this is correct??

APPLICATION.setVariableValue("0CURRENCY","USD")

Thanks again,

Krishna

[IngoH]

Hello Krishna,

why don't you take a very simple first step and use the setVariableValue and create a single line of script for all the mandatory variables you have and use fixed values in the script to see if that works in your scenario and if that works you go to the next step and replace the fixed values with variable values

regards

Ingo Hilgefort

[Former Member]

I finally got it to work, below is the followed procedure (thanks to everyone) so others can use

- NO global script variables

- Application's On variable init:

APPLICATION.setVariableValue("BVAR_SALES_ORG_IP_MSV_MAN_AUTH","1012");

variable is the technical name I copied from Query designer and value is looked up in BW infoprovider

- Extra step to check what I used as default values: Application's On startup property:

APPLICATION.openPromptDialog(500,500);

- NO Load in script property and NO Load datasource() in On startup

Thanks again

Kris

[carlos_weffer]

Hi Krishna

Glad to hear you got it to work, Don't forget to change the status of your question from 'not answered' to 'answered'.

Regards

Carlos W.