The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

Anitha1's avatar
Anitha1
New Contributor
1 year 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?

 

Cube View
dashboards

1 Reply

  • sameburn's avatar
    sameburn
    Icon for OneStream Employee rankOneStream Employee
    1 year ago

    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