Oracle Fusion AI Data Platform Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Fusion AI Data Platform Forum

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Analytics report shows previous direct reports for the Manager

Received Response
51
Views
7
Comments
Shaily
Shaily Rank 1 - Community Starter
edited Jan 29, 2026 3:57PM in Oracle Fusion AI Data Platform Forum

Hi,

In Analytics report for MSS its showing the previous direct reports for the Manager who was recently transfered. How do we fix it?

Regards

Tagged:

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    Hi Shaily,

    Welcome to the Oracle Analytics community and forum.

    Do you mind providing some more details about your question?

    Information like the product (and version) you are using and describe a bit more what you are seeing, and what expected to see instead. All these details are obvious for you as you are working on it, but here in the forum it isn't…

  • Chere-Oracle
    Chere-Oracle Rank 6 - Analytics & AI Lead

    How often is the manager hierarchy data updated? Does the data expected to include historical, or only current?

  • MandeepGupta
    MandeepGupta Rank 8 - Analytics & AI Strategist
    https://community.oracle.com/products/oracleanalytics/discussion/27969/analytics-report-shows-pervious-direct-reports-for-the-manager

    Hi Shaily,

    I think this report is fusion OTBI analytics but details are missing as highlighted by Gianni. But on the looks of it, it looks like manager hirearchy refresh is missing. Can you please schedule below process if not done already:

    Refresh Manager Hierarchies

    Thanks.

  • Jen Paddington
    Jen Paddington Rank 2 - Community Beginner

    Hi All,

    I work with Shaily, and we are trying to determine why a specific dashboard is not using delivered expected security behaviour for a Line Manager. The dashboard that Shaily is referring to is within Fusion Data Intelligence (not OTBI Analytics). We run the refresh manager hierarchy regularly in Oracle HCM. We have one dashboard within Fusion Data Intelligence that is not behaving as expected for the supervisor security. We are using delivered Supervisor Hierarchy for the data security for our custom Line Manager role with FDI.

    image.png

    The Line Manager is seeing people who previously reported to him, not just people who currently report to him. The expected behaviour is that the Line Manager can see all people currently reporting to him and be able to see all the data in reports/dashboards within FDI for the people that currently report to him.

    Note the subject area being used is: Workforce Core, and we are pulling in data from the Person Extensible Flexfield into this dashboard.

    Any additional insight on this behaviour would be helpful.

    Thank you!

    Jen

  • Gianni Ceresa
    Gianni Ceresa Mod

    (Thread moved to the Fusion AI Data Platform category, the new name of FDI. Future FDI questions can be posted in https://community.oracle.com/products/oracleanalytics/categories/fusion-data-intelligence directly.)

  • Silvio Garber-Oracle
    Silvio Garber-Oracle Rank 6 - Analytics & AI Lead

    You may try reloading the Workforce Management functional area.
    Reload Data for a Data Pipeline

  • Daniel Ryan
    Daniel Ryan Rank 4 - Community Specialist

    Hi
    I had this with a previous customer. The reason for the difference is FAIDP is looking at this from a different lens than OTBI. Where OTBI is enabling a manager to look at the full history of the employees they currently have, FAIDP is looking at the performance of the manager at the time the person reported to them so for example, if 10 people had poor performance under a manager but are now under a different manager, why should the new manager look as though they weren't managing the staff well.

    The way around this was to create a new hierarchy for the latest manager which took some work in the Data Warehouse to create the necessary table, followed by a semantic model extension for creating the new hierarchy. We called it Latest Manager Hierarchy.