Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Framework Manager => Topic started by: ranne_78 on 17 Mar 2008 04:08:00 PM

Title: Nulls treatment
Post by: ranne_78 on 17 Mar 2008 04:08:00 PM
Hello,

We recently migrated from cognos 7 series to Cognos 8. There were some calculations in our
catalog are based on if-nullnumeric function which is not exist in cognos 8. If anybody had
replaced this function using any workaround? database is SQL Server.

Ranne
Title: Re: Nulls treatment
Post by: rockytopmark on 17 Mar 2008 10:26:47 PM
coalesce() is the equivalent
Title: Re: Nulls treatment
Post by: ranne_78 on 18 Mar 2008 08:19:10 AM
Hi Rockytopmark,

Thanks for your reply. Do you know any alternative function from Cognos side?

Thanks,

Ranne
Title: Re: Nulls treatment
Post by: rockytopmark on 18 Mar 2008 08:59:50 AM
coalesce() is an available function in Cognos... Framework Manager, Report Studio, etc.
Text only | Text with Images