topic Re: Visual analytics columns hiding in SAS Visual Analytics

Visual analytics columns hiding

vallsas — Thu, 02 Nov 2017 07:01:56 GMT

Hi All,

I would like to check whether can we hide the columns in VA?

Even developer should not see these columns data (Like descriptive columns(name , address, phone , city))

developer can generate the report by using id, age,salary,married status,education and he drag the other columns (name,address,phone,city) but should not see the data.

once developer generate the report then the report will go to admin, then admins decision whether he can give access to end-user should see this information or not from this report. If admin approves then end-user can see the report.

Its customized specific type of report. where as it not like normal report where we generate the report and giving particular user access to see it.

here admin who approves the specific columns permission to the end-user.

something new which we do in

Re: Visual analytics columns hiding

ali_jooan — Fri, 03 Nov 2017 03:40:14 GMT

you need to mask the development data before giving it to the developers ... VA can do row level security to hide some rows but in your case you need to hide some columns and thus VA can't do column level security it will never hide any columns from users ..

Re: Visual analytics columns hiding

vallsas — Fri, 03 Nov 2017 14:21:59 GMT

Hi Ali_jooan,

is there any technique to hide/mask the columns (as you said mask developement data)?

thanks

Re: Visual analytics columns hiding

ali_jooan — Sat, 04 Nov 2017 13:28:23 GMT

it depends case to case .. if you just want to hide names and contact details .. you can replace the originals with either nulls or junk data .. search online or contact your data management team ..

Re: Visual analytics columns hiding

PeterWijers — Sat, 04 Nov 2017 18:01:26 GMT

Hi There,

as already mentioned, hiding columns is not yet supported.

In stead of using different columns, you could add some Demo records to the database with a clear marked key.

For developer you only allow data access to these record. (So the reports is already ok for use)

If the admin agrees, he just has to allow the Actual planned users to read the real data. (excluding the Demo records)

This might solve your problem easily.

greetings Peter