Solved

IBM COGNOS Report Query Question:  Limiting a list to only the latest entry for a given MsrCd

Posted on 2014-02-04
2
412 Views
Last Modified: 2014-02-05
In a Performance Measure History table is a list of when the users periodically key in their  info regarding their targets.
However, for most of the requested reports all that is wanted is the latest entry for a given Measure.  Measures are uniquely identified with a MsrCd#.
The History table not only has a unique date/time of entry, but each entry in the table creates a unique sequential ID.
None of the reports want to see either the entry date, MsrCd or the ID, and I have unsuccessfully been attempting to -behind the scenes- create such a filter, via “Data item”,  “Filter”, Query Calculation, etc. using the below syntax.  On occasion the syntax gets approved, but I do not accomplish my goal.

maximum ( [PM View prd].[DataTarget History].[ID]  for  [PM View prd].[DataTarget History].[MsrCd]  )

Assistance please.
0
Comment
Question by:willjx
2 Comments
 
LVL 12

Accepted Solution

by:
RWrigley earned 500 total points
ID: 39835267
Probably the easiest way I can think of is to create a dataitem like:
rank([PM View prd].[DataTarget History].[ID]  for [PM View prd].[DataTarget History].[MsrCd]  )

Then add a detail filter for [rankMSR] = 1
0
 

Author Closing Comment

by:willjx
ID: 39836536
Thank you very much.
You just saved me innnumerable hours of trial and error attempts. I was totally on a different track.
0

Featured Post

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

As they say in love and is true in SQL: you can sum some Data some of the time, but you can't always aggregate all Data all the time! Introduction: By the end of this Article it is my intention to bring the meaning and value of the above quote to…
'Between' is such a common word we rarely think about it but in SQL it has a very specific definition we should be aware of. While most database vendors will have their own unique phrases to describe it (see references at end) the concept in common …
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

773 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question