top of page
Search

Cognos BI Tool Tips

Updated: Dec 20, 2023



Reporting changes in multi-record data sets using the Cognos BI tool requires specific techniques to ensure accuracy and relevance, especially when dealing with dynamic data like employee job titles over time. This process often involves filtering the data to reflect the most recent changes up to a specific period.


To report the latest changes in Cognos BI, you can set up a filter using the Maximum Function, which pulls the latest date for each record. This approach is particularly useful when you need to report on data like employee job titles as of the end of a prior period, ensuring you're working with the most up-to-date information.


We'll demonstrate how to effectively use the Maximum Function in Cognos BI to report on changes, using employee data as an example. We’ll also explain how field names are structured in Cognos BI and their significance in your queries.



The format is:


[Business Layer].[Employee Job History].[Effective Date]

=

Maximum([Business Layer].[Employee Job History].[Effective Date] for [Business Layer].[Employee].[Employee Number])


If you are not used to seeing a field name such as [Effective Date] with the additional identifiers [Business Layer].[Employee Job History], this indicates that the field name is not included in Query. The filter still functions the same but your Query does not contain with unnecessary fields.

 
 
 

Comments


Vintage Hill Consulting is an HCM consulting firm with consultants across the continental United States. Our consultants partner with organizations across multiple industries helping them realize their full HCM solution investment while maximizing an organization’s most important resource, their people.

  • Twitter
  • LinkedIn
  • Facebook
HR Tech Logo

8801 Fast Park Dr.
Suite 301
Raleigh, NC 27617

(877) 275-5788

Top 10 HRMS Solution Providers

Copyright © 2021 Vintage Hill Consulting. All rights reserved.

bottom of page