on 07-15-2008 12:08 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.