Universe level Restrictions are working only for Measure objects

[former_member188264]

BO (UDT) Version : 4.1 (14.1)

In Universe we have applied Access Level Restrictions to restricts rows/records (Tools--> Manage Security ---> Manage Access Restrictions --> Row)

We have applied filter condition/ Restrictions like Table.Column IS NOT NULL (Employee.Employee_ID IS NOT NULL)

This restriction (filter condition) is only comes into picture in report only if I select any MEASURE object from the table (Employee table or any other table which is joined with Employee) . If I use only Dimensions objects in report this restriction is not coming in report in filter conditions.

Im wondering if is there any setting which is not allowing restrictions/filter to come in report if I select only Dimensions.

[sateesh_kumar1]

Hi Sagar ,

Row level restrictions are meant to work like a where condition on object for user / user group .

Ex: Display only country=AUS rows to Usergroup1 and so on..

for your requirement , use filter at webi query panel(very simple) or create condition at universe .

Thanks

[former_member188264]

Thanks Sateesh for response. I am aware that this works like Where condition. My question is different, why Universe level restrictions are not reflecting in report when I select ONLY Dimensions object (It is reflecting when I select any measure object along with dimensions)