Wednesday, December 15, 2010

Upgrading OBIEE 10g RPD & Catalog to OBIEE 11g

About Upgrade:
What is Upgrade?
 
The term upgrade refers to the replacement of a product with a newer version
of the same product.
Example: OBIEE 10g – OBIEE 11g
Why to Upgrade?
Suppose if we want to use developed RPD & Catalog (10g) in Higher version (11g)
we have  to go for upgrading.  

In desktop under folder kk contains OBIEE 10g Paint RPD & Catalog

 
 




List of Repositories in OBIEE 11g before upgrade                                                          








List of Catalogs in OBIEE 11g before upgrade                                                          

  





To run Oracle Fusion Middle ware Upgrade Assistant click on ua.bat


  
  















List of Repositories in OBIEE 11g after upgrade


  








Thanks
Pasupuleti 

Monday, December 13, 2010

Language Translation in OBIEE

About language Translation:

 
What is Language Translation?
  Translating Language from one to another.
 
Example: English – French
Why to Translate
Suppose we have 2 Users (English & French), If French User wants to see dashboard
 reports & pages in French. He can log in with French-language and see all in French.
By Default it will be English 
-------------------------------------------------------------
How to do language Translation in OBIEE:
 
We Have 2 Methods:
 
Externalize Strings
Catalog Manger
 OBIEE11g-Language Translation:
For Language Translation in OBIEE_11g, we need to export catalog captions. 

 





Below are the Steps to Export Catalog Captions

· Back up the catalog before exporting from it. 
Ensure that you run the export utility against the actual catalog, not against a copy of the catalog, because the export utility changes the properties of the objects in the catalog against which it runs. 
· In Catalog Manager, open the catalog in either online or offline mode
· Select the target folder that contains the strings to export. The utility runs against the files in that folder and all its subfolders. 
For example, the Report in the following analysis can be exported for translation. 

 


STEPS To Export CATALOG:
From the Tools menu, select Export Captions. 
· Click Browse to select the location in which to write the output file, then click OK. 
· To export only new text strings and those that have been changed since the last export, select only export new or changed strings. 
· To exclude the Description properties from the export, select Exclude Descriptions.
· Click OK. 
The export process might take several minutes. 
· When the export process is complete, deliver the output file to the localization team. 
You can make a copy of every output file for each language to be translated. 
Create one folder (Eg: captions on Desktop)
 







Use  GOOGLE TRANSLATION: English to French

 
  







We can edit the XML for Translation:



 
 










NOTE: we should change the word which is in between <Text>….</Text>

 
The following shows an extract from an exported caption XML file before translation (for example, samplelitecaptions.xml) and after translation (for example, samplelitecaptions_fr.xml). 


The below is the path in which we need to place the updated French xml.


Steps: 

Create a folder with name l_fr as shown in below pic.
 
 










Create another folder with name l_fr in which captions should be placed










After that stop all services once and start

 

  You can find the changes as below when we login with language Francis.
 











Thanks,
Pasupuleti