How can we add different a row level security for different reports using same LASR table.

SASINDIA001 — Tue, 19 Dec 2017 08:58:45 GMT

Hi ,

We have a situation where we need to create a series of reports with different levels of overlapping security. Data looks like shown below.

Account L1 L2 L3 Business Segment Business Segment Head

A1 E101 E201 E301 S1 E302

A2 E101 E201 E301 S2 E302

A3 E102 E201 E301 S3 E302

A4 E103 E202 E301 S3 E301

A5 E104 E202 E301 S4 E301

Report 1(Employee Level Hierarchy Based Report):- This is a report based on different reporting levels in the Employee Hierarchy of the organization. For example employees at level L1 is junior most employee. Employees at L2 are typically managers of L1 employees. Further, Employees at L3 are managers of L2 employees and so on…

So in this report the report should show only the accounts that are associated with corresponding employees.

Account Visible to

A1 E101 and E201 and E301

A2 E101 and E201 and E301

A3 E102 and E201 and E301

A4 E103 and E202 and E301

A5 E104 and E202 and E301

2. Report for Segment Head : This is a Business Segment based report in which a particular account should be seen only to corresponding segment heads. Some of these segment heads are also Level 3(L3) employee shown above. Hence there is clearly an overlap.

Account Visible to

A1 E302*

A2 E302*

A3 E302*

A4 E301

A5 E301

*please note account A1,A2 and A3 are visible to Employee E301 in Report 1, but should not be visible to him in Report 2.

Now we have one common LASR table on which both these reports are based. The table size 2.1 GB Approx. and will get updated on Daily basis. Question is how can we add different a row level security for different reports using same LASR table.

Re: How can we add different a row level security for different reports using same LASR table.

FredrikE — Wed, 20 Dec 2017 07:45:44 GMT

One solution could be to have separat tables for each report with different row level security in each of them and then in each report you link one of the RLS tables to the data table,

I dont know if this will be enough for you but maybe worth a try 🙂 ?

//Fredrik

topic Re: How can we add different a row level security for different reports using same LASR table. in SAS Visual Analytics

How can we add different a row level security for different reports using same LASR table.

Re: How can we add different a row level security for different reports using same LASR table.