Print Page - security in report level

Title: security in report level
Post by: madhancog on 20 Jan 2010 11:09:37 PM

Hi Gurus,
I need to know is there any way we can secure our reports with out doing anything in FM & cognos connection.

Thanks in advance,
K.M

Title: Re: security in report level
Post by: MFGF on 21 Jan 2010 02:48:41 AM

Hi,

The only other option you have is security in the database.

MF.

Title: Re: security in report level
Post by: madhancog on 21 Jan 2010 02:56:21 AM

Thanks a lot for your kind reply....

Regards,
K.M

Title: Re: security in report level
Post by: Naven on 22 Jan 2010 07:43:20 AM

I think u can use #CSVIdentityNameList()# macro in your report filters.

Regards,
Naveen

Title: Re: security in report level
Post by: anilkumar on 23 Jan 2010 12:46:54 AM

HI

plese brief about report level security and steps
how to do it and where.

Regards
Anil k MARRI

Title: Re: security in report level
Post by: Sreeni P on 23 Jan 2010 02:08:22 PM

Yeah............do elaborate it ,to understand properly that how to use in the report

Title: Re: security in report level
Post by: Sreeni P on 25 Jan 2010 12:04:49 PM

Need update on this plz.........gimme the notes ASAP

Title: Re: security in report level
Post by: paddhu on 27 Jan 2010 12:41:41 AM

I have not worked on this practically, but I think you can give filters based on the CSVIdentityNameList function. Here is the technical notes on the same (from Cognos guides)

CSVIdentityNameList
Returns the pieces of the user's identity (account name, group names, role names) as a list of
strings. The unique list of values is returned as a string, where each value is surrounded by single
quotes and where multiple values are separated by commas.

Syntax
CSVIdentityNameList ( [ separator_string ] )
Example
#CSVIdentityNameList ( )#
Result: 'Everyone' , 'Report Administrators' , 'Query User'

After this, you can extract only the first string (from index 1 to the first occurence of ',') and define your filter. Hope this helps.

Title: Re: security in report level
Post by: Naven on 27 Jan 2010 02:08:06 AM

Hi Guys,

Sorry for the delay.Even I havent tried this practically in reports.

The filter condition can be [COLUMN_NAME] in #CSVIdentityNameList ( )#
For Ex: [SALES_PERSON] in #CSVIdentityNameList ( )#

But please note that the names in database table and the user groups (to which users or tagged to) created in Cognos Namespace has to be in sync.

Regards,
Naveen

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: madhancog on 20 Jan 2010 11:09:37 PM