Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS ReportNet => Report Studio => Topic started by: acabugason on 05 Oct 2007 10:51:13 AM

Title: Row Level Security in Report Studio
Post by: acabugason on 05 Oct 2007 10:51:13 AM
Hi all -

I have a requirement to provide row-level security to a report. I've tried a number of things in Framework Manager as well as Report Studio but can't seem to get it going.

I know row-level security can be achieved using a third party security software such as LDAP but unfortunately, we don't have that. Currently, I am experimenting with both a DMR and a cube as my sources.

Any ideas?

Thanks!
Title: Re: Row Level Security in Report Studio
Post by: MFGF on 05 Oct 2007 11:45:59 AM
Hi,

Row-level security is normally implemented by adding security filters to objects in Framework Manager.  Have you tried this?

Regards,

MF.
Title: Re: Row Level Security in Report Studio
Post by: acabugason on 05 Oct 2007 12:48:12 PM
MFGF,

I haven't tried that. How's that done?

thanks
Title: Re: Row Level Security in Report Studio
Post by: raj_tumati on 02 Nov 2007 06:41:43 AM


Hi,
      its  implemented by adding security filters to objects in model in the frameworkmanager
Title: Re: Row Level Security in Report Studio
Post by: rockytopmark on 02 Nov 2007 05:56:46 PM
1). In FM, locate the Query Subject you wish to filter, and click to select it.
2). Click the Actions menu and select "Specify Data Security"
3). Add Filters as needed. 

Generally, you will utilize information that is available in the session parameters for the Authenticated User.  In Security Filter's expression dialog, you have access to the available parameters.
Text only | Text with Images