12-14-2011 05:45 AM
I have a field that I use in an information map and that should not be seen by some users. How can I hide this ? Is there the possibility for column level security in the information map studio ? if not, what is in your oppinion a good workaround ?
01-03-2012 12:45 PM
How are the users accessing the SAS information map. If you have created a web report using the information map, then you can create a report specifically for these users and let them see the field and probably another report for the rest of the users without the specific field.
01-03-2012 01:11 PM
Column-level security is not supported (http://support.sas.com/kb/45/094.html). You will have to create a different information map for each set of users.
01-13-2012 09:48 AM
You unforunately can't hide (as this would change the Metadata making the report invalid), a workaround would be to set all of the values in this column to something else (for instance missing). So som users see the data, others don't.
I would do it in one of two ways:
- Use a STP in the Information Map to subset the data (set the column to " " for instance). See http://support.sas.com/kb/39/432.html.
- Create a underlying view that either uses a lookup table or a variable (for instance the username) to show a empty column for some users, and the original column for others and then create the Information Map on this view instead of directly on the table.
Have a great weekend,
08-17-2012 09:39 AM
I've found this article, maybe it could be useful to you: http://www.zencos.com/2012/04/column-level-security-for-web-reports/
You have to create two infomap and two reports