Need to pull in Seniority Date using SQL and add to an analysis
Summary
Adding Seniority Date to my Logical SQLContent
Hi All,
I hope someone is able to help me out.
We currently have an Analysis that we were using to produce a report for terminated employees and was supposed to calculate the Years of service based on the seniority date.
We recently noticed that the seniority date isn't calculating/populated in the dataset (which seems to be a known issue)
I created an Oracle BI EE data set using the SQL from the analysis
Then I created a SQL ApplicationDB_HCM data set that will provide the seniority date
I tried joining the two data sets on person_id but when I check the data, the second data set appears to blank (I have tried testing using a small number of records but it doesn't seem to matter) - as soon as I link the query, the seniority date information is blank.