<div>
Thank you very much.<br />
You just saved me innnumerable hours of trial and error attempts. I was totally on a different track.
</div>


Thank you very much.
You just saved me innnumerable hours of trial and error attempts. I was totally on a different track.

<div>
<div class="content wysiwyg-content">
In a Performance Measure History table is a list of when the users periodically key in their &nbsp;info regarding their targets.<br />
However, for most of the requested reports all that is wanted is the latest entry for a given Measure. &nbsp;Measures are uniquely identified with a MsrCd#.<br />
The History table not only has a unique date/time of entry, but each entry in the table creates a unique sequential ID.<br />
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”, &nbsp;“Filter”, Query Calculation, etc. using the below syntax. &nbsp;On occasion the syntax gets approved, but I do not accomplish my goal.<br />
<br />
maximum ( [PM View prd].[DataTarget History].[ID] &nbsp;for &nbsp;[PM View prd].[DataTarget History].[MsrCd] &nbsp;)<br />
<br />
Assistance please.
</div>
</div>


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.

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

A database report is the formatted result of database queries and contains useful data for decision-making and analysis. Most good business applications contain a built-in reporting tool; this is simply a front-end interface that calls or runs back-end database queries that are formatted for easy application usage.

DB Reporting Tools

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.