Can we refer a value from view selector in OBIEE Analysis filter? — Oracle Analytics

Oracle Analytics Cloud and Server

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

Can we refer a value from view selector in OBIEE Analysis filter?

Received Response
21
Views
6
Comments
3545306
3545306 Rank 3 - Community Apprentice

I have four different  pivot table views with project details like "Project view", "Summary View", "Year View" and "Realty View" and I am using view selector to select the required view.

My requirement is when I select "Realty View" from the view selector, It should only display "Realty" projects, should not display "Not Realty" projects. when I select other views( "Project view", "Summary View" and "Year View") it should show both "Realty'' and "Not Realty" projects. If I apply filter condition on analysis, that filters the data from all the views. But I want to apply the filter only on "Realty View" to display only "Realty" projects.

Could anyone please suggest me what would be the approach.

Thanks,

Vijaya

Answers

  • Martin van Donselaar
    Martin van Donselaar Rank 6 - Analytics Lead

    You could calculate separate measures like this:

    CASE WHEN "Project Dimension"."ProjectType" = 'Realty' THEN "Measures"."Value" Else 0 END.

    Per view exclude the measures you do not want to show.

  • asim cholas
    asim cholas Rank 6 - Analytics Lead

    How did you apply filter for that now?

  • View selector simply switch between views, and a view just display the result of the query. The query is one and unique and so you can't change the filter of the query based on the selected view, for that you would need different analysis (as the filter is at that level).

    You can only try to "cheat" a bit but visually things will not be exactly as you expect, although being a pivot it can exclude columns with only NULL values and that can also be a workaround.

  • Joel
    Joel Rank 8 - Analytics Strategist

    A workaround would be to simulate the View Selector by creating a Dashboard Variable Prompt which effectively is a drop-down with values for each of your views. This variable prompt will in turn populate a presentation variable which should have a value for each view. This presentation variable will then be used in section conditions to hide/show section within your dashboard. You'll probably need a section per "view" in order to get this working.

  • 3545306
    3545306 Rank 3 - Community Apprentice

    I tried this solution, It worked. Thank you so much.

  • Joel
    Joel Rank 8 - Analytics Strategist

    Excellent! Please mark answer as correctto help others who may have a similar problem.