Hi, I have this situation:
User1 has the authorization to view just 2 reports, named REPORT_A and REPORT_B. Of course, the authorizations are not assigned directly to the user but to the groups to which he belongs (GROUP_REPORT_A and GROUP_REPORT_B).
Both reports are built with few tables and they have a table in common, named TABLE_X.
This TABLE_X has a lot of data, columns, rows.. but has a column identifying city names, named NAMENATION.
For example, this column has values like "Paris", "Milan", "New York"...
I would set authorizations so that when User1 opens REPORT_A , he will see the report without any filters. But when he opens REPORT_B, he will see the report filtered by NAMENATION.
I have setted authorizations on TABLE_X in this way:
GROUP_REPORT_A: ReadInfo --> Grant ; Select --> Grant
GROUP_REPORT_B: ReadInfo --> Grant ; Select --> Row-Level Grant (NAMENATION = 'Paris').
Unfortunately in this way, User1 always sees, for both records, all the data without filters.. where am I wrong?
If your query is urgent then please open a Tech Support track for your issue.
Looks like this is a duplicate of this thread
Re: Row Level filter with a table linked to many reports - SAS Support Communities
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
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.