Is global workbook-level filtering possible in OAC to apply filters across all canvases simultaneous

Question

My organization needs to implement global filter functionality across our OAC DV workbooks. Currently, our business users must repeatedly apply the same filters (such as Region and Division) on each individual canvas, creating inefficiency and potential inconsistency in analysis.

We require a solution that allows users to set filters once at the workbook level (such as selecting 'Europe' for Region and 'Sales' for Division) and have these filters automatically applied across all canvases. This would significantly improve user experience, ensure data consistency across analyses, and reduce the time spent configuring filters on multiple canvases.

This global filtering capability would enable our analysts to maintain a consistent view of data throughout their analysis journey and greatly enhance productivity when working with multi-canvas workbooks

Gianni Ceresa · Answer

Would you like to be able to use the "Dashboard Filters" visualization? (it gives some extra controls on how the filters look like on screen)

What could maybe be tested is to set parameters from a dashboard filter visualization and then use the parameter in the workbook pinned filters. This would give you a second GUI setting the same filter. I didn't try it, I imagine it could work, despite not being ideal and requiring more work.

Ajinkya Vyawahare · Answer

I tried using using Pin to all Canvas option but that gives very limited functionality, I was a looking for a more intuitive way where I can map my filter selection as Radion button to all Canvas. I am using Oracle EPM as my source , since everything is hierarchy there are lot of restriction to make this happen.

Benjamin Arnulf-Oracle · Answer

Hi @Ajinkya Vyawahare , if you are speaking about Canvas Filters for analysts, I believe you are asking to "Pin" a workbook filter, so it every canvas you are opening are showing by default Europe and Sales. See below example, just click on the pin icon on your canvas filter:

If you are speaking about Dashboard Filters then someone else can provide another solution.