Number of canvases in workbook based on filter selection?

Question

Hi,

Is it possible to create a workbook where the number of canvases displayed is dynamic - based on a user's filter selections?

Use case: a general ledger budget v actual report where we'd like to show a canvas for each lowest level cost centre in the segment hierarchy based on the parent cost centre segment selected.

For example, if cost centre parent segment value 1000 has five lowest level cost centres underneath, then the workbook would show six canvases - one at the aggregated parent level plus one canvas for each of the 5 cost centres. If cost centre parent segment value 2000 is selected and it has 10 cost centres underneath then the workbook would show 11 canvases etc.

Thanks

Elaine

Bhaskar Konar · Answer

Hi @Elaine Hendry,

I'm not aware of a feature that dynamically generates canvases at runtime based on a user's filter selections or the number of members returned by a filter.

However, you may want to explore the 'Parameter Binding' and 'Visibility Parameter' features as they can help create a more dynamic user experience:

* 'Parameter Binding' lets you pass filter values to parameters and use them across canvases.
* 'Visibility Parameters' let you conditionally show or hide predefined visualizations based on parameter values.

While these features don't dynamically create additional canvases or visualizations, they may provide an alternative approach depending on your reporting requirements.

Please take a look at the following Oracle blog and YouTube video which might be useful:

* Oracle Blog – Create Powerful Oracle Analytics Cloud Dashboards with Parameter Binding: https://blogs.oracle.com/analytics/create-powerful-oracle-analytics-cloud-dashboards-with-parameter-binding
* YouTube demo: https://www.youtube.com/watch?v=de5--jmrxLM

Hope this help.

It would be interesting to hear if other community members have implemented a creative workaround for this scenario.

Thank you.