Welcome to the Oracle Analytics Community

Home› User_DAALX› Comments
Default Avatar
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

User_DAALX Rank 3 - Community Apprentice

Comments

  • Thanks both for your comments, it's sad but true that we only get to manipulate the data as you've suspected at a higher level (analytics) and when we get little to no help when we need to find workarounds to poor data setup in the system which is outsourced to a third party. Some of the data items in the system haven't…
    in Using Substring Comment by User_DAALX Dec 12, 2022 11:17AM
  • Thank you, I'm sort of getting there using your example which I found very useful. This has been turned into: SUBSTRING("Supervisor"."Supervisor Name" FROM LOCATE(' ', "Supervisor"."Supervisor Name", LOCATE(', ', "Supervisor"."Supervisor Name")+2) FOR LOCATE(' ', "Supervisor"."Supervisor Name", LOCATE(' ',…
    in Using Substring Comment by User_DAALX Dec 10, 2022 1:29PM
  • Hi Gianni, I'm still struggling to get this to work and I was wondering if you could help me with the syntax, which runs fine but still isn't locating the first name from the string as outlined below: Using the syntax below: SUBSTRING("Supervisor"."Supervisor Name" FROM LOCATE(' ',"Supervisor"."Supervisor Name", LOCATE('…
    in Using Substring Comment by User_DAALX Dec 10, 2022 1:29AM
  • Thanks. I have been able to locate the 1st space within the string, but I'm stuck on how to locate the 2nd space. I have outlined below the syntax used to get the 1st space: 1st Space (No Error) substring("Supervisor"."Supervisor Name",(locate(' ',"Supervisor"."Supervisor Name") + 1),(length("Supervisor"."Supervisor Name")…
    in Using Substring Comment by User_DAALX Dec 4, 2022 10:17PM
  • Thanks Gianni, for your comments, it has now worked! I was testing the first part of my case statement with a timestamp function and running not thinking this would affect the whole of the nested case statements as I have multiple anniversary dates to work on, Now I have a better understanding, thanks again!
    in Calculating length of service by increment Comment by User_DAALX Nov 25, 2022 2:11PM
  • Hi, I use the syntax below CASE WHEN TIMESTAMPDIFF(SQL_TSI_DAY, "Employee Attributes"."Employee NHS Entry Date", CURRENT_DATE)/365.12 <10 AND (TIMESTAMPDIFF(SQL_TSI_DAY, "Employee Attributes"."Employee NHS Entry Date", CURRENT_DATE)/365.12)+2 >=10 THEN TIMESTAMPADD(SQL_TSI_YEAR,10, "Employee Attributes"."Employee NHS Entry…
    in Calculating length of service by increment Comment by User_DAALX Nov 25, 2022 11:07AM
  • Thanks for your response, I have tried different TIMESTAMPADD syntaxes but always comes back with an error, I'm new to Oracle BI
    in Calculating length of service by increment Comment by User_DAALX Nov 25, 2022 10:02AM
  • in Calculating length of service by increment Comment by User_DAALX Nov 25, 2022 12:58AM