Variable screen doesnot appear when query is executed

[Former Member]

Hi All,

We recently upgraded the BW 3.1 to 2004s(BI 7.0).

When i am executing the query, the selection screen is not popping up.

Instead the query is executing with default selection.

I am facing problem when there are any mandatory fields.

I appreciate your help,

Thanks,

Joseph.

[Former Member · Accepted solution]

Hi Joseph,

If your are not able to get the Variable pop in WAD when their are no mandatory variables in one of the varaiables avaialable then go to your WAD template in the web template options properties select the option variable screen = on then even if you don't have manadatory variable you will get the popup.

regards

Neel

[Former Member · Accepted solution]

HI Neel,

Thanks, for your info.

But i am not getting the variable screen in BEx Analyzer.

Is there any special authorization settings required, or any code change needed

Thanks,

Joseph

[Former Member · Accepted solution]

Josh,

In WAD you need to ensure that in the Web template properties Force Variable Screen option has to be checked. PLease check that box and save it and run it..

Hope it will help you...

Regards,

Gatttu

[Former Member · Accepted solution]

Hello,

Please check patch level it should 14 or above

SAP GUI should be 7.1

I hope it helps,

Kishore

[Former Member]

Hi Josh,

Any of these three things can happened

1.First check weather the 'ready for input' check box is checked while creating the variable.

2.Also make sure that variable is used in that query.You might have forgotten to pull that variable into your query.

Finally try this

open the query - click on refresh variables and you will get the window - then in the icon of a face next to the variable entry boxes - see if personalization has been done - is so - click on that to delete personalization and check again

Hope it solves the problem

Regards

Karthik

[Former Member]

Hi,

the variable is checked 'ready for input'

it is used in a formula

actually it is appearing for some users with BI_ALL auth,

but were trying for some test users the variable screen is not appearing.

even 'change variable value' to remove any personalization is not working from test user.

and for BI_ALL users at change variable screen if we remove personilization, the following error is comming

An exception with the type CX_SY_PROGRAM_NOT_FOUND occurred, but was neit

Program GP3T375QSSYZZ29YGQVGFUV7OO2 does not exist

Thanks,

Joseph

[Former Member]

Josh,

We fixed it by adding following objects to our query builder roles.

1) Business Explorer - BEx Web Templates (NW 7.0+) S_RS_BTMP

2) Business Explorer - Individual Tools S_RS_TOOLS

3) Business Explorer - Data Access Services S_RS_DAS

Hope this helps.

[Former Member]

Hi Friends,

Thanks for your suggestions

[Former Member]

Hi Josh,

Could you solve you issue. We are facing the same problem and I tried all suggested about and nothing worked for me?

I will appreciate any suggestion...

Regards,

Raimundo Alvarez

[Former Member]

Hi Josh,

We are also facing the same problem. Can you please let us know if u have solved the problem.

Thanks,

PM

[Former Member]

Its working fine.

Applied note : Note 918598 - Error in variable screen if authorization S_BDS_D is missing

thx,

PM