April 11 2017

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.  

Export 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.

Export BAM data from a 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.

   

About the Author

Dan Atwood

Dan has more than sixteen years of experience in all phases of design, development, and implementation of software applications using BPM. He has developed Oracle BPM, BAM, business rule and integration solutions for financial services, insurance, food cooperative, and telecommunications clients.

Join the Conversation

Enter your first name. It will only be used to display with your comment.
Enter your email. This will be used to validate you as a real user but will NOT be displayed with the comment.
By submitting this form, you accept the Mollom privacy policy.