You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

how can I get one seniority date when multiple seniority dates are there for a person in OTBI

Received Response
62
Views
1
Comments
in Reporting and Analytics for HCM 1 comment

Summary:

I am reporting from Workforce Goals - Goal Status Overview Real Time and Workforce Management - Person Seniority Real Time. When I have Seniority Date showing, there are multiple rows shown but I want only one row.

Using this condition in Edit formula-(MAX((CASE WHEN "Workforce Management - Person Seniority Real Time"."Seniority Date Setup"."Seniority Rule Name" = 'ORA_PER_MIGR_ESD_P' THEN "Workforce Management - Person Seniority Real Time"."Person Seniority Details"."Seniority Date" ELSE NULL END) BY "Workforce Management - Person Seniority Real Time"."Worker"."Person Number")) ,Am not getting latest one record can anyone help me.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!