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?
Looks like this is a duplicate of this thread
Re: Row Level filter with a table linked to many reports - SAS Support Communities
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.