Exploring, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

Visual analytics columns hiding

Reply
Frequent Contributor
Posts: 88

Visual analytics columns hiding

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 

Contributor
Posts: 29

Re: Visual analytics columns hiding

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

Frequent Contributor
Posts: 88

Re: Visual analytics columns hiding

Posted in reply to ali_jooan

Hi Ali_jooan,

 

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

 

thanks

Contributor
Posts: 29

Re: Visual analytics columns hiding

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

Regular Contributor
Posts: 191

Re: Visual analytics columns hiding

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

 

Ask a Question
Discussion stats
  • 4 replies
  • 366 views
  • 0 likes
  • 3 in conversation