topic Hide columns for certain users in a SAS Information Map in SAS Web Report Studio

Hide columns for certain users in a SAS Information Map

CarlS — Wed, 14 Dec 2011 10:45:51 GMT

Dear All,

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 ?

Kind regards

Carl

Hide columns for certain users in a SAS Information Map

sks — Tue, 03 Jan 2012 17:45:55 GMT

Carl,

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.

Shri

Hide columns for certain users in a SAS Information Map

Madelyn_SAS — Tue, 03 Jan 2012 18:11:28 GMT

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.

Hide columns for certain users in a SAS Information Map

marius_sommerseth — Fri, 13 Jan 2012 14:48:57 GMT

Hi Carl,

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,

Marius

Re: Hide columns for certain users in a SAS Information Map

MicheleS_SAS — Fri, 17 Aug 2012 13:39:40 GMT

Hi CarlS,

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

Michele