Categories
- All Categories
- 73 Oracle Analytics News
- 7 Oracle Analytics Videos
- 14K Oracle Analytics Forums
- 5.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 39 Oracle Analytics Trainings
- 58 Oracle Analytics Data Visualizations
- 2 Oracle Analytics Data Visualizations Challenge
- 3 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