WebI Publication: Logical OR in Profile Values

[Former Member]

Hello,

In my WebI publication I am using profile values, which I defined for every user.

For example I have two profiles: "Employee City" and "Sales City". For my user I defined the the values Employee City=New York, Sales City=New York.

How can I define an logical OR between those profiles, so that a row shows up in the report, if the dimension [Employee City]="New York" OR [Sales City]="New York"?

I am using BO 4.0 SP7 Patch 2

Thanks!

[Former Member · Accepted solution]

The only solution would be implementing in with Row Level Security. Or has anyone a better idea?

Thanks!