Skip to Content
0
Former Member
May 05, 2016 at 11:51 AM

Hierarchy LOV not working in webi if we have data security profile assinged to the UNX

52 Views

Dears,

I would like to get a suggestion from you guys.

Environment is as below:

We are using SQL Server as Back end and we have developed universes on that, Universes have list of values and security profiles attached to them, LOV are:

unit

department

section

team

sub team

When i attached this universe to a webi document, and place the above dimensions in quick filter bar, upon selecting unit, it gives whole list of department instead of just the departments which are related to selected unit dimension.

Any words on it are highly appreciated.

Thanks in advance.