Discussions related with no resolution: 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

Has anyone attempted to add a SQL predicate or custom filter to determine a user's AoR based on subject areas or tables? This would include leveraging session variables to dynamically filter records according to these values.

We have the same issue. Multiple AoRs are reflected as smallest intersection in HCM, but adding up all AoRs in OTBI