Categories
- All Categories
- Oracle Analytics Learning Hub
- 32 Oracle Analytics Sharing Center
- 22 Oracle Analytics Lounge
- 255 Oracle Analytics News
- 45 Oracle Analytics Videos
- 16.1K Oracle Analytics Forums
- 6.3K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 95 Oracle Analytics Trainings
- 16 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Finding Most Recent Row FDI Detail Report
Apologies in advance, new Oracle/FDI user…
Using workforce core, I'm building a supplemental Active with Salary detail report. The issue I'm running into is once I bring in the salary field the dataset returns all of the compensation history which then causes multiple rows per employee.
My question is whether or not there is a way to filter on the person's most recent row?
Answers
-
Do you want to sort based on Person ID ?
0 -
Hi Krishna -
I'm more trying to filter on the most recent row.
Mike
0 -
Hi Mike - I moved your question to the Forums instead of the Idea Lab - the Idea Lab is more for requests for future product features. You're more likely to find an answer to "how to" questions here.
0 -
Mike, It looks like you're trying to just show the latest salary for an employee using Workforce Core.
@Raghavendra Raghunath-Oracle , @Nupur Joshi-Oracle , @Gunvansh Khanna-Oracle - do we have this capability? I imagine a time filter would not satisfy the requirement if Mike is trying to pull the latest salary, and that timeframe can vary depending on when a salary is updated.0 -
Hi, perhaps the RANK function can be leveraged,
0 -
Hi @User_LW96B Please use an expression filter criteria like below
"HCM - Workforce Rewards - Salary Basis"."Worker Salary Basis Details"."Salary Change Start Date" = (MAX("HCM - Workforce Rewards - Salary Basis"."Worker Salary Basis Details"."Salary Change Start Date" by "HCM - Workforce Rewards - Salary Basis"."Basic Information"."Person Number"))
1
