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.
... View more