BookmarkSubscribeRSS Feed
vallsas
Pyrite | Level 9

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 

4 REPLIES 4
ali_jooan
Obsidian | Level 7

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 ..

vallsas
Pyrite | Level 9

Hi Ali_jooan,

 

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

 

thanks

ali_jooan
Obsidian | Level 7

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 ..

PeterWijers
Lapis Lazuli | Level 10

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

 

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

Tips for filtering data sources in SAS Visual Analytics

See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 4 replies
  • 2426 views
  • 0 likes
  • 3 in conversation