Hello,
based on a Cognos group of a user I would like to do some actions. So i tried the following:

#CASE csv(grep('anyCognosGrouop';split(';';CSVIdentityNameList(';')));';';'')
WHEN 'anyCognosGrouop' THEN '1'
ELSE csv(grep('anyCognosGroup';split(';';CSVIdentityNameList(';')));';';'')
END#
---Result: anyCognosGroup

Can you help me why the "ELSE-Statement" is executed, even though I match the exact string in the WHEN-Clause?

Thanks a lot,

Ole

------------------------------
Ole Schmidt
------------------------------

#CognosAnalyticswithWatson

Here is an example that I use within FM for data blinding, depending it the User exists in a Role Called Company A.
If the user exists in the Role Company A, then show the field Race, otherwise show asteroids for data blinding.

if ( ( 'Company A' in (#CSVIdentityNameList()#) ) )

Then ([Physical View].[Member_Composite].[Race_1_Cd_Desc])

Else ( '***' )

------------------------------
Michael Matson
------------------------------