Dashboard Filter Prompt - Restricting drop down values based on logins
xarg-XrcOct 27 2011 — edited Oct 28 2011Hi All,
Is it possible to restrict dashboard prompt values based on user login?
For example I have 3 users: John, David and Administrator.
I got 5 values for my dashboard filter: Site 1, Site 2, Site 3, Site 4, Site 5 all in a drop down.
I want to make sure that John can only have Site 1 and Site 2 in his drop down prompt while Administrator have all 5 sites when they login and click on the drop down.
Had a good look around BI Answers where you create filters, can't see any such mechanism to link users with dashboard values (list populated with a SELECT * SQL query against database).
Would appreciate any advice if this is at all possible.
I am using internal authentication and BI 10.1.3.4.1
Cheers