COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: guitrman1001 on 17 Sep 2010 05:49:29 PM

Title: How do I hide a query result from Report
Post by: guitrman1001 on 17 Sep 2010 05:49:29 PM
I am running a query on locations but certain locations I don't want them to see the result
they need to be hidden for management over ride only.

For instance

I am running

[Files].[Warehouse Locations].[Location] = ?loc?

If the location they look up is lets say MISSING
I don't want it to show the result.

Thanks

Title: Re: How do I hide a query result from Report
Post by: RobsWalker68 on 18 Sep 2010 06:23:44 AM
Hi,

The most consistent way to handle this so that you apply it to multiple reports is to add data security within your framework model.  You can then apply a security filter to certain groups of users.

Have a look in the Framework Manager Guide in the section

Publishing Packages -> Security -> Add Data Security

Kind Regards

Rob