Oracle^® Business Intelligence Presentation Services Administration Guide > Managing Presentation Catalogs Using Oracle BI Catalog Manager > Searching for and Replacing Presentation Catalog Text Using Catalog Manager >

About Searching for and Replacing Multiple Presentation Catalog Text Strings

You can search for and replace multiple Presentation Catalog text strings all at once by importing a XML file that identifies each text string to search for and replace.

Format of the XML File for Searching for and Replacing Multiple Text Strings

In the search and replace XML file, you use an <action> element to identify each text string to search for and replace. The <action> elements are contained in a <commands> element.

The <action> element has the following attributes:

• command — Specifies whether you want to replace text, a Column name, or a Subject Area name. Valid values are:
  • textReplace — Replaces text other than the name of a Column or the name of a Subject Area.
  • renameColumn — Replaces the name of a Column.
  • renameSubjectArea — Replaces the name of a Subject Area.
• oldValue — Specifies the text string to search for.
• newValue — Specifies the replacement text.

Example XML File for Searching for and Replacing Multiple Text Strings

Here is an example of an XML file for searching for and replacing multiple text strings all at once:

- <commands>

<action command="textReplace" oldValue="Analytics" new Value="Oracle Business Intelligence"/>

<action command="textReplace" oldValue="Markets.Region" new Value="Markets.CountryRegion"/>

<action command="renameColumn" oldValue="Region" new Value="CountryRegion"/>

<action command="renameSubjectArea" oldValue="SupplierSales" new Value="SupplySales"/>

  </commands>