COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: HERRERA on 23 Jan 2009 11:47:15 AM

Title: Substring with dimensional source
Post by: HERRERA on 23 Jan 2009 11:47:15 AM
Can i use substring with dimensional sources ?

Im tying this : substring(caption([Month Long Name]);1;3)

Appear following : Invalid coercion from 'string' to 'member'..

What can i do ?

Tks,

Herrera
Title: Re: Substring with dimensional source
Post by: unnava on 23 Jan 2009 11:37:25 PM
hi

    u try  substring([Month Long Name],1,4)