security in report level

[madhancog]

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

[MFGF]

Hi,

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

MF.

[madhancog]

Thanks a lot for your kind reply....

Regards,
K.M

[Naven]

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

Regards,
Naveen

[anilkumar]

HI

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

Regards
Anil k MARRI

[Sreeni P]

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

[Sreeni P]

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

[paddhu]

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.

[Naven]

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