Categories
- All Categories
- 145 Oracle Analytics News
- 27 Oracle Analytics Videos
- 14.7K Oracle Analytics Forums
- 5.7K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 54 Oracle Analytics Trainings
- 12 Oracle Analytics Data Visualizations Challenge
- 4 Oracle Analytics Career
- 2 Oracle Analytics Industry
- Find Partners
- For Partners
Filter the reports on OBIEE 12c dashboard based on user selection

Hi Guys,
I have 9 reports on my dashboard that appear by default. My requirement is:
Suppose a user wants to view only 2 or 3 reports out of those 9, how can I create a filter based on user selection for the same?
As an example, I have reports: Release, Incidents, Defects, Test Coverage etc.
Now, I need to create checkboxes on the left corresponding to each report such that when I check Release, Only Release report should be displayed, when I select Release and Incident, only these two reports are displayed.
Can anyone please help me to achieve this requirement?
Great thanks,
Dolly
Answers
-
Your checkbox dashboard prompts will need to populate a presentation vaia.
Each of your reports will will need to be placed in individual sections. Each of these sections will need to have a condition and this condition will be dependent on the presentation variable vale.
This is will work if you’re only displaying a single report based on selected checkbox. It gets more complex if you want to display multiple reports.
0 -
Thanks for replying!
As I was also thinking in the same direction, but can it be possible if I select 1 report can its size be adjusted on the entire dashboard, similarly if I select 2 reports , they both fit into the entire dashboard?
Or, we have a fixed width and height for a report, and it remains the same irrespective of either 1 or multiple reports are selected?
0 -
To me it sounds like you are over engineering your solution.
I would try and keep your user experience clean and simple.
0 -
Make all sections collapsible. That way the user can collapse all the sections he/she doesn't need to see. The user can save this customization and make it the default for this dashboard.
0 -
The "size" isn't affected by the visibility option. The same properties your analysis (yes, it's an analysis and not a report except if they are all Publisher reports) has now will be there with the visibility conditions.
The concept of "entire dashboard" is quite vague knowing it's a webpage and scrolls can exists both vertically and horizontally, so where does the dashboard finish? Never in theory ...
0 -
Thanks all for replying!
My requirement is somewhat changed.
I have total 7 reports. What I am supposed to do is:
I need to check 3 checkboxes such that when I click on 1st one (Adoption %- 2 reports i.e only CI Adoption and Sonar Adoption should display).
Next checkbox: (Release quality) : When I click on it, 3 reports: Release, Incident and Defects should display.
Next checkbox (Code Quality): When I click on it, 2 graphs (Technical Debt, Code Coverage) should get displayed.
When I select any 2 check boxes, those corresponding reports need to display, and rest sections should be adjusted.
Is there a way to achieve this?
0 -
Late to the party here @DollyG but Martin gave you the out-of-the-box, no-code, vanilla functionality solution which does precisely what you are trying to achieve.
It is about the end result, not about the HOW you achieve it.
If you want to invent a convoluted, code-based "solution" for an issue which can be done with standard config, then that "solution" is pretty much a waste of resources and effort.
0