Query not displaying Variables in the portal

[Former Member]

Hi ,

I have variable issue, when i execute query through bex it is displaying Variable selection screen ,but when i run the same query from PORTAL it is not displaying variables selection screen ,can some help me in finding the solution.

Thanks,

SUbhash

[arvind_doomra · Accepted solution]

Hi Subhash,

Please make sure that variables are mandatory. and if you wanted to call the variable screen forcefully, please append

&Variable_screen=x to the url.

Regards,

Arvind

[former_member225306]

Hi,

VARIABLE SCREEN NOT SHOWN BY DEFAULT SCENARIOS:

===============================================

1. If a query has no variables, no variable screen will be shown in web.

It is not at all possible to see variable screen in this case.

2. If a query has variables (only optional variables but no mandatory

variables ) then variable screen will not be shown.

3. If a query has mandatory variable but if it is prefilled, then

variable screen will not be shown.

you can enforce to see variable screen only in case 2 and 3 by using the

parameter '&VARIABLE_SCREEN=X' to the end of context url as shown in

example below:

/irj/servlet/prt/portal/prtroot/pcd!3aportal_co

ntent!2fcom.sap.pct!2fplatform_add_ons!2fcom.sa

p.ip.bi!2fiViews!2fcom.sap.ip.bi.bex?TEMPLATE=

<XXX>&VARIABLE_SCREEN=X

The variable screen wont be shown if there are no mandatory variables

in the query. You can force it with the following methods,

1) Append the parameter '&VARIABLE_SCREEN=X' to the links in your menu.

2) Change the parameter in the web template used > template property

'Force variable screen' in the Web Application Designer, per

default it is not checked.

3) In case, no template is specified, the standard web template is

used > transaction SPRO. In case, no web template is maintained as

standard web template in transaction SPRO the standard web template

delivered by SAP is used. It is recommended not to change

the original SAP template but to create a copy, apply changes and

maintain it as new standard web template in transaction SPRO. Please

review note 643464 for further informations."

VARIABLE SCREEN SHOWN BY DEFAULT SCENARIOS:

===========================================

Only when there is a mandatory variable which is not filled and has

to be filled only by user via F4 help, then variable screen will

be shown automatically.

Thanks,

Venkat