Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: GeorgeBush on 23 Aug 2007 06:33:54 AM

Title: Cognos8-Getting coercion error while using built-in Functions.
Post by: GeorgeBush on 23 Aug 2007 06:33:54 AM
Our database is dimensionally modelled. When built-in functions like _add_days are used,
coercion error occurs at the report levelthough the expression is getting validated in the expression editor.
The Expression used is {cast([Period],date)-{_add_days(cast([Period],date),-84)}}
The error displayed is" QE-DEF-0459 Invalid coercion from level to date".Here Period is the Level in a Hierarchy.
Title: Re: Cognos8-Getting coercion error while using built-in Functions.
Post by: COGNOiSe administrator on 23 Aug 2007 11:01:55 AM
Why curly brackets?
Text only | Text with Images