Oracle Analytics and AI

How to replace column name in existing reports

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

Find more posts tagged with

Accepted answers

All comments

Gianni Ceresa

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

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 ""dim1"."Level8"" -new ""dim1"."Level9"" -folder "/shared/test"

DeepaliG-Oracle

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

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

DeepaliG-Oracle

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

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

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 !