I have a requirement from a client where they would like certain data filtered out of a report if a particular user is logged in, to prevent that user from seeing data of a certain category. I'm pretty sure it's possible to do this by adding filters either to the report or to the data model but I'm not sure how to go about doing it. Can anybody help?
I'm interested in this one too as I got a problem much alike.
if anyone could help us on this one, it'd be most appreciated.
Are you looking at filtering for 1 particular user, and all other users can see everything, or setting up a report so that anyone who runs the report will only see "their" information?
In FM, when you create a security filter, you apply it to a query subject, and the add teh groups and roles to which the securty filter will be applied. For each group or role, you can create filter expression that will be used to filter data for that group or role. These filter expressions can incorporate macros, parameter maps and session parameters.
Create some security table with one column for user name n 1 for level and last for name of the level.Now join this with the dimension on which the data needs to be filtered. U can also use the approach said by MDXpressor
#sq($account.defaultName)#
I am having a similiar issue against a Microsoft cube. We are using Active Directory for security. Has anyone tried using data security in Report Studio against a Microsoft cube. I have added a new dimension/relationship to the cube by "user". The dimension that the security is applied on has multiple levels. Access can be granted on various levels. I obtain the Active Directory ID from #sq($account.defaultName)#. I match the "caption" value of the dimension user to the value returned from #sq($account.defaultName)#. The report comes up empty....any ideas....