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
111
Views
7
Comments
DollyG
DollyG 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

Answers

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

  • DollyG
    DollyG 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?

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

  • Martin van Donselaar
    Martin van Donselaar 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 ...

  • DollyG
    DollyG 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?

  • [Deleted User]
    [Deleted User] 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.