Filtering an analysis based on another anaylisis — Oracle Analytics

Oracle Analytics Cloud and Server

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

Filtering an analysis based on another anaylisis

Received Response
41
Views
6
Comments
John305
John305 Rank 5 - Community Champion

Hello everyone, i am using OBIEE 12.2.1.3.0

i documented myself about passing filter from an analysis to another , i tried to do it but it doesnt work , let me show you :

i want to filter the graph on the right based on the " Pays d'origine"  in the left

pastedImage_0.png

I have  " Pays d'origine "   in my two analysis .

I created a filter in my second graph like this :

pastedImage_1.png

so i think that i did everything good, but it's not working , if you can help it will be amazing.

Thank you !

Answers

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    You're more looking at master-detail linking in your case:

    https://gerardnico.com/dat/obiee/obips/master_detail

  • Jerry Casey
    Jerry Casey Rank 6 - Analytics Lead

    Hi John,

    It's not clear to me what you expect to see on the right.  Algeria is highlighted on the left and its chart is shown on the right.

    Can you provide more detail?

    How are you passing the "Pays d'origine "?  Action link? Master-detail? a simple drill-down?

    Jerry

  • John305
    John305 Rank 5 - Community Champion

    Oh sorry , its not working  , even if i choose another one highlighted in the left nothing change in the right

  • John305
    John305 Rank 5 - Community Champion

    Merciii Christian , it's working !!!!!!!

    Very nice to learn from you guys !

  • Jerry Casey
    Jerry Casey Rank 6 - Analytics Lead

    As Christian said, master-detail linking is the way to go, unless there are union queries involved. (it doesn't work on those.)

  • John305
    John305 Rank 5 - Community Champion

    Yes Jerry,   perfect for the union queries ! i will remember that

    Thank you !