Business Intelligence – Oracle

Oracle BI EE 10.1.3.3/2 – Customizing Output Messages

Posted by Venkatakrishnan J on October 4, 2007

We had a question today in the forums on how to go about customizing output messages in OBI EE. In this case, the question was about how to modify “No Results The specified criteria didn’t result in any data” message when the report that we have created does not return any data. Lets see how to go about modifying the same here. The steps that i am defining here are documented in the Presentation Services Guide and it does work as documented.

1.   Go to the folder {OracleBI}/web/msgdb. This is the folder that would contain all the custom messages for all the languages that BI EE supports. All the custom messages are contained in XML files.

2.   The next step is to identify the XML file wherein the No Result message is present. For that lets do a normal windows search for the text “The specified criteria”

      

As you see above, the message is present in 2 XML files and file of our interest is the viewmessages.xml.

3.   Go to {OracleBIData}/web/msgdb. Create a new folder l_en(for english). Create a subfolder customMessages under l_en. Once this is done copy the viewmessages.xml file into the customMessages folder.

4.   The idea is to make modifications to all the XML messages in a seperate data directory so that we do not lose these during the next upgrade.

5.   Now lets open the viewmessages.xml in a text editor and modify the message that we needed to make a change to.

      

Lets modify the message to say “Oops Sorry. No Data found” and save the file.

      

6.   Once this is done all one would have to do is to restart the Presentation Server and the BI Server. Now we should be able to see the customized message in both Answers and Dashboards.

      

Advertisements

7 Responses to “Oracle BI EE 10.1.3.3/2 – Customizing Output Messages”

  1. Nicolas said

    There is an easier way to set a default no result (but which will not apply to all reports)
    When you are in your report (result view), Click on drop down list “Compound Layout” (or whatever layer you are in), choose “other views”, “no results”
    You are able to customize there what happened when no data are returned

    Cheers
    Nicolas

  2. Venkatakrishnan J said

    Thanks Nicolas you are right. But as you said, this would involve modification to all the reports. I just took this as an example to show how to go about modifying the XML messages.

  3. […] 1. Go to {OracleBI}webmsgdbmessages. Open the file answerstemplates.xml in notepad. Search for the function validateAnalysisCriteria. This is the function which we are going to override using a custom function. To override we would be following the same method about which we saw earlier here. […]

  4. vyke said

    For those who are not sure what messages to change..

    • Change kmsgEVCNoRowsTitle message to “No Records Found” or something like that
    • kmsgEVCNoRowsFilters message to ‘’

    This gives a one line message in bold blue.

  5. Shantaram said

    Venkat,

    Is there a way to pass parameters into the output messages? One of my customers want to change

    “Welcome ” to
    “Welcome today is Analytics was last refreshed on ”

    this message is coming from custmessage.xml but how do I create new parameters to pass in?

    Regards
    Shantaram

  6. Vlad Valeyev said

    Venkat –

    in some of the message files there are links and variable represented by insert=”” tag. It looks like insert=”1″ links back to the login page. Is there a place that documents all these parameters? What is the source of 1, 2, 3,..? Is it some kind of config file?

    Thank you

    Vlad Valeyev

  7. Joan Massegú said

    Hi,

    just note something. Presentation Services Guide states that:
    “You can create multiple XML files in the customMessages folder, or create a single XML file that holds customized messages, for example, custommessages.xml. This is because the application goes through the customMessages folder and reads every file that has an XML extension, regardless of the file’s name.”

    But it seems not to be exactly truth (on 10.1.3.4.1) as I created a single file containing the exact messages to replace and it didn’t work. Then I coppied the whole original xml file (as in your example) and modified it, working propertly this time.
    What else coult it be? Any issue with my customized file format?
    It was (DOS format, UTF-8 codepage):

    Ver

    Ver

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: