- OneStream Community
- Forums
- Reporting
- Extract BI Viewer to excel through a Business Rule BR
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Extract BI Viewer to excel through a Business Rule BR
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
3 weeks ago
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
3 weeks 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.
