Print Page - Issues using current

Title: Issues using current_date/{sysdate}
Post by: AR_Cognos_Enthusiast on 28 Aug 2020 08:50:36 AM

Hello everyone,

I have the following problem:

I am using a date filter in a report that uses a parameter from a date prompt:

p_date between [date_from] and [date_to].

This filter runs smoothly and the report is done in 2 minutes.

However, if I use the current_date or {sysdate} function instead of p_date, the report keeps running and does not finish.(There is no error massage either)

Has anyone of you experienced similar problems and can help me out?

Thank you very much in advance and kind regards,
AR

Title: Re: Issues using current_date/{sysdate}
Post by: David_Efr on 30 Aug 2020 03:56:26 AM

Is the SQL code for the query properly generated?

Title: Re: Issues using current_date/{sysdate}
Post by: AR_Cognos_Enthusiast on 31 Aug 2020 04:35:13 AM

Hello,

thanks for the reply.
Yes, it is.

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: AR_Cognos_Enthusiast on 28 Aug 2020 08:50:36 AM