I hear regularly from Oracle BAM 12c business users that they need to export the data from their dashboards into Excel.
While I think Oracle BAM 12c is a powerful tool, until recently I did not have a good answer for them.
My standard answer before 12.2.1.2 came out has been to export the raw data object data into a CSV.
Why this has never gone over well
This has never gone over well with business people. While the business users are given access to dashboards, they are not typically given access to BAM Composer (where the data object data is displayed). If they have access to BAM Composer, the BAM data object can be opened and its data exported by opening the data object -> clicking the Data tab -> click Export All Rows to CSV. The problem has been that users find this of little use because the information is not filtered. All of the data object’s columns are exported, and all of its rows are exported.
New Oracle BAM 12.2.1.2 feature makes exporting to CSV files simple
The good news is that a new 12.2.1.2 feature supports exporting to CSV files directly from a dashboard. To accomplish this, create a dashboard based on a list view. As shown below, the user then only has to click the Download icon in the upper right corner of the dashboard.
The benefit to this is that the only data exported is the filtered data shown on the dashboard, and only the columns and rows the user cares about are exported.