Print Page - Coercion error after upgrading from 8.2 to 8.4

Title: Coercion error after upgrading from 8.2 to 8.4
Post by: Bob_T on 20 May 2009 12:59:47 PM

Hi all,

I have a report that has a field called [Month Short]. This field contains short month names from 'Jan' to 'Dec'

I have another field called [April 1] which is a single string saying 'Apr 1'

In Cognos 8.2, I was able to use the following calculation to add add 'Apr 1' to the [month Short] field inside a query:

union([April 1], [Short Month])

I am now receiving the following:

Invalid coercion from 'string' to 'memberSet' for '[April 1]' in 'union([April 1],[Reporting Structure].[Time].[Month Short])'.

My model is Realational and does not cotain levels, members....

Any idea how I can surpass this error? I have tried everything I can think of including writing my own SQL and I still get errors.

Thanks very much.

Title: Re: Coercion error after upgrading from 8.2 to 8.4
Post by: blom0344 on 22 May 2009 05:09:07 AM

Try article 1376464 in the Cognos KB:

http://www-01.ibm.com/software/data/cognos/support/search.html

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: Bob_T on 20 May 2009 12:59:47 PM