A calculation for maximum (effective start date) that is ≤ the forecast date and use its FTE only could work to get the effective latest change date. But I might be wrong.

Maybe, you can identify the greatest effective start date. So you can filter to select only the one with the maximum (effective start date) that is ≤ the forecast date? Not sure if there is a default filtering option for latest effective change.

Well, yes it could, if it reflects future dated changes of FTE based on an action, I guess…

Anybody any updates? Thx!

https://community.oracle.com/products/oracleanalytics/discussion/comment/70869#Comment_70869 You're speaking from our hearts, somehow...

any confirmation for future releases?

right this hits badly if data is needed for long term analyses, that may fall under such a retention policy in Fusion source. Has anyone built successfully a custom snapshot logic? I can image how, but usually you don't want to re-setup ootb KPIs to incorporate the custom snapshot.

Right, detailed documentation on attributes/field names/logic/filters highly appreciated. Reverse engineering or data archelogy is not fun…

seems to be similar here… https://community.oracle.com/customerconnect/discussion/785681/limit-view-on-talent-pool-members-by-aor-members-retrieved-from-analysis

Great!

What are you trying to report? The recent population by historical Org tree or the historical population by historical Org tree?

Sometimes it needs a: Import User and Role Application Security Data Process to be triggered

Have you tried to clear cache? Advanced Techniques: Set Caching Options for Your Analysis

@Rob: Are you handling multiple AoRs in a role?

might be affecting this: Can you secure reports using area of responsibility? — Cloud Customer Connect

yet another one Areas of Responsibility data security not being pulled through to OTBI — Cloud Customer Connect

another one OTBI not pulling data by AOR — Cloud Customer Connect

Related: OTBI Reports take into Account AoR settings ? — Oracle Analytics

I think you are running into this issue: Person Records Secured By AOR Does Not Restrict Data Reflected In OTBI Reports — Oracle Analytics

strongly agree Issue seems to be common: How to restrict the data in OTBI report based on AOR (Area of Responsibility) — Cloud Customer Connect Need inputs to restrict OTBI reports only based on the AOR role — Cloud Customer Connect Person Records Secured By AOR Does Not Restrict Data Reflected In OTBI Reports — Oracle…