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

[SASINDIA001]

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

1. 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.

[FredrikE]

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