Forum Discussion

Anitha1's avatar
Anitha1
New Contributor
2 days ago

Displaying Cube Views Based on Report Selection

Hi,

I am encountering a few issues with dashboard creation. My goal is to display all the reporting dashboards on a single dashboard. Below is a screenshot of my current setup.

I have one combo box named "Report Type," which contains a delimited parameter with options like Balance Sheet, Income Statement, and Trial Balance. Additionally, there is a list box that contains a list of report names. I’ve connected a business rule to the list box parameter to dynamically populate the report names based on the selection from the "Report Type" combo box.

I also created an embedded dashboard with the main cube view. Could someone please assist me with the cube view part? Specifically, when I select a report from the "Report Name" list box, its cube view should display on the right side.

Could you help me understand the changes I need to make in "Consolidated Report_Sub_CV" to pull the corresponding report cube views based on the selection in the report name list box?

 

  • sameburn's avatar
    sameburn
    Contributor II

    Hi Anitha1

    You need to call the bound parameter value from your list box (that contains your cube view names) from your cube view component (the target) e.g |!yourlistboxparam!|

    The list box component also needs to trigger a refresh of the dashboard that contains your cube view

    If you've come this far, that should be straightforward :D

    Hope this helps

    Sam