The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

abdelhassine's avatar
abdelhassine
New Contributor
1 year ago

Extract BI Viewer to excel through a Business Rule BR

Hey there,

We have created a BI Viewer and we want to extract the BI viewer to excel but through a button in a different dashboard. Is there way to get the data in the Bi Viewer through a Business Rule, create an excel workbook and save it to File Explorer>Application Database>users>(userName) ?

I know how to create a workbook from a dataTable or a dataset in the BR and save it, but I am having a hard time getting data from the Bi Viewer to the business rule.

Thanks

BI Viewer
Reports

1 Reply

  • JackLacava's avatar
    JackLacava
    Icon for OneStream Employee rankOneStream Employee
    1 year ago

    BiViewer is meant to display data, but in itself it doesn't contain anything. The data will come from the Data Adapter (s) attached to the BiViewer component. You can execute the adapter directly in a business rule, search the object helper tree for "ADO" methods and you'll find what you need.