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

How to replace column name in existing reports

Received Response
52
Views
7
Comments
DeepaliG-Oracle
DeepaliG-Oracle Rank 3 - Community Apprentice
edited Aug 13, 2024 5:14PM in Oracle Analytics Cloud and Server

Hi,

I am on OBIEE 12.2.1.4.

We have existing 100+ reports using a dimension, say dim1. dim1 contains columns Level1, Level2...Level8.

There is a change in design and now, there are Level1 to Level9 columns and levels are going 1 up. Which means analysis using Level1 should use Level2, using Level2 should use Level3 ....(so on) now.

We now need to update the existing 100+ reports/filters using dim1 level columns.

I tried using the runcat replace command to achieve this migration

e.g. following command is for a test catalog folder "/shared/test"

./runcat.sh -cmd replace -online <saw.dll path> -credentials creds.txt -old "dim1"."Level8" -new "dim1"."Level9" -folder "/shared/test"

This command runs fine but shows:

Items Changed

None

Although there is column "dim1"."Level8" in one of the report in "/shared/test".

Can anyone please guide what am I doing wrong here?

Thanks,

Deepali

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    Did you try some alternative syntax to escape " ?

    " in your command is probably interpreted as a quoting of the values and not as part of the value to search & replace.

  • DeepaliG-Oracle
    DeepaliG-Oracle Rank 3 - Community Apprentice

    Thanks for your response Gianni.

    Yes I tried the escaping as well. I tried following command as well, but result is the same .

    ./runcat.sh -cmd replace -online <saw.dll path> -credentials creds.txt -old "&quot;dim1&quot;.&quot;Level8&quot;" -new "&quot;dim1&quot;.&quot;Level9&quot;" -folder "/shared/test"

  • DeepaliG-Oracle
    DeepaliG-Oracle Rank 3 - Community Apprentice

    I also tried giving the input in xml file with renameFormula/renameColumn (followed the example from help). But it also doesn't update anything :(.

  • Gianni Ceresa
    Gianni Ceresa Mod

    How about trying from the GUI of runcat? It should deal with the escaping there....

  • DeepaliG-Oracle
    DeepaliG-Oracle Rank 3 - Community Apprentice

    Just tried, yes it works from Catalog Manager for a single test report...Thanks!

    Although it will not be feasible to do it from UI in Production. Please suggest how to achieve this from runcat command please.

  • Gianni Ceresa
    Gianni Ceresa Mod

    It's all about finding how to escape / encode correctly things. I know it is possible (done that), but it was so long ago that I just can't remember anymore what it was like...

    Not having much time to try it myself today.

  • DeepaliG-Oracle
    DeepaliG-Oracle Rank 3 - Community Apprentice

    Tried escaping this way and it Worked!

    ./runcat.sh -cmd replace -online <saw.dll path> -credentials creds.txt -old "\"dim1\".\"Level8\"" -new "\"dim1\".\"Level9\"" -folder "/shared/test"

    Thanks Gianni !