How to Localize Oracle BI Presentation Catalog in 11g | The Big Data - Business Intelligence by Sandeep Venu

Enter key word

How to Localize Oracle BI Presentation Catalog in 11g

Hi All,

Here is the steps to localize  the OBIEE presentation catalog items in OBIEE 11G.

Presentation Catalog is used to store objects that are created by the users to define the dashboard and analysis. These objects are stored in a FOLDER known as the WEB CATALOG or CATALOG.


Step 1: Create A Dashboard Page with A sample report

In My Case "Product Dashboard" and Report Name is "Photo Gallery"



Step 2: Caption Directory Creation

Make sure that the following directory path exists in your INSTANCE_HOME


D:\FUSSION\instances\instance2\bifoundation\OracleBIPresentationServicesComponent\coreapplication_obips1\msgdb\l_fr\captions


iF it does not exist then CREATE IT like shown above.
Here i have used French Translation so that i have created the folder "l_fr"

Other examples of language extensions include:

'cs' for Czech
'de' for German
'ar' for Arabic


###################################################################
"The above directory will exist only if you have the Oracle Business Intelligence Application are installed."
###################################################################
  1. Oracle Database
  2. OBIEE Server
  3. OBIEE RPD
  4. OBIEE Maps
  5. Weblogic
  6. Errors
  7. Upgrade
  8. Customize
  9. Patch


Step 3: Open the catalog manager

You can open the catalog manager from the following path

D:\FUSSION\instances\instance2\bifoundation\OracleBIPresentationServicesComponent\coreapplication_obips1\catalogmanager\runcat.cmd

Open the catalog in ONLINE or OFFLINE mode and then open your catalog.

Select the folder which has your metadata (Shared folder). In my case the folder is BISAMPLE




Select the Folder > click on TOOL


Give an EXPORT folder and then click ok (Refer the pic above).





Step 4: Edit the BISAMPLE.XML file

Navigate to the exported folder and open the xml file in a notepad




Edit the Captions and Report titles as below.








Step 5: Deploy the Caption XML.

Copy the edited xml file and paste it in to the captions directory created before

D:\FUSSION\instances\instance2\bifoundation\OracleBIPresentationServicesComponent\coreapplication_obips1\msgdb\l_fr\captions





Step 6: Login to the Analytics using English and then go the the Administrations tab

Click the Reload Metadata files




Step 7: Log out and Login using French language

You can now find the changes as below




Dashboard



Report


Catalog




NB: If you don't see the metadata reflected then bounce the OPMN services.

  1. Oracle Database
  2. OBIEE Server
  3. OBIEE RPD
  4. OBIEE Maps
  5. Weblogic
  6. Errors
  7. Upgrade
  8. Customize
  9. Patch
Till Next Time,

Sandeep Venu

SHARE

About Sandeep Venu

    Blogger Comment
    Facebook Comment

0 comments:

Top Links

Upgrading BI Publisher

Add Google Search

OBIEE- LDAP

Change Admin Password

Best Practices

ORACLE 11GR2

Host Files

Customization

OBIEE-SIEBEL

Bug Fixes

Setting Default

OBIEE Installation failed

OBIEE Installation

Oracle Databse

Oracle In Linux

Loopback Adapter

Weblogic Failed

Yum Commands

Weblogic Admin

Linux Static IP

OBIEE LDAP

Admin Paswword

Scaling

Weblogic Starting Error

Localizing BI

Physical Schemas

Multimedia Dashboard

Video in OBIEE

Variables in OBIEE

Ago 30 Days

Email Link

ODI Installation

AGO Function

Sort Pivote table

OBIEE Patch

Reset Sys password

Date Calculation

Add Row in Report

Increase Row limit

OBIEE with Essbase

Reset Weblogic

BIP Login Error

MDS and BI Platform

ORA 28001 Error

ORA 12560 TNS Protocal Error

ORA 12154 TNS Error

OBIEE ON AIX

Pre Requsite

AIX Commands

Commands