Restricted values are seen in the query

[Former Member]

I have restricted few values in the query. when i execute the query those restricted values are displayed on the top. can any one tell me how to remove it.

[Former Member]

As Paveen suggested, Open the Analyzer...instead of opening a query, open a workbook(the one you have saved already). Here, you van change the variable also and execute. It wont have restrivted value.

Thanks...

Shambhu

[former_member205352]

Restricted values get displayed at the top by default.

You may want to delete those lines and save as workbook.

So on next refresh it wont appear.

Hope this helps.

[Former Member]

If i do like that i wont see those values in Workbook but it appears in the query again when i execute.

[former_member205352]

To avoid that you need to use the workbook instead of the query.

If you execute the query you will get back those restrictions but if you refresh the workbook you wont get it back.

Hope this helps.