by-clause-for-group-by In OTBI/OBIEE reports (Doc ID 2708150.1)

Last updated on APRIL 04, 2024

Applies to:

Symptoms

Scenario :  To fetch job change date of employees. What is the logic for this scenario

Example scenario: Workforce Management - Worker Assignment Event Real Time subject area. The worker contains 4 effective dated record in his assignment history where 3 times his job has been changed.

Want another field in this report where Job change date to display on the report. 
Example Expected result:

Effective Start Date             Effective End Date                     Job Name Job                                    Change Date( the new field)
09/22/2015                         07/23/2017                              Default
07/24/2017                         06/13/2020                              Floor Supervisor                                         07/24/2017
06/14/2020                         07/14/2020                             Floor Supervisor                                          07/24/2017
07/15/2020                         12/31/4712                             Shift Manager Trainee                                  07/15/2020

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.