OBIEE - Line Breaks

Customer asked for line breaks in analysis. This was basically covered before for example here by obiee10grevisited.blogspot.com but I felt it needs so more examples.

(done in OBIEE 11.1.1.7.140527)

Lets create a simple Analysis with 2 column, on of them the string I want line breaks in. The mark for line breaks in OBIEE is <br>. So my formula is: 'Hello<br>people'

This is the formula:

To force <br> to work we will set the text to be HTML in Data format:

Now we see it's working:

You might want the line break to work in the header as well. In that case, select the “contains HTML Markup” in Formula (or in Column Properties->Column Format) :

I was very much surprised to see the export and printing options handling this well not only in HTML output, but also in PDF:

In case your data does not contain <br> you can always use the replace function.

For example:

Replace('Hello !! People','!! ','<br>')

Special characters in data should work as well:

Replace('Hello'|| CHAR(13) ||'People',CHAR(13),'<br>')

 

 This kind of columns might cause some problems in Graph legends.

Oracle DB SE2 12.1.0.2.0 is available

Oracle DB Standard Edition 2 (SE2) 12.1.0.2.0 is available for download from Oracle here.The link to it's page is here.

At the moment it's available for the following platforms:

• Microsoft Windows x64 (64-bit)
• Linux x86-64
• Oracle Solaris (SPARC systems, 64-bit)
• Oracle Solaris (x86 systems, 64-bit)
• HP-UX Itanium     
• AIX (PPC64)
• zLinux64

It is described as: 

Oracle Database Standard Edition 2 is an affordable, full-featured database built for unprecedented ease of use, power, and performance. From single-server environments for small business to highly distributed branch environments, Oracle Database Standard Edition 2 includes all the features necessary to build business applications.

• Optimized for deployment in small enterprises, line-of-business departments, and distributed branch environments
• Offers customers a container database architecture, making it easier to plug into the cloud
• Includes rapid application development tools and supports a wide range of developer frameworks and data types including XML and JSON
• Available on servers supporting a maximum of two sockets on all Oracle-supported operating systems, including Windows, Linux, and Unix
• Provides complete upward compatibility, protecting your investment as your usage requirements grow

BDD 1.1 VM is availble as part of the Oracle Big Data VM

BDD 1.1 VM is available as part of the Oracle Oracle Big Data Lite Virtual Machine here, as part of the version 4.2.1.

Please note: This appliance is for testing and educational purposes only; it is unsupported and not to be used in production.  It includes software products that are optional on the Oracle Big Data Appliance (BDA), including Oracle NoSQL Database Enterprise Edition and Oracle Big Data Connectors (and now, BDD).