OBIEE Security Variables3 2014 08 17 08 27

[@manjit534]

I suppose You can also do this in case of row wise initialization: Ex: If a Salesrep X belongs to a single region called Hyderabad, as you said, You can straight forward go with a Session IB without RowWise. Because, a variable doesn't have to hold multiple values. If Y belongs to multiple regions called Hyderabad and Delhi and Z belongs to Bangalore and Chennai. CUSTOMER Salesrep Region Dollars X HYDERABAD 500 Y DELHI 750 Z Bangalore 1000 Y HYDERABAD 1250 Z CHENNAI 800 Then we can also write the Session IB as follows: SQL: Select 'RowWise', region from customer where Salesrep = ':USER' Above RowWise is a variable that is defined within the sql. All you have to do is enable row wise. Give the data filter for Y and Z users as follows: Region=VALUEOF(NQ_SESSION.RowWise). If Y Salesrep logs in, he will see Hyderabad and Delhi under region column. Bangalore and Chennai for Z user.