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

obiee 11g hierarchy drill down not working

Received Response
22
Views
3
Comments
2785553
2785553 Rank 1 - Community Starter
edited Aug 13, 2024 7:02PM in Oracle Analytics Cloud and Server

Hi,

We have a hierarchy with columns division as level 1,  business level as level 2 and  business unit as level 3

when year, division and amount columns are selected in an analysis, on the results page when clicked on division, the drill down is directly going to business unit (level 3)  instead of  business level (level 2). This is happening in prod instance but the same is working fine (going to level 2 and then to level 3) in our dev instance.

any suggestions on how to resolve this?

OBIEE version: 11.1.1.7.141014

Answers

  • Felipe_Idalgo
    Felipe_Idalgo Rank 5 - Community Champion


    Hi,

    Post here a screenshot of your logical and presentation hierarchy with all levels from your PROD env.

    Felipe Idalgo

  • cesar.advincula.o
    cesar.advincula.o Rank 6 - Analytics Lead

    Hello,

    This is your scenario

    division as level 1,

    business level as level 2

    business unit as level 3


    1. Please check your "preferred Drill path"

    dr1.png

    division.png

    2. Check if you are using action links in your reports.

    Kind Regards,

  • 2785553
    2785553 Rank 1 - Community Starter


    Hi,

    Thank you for the replies, when I restarted the services, everything is back to normal, drill down is working as it suppose to.

    Thanks again

    Phani