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
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 ..
Hi Ali_jooan,
is there any technique to hide/mask the columns (as you said mask developement data)?
thanks
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 ..
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
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.