OTBI Edit Column Formula for YYYYMMDD

Summary:

Hello, We tried using the solution listed in the Oracle Doc below but unable to successfully edit the column formula of the OTBI analysis for Workforce Management - Worker Assignment Real Time SA | Worker Folder | Date of Birth and Enterprise Hire Date so that the format shows as YYYYMMDD. This is ncessary as this analysis is the basis for a data model and BIP Report.

Oracle Fusion BIP: How to change the date Format in OTBI analysis so that it keeps the formatting in BI Publisher Reporting. (Doc ID 2184776.1)

Solution: CASE WHEN "Worker"."Employee Hire Date" is not null THEN CONCAT (CONCAT( CONCAT( CONCAT(SUBSTRING((CAST("Worker"."Employee Hire Date" AS CHAR)) FROM 9 FOR 2), '/') , SUBSTRING((CAST("Worker"."Employee Hire Date" AS CHAR)) FROM 6 FOR 2)), '/'), SUBSTRING((CAST("Worker"."Employee Hire Date" AS CHAR)) FROM 1 FOR 4)) ELSE '' END