Oracle Transactional Business Intelligence

Products Banner

is it possible to compare Person Number (Colleague) with Manager Person Number (Supervisor)?

Received Response


Can we compare Person Number with Manager Person Number dynamically (for all records in a report) to analyze if listed Supervisor is actively present in Person Number field.

Ideally, I would like to return values as 'True/ False' if manager person number is found (or not found) thru Person Number field. Is it feasible?

PS: tried through using operator 'based on results of different analysis via filter' however this filters out the entire report only for the manager numbers it can find through analysis.

As well, Direct Manager Assignment Status Field is available however it is currently not mandate to update in myHR in our org therefore i cannot rely on the field as for now.

Please suggest if anyone has any way around. Thanks in advance!

Content (required):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):


  • Jahnavi-Oracle
    Jahnavi-Oracle ✭✭✭✭✭

    Hi Abhishek,

    I have tried a similar scenario as well and the option to use 'based on results of different analysis via filter' worked for me. And yes this will filter out only the person numbers who are Managers as the filter is set at the report level, not at the column level.

    The other method which might work would be variables in rpd. But storing so much data in varioales might not be good. So better approach would be to flag the rows in ETL process for your requirement.

  • Hi Abhishek,

    Could check the attached report. There is a field called "Manager"."Manager Flag", which indicates whether a person is a manager or not. This is from the Workforce Management - Worker Assignment Real Time subject area.

    The attachment contains the xml of a report i created. Please create a report using the xml and check.

  • Hi @Jahnavi-Oracle - Thanks for your response & explanation. You are right, the former approach won't provide exactly what I want to achieve. Later approach would be more appropriate. Thanks so much!



  • Hi @Amrita Gupta-Oracle - Thanks for your response. Have added in this field in the report i built, this helps however my query was mainly on creating a flag for Supervisor (while comparing with Person Number) to understand if the existing Supervisor is active or in-active. In our organization, Manager Flag & Direct Manager Assignment Status fields are not mandate to update therefore thought to derive the fields in report.

    Thanks for your assistance.