Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I have a dimension with 30 field.
May i know how to hide one of the dimension "_DESC" ? So that user are unable to click on this field and drill in to view the report , only i am allow to click on this .
Because if they are able to click on the _DESC as dimension , they can view some of the confidential information.
Paul
In Section Access you can use OMIT for the Particular user to avoid him to see _DESC Dimension .
my QV Doc
One solution could be to use this if statement for the expression:
=If([Pls select 101st Dim] <> '_DESC', [Pls select 101st Dim])
But the issue remains that the option is still available and if someone creates a new list box for [Pls select 101st Dim] then they will still see _DESC. The only way to remove that would be to remove it during the load so that it is just not available in the application.
HTH
Best,
Sunny
In Section Access you can use OMIT for the Particular user to avoid him to see _DESC Dimension .
Hi Paul
If you are talking about a dimension within a table could you not clone the table and then restrict which table the user sees based on their login via section access?
Kindest Regards
Brian
Hi Sunny
Thank you very much for your sharing , while driving back After my dinner , I found a solution , that is I will use mapping to recode all those sensitive field into one common word like salary , so that user even drill in unable to view the detail break down. So it is okay.
Paul
Sent from my iPhone
Good suggestion.
Sent from my iPhone
Thank you for the suggestion. I will try it out
Sent from my iPhone