Forum Discussion

NicolasFarro's avatar
NicolasFarro
New Contributor
9 days ago

Executing QuickViews using BRs

Hi everyone,

Does anyone know if there's a specific method to be able to run Quickviews using a Business Rule? Trying to understand if OS is capable of doing something like that. 

Presumably, what I would like is to execute a dashboard that would allow me to see one, just seeking for some ideas on this topic.

Thank you!

1 Reply

  • Pierre_VISEA's avatar
    Pierre_VISEA
    New Contributor

    Hi Nicolas,

    Not sure to understand. You want tot refresh a quickview by using a BR ? Or to build one ? Or you want to use BR in your quickview ?

    I am not sure you can refresh a quickview by a BR, but in the spreadsheet component you have a "refresh Speadsheet when Opened" property that refreshes all cubeviews. If you refresh the dashboard containing the spreadsheet (by a button for instance) you will also update quick views.

    You also have api usable in Excel macro to refresh your quickviews directly in Excel:

    https://community.onestreamsoftware.com/discussions/Reporting/excel-vba-automation---refresh-workbook-function/3949

    But since version 8.5, you can include refresh button directly in Excel from the addin (in sheet actions)

    https://community.onestreamsoftware.com/discussions/Reporting/in-sheet-actions/44651

    Pierre