How to forecast future FTE in Fusion AI Data Platform (FDI) when OOTB FTE stops at last actual?

JT_DC_2023

Hi all,
In Oracle Fusion AI Data Platform (FDI), the OOTB FTE measure stops at the last actual period and does not show future months, even when I extend the date filter forward.

My question is: Should future FTE not be possible because Fusion HCM is effective-dated?
In Fusion HCM, many worker components (including assignment-related data) are date-effective with Effective Start Date / Effective End Date, meaning records can be past, current, or future-dated and should be retrievable “as of” a given date.

So if we have future-dated hires or future-dated assignment/work-measure changes, I would expect FDI to be able to compute FTE as-of future months (not just historical snapshots).

Questions:

• Has anyone managed to retrieve/plot future-dated workforce records (future hires / future assignment changes) in FDI and derive future FTE from them?
• If yes, what’s the approach: as-of/effective dating logic, a specific subject area, or a data flow/calendar scaffold pattern?

Any pointers (subject area, measure, or modeling approach) would be greatly appreciated. Thanks!