Topic
  • 3 replies
  • Latest Post - ‏2013-02-13T21:24:37Z by DanielWagemann
Senators
Senators
37 Posts

Pinned topic Cognos 8 - Create report that compares values

‏2013-02-13T15:48:27Z |
Hello

I have a request for the following:

  • A user would like a report returned when the Volume is the same over 5 intervals (by hour)
  • When the values for Volume are the same for 5 consecutive hours, return it in the report. (This is an exception report, seen as a negative)

Volume is an integer field
Hours is an integer field
Date is a date time

I was looking at the interval function. I'm a bit confused in the best approach. Can someone recommend something?

Thank you
Updated on 2013-02-13T21:24:37Z at 2013-02-13T21:24:37Z by DanielWagemann
  • SystemAdmin
    SystemAdmin
    15496 Posts

    Re: Cognos 8 - Create report that compares values

    ‏2013-02-13T16:19:15Z  
    You can refer our website for details
    SegmentIB consulting Services INC
    http://www.segmentbi.com/index.php/about-us/blogs
  • Senators
    Senators
    37 Posts

    Re: Cognos 8 - Create report that compares values

    ‏2013-02-13T16:23:45Z  
    You can refer our website for details
    SegmentIB consulting Services INC
    http://www.segmentbi.com/index.php/about-us/blogs
    Which post exactly in the blog is relevent to my question? your link only takes me to the main page.
  • DanielWagemann
    DanielWagemann
    411 Posts

    Re: Cognos 8 - Create report that compares values

    ‏2013-02-13T21:24:37Z  
    How are you determining what the last 5 intervals are?

    Is it based on the hour of current time? Do you need to account for a time period that crosses days?

    Is the query that contains the interval limited via a filter to just the 5 values or does it have all intervals.

    With the answers to the above I may be able to help further.