11g When Exporting A Smart Watchlist To HTML, PDF or EXCEL "Custom Columns" Are Not Exported - The Default Values Are Exported Instead
Last updated on SEPTEMBER 28, 2016
Applies to:Business Intelligence Server Enterprise Edition - Version 220.127.116.11.140114 and later
Information in this document applies to any platform.
Users are trying to export to PDF, HTML and Excel the output of a Smart Watchlist, in that moment an issue is seen. Basically if you add some "Custom Columns" to the view when you export this it shows the default ones and doesn't include the custom ones. For examples:
1. When seeing the Smart Watchlist in the Dashboard
2. Under "New Smart Watchlist View" you have View option to "Show More Columns". Click there.
3. Scroll down in the Available Columns section and move to the right i.e the "Custom Column 1"
4. Click on Ok
5. Go to Page options (where you commonly go to Edit the dashboard) and choose Print. Here you can try HTML, PDF or Export to Excel.
As described, export results don't have the same columns that the Dashboard shows. In fact you see all default columns.
Below is an example of the Dashboard:
And this is an example result after exporting to PDF:
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms