Row Level Filter with a table linked to many reports

gemi — Thu, 17 Nov 2022 19:46:59 GMT

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?

Re: Row Level Filter with a table linked to many reports

gemi — Sun, 20 Nov 2022 09:10:09 GMT

Anyone?

Re: Row Level Filter with a table linked to many reports

SASKiwi — Sun, 20 Nov 2022 21:57:05 GMT

If your query is urgent then please open a Tech Support track for your issue.

Re: Row Level Filter with a table linked to many reports

Sajid01 — Tue, 29 Nov 2022 02:32:36 GMT

Looks like this is a duplicate of this thread
Re: Row Level filter with a table linked to many reports - SAS Support Communities

topic Re: Row Level Filter with a table linked to many reports in SAS Visual Analytics

Row Level Filter with a table linked to many reports

Re: Row Level Filter with a table linked to many reports

Re: Row Level Filter with a table linked to many reports

Re: Row Level Filter with a table linked to many reports