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:
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.