Categories
- All Categories
- Oracle Analytics Learning Hub
- 30 Oracle Analytics Sharing Center
- 18 Oracle Analytics Lounge
- 238 Oracle Analytics News
- 45 Oracle Analytics Videos
- 16K Oracle Analytics Forums
- 6.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 88 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Is there any possibility to get latest job change date in OTBI Report
Divya Kollipara
Rank 1 - Community Starter
Hi Experts,
Good Day!!
Can someone please let me know how to get the latest job change date in OTBI Report
For Example, one employee Job changed from "AA" to "BB" on 01-Jan-2022 then multiple assignment changes happened for the same person. I need to get the 01-Jan-2022 (As the job changed from "AA" to "BB") in OTBI Report.
Regards,
Divya
0
Answers
-
Hi Divya,
You can check subject area: Workforce Management - Worker Assignment Event Real Time
See Folder & Attribute: Additional Attributes - Job Creation Date
Also, you can refer to this post on various Calendar Date/Time Functions that you can apply with regards to your requirement:
https://docs.oracle.com/cd/E17904_01/bi.1111/e10544/appasql.htm#BIEUG539
Regards,
Dave
0