How do I hide a query result from Report

[guitrman1001]

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

[RobsWalker68]

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