Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: sg@sfwater on 22 Dec 2016 02:40:15 PM

Title: Filtering by date and time
Post by: sg@sfwater on 22 Dec 2016 02:40:15 PM
I am using Cognos 10.2 and I'm having trouble filtering the time associated with my date prompt.  I want to average the data for the date range picked on the prompt page from 12:01 AM to 11:59 PM.  This is what I have so far:

[History Version].[History Version].[Date/Time]between ?StartDate? and ?EndDate?

When I try to enter the time range I get an error.  Can anyone help with this?


Thanks
Title: Re: Filtering by date and time
Post by: MFGF on 23 Dec 2016 01:59:58 AM
Quote from: sg@sfwater on 22 Dec 2016 02:40:15 PM
I am using Cognos 10.2 and I'm having trouble filtering the time associated with my date prompt.  I want to average the data for the date range picked on the prompt page from 12:01 AM to 11:59 PM.  This is what I have so far:

[History Version].[History Version].[Date/Time]between ?StartDate? and ?EndDate?

When I try to enter the time range I get an error.  Can anyone help with this?


Thanks

Ummmmmmmmm.... Ahhhhhhhhhhh...... Mmmmmmmmmmmmm....

Nope. It's not working. My clairvoyance hat isn't giving me any success today, no matter how hard I try to focus my mind.

Sadly we're going to have to do this the good old-fashioned way. You're going to have to tell us what the error message is, as the hat is stubbornly refusing to work.

MF.
Title: Re: Filtering by date and time
Post by: Lynn on 23 Dec 2016 02:07:41 AM
(https://upload.wikimedia.org/wikipedia/en/2/21/Carnac.jpg)
Title: Re: Filtering by date and time
Post by: bdbits on 23 Dec 2016 10:47:12 AM
 ;D  ;D  ;D  ;D  ;D  ;D  ;D  ;D  ;D  ;D  ;D  ;D
Title: Re: Filtering by date and time
Post by: sg@sfwater on 23 Dec 2016 11:03:10 AM
error is  CAF-WRN-2082 An error has occurred. Please contact your administrator. The complete error has been logged by CAF with SecureErrorID:2016-12-23-08:59:54.174-#1577
OK
Title: Re: Filtering by date and time
Post by: Andrei I on 23 Dec 2016 12:50:59 PM
Please recreate the same issue in a simplified report against Cognos Samples and publish report source.
Title: Re: Filtering by date and time
Post by: bdbits on 02 Jan 2017 10:15:21 AM
sg@sfwater, when you get errors like that you need to have your admin check the cognos log, which will undoubtedly contain more information.
Title: Re: Filtering by date and time
Post by: prikala on 03 Jan 2017 01:30:13 AM
Quote from: bdbits on 02 Jan 2017 10:15:21 AM
sg@sfwater, when you get errors like that you need to have your admin check the cognos log, which will undoubtedly contain more information.
And if your admin is feeling lazy, he/she can grant you the "Detailed Errors" capability.
Then you get the actual error message instead of "...Please contact your administrator. The complete error has been logged by..."
Saves time...
Text only | Text with Images