COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Business Insight / Cognos Workspace => Topic started by: hschembri on 30 Jul 2014 07:24:27 AM

Title: Error: To prevent unexpected results.....
Post by: hschembri on 30 Jul 2014 07:24:27 AM
I have successfully created a report with a prompt page. When I come to the workspace, I drag the cross tab component of the report and than my prompt page and on apply of the filter, I get the error:

To prevent unexpected results, this widget is not currently responding to prompts.

Screenshot below:
https://drive.google.com/file/d/0B13O4Lr3CqAlcmttcS1TYTFzbVE/edit?usp=sharing

I am using IBM Cognos Workspace 10.2.1.
Title: Re: Error: To prevent unexpected results.....
Post by: vkraju on 06 Nov 2014 02:05:21 PM
using "CAST" instead of to_date or to_char in the filter fixed the issue.

Example
cast([Presentation Layer].[Calendar].[Date Time], varchar(50) )  between (?p_dur_from?) and  (?p_dur_end?)