COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: bartburg on 10 Nov 2015 03:56:38 AM

Title: ORA-01704: Stringconstante is to long.
Post by: bartburg on 10 Nov 2015 03:56:38 AM
Hi

i want to use # CSVIdentityNameList ( ) # to get a list cognos specified groupnames so i can set the following

case when [xxx] in # CSVIdentityNameList ( ) #
then [name]
else null
end

when i try to do this i get error involving the string lenght.

is there a easy way to get only cognos specified groups for a cognos user?

we use single signon so i think iam getting the full ad list wich i dont want!

Title: Re: ORA-01704: Stringconstante is to long.
Post by: Francis aka khayman on 10 Nov 2015 07:43:13 PM
not sure if this will work and this is a crude solution. to break the string in three parts using substring function
Title: Re: ORA-01704: Stringconstante is to long.
Post by: bartburg on 11 Nov 2015 06:44:45 AM
Could you give me an example?