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

Question

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

Joel Acha · Answer

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

3545306 · Answer

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

Joel Acha · Answer

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.