Linebreaks are removed from CLOB-content in BI reports
In reports we have problems getting linebreaks from CLOB database-columns to be present. The linebreaks are simply stripped away, resulting in a long string of "unformatted" text.We are using BI Publisher via OBIEE where a SQL has been used as a datamodel / dataresource targeting an Oracle DB directly.
We've also tried different work-arounds to pinpoint the problem, but the BI-report just won't include the linebreaks. F.ex. we've tried selecting data from dual with different ways of creating linebreaks (Chr(13), Chr(10)...). The same problem applies to all CLOB-content reports.
We've also tried different work-arounds to pinpoint the problem, but the BI-report just won't include the linebreaks. F.ex. we've tried selecting data from dual with different ways of creating linebreaks (Chr(13), Chr(10)...). The same problem applies to all CLOB-content reports.
Does anybody have any idea how to fix this?
Product version is 11.1.1.6.7
0