Forum Discussion

EG's avatar
EG
New Contributor
16 days ago

Reports not displaying in Dashboard

I'm having trouble with a dashboard I'm building. I want to display either an IS or a BS on a single dashboard frame based on user's selection. I've created a list parameter with the options "Income Statement" and "Balance Sheet". However, no matter which option I select, the dashboard only displays the IS. I suspect I'm missing a step to properly link parameter selection to switch between the two reports. I don't have much experience with multi report dashboards up to now, I've only worked on single report dashboards. Could someone help point out what I am doing wrong or guide me on how to make the report dynamically switch based on the parameter. Thanks.

Dashboards

1 Reply

Sort By
  • Samwise's avatar
    Samwise
    New Contributor II
    5 days ago

    Refer to the individual cube views in the list parameter. You will then need two components being the cube view a combo box. Attach the bound list parameter to the bound parameter section of the combo box. In the cube view component, attach the parameter to the cube view section. Make sure the combo box refreshes the dashboard the cube view is attached to. Avoid using & in the cube view name as well. I've had problems with the cube view displaying on the dashboard if the cube view name contains an "&".