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

Catalog translation


You can use this type of translation when you want all the objects that BI Publisher includes to be translated. This feature allows translation of the following:

  • Report layouts

  • Catalog object descriptions

  • Report parameter's names

  • Data display names

It is a good choice to use catalog translation when the users working with BI Publisher use a language other than English. Users viewing the catalog will see the item translations appropriate for the UI Language and report translations appropriate for the Report Locale they selected in their My Account preferences.

On the home page of BI Publisher, click on the My Account link found under your username, to set your preferences. This is shown in the following screenshot:

Your preferences may be inherited from another Oracle product. In this case, you cannot update your preferences from within BI Publisher. This is one of the situations captured in the preceding image.

Note

When BI Publisher is integrated with Oracle BIEE, BI Publisher catalog translation is ignored.

For a catalog translation perform the following steps:

  1. In BI Publisher, open the catalog and select the folder to be translated.

  2. Click on the Translation icon shown in the following screenshot and select the Export XLIFF menu option.

  3. Save the .xlf file in a folder of your choice:

  4. Open the XLIFF file using a text editor. It will look like the following screenshot:

  5. Change the target-language attribute of the <file> tag with the target language code.

    Note

    Only en is available for the source language.

  6. Provide a translation for the text contained by the <source> tags. You have to enter the translation between the corresponding <target> tags.

    This file also contains object names and not only text strings contained by these objects, as you can see in the following screenshot:

    Notice that opening the file in MS Word 2007—as shown in the following image—will generate a simplified version, not allowing attribute changing or viewing. But at the same time, simpler is better when you only need <source> and <target> tags to enter the translation and your work will be ready in no time:

  7. Upload the translated file back to BI Publisher.

    Click on the Translation icon and go to the Import XLIFF menu option. This will open the Upload dialog window. Browse for the file containing the catalog translation and click on Upload: