Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 43 Oracle Analytics and AI Sharing Center
- 19 Oracle Analytics and AI Lounge
- 283 Oracle Analytics and AI News
- 60 Oracle Analytics and AI Videos
- 16.3K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 108 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
FDI attributes without Start & End date included
When creating reports in FDI, we find attributes that are present in the subject area but the attributes Effective Start Date and Effective End Date (and sometimes other required attributes) are not included. This makes these attributes unusable as we cannot determine which row is accurate for each employee. What is the best practice in these scenarios? Currently we are building OTBI reports so we can filter to the currently active record (since OTBI contains Start & End dates) and then using the SAAS connection to create a dataset for the attribute, scheduling that dataset, then we have to join the dataset to the subject area via a Data Flow, and schedule that. Here are a couple examples:
HCM - Workforce Core > Worker > Education > Highest Education Degree Name
HCM - Workforce Core > Common > Grade > Grade Rates> Midpoint Value