Ad-Hoc report Dimensions and expression selection in CurrentSelection box

[thakkarrahul01]

Hello Experts,

While selecting dimensions and expressions used for Ad-Hoc Report straight table selections are appearing in the current selection box, which I don't want to display. I am missing at some step, Can anyone please help.

Please find attached qvw for sample.

swuehl‌ MRKachhiaIMP‌hic‌gwassenaar‌rwunderlich‌

[Kushal_Chawda]

I didn't understand .. can you elaborate

[swuehl · Accepted solution]

Use a hide prefix in your script:

SET HidePrefix = '_';

[thakkarrahul01]

Perfect !! Thank you swuehl!

[#5]

I actually like $hidden tag better, gives you a bit more control but both ways works of course .

tag Fields _Dimension,_Metric,ReportName $hidden;