Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Can we make 'XML Search and Replace' conditional ?

Received Response
3
Views
3
Comments
Tom Lype
Tom Lype Rank 1 - Community Starter
edited Aug 13, 2024 5:51PM in Oracle Analytics Cloud and Server

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

Answers

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    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.

  • Gianni Ceresa
    Gianni Ceresa Mod

    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]
    [Deleted User] Rank 2 - Community Beginner 
    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