Topic
  • 2 replies
  • Latest Post - ‏2012-08-01T17:36:13Z by SystemAdmin
pjewett
pjewett
2 Posts

Pinned topic Using the MAX function in Cognos (not quite getting it to work)

‏2012-06-12T15:06:29Z |
Hi All

I'm fairly new to Cognos so this may be a rookie question. Using Cognos 7.3 Admin version, pulling from a SQL 2008 db.

We're a publishing company and as our books reprint again and again new "printings" for the same title (ISBN) are created in the db and all have among other items...a unique unit cost for each printing.

Unfiltered this report displays multiple records for each ISBN for each printing and thus multiple costs.

I'm trying to "pre-filter" the report to only give me ONE record for each ISBN.....the cost of the MAX printing number. However so far it looks as though the best I've been able to do is create a "summary" report that looks like...

ISBN Cost maximum (printing number)
0009996661
1.50 3
1.25
1.15 (this is the only cost I want..the latest)
When what I really want is...

ISBN Cost maximum (printing number)
0009996661 1.15 3
I got this result by creating a column expression....maximum (Printing Number) (screenshots attached)
Hope this is enough info to get the ball rolling...any help would be appreciated.

Thanks
Updated on 2012-08-01T17:36:13Z at 2012-08-01T17:36:13Z by SystemAdmin
  • yangling
    yangling
    38 Posts

    Re: Using the MAX function in Cognos (not quite getting it to work)

    ‏2012-06-12T18:50:40Z  
    Just a side note that Cognos 7.3, even 7.4 version, does not support SQL 2008 db. You are lucky you have done so far so good;-)
  • SystemAdmin
    SystemAdmin
    280 Posts

    Re: Using the MAX function in Cognos (not quite getting it to work)

    ‏2012-08-01T17:36:13Z  
    Hi,

    Within the Impromptu report, you need to put in a date/time field, or another type of data item that shows defiantly that the printing number is the newest number for ISBN then you would filter based of this field.