Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Can we refer a value from view selector in OBIEE Analysis filter?

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
-
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.
0 -
How did you apply filter for that now?
0 -
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.
0 -
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.
0 -
I tried this solution, It worked. Thank you so much.
0 -
Excellent! Please mark answer as correctto help others who may have a similar problem.
0