Oracle Analytics Publisher

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Publisher

Categories

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

Help with Extracting L1/L2/L3 Managers in Reports

Received Response
6
Views
1
Comments
Guy_Ora
Guy_Ora Rank 1 - Community Starter
in Oracle Analytics Publisher

Hi,

We’re working on extracting L1/L2/L3 manager hierarchy using the standard logic (e.g., PER_MANAGER_HRCHY_DN).
In most cases, the extraction works fine — but in specific scenarios, some employees don’t appear at all, likely due to how the query is structured.

If you’ve solved something similar, I’d really appreciate it if you could share the code/logic you're using to pull the hierarchy in your reports.

Thanks in advance!

Tagged:

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    Hi,

    Your question seems to imply some common data structures or models. Publisher as a tool doesn't contain any data.

    What product are you talking about? If it's some data available by default in another product (Fusion apps etc.), you should consider asking in the forum covering those products, like https://community.oracle.com/customerconnect for Fusion and co.

    If it's some custom model you built yourself, you should consider providing more details on how your hierarchy is modelled, what your publisher model looks like etc.