Unable to see Selection window in portal when we run a query.

[Former Member]

Hello Friends,

Here is the situation where we cannot see Variable selection window from portals when we run query and the query executes wide open.

But when running from Bex Analyzer or Report designer or web analyzer we can get the Variable selection screen and able to select the variables.

Did any one experience this problem.If so please share the experience and solution.

We are on BI 7.0 upgraded from BW 3.1 and BI SP15.

Thanks,

Ram

[jabella]

Hello Ram,

Have you try doing a trace? Some systems need the authorization object S_BDS_DS inthe role in order to show the selection window.

Regards, Jose

[Former Member]

A few things to check...

1. Are the variables in the query set to required? If so and a value is not passed in as a parameter, then the variable screen should pop up.

2. Have a look at the web template that is being used from the portal..you can see this in the iview under "Content- Bex Web Application" property category in the field called BEx Web Appliation Query String. The web template is the portion after template_id=<technical name of web template>. There is a parameter on the web template called Force Variable Screen (VARIABLE_SCREEN). You have 2 options, if it is a custom web template, you can set this box to checked in order to see the variable screen. If it is SAP delivered web template and you don't want to mod it, you may want to adjust the iview to pass the VARIABLE_SCREEN=X parameter in the query string. See the help.sap.com on passing parameters to web templates.