Book Image

Oracle BI Publisher 11g: A Practical Guide to Enterprise Reporting

By : Daniela Bozdoc
Book Image

Oracle BI Publisher 11g: A Practical Guide to Enterprise Reporting

By: Daniela Bozdoc

Overview of this book

<p>Oracle BI Publisher 11g (formerly XML Publisher) enables the creation, management and delivery of various reports, making it a desirable tool for any company to achieve the best image of your resources. This book offers practical application of BIP functionality for improving your ability to design and deliver quality reports just when they are needed.<br /><br />“Oracle BI Publisher 11g: A Practical Guide to Enterprise Reporting” is an applicable guide for using Oracle BIP from the perspective of a report developer, helping you to utilize the tool from simple to complex report design. You can take advantage of both the existing functionality of BIP 10g, as well as a special emphasis on the new 11g features.<br /><br />This guide will take you on a tour of Oracle BI Publisher 11g, beginning with a description of all of the new features in 11g. You’ll continue by learning from a range of step-by –step procedures for building Data Models, Layout Templates and report configurations, packed with screenshots to help you along. Finally, you’ll tackle themes like integration with Oracle EBS, Oracle report migration, and report translations.<br /><br />By the end of “Oracle BI Publisher 11g: A Practical Guide to Enterprise Reporting”, you’ll be equipped with all you need to know to produce complex reports detailing your company’s data.</p>
Table of Contents (20 chapters)
Oracle BI Publisher 11g: A Practical Guide to Enterprise Reporting
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Glossary
A
B
C
D
E
F
G
H
J
L
M
N
O
P
R
S
T
U
X
Z
Index

File translation


At a lower level than catalog translation, file translation allows you to translate only specific objects from the BI Publisher catalog. The objects you can translate are as follows:

  • RTF templates

  • Style templates

  • Subtemplates

  • BI Publisher templates (.XPT)

Using this technique, you will be able to provide translations in circumstances where the users want to consult only some reports in another language, or they want to send documents to the partners in different languages.

The way file translation is actually realized depends on another factor: whether the translated template needs another layout than the original template or not. In the first case, you must create another localized template, in the second case you'll use an XLIFF file, allowing you to translate only the text strings of the template.

This section will present concrete steps to follow in order to generate report translation for the cases listed as follows:

  • Same layout using BIP

  • Same layout using Template Builder for Word

  • Different layouts

Same layout using BIP

Let's assume first that you only need the text strings of the layout template to be translated. In this case, follow the steps:

  1. Open BI Publisher catalog.

  2. Click on the Edit link under the report name you want to translate.

  3. Click on the Properties link under the report layout to be translated, as shown in the following screenshot:

  4. This will open the Properties page shown below:

  5. Click on Extract translation to trigger the process that generates the XLIFF file.

  6. Save the XLIFF file to a folder of your choice.

  7. Update the XLIFF file by providing text between the <target> tags corresponding to the translated text from the <source> tags as you can see in the following screenshot:

  8. Click on the Upload icon in the Translations section to get your translated XLIFF file into BIP:

In this way, when choosing Romanian as Report Locale, BI Publisher will apply the translation for this particular report layout template when viewing the report.

Same layout using Template Builder for Word

As mentioned earlier, the Template Builder for Word can be used to generate the XLIFF file. The steps required in this case are as follows:

  1. Open the RTF layout template file using Word.

  2. Go to the Translation | Extract Text... menu option on the toolbar. This will generate the XLIFF file.

  3. Save the XLIFF file in a folder of your choice using the .xlf extension.

  4. Translate the text between the <target> tags providing translation for the text between the <source> tags, and save your work:

  5. Go to the Translation | Preview Translation... menu option on the toolbar and choose the modified file to see the result, as shown in the following screenshot:

    A good result means that your XLIFF file is correct and now you can proceed to upload it into BIP.

  6. In BIP, click on the Upload icon in the Translations section, and browse for the saved XLIFF file in order to get your translation file into BIP.

Different layouts

Here are the steps to follow when different layouts are needed for different languages:

  1. Design a brand new layout for your report. For example, here the columns have a different order than those in the original layout template and a column is missing. At the same time, the template text strings are translated:

    Tip

    You can make changes to the translated template permanently by clicking on the Translation | Localize Template... menu option on the toolbar. In this way, when only minor changes are necessary, you don't need to start your new layout design from scratch (or worst, with a blank document).

  2. Upload the template into BIP. Be careful to choose the appropriate Locale for your template, as shown in the following screenshot: