Oracle Analytics Cloud and Server

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

Filter the reports on OBIEE 12c dashboard based on user selection

Received Response
118
Views
7
Comments
Rank 5 - Community Champion

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

Welcome!

It looks like you're new here. Sign in or register to get started.

Answers

  • Rank 8 - Analytics Strategist

    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.

  • Rank 5 - Community Champion

    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?

  • Rank 8 - Analytics Strategist

    To me it sounds like you are over engineering your solution.

    I would try and keep your user experience clean and simple.

  • Rank 6 - Analytics Lead

    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.

    pastedImage_1.pngpastedImage_0.png

  • 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 ...

  • Rank 5 - Community Champion

    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?

  • Rank 2 - Community Beginner

    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.

Welcome!

It looks like you're new here. Sign in or register to get started.