Skip to Content
Former Member
Feb 15, 2016 at 04:58 PM

Multiple data security profile filter


Dear community,

though I searched SCN and found some documents that seem to cover my problem (like SAP BI 4.1 SP5 IDT Business Security & Data Security Profile Filter Implementation ), the solutions provided there do not work out for me.

Using SAP BO 4.1. SP5, I want to build multiple Data Security Profiles for row level security with following requirements:

Filter is applied on only one dimension, [Company]. A user can belong to several user groups, each group is allowed to retrieve information for just one company.

Filter for each security profile looks this: "[Company] = 'Company_A'"; or "[Company] = 'Company_B'"

Everything is fine as long as a user belongs to only one group. But if a user is assigned to 2 or more groups, the queries do not retrieve any values. This is because the WHERE clause in the query looks like:

WHERE ("[Company] = 'Company_A'") AND ("[Company] = 'Company_B'")

which obviously prevents any data to be retrieved. I also tried "IN" as a filter condition ([Company] IN ('Company_A')), but it didn't work out either.

Has anyone an idea how to solve this issue?

Thanks in advance,