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

21
Views
3
Comments

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

Tagged:
1
1 votes

Submitted · Last Updated

Comments

  • Stephane Cote-Oracle
    Stephane Cote-Oracle Rank 1 - Community Starter

    Hi Gunilla,

    The same size limits would exist if we put everything in text fields without HTML (which we have already added as an enhancement). We can't concatenate everything in one field because of oracle field size limits. 

    Thanks!

    Stephane

  • Gunilla Runhall
    Gunilla Runhall Rank 3 - Community Apprentice

    Hi, 

    we are desperately looking for a solution for this, when migrating to HCM

    As far as I know this would be implemented in 17.3, right?

    Could you please give more details about if there is any formatting kept,or would it be one long text string?

    Regards

    Gunilla

     

  • Stephane Cote-Oracle
    Stephane Cote-Oracle Rank 1 - Community Starter

    Yes, it's 17.3 and it would be one long text string.