Hi All,
Null dates are displayed as 11/30/0 in my dashboard. How can this to be displayed as blanks.
Thank you
Hi @A.Aj,
Can you please try a CASE Statement like following to replace the value to null?
CASE WHEN "Your_Date_Column" IS NULL THEN NULL WHEN "Your_Date_Column" = TO_DATE('0001-01-01', 'YYYY-MM-DD') THEN NULL -- Handles potential '0000' dates ELSE "Your_Date_Column" END
Hope this help.
Thank you.
Additionally, it seems it is an expected behaviour and got the following Idea.
FDI Workbook should show NULLs for empty Date column cells, instead of "30/11/0". — Oracle
Please vote or comments.
@Jae.L , in case, if this column is display only, then try to make it NULL safe, essentially if it is NULL then ' ' else use CAST function. Hope it helps!
@Bhaskar Konar this worked, thank you.
Glad you found it helpful.
Thank you very much, @Jae.L!
Hello, I'm looking for some guidance on adding Extensible Flexfields (EFFs) into FDI. I'm particularly looking to add fields from the Additional Assignment Info area (PER_ASSIGNMENT_EXTRA_INFO_M). Has anyone done this and have any guidance to share? The documentation I have found to date has not been very insightful. Thank…
Hello, Am new to FDI but learning. I know that we can access the FDI Workbook (which you normally see in Oracle Analytics - see below) from the Fusion landing page, as demo-ed by one of our consultants. However, how do we do this? I know that in Fusion Security Console, you need to add several application roles in order to…
In an analysis/report, when the Bottom Up Manager details are selected from the hierarchy, the Top Position Person record drops out. This is due to the fact that this top level position does not have a record in the Fusion table : PER_MANAGER_HRCHY_CF which is the source to load OAX$OAC.DW_MANAGER_CF_DH . The requirement…
I want to know how PaaS data can be brought into FDI. Ex : Some customer related information is on PaaS. I want to bring it in FDI to join it with customer data coming from oracle fusion and then build an overall report.
We noticed today that the data augmentation card isn't available for us anymore. Anyone with the same issue? Regards
