COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Security => Topic started by: vished on 25 Oct 2016 06:48:15 AM

Title: CSVIdentityNameList()# - reduce number of entries
Post by: vished on 25 Oct 2016 06:48:15 AM
Dear all,

I would like to reduce the number of entries from the output from the CSVIdentityNameList()#)
[Database View].[COMPANY] IN (# CSVIdentityNameList()#)

I need only a list of my companies like "ABCD" (4 digits code)

Currently I have a lot of not is use entries from the Active Directory.
Is there a way to remove all those groups?

Thank you very much for your help