If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Cognos8-Getting coercion error while using built-in Functions.

Started by GeorgeBush, 23 Aug 2007 06:33:54 AM

Previous topic - Next topic

GeorgeBush

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.

COGNOiSe administrator