cancel
Showing results for 
Search instead for 
Did you mean: 

Selection screen not coming up in Portal for Query view

Former Member
0 Kudos

Hi,

I have a query view in Query designer which is also executed in Portal by assigning it to a Role. The user will login with his User id and he will be seeing this report. Similarly, there are some other Queries assigned in the same way. The problem is for the query view alone, the selection screen is not coming up in the Portal. When i click on that report in portal, it automatically displays the output without showing the selection screen. But, the same query view is showing up the selection screen in Query Designer. For the Queries, i could see the selection screen in both Query Designer & Portal, only for the Query views i am getting this problem.

Is it like the selection screen wont appear for query views in portal or is it possible to make it appear?

Thanks for your time.

Regards,

Murali

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

This usually happens if the user has personlized the selection screen values(by clicking on personalise values on the screen). once you do this, the query will always run for those values when you login with your ID and will not show the selection screen. Try using some other user ID and see if the selection screen appears. If the screen appears for other users and not for your ID then it is surely because of the personilzation of the selection values. You can remove this by deleting the entries from the ODS 0PERS_BOD.

Regards,

Shilpa

Former Member
0 Kudos

Hi Shilpa,

Thanks for your response. I have checked this already and this problem comes not only for me but for all the Portal users.

Regards,

Murali

Former Member
0 Kudos

HI,

Try to include the following at the the end of the link for the reprot in portal.

&VARIABLE_SCREEN=X

Regds,

Shashank

Former Member
0 Kudos

Thanks Shashank, it worked :-)..

Regards,

Murali

Answers (0)