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

How to pass on filter with a drill down from analysis to another one (From different subject area)

Received Response
181
Views
5
Comments
2783793
2783793 Rank 3 - Community Apprentice
edited Aug 13, 2024 6:05PM in Oracle Analytics Cloud and Server

Hello,

I'm struggling to pass on filter from a drill down (using the action link to another analysis). The problem is that in the child analysis I do have the "Customer name" = "as prompted" but the "customer name" column has a different name in the parent analysis and child analysis (different subject area but the table itself is identical). So when I click on the "customer name" column on a row from the parent analysis, OBIEE does bring me to the child analysis but show ALL customers, not the one I clicked on...

Any idea how to achieve this? Is there a way to set a presentation variable on a drill down so I can use the value in a different subject area?

Thanks,

Yann

Answers

  • Manoj Dixit
    Manoj Dixit Rank 6 - Analytics Lead

    Hi,

    Did you try keeping the names same in both the subject areas, for example, "Subject Area 1".Customer."Customer Name" and "Subject Area 2".Customer."Customer Name"? This works without issues.

    Regards,

    Manoj.

  • John_K
    John_K Rank 5 - Community Champion

    If you have a single dimension which is shared between the two subject areas then it should have a common name.

  • 2783793
    2783793 Rank 3 - Community Apprentice

    Hello and thanks for the reply. Unfortunately I don't have control over the column names as they are built-in in the subject area. In one subject area it is called "Customers"."Account" and the other one "Customer"."Account, so there is a difference of one extra "s"... but again it is the same table. I however have the same column heading name but that doesn't help.

    So far it seems that the only way to pass over the filter to a different subject area (and a different column name) is through Go URL which I was trying to avoid... but if anybody has an idea how to achieve the desired result without it, please let me know...

    Thanks

    Yann

  • FTisiot
    FTisiot Rank 6 - Analytics Lead

    Hi @2783793

    Try this

    https://www.rittmanmead.com/blog/2012/07/navigating-to-bi-content-in-obiee11g-and-passing-multiple-parameters/

  • Manoj Dixit
    Manoj Dixit Rank 6 - Analytics Lead

    Thanks for the update.

    Then in that case did you try using presentation variable? I think we can use presentation variables at dashboard level so that they can be used across pages. 

    Regards,

    Manoj.