Hello,
I am trying to create a Dashboard with several cubeviews in it. I created a delimited list parameter with different categories of cubeviews. Does anyone know how to assign the cubeviews to the different display items?
For examples, I will have a category "Sales" and when the user will select "Sales" in the drop-down menu, I want certain cubeviews to be displayed in my dashboard.
thank you!!
Hi Emilie: what you are trying to do sounds like a strong fit with the marketplace solution 'Guided Reporting'. It simplifies the creation of report groups that contain multiple base reports.
Documentation/Overview: Guided Reporting Overview (check out the embedded video here for a brief overview)
Get it from the Solution Exchange: https://solutionexchange.onestream.com/
I'd recommend checking that out first before trying to roll your own solution.
Although I agree that this could be a good use case for Guided Reporting, the marketplace solution may not be necessary. If you would like more control over the user interface (i.e., want to add additional buttons or vary which parameters appear by report), you have a few options that could be simpler/easier for your specific use case.
I would probably suggest using the "Selection Changed Navigation Arguments" to open a new dashboard frame (which contains the applicable cube view group(s).
In your example, you could pass a delimited list parameter into the navigation link arguments. When the user selects the "Sales" option, you could open up a dashboard frame (which opens an underlying dashboard named "0_SalesReports_Frame").
Alternatively, you can link/hard-code specific dashboard frames to a button if preferred.
There are a few other ways to accomplish this, but this is simplest/cleanest one that comes to mind. Hopefully this helps!
