RSS

HTML code in OBIEE 11g Narrative View

17 Apr

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 11.1.1.3.0 Oracle identified this as a bug and will be fixed in 11.1.1.4.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:

<Security>

              <HardenXSS>false</HardenXSS>

</Security>

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…

Thanks,

Shiva

Advertisements
 
10 Comments

Posted by on April 17, 2011 in OBI EE, OBIEE 11g

 

10 responses to “HTML code in OBIEE 11g Narrative View

  1. Sachin

    May 31, 2011 at 8:31 am

    Thanks a lot for this article. This is very helpful for users who want to do quick reporting without much background inputs on reporting.

     
  2. Mark Thompson

    June 27, 2011 at 4:20 pm

    As Shiva noted, this problem is corrected in 11.1.1.5. In fact, I’ve discovered that including the HardenXSS line in instanceconfig.xml in 11.1.1.5 will cause the BI Presentation Server to not start.

     
  3. Neha

    June 28, 2011 at 3:44 pm

    i tried to add this element on instanceConfig.xml but while staring my presentation services, I am getting the following error:

    Element ‘HardenXSS’ is not valid for content model: ‘All(AllowRememberPassword,ClientSessionExpireMinutes,LogonExpireMinutes,MaxTicketLifetimeMinutes,CookieDomain,CookieLifetimeMinutes,CookiePath,CookieSecure,HttpOnlyCookies,SecureCookieLifetimeMinutes,CookieByteLength,CheckUrlFreshness,FreshnessIdByteLength,EscapeFormulasForCSVAndExcelDownloads,MsgCRCChecking,SessionIDEntropySourceQuality,SessionIDCookieName,PersistCookies,EnableWebServerAuthInSoap,LogSessionIDWithNewClient,InIFrameRenderingMode)’

    Can you please help me resolve this?

     
  4. lucas rehem

    July 15, 2011 at 1:08 pm

    Hello Neha,
    To add the element ‘HardenXSS’ you need to insert this in the following tag:


    210
    false

    Then you restart all the services (OPMN)

    I hope that help you

     
    • Shahzad

      December 8, 2011 at 2:46 pm

      Hello Lucas could you pls. be more specific about this solution like where exavctly I have to add Harden XSS . I tried inserting this in securiy tag but afterwards the presenattion server is not starting.

       
  5. Nate

    February 21, 2013 at 6:58 pm

    is it possible to add html tag in column header to get hover on mouse over and pull the value for hover text from variable or external table

     
  6. suraj

    January 29, 2015 at 12:26 am

    Thanks.. this helped me ..

     
  7. Shanthan

    June 12, 2015 at 4:35 pm

    Hi Shiva,

    I have created a small TILE using HTML in Narrative View, with some data in it,
    for Ex: Hello World

    If you EXPORT this to EXCEL then im not able to see TILE, can you please let me know if you have any suggestions for me.

    Thanks,
    Shanthan

     
    • Shiva Molabanti

      June 14, 2015 at 3:43 pm

      Hey Shanthan,
      You can do this in same HTML code. Add desc or alt text to that Tile html attribute.

      shiva

       

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: