Solved

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

Posted on 2014-02-04
2
419 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

PL/SQL can be a very powerful tool for working directly with database tables. Being able to loop will allow you to perform more complex operations, but can be a little tricky to write correctly. This article will provide examples of basic loops alon…
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.

717 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