Categories
- All Categories
- 101 Oracle Analytics News
- 9 Oracle Analytics Videos
- 14.3K Oracle Analytics Forums
- 5.3K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 56 Oracle Analytics Trainings
- 60 Oracle Analytics Data Visualizations Gallery
- 5 Oracle Analytics Data Visualizations Challenge
- 4 Oracle Analytics Career
- 4 Oracle Analytics Industry
- Find Partners
- For Partners
Where to find the Enterprise Legal Seniority/ Hire Date fields to add in a OTBI report
Answers
-
Hi Abhishek,
In OTBI most of subject areas available in below cloumns
Worker assigmnent real time subject area -in worker folder please find.
"Worker"."Enterprise Seniority Date"
"Worker"."Enterprise Hire Date"
--------------------------------------------------------------
SQL Issued-
SET VARIABLE PREFERRED_CURRENCY='User Preferred Currency 1';SELECT
0 s_0,
"Workforce Management - Worker Assignment Real Time"."Worker"."Enterprise Hire Date" s_1,
"Workforce Management - Worker Assignment Real Time"."Worker"."Enterprise Seniority Date" s_2
FROM "Workforce Management - Worker Assignment Real Time"
ORDER BY 3 ASC NULLS LAST, 2 ASC NULLS LAST
FETCH FIRST 500001 ROWS ONLY.
Thanks,
Ajay.
0 -
HI @AjayKumar Maddipati -
Thanks for your response. Helpful.
I was however looking for Legal Seniority & Legal Hire Date. I have Enterprise Seniority/ Hire Date in my report already but would like to add the Legal ones too. Can you suggest on the above please?
Regards, Abhishek
0 -
Any update on this?
0