In OBIEE 11G we are all having issues with Narrative view. It is though we enabled “Contains HTML Markup” option in Narrative view we are not seeing any effect of the HTML code. In 220.127.116.11.0 Oracle identified this as a bug and will be fixed in 18.104.22.168.0 version.
E.g.: In below example I would like to show the Year values in red color with bold effect. For this I have written all the html code and also selected the “Contains HTML Markup”. But it is not rendered with the HTML code and it is showing like a plain text as shown below.
The reason is by default, Presentation Services is secured against XSS, which means that users cannot save content that is flagged as HTML. This can be handled by the HardenXSS element to secure Presentation Services against cross-site scripting (XSS). Securing against XSS escapes input in fields in Presentation Services and renders it as plain text.
So In order to get the above example working you need to do two things:
1. Set HardenXSS to false in the instanceconfig.xml file and restart the service. Here is a snippet of a working instanceconfig.xml with this tag:
2. Restart the Presentation server after making changes to instanceconfig.xml.
3. Login to OBIEE presentation services and open the report and check the “Contains HTML markup” checkbox in the Narative view
4. Now you see the HTML rendered output for the same above example as show below:
Hope This helps to meet your Report requirements…