Print Page - Total for last hour

Title: Total for last hour
Post by: RGascoigne on 12 Sep 2017 09:05:22 AM

Hi Cognos Guru's,

I am creating a dashboard and want to show total Quantity achieved in the last hour. I can't find a way to show do I get data from the last hour when refreshing the dashboard? Any suggestions?

Thanks,

Rob

Title: Re: Total for last hour
Post by: New_Guy on 12 Sep 2017 09:56:14 AM

Hi,
Do you have a time or date column in the dashboard object? if you have a column with a time then you can add filter on that column as [Time and date column] = _add_hours(current_timestamp,-1). Try it and let us know if this hepls. You might have to tweak it as per the formats you have with your data.
Good luck
New guy

Title: Re: Total for last hour
Post by: RGascoigne on 13 Sep 2017 02:35:14 AM

I have [DATE_TIME_STAMP]

Put the below in

[DATE_TIME_STAMP] = _add_hours (current_time , -1)

Tired in Detail filters and summery filters.

This returned a few error when Validating.

UDA-QOS-0006 Error
UDA-SQL-0460 A general exception has occurred during local processing
UDA-EE-0094 The operation "equal" is invalid for the following combination of data types of data types: "timestamp2" and "timeTZ"

Title: Re: Total for last hour
Post by: Invisi on 13 Sep 2017 04:43:48 AM

I have something similar with date types. Which database do you have for your underlying data warehouse?

Title: Re: Total for last hour
Post by: New_Guy on 14 Sep 2017 11:28:53 AM

Hi,
We have to use between for this situation. [Date Time Column] between current_timestamp and _add_hours (current_timestamp , -1). Can you post a screen shot of your time column? In some cases you have to create data items for current and current - 1 hr and then you can use them in the filter condition.
Good luck
New guy

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: RGascoigne on 12 Sep 2017 09:05:22 AM