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).

BDD - Oracle BDD 1.1 (Big Data Discovery 1.1) is available

The second release of Oracle Big Data Discovery (BDD), 1.1 is available.

You can find it's main page here: https://www.oracle.com/bigdata/big-data-discovery/index.html. That includes data sheet, executive briefing and video. You can read there about Capabilities.

The OTN page is here.

The documentation of BDD 1.1 is here.

The YouTube channel is here.

The Learning library is here.

The download is from edelivery (search for Big Data Discovery).

To get a list of the new features in BDD 1.1, I used the Cumulative Feature Overview Tool described in https://blogs.oracle.com/proactivesupportEPM/entry/cfo_web_interface_bi_bdd. 

• Hortonworks Data Platform (HDP): Oracle Big Data Discovery supports the two most widely-used Hadoop distributions; Hortonworks Data Platform and Cloudera Distribution for Hadoop.
• Kerberos in Hadoop: Oracle Big Data Discovery runs on Hadoop clusters secured by Kerberos authentication, allowing secure analysis of big data across whole organizations. 
• Spark on YARN: Oracle Big Data Discovery uses Spark on YARN, making data processing faster and more stable. 
• Multiple versions of Cloudera Distribution for Hadoop (CDH): CDH support has been expanded to include multiple versions, so you can install on a wider range of systems and updated to incorporate improvements to the evolving Hadoop ecosystem. 
• Options for initial data loading: A new self-service data load experience makes it even easier for business analysts to build innovative data combinations that bring together Hadoop and desktop data. 
• Data set and project level security: Access to individual data sets and projects can be restricted for specific users and user groups, allowing Oracle Big Data Discovery to be rolled out to large groups of analysts securely. 
• Update and reload data: Data sets can be updated from within Studio both manually and automatically, making it easy to keep projects and dashboards in synch with rapidly changing data. 
• Big Data Discovery applications: A business-user friendly experience that supports a whole range of data operations for projects and applications: Projects let business users perform ad-hoc exploration and discovery using standard and advanced analytic techniques. Applications expose interactive analytic dashboards to a broad set of users and are set up to periodically receive new or refreshed data. 
• You can publish and share transformation scripts, accelerating the process of data cleansing. 
• Transform enhancements: Support for Geotagger, Whitelist, and Entity Extraction transformations on the Studio Transform page make it easier to derive structured data from messy Hadoop sources without writing code. A redesigned Transform Editor provides more help to business analysts who need to go beyond one-click transformations. Transform performance is improved, tightening the cycle of improving data quality in Transform and analyzing the results in Explore and Discover. 
• Data visualizations are standardized and enhanced to allow easier visualization interpretation and interaction by business analysts and data scientists alike. A refreshed configuration experience makes the creation of data visualizations faster while also offering more control. 
• A new Custom Visualization Component makes it easy for you to build and deploy interactive data visualizations using JavaScript and EQL. 
• Enhanced upgrade experience allowing in-place upgrades to new Oracle Big Data Discovery releases. 
• A new JDBC connector allows IT to securely set up connections to gold-standard enterprise databases. Business users can then add data sets originating in JDBC and use them along with data sets originating in Hadoop. 
• The bdd-admin script includes a number of new capabilities that give administrators more options for managing Oracle Big Data Discovery. 
• Language processing capabilities are expanded to support more than 80 languages. 
• Log files contain new properties that give administrators more control over their behavior and the information they provide. 
• The Enterprise Manager plug-in includes new metrics and operations that make it easier for administrators to monitor and manage Oracle Big Data Discovery clusters. 

The Oracle Big Data virtual machine 4.2.1 available here, now includes BDD 1.1