Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Comments
-
Whats the return type from this expression? looks like date !! DateType/NumberType !! (SUM(SUM(CASE WHEN "Requisition Status - Current"."Current Status" = 'Filled' THEN (TIMESTAMPDIFF(SQL_TSI_DAY,(CASE WHEN "Requisition Identification"."Req. Identifier" IN ('1004932','1004933'','1100495') THEN…
-
You need to look at TIMESTAMPDIFF(SQL_TSI_DAY, (CASE WHEN "Requisition Identification"."Req. Identifier" IN ('1004932','1004933'','1100495') THEN TO_DATETIME('2010-01-01','yyyy-mm-dd') ELSE "Requisition Dates"."Req. Creation Date" END), "Submission Dates"."Offer Accepted Date")+1) validate this first
-
You need to work on mappings to populate the data for new column.
-
You should look at Lineage doc. I think that's what you are looking for. Use same doc id to find Lineage doc
-
Check this doc id 2065612.1 You'll get everything
-
Check this http://docs.oracle.com/cd/E63231_01/doc/BIAIN/GUID-0EAF50FB-0A44-4E88-B3B1-09A5F3E806D2.htm#BIAIN24602
-
For time being you may point UAT console to any other environment to make sure your uat bi is up and running. mean time you can think of what to do with uat schema like going for rcu creation for uat or else copy from any other environment.
-
Also check these $$ANALYSIS_START $$ANALYSIS_START_WID