Proper Reporting / exporting on HTML columns in Performance needed — Oracle Analytics

Oracle Transactional Business Intelligence Idea Lab

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Proper Reporting / exporting on HTML columns in Performance needed

1
Views
0
Comments
Gunilla Runhall
Gunilla Runhall Rank 3 - Community Apprentice

Use Case and Business Need

We are experiencing several problems with HTML columns in Performance, (like goal decriptions, comments etc). 

One way is to set column format to html, but then we have to replace size = 11 , 12 etc  to decrease font size, and still export to excel 2007+ will not work properly, line breaks will give multiple cells. 

The other way is to remove HTML coding with regexp_replace, which mostly works well with export,  but if html continues in 2nd (3rd , 4th) part this will not work properly, and we cannot concatenate all 4 columns due to size limits. 

We want all html columns to be properly reportable AND exportable!

If this cannot be solved, one solution would be to include pure text field columns in addition to html columns in the subject area, to support export.

Original Idea Number: 8548276198

1
1 votes

Submitted · Last Updated