Hi,

I am on OBIEE12.2.1.4.

We have 100+ reports/filters using a dimension table, say dim1. dim1 has columns level1, level2...level8.

There is a change in design of dim1 and now there will be 9 columns instead: level1, level2...level9. And value in these columns are going 1 level up. Which means the existing report using level1 will have to use level2, using level2 will use level3 ....(so on) now.

To keep the existing reports/filters working, I tried running the following runcat replace command on a test catalog folder "/shared/test" :

e.g.

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

This command runs but gives following output

Items Changed

None

Although there is a report using dim1.level8 column in "/shared/test".

Can anyone please suggest what am I doing wrong?

Thanks,

Deepali