RSS

TIP #1:Export BI Catalog captions from command line in OBIEE 11g

04 Nov

Localization is the most important and useful feature in OBIEE which will help to use the OBI Application across several countries in their own language.

The Oracle Business Intelligence Presentation layer supports multiple language translations for any presentation column name and column description. When working with Oracle BI Answers or rendering a dashboard, users should see their local language strings in their reports. For example, English-speaking and French-speaking users would see their local language strings in their reports.

There are two kinds of application strings required for the translation in Oracle Business Intelligence.

One we need to externalize the captions from RPD perspective and other from BI Catalog perspective.

In BI Catalog Perspective the Presentation Services objects are end-user created objects such as Reports, Dashboards, and Pages. Translations for Presentation Services strings are stored in the captions.xml file. How this could be accessed can be found from Oracle BI Presentation Service Admin Guide.

We all know how to do this from catalog manager. The same we can do from command line in OBIEE 11g we can export catalog captions for localization/Translating your BI catalog. One major advantage of this command is we can achieve same from LINUX/UNIX environments without opening catalog Manager Utility.

The steps to achieve this are as follows:

  1. Open command prompt and navigate to <MW_HOME>instances\instance1\bifoundation\OracleBIPresentationServicesComponent\
    coreapplication_obips1\catalogmanager\
  2. Execute the following command to export captions as per the below syntax:

Syntax for localization command:

runcat.cmd/runcat.sh -cmd localize -outputDirectory <output directory>

[-excludeDesc] [-incremental] [-duplicates (leaveAlone | removeIds | removeTexts)]

[-folder <path{:path}>] [-skipFolder <path{:path}>]

( (-offline <path of catalog>) | (-online <OBIPS url> -credentials <credentials properties file>) )

Basic Arguments

-outputDirectory <output directory>     Where to put the to-be-translated caption files.

Optional Arguments

-excludeDesc Don’t bother localizing descriptions

-incremental Only write changes to the output files

-duplicates (leaveAlone | removeIds | removeTexts) What to do with duplicate messages

-folder <path{:path}> Which folders in the catalog to localize

-skipFolder <path{:path}> Which ones not to

Common Arguments

-offline <path of catalog>

-online <OBIPS url>

-credentials <credentials properties file>

Example

1. To generate localization tags for everything in the catalog:

In Windows:

<command_prompt>: runcat.cmd -cmd localize -offline c:\oraclebi\data\web\catalog\paint -outputDirectory c:\temp\localized

In UNIX/LINUX:

<command_prompt>: ./runcat.sh -cmd localize -offline c:\oraclebi\data\web\catalog\paint -outputDirectory c:\temp\localized


2. To generate localization tags for only new or changed item names from the catalog folder /shared/Sales:

In Windows:

<Command_prompt>: runcat.cmd -cmd localize -offline c:\oraclebi\data\web\catalog\paint -outputDirectory c:\temp\localized -folder /shared/Sales -excludeDesc –incremental

In UNIX/LINUX:

<Command_prompt>: ./runcat.sh -cmd localize -offline c:\oraclebi\data\web\catalog\paint -outputDirectory c:\temp\localized -folder /shared/Sales -excludeDesc –incremental

Note: incremental changes will require merging by hand into existing translation files.

Thanks,
Shiva.

Advertisements
 
5 Comments

Posted by on November 4, 2010 in OBI EE, OBIEE 11g

 

5 responses to “TIP #1:Export BI Catalog captions from command line in OBIEE 11g

  1. sudhir

    June 28, 2011 at 3:10 pm

    Thanks Shiva, Do you know what would be the equivalent command line arguments for Archiving a catalog?

    Many Thanks in Advance!

     
  2. Sathish Kumar.G

    November 12, 2011 at 6:07 am

    Hi Shiva,

    I would like to appreciate you for your work.

    I need to know is there any possibility to relocate/change the position of the Oracle Logo in Login page from left to right side corner in 11G?If we can do so,can you elaborate it?

     
  3. SN

    December 15, 2011 at 5:10 am

    What is the syntax of the credential.properties file?

     
  4. Sreekanth Miryala

    May 10, 2012 at 3:26 pm

    Syntax should have catalog path in it
    runcat.sh -cmd localize -offline -outputDirectory

     
  5. prag1947

    March 16, 2016 at 3:44 pm

    Hi Shiva,

    I would like to upload word document/user guide into catalog using runcat.cmd?
    Can you advice me on it.

    Thanks in advance
    prag1947

     

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: