Can we make 'XML Search and Replace' conditional ?

Question

Hi,

Is it possible to customize catalog manager feature 'XML Search and Replace' to replace certain columns/text only if another column/text exists in the report XML? Basically, I am looking to apply the changes only in some conditions.

This is in OBIEE 12c.  I looked into all the available options in the catalog manager but nothing. Even the file commands are limited via XML file changes.

* command – Specifies what action is to be taken
* textReplace – Replaces text other than the name of a table, column, formula
* renameTable – Renames the Table part of a formula alone
* renameColumn – Replaces the name of a column
* renameFormula – Renames the entire formula
* renameSubjectArea – Replaces the name of a subject area
* subjectArea – Apply this optional attribute to renameTable, renameColumn
* old Value – Specifies the text string to search for

If anyone has succeeded in doing the mass report changes on certain conditions please let me know.

---
Tom

[Deleted User] · Answer

Gianni Ceresa wrote:But ... you can always do a string working on the file system files containing the XML ....

That isn't "XML Search and Replace" So...technically... :-P

Gianni Ceresa · Answer

I will be a bit less categorical than Christian ...

Official by XML Search and Replace no.

But ... you can always do a string working on the file system files containing the XML ....

Just remember it's up to you to make sure you aren't going to destroy the catalog and you actually don't break the XML inside objects. (backup, backup, backup and don't expect Oracle support to help you if you break things doing it).

[Deleted User] · Answer

Short answer: No

Longer answer: No. If you want to "case-when" things then basically that has to happen before the execution of the command. basically execute the command or not based on the CASE.