I managed to solve the problem by applying a filter using the MAX function :
"Person Work Permit"."Expiration Date" = MAX("Person Work Permit"."Expiration Date" by "Person Details"."Person Number") on the Expiration Date field
Hi Alan,
I have similar requirements for DBS Checks and Work Permits, but I use RANK instead of MAX. I have a calculated column called 'Rank of Renewal Date' with the following formula:
RANK("Workforce Management - Documents of Record Real Time"."Document of Record Details"."PER_DOCUMENTS_OF_RECORD_DFF_RENEWAL_DATE_" BY "Worker"."Person Number")
I then use this column in the Analytic Filter as shown in the screenshot below.
Welcome to Oracle Analytics Community.
Can you please elaborate your query? And share the product details where you want to get this data? A detailed question helps the community members to understand the requirement and answer appropriately.
Thanks.
Hi MandeepGupta
Thanks for responding
I have an OTBI report that is returning rows containing the "Person Details.Employee Number" and "Person Work Permit.Expiration Date" from the WFM- Person Real Time subject area.
I need to be able to return a single row for each person that contains the latest expiry date.
I have seen solutions on here involving use of the max function in a new column such as MAX(
"Person Work Permit.Expiration Date" by "Person Details.Employee Number") and adding a filter where the value retuned in the new column is equal to the value in the Expiration date column
But this doesn't seem to be working
Thanks for sharing the details, Alan. What issue you are facing with this approach? Is it not giving any data or gives incorrect data?
Thanks for the update, Alan. What was the issue previously? Just curious to know.
The method involving creating a new column containing the MAX function to compare against, produced null values for some rows and is clunky in comparison to using the max function directly in the filter, it is similar to the ROWNUMBER() over partition method when in SQL
Description: Join our Product Management team to learn about new features that are part of 26.R3 Application release of Fusion Data Intelligence (SCM). The session will cover updates on Supply Chain Management and Procurement. Presented by: Anil Sebastian - Senior Director, SCM Product Management, Fusion Data Intelligence…
We would like to understand the reason for the difference in configuration options for the “Send Message to Team” action across the Redwood VBCS Recruiting pages. Currently, we observe the following behavior: On the Job Requisition and Job Requisition List pages, it is possible to hide/remove the “Send Message to Team”…
Is there a way to extract existing BIP reports saved in a specific folder? Like can capture Report Name, Report Path and Owner for example?
Is there a log that can be checked on our side that might help with the issue. I've submitted an SR, however it is currently being bounced around between different areas. Could not establish connection. oracle.xdo.delivery.ssh2.SSHMessageException: Error in decrypting message Current thought is that this is an issue with…
Hello, I'm trying my hand at creating some KPI's and Dashboard Visualizations for the Recruiting Activity Center (RAC) per the following documentation: Flexible Reporting in Redwood Dashboards Redwood Experience: Recruiting Dashboard When I add a session variable to my OTBI reports, I correctly see a value of 0 in my…
'Facility Name' exists in the Recruiting - Recruiting Real Time multiple times with varying usage. Job Requistion -> Job Requisition - Additional Details -> Facility Name Job Requistion -> Location -> Facility Name Is there any reason why these two Facility Names would not exist in the Recruiting - Real Time Events subject…
