Business Intelligence – Oracle

Oracle BI EE – Presentation Catalog Captions

Posted by Venkatakrishnan J on October 19, 2007

There was one question today in the forums here with regard to the procedure for setting up Presentation Catalog Captions. Even though it is pretty much straight forward, i thought i would blog about it here since there have been some confusion with regard to the folders where Captions had to be copied. Let me first start with a brief introduction of what Presentation Catalog Captions actually mean. As you would know, BI EE suppors a variety of languages. The login screen would contain the list box having the list of languages and one can choose language based on his locale/preference. But when you actually login using the various languages you would find that all the Dashboards, Folders, Reports etc would be in Englidh by default. So what presentation catalog captions does is that it provides a procedure for translating all the presentation catalog data to the desired language. In our case, we will see how to go about converting the presentation catalog captions to french.

1.   Open the Catalog Manager. Open your presentation catalog in offline mode. The presentation catalog, if you had done a default install, would be under this directory {OracleBIData}/web/catalog/paint. Now go to Tools and click on Export Captions. That would prompt you to save the output XML file. Save this in any folder.



In my case i had copied it to D drive. As you see, the export process will basically create different XML files for different catalogs. The XML file of our interest is the PaintDemoCaptions.XML.

2.   Go to {OracleBIData}/web/res and create a folder l_fr(fr denotes the language french. If you are trying to do this for some other language put the corresponding abbr here). Open l_fr folder and under that create another folder called Captions. Now copy the PaintDemoCaptions.XML to this Captions directory.


3.   Open this XML file. As you would see this XML file would contain multiple tags and each of the names of Dashboards, Report, Folders etc would be under the Text Tags. Our aim is to translate these text strings to French. Just for demonstration purposes i would be showing the translation of a Dashboard Page Name and a Report name. I have used Babel Fish web site here to do the translation of 2 strings. The 2 strings i translated are

   Paint Demo   –   Peignez la Démo
   Brand Analysis   –   Analyse De Marque

Change these names in the PaintDemoCaptions.XML file and save the file.



4.   Restart the presentation services. First open the login to the dashboards with English as the language.


Log out and then login with French as the language.


As you see above the report name and the dashboard names have been translated to french.

7 Responses to “Oracle BI EE – Presentation Catalog Captions”

  1. schandrak said

    Hi Venkat,
    Followed your procedure to the proverbial ‘T’. But even then it only works for ‘Cesky’.No luck with French or any other language. Cannot think of any cause for the problem.Thanks for the post its very informative.Keep up the good work.

  2. […] System 9 BI – OverviewOracle BI EE and Mapviewer – Step by Step integration – Phase1Oracle BI EE – Presentation Catalog CaptionsAbout […]

  3. sreeharsha g s said

    Hi, On the presentation services screen of Oracle BI the default language which I am seeing is Arabic. I want to make the default as English.

    Even in my account , it is set to english. How can change it to english?

  4. sreeharsha g s said


    The default chart style is cylinder in Oracle Bi where it used to be rectangle in Siebel Analytics. Is there any way I can change the default style to rectangle across the system(in all the reports at once). I tried adding this in instanceconfig.xml. But it didnt work.


    I added the above tags just below the as given in the OBI guide…

    But it was no use..

  5. James said

    Hi Venkat,

    Follow your procedures to translate my dashboard captions to simplified chinese. But it doesn’t show the chinese characters as I expected. I suppose the l_zh is the abbr. for simplified chinese language, right? Is there any other settings I have to config?

  6. Rick said

    Hi Venkat,

    Excellent posting, very helpful. I was able to succesfully translate the catalog. Is there a way to translate the data from the warehouse? does OBIEE Plus supports multiple languages for the data. i.e., Month, and dislplay the month elements in english, german, spanish, etc.?

    Many thanks

  7. Vinayak said

    Hi Venkat,
    I am not able to get the translation done in my environment. Can you tell if you are assuming any settings in the environment since it has worked for you and another reader.


Leave a Reply

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

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

Google photo

You are commenting using your Google 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 )

Connecting to %s

%d bloggers like this: