Thanks The users find all there data through metadata/SAS Folders. I can teach them to go look at the serverlist and find data through libname, when they are looking for data created by other users, and not data from the dwh. But it is inconsistant, to have data listed in two different areas. :smileyplain: But I asked for best practice, and it is a better solution then what we are doing today. So thanks for the help! ... View more

Made a libname where the team has read and write access. Anthony is able to store data in the library. But the data don't show up in SAS Folders. Anthony has to run the Update Metadata on the library, before it shows up. Is this still part of best practice? For the user it seems like unnecessarystep. And to delete data, the user has to run task "Delete data set and formats" and then Update Metadata again. In almost every other programs you can just right click and select "Delete" or somthing that easy. ... View more

I have used the theme designer to create a style that has a more clean look and uses the company colors. Most important: company logo at loading screen logo and color of banner white background table header (olap table has to be changed directly in the xml-file) colors on graphs data style and then setting different elements to white (as background) to get a more clean look. The theme designer (v.6.3) is easy to use except changes to the OLAP-table. I would like to be able to make changes to the OLAP-table directly in the designer to change the log on screen barchart.direction = vertical remove barchart.axisline top/right barchart.outlines And it would be nice if the users have access to default company colors when he/she is making changes en the report designer.As for now the users have to type in color HEX codes in the Custom Colors pane. The new theme: va denmark.pdf - Google Drive ... View more

There was a similar discussion earlier. But no good solution. And remember, when you have multiple sections in a report, the user have to adjust the period on every section. The user will often miss this, and instead get the wrong information form the report. ... View more

I have the same problem, and have not found a way around. I don't think that Visual Analytics is intended for bench marking. For now the best solution I could come up with is to display two separate graphs. The left shows average of the hole population and the one to the right shows the department itself. In the back there are two tables with the same data. But the table that I use on the right has row-level-security so that the user only get access til the departments own data. ... View more

Take a look at the batch-tools. SAS(R) 9.4 Intelligence Platform: Security Administration Guide, Second Edition The you are able to use commands like this ./sas-set-metadata-access -host servername -port 8561 -user USERNAME -password PASSWORD "Table" -grant "SalesUsers":Read -condition '("rbs-"|| departmentname) IN ("SUB::SAS.IdentityGroups")'  ... View more

In VA 6.1 you can write expressions like this ("rbs-"|| departmentname) IN ("SUB::SAS.IdentityGroups") OR "rbs-FullAccess" IN ("SUB::SAS.IdentityGroups") If the user is member of the group "rbs-Sales" then they will have access to all rows where departmentname = 'Sales'. I have a extra condition that allows users in the group 'rbs-FullAccess' to read all data. There are other identity driven properties like SAS.Userid SAS.Personname, SAS.IdentityName that you can use. BTW: In VA 6.2 and 6.3 (and maybe even later versions) SAS have removed the option to write expression, and replaced the editor with a drag-and-drop editor, and you can not use identity driven properties. There is a workaround. You can activate the old editor on a table with a command like this ./sas-set-metadata-access -host servername -port 8561 -user USERNAME -password PASSWORD "Analytical LASR Data - Sandbox/SALES(Table)" -grant "SalesUsers":Read -condition '("rbs-"|| departmentname) IN ("SUB::SAS.IdentityGroups") OR "rbs-FullAccess" IN ("SUB::SAS.IdentityGroups")' ... View more