If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Filtering According to Login

Started by neilunderwood, 12 Jan 2007 04:53:29 AM

Previous topic - Next topic

neilunderwood

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?

alex11343

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.

ajax6262

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?

MDXpressor

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.

No, a proof is a proof. What kind of a proof? It's a proof. A proof is a proof, and when you have a good proof, it's because it's proven.

-Jean Chretien

mrcool

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

bdybldr


angelicgibson

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