Report w/Parent Child Hierarchy not filtering — Oracle Analytics

Oracle Analytics Cloud and Server

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

Categories

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

Report w/Parent Child Hierarchy not filtering

Received Response
41
Views
6
Comments
User_ZZQJ0
User_ZZQJ0 Rank 4 - Community Specialist
edited Aug 13, 2024 5:54PM in Oracle Analytics Cloud and Server

OBIEE 12c

I have created a parent child hierarchy table using wizard in the RPD. The hierarchy is an organizational hierarchy that shows an employee and their direct and indirect reports. The structure is similar to the following:

Title                           Employee Name     Employee No

CEO                          James                     100

  Vice President         Sally                       101

    Director                 Greg                       102

      Manager              Andy                       103

I can view and expand the hierarchy without any problems however I am unable to filter the report with any of the columns shown above. Any time I apply a filter the result set returns no records. Please advise

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    Depends what kind of filter you are setting ....

    You have the log telling you exactly what happen when you add a filter and have no record anymore.

    Hierarchies aren't filtered with a filter but mainly with selection steps.

    So look at your logs and you will see the reasons of the "no records" as the query will be quite obvious.

  • User_ZZQJ0
    User_ZZQJ0 Rank 4 - Community Specialist

    Thanks. So I am trying to run the report that is using this hierarchy on a dashboard. I want to be able to prompt the user to filter the report by the employee name. In the above example the user would select any employee from the prompt and the report would then filter the results by showing that employee and their direct and indirect reports. Would I be able to achieve the same functionality via selection steps or another method?

  • User_ZZQJ0
    User_ZZQJ0 Rank 4 - Community Specialist

    Hi All. I havent found a solution for this. I am trying to filter results of a parent child hierarchy on a dashboard.

  • asim cholas
    asim cholas Rank 6 - Analytics Lead

    Hello,

    What is the structure of your table?

  • 3489434
    3489434 Rank 1 - Community Starter

    Did you find a solution for this. I too have same issue filtering PCH.

  • Gianni Ceresa
    Gianni Ceresa Mod

    You better open a new thread explaining your case as the OP gave up on this (so didn't answer to any question etc.).