Wednesday, August 4, 2010

OBIEE Catalog Search and Replace

Say we have 100+ reports where we need to replace the subject area from

PA_Production to SA_Production

image

Open the catalog in off-line mode.

image

Select folder which contains the reports you want to change:

image

goto Tools > XML Search and Replace

image 

Do the replace:

image

image 

Press Refresh:

image

Check the result:

image

Till Next Time

6 comments:

Bitloo said...

John:

My question is not about this post but in general around Union, Union All. I am running into sum calculation issues.

I have a union between two subject areas. The Result is:

Month
Count 1
Count 2

Until this point everything looks good. However when I perform Count 2 / Count 3 it does not work. The result I get is from 1st set. Union does not work. Any thoughts.

John Minkjan said...

@bitloo

please post off subject question on OTN
http://forums.oracle.com/forums/forum.jspa?forumID=378
or
http://obiee101.blogspot.com/2009/04/obiee-questions.html

As to your question, did you add the formula on the highest level of your combined request ("Result Columns")?

regards

John

Bitloo said...

@John:

I apologize. I have posted it on your Questions page.

Hemanth said...

Hi John,

Using XML Search and Replace we have an option of using input XML file to update specific objects using action commands like 'renameColumn'. Currently this update runs in background, can you please let me know where do I set up to run in foreground so that I can see the log of the list of reports updated using this tool. Thanks.

John Minkjan said...

@Hemanth

I'm not sure I understand your question, can you elaborate?

Hemanth said...

@John,
Pop-up screen having options 'Run in Background', 'Cancel', 'Details' (6th screenshot) would just flash and disapper. I mistook the process to be running in background whereas the process is actually completed. One other point, it has been confirmed that when using input XML file option to rename column names- action command 'renameColumn' does not work. We can only use action command 'textReplace' which is sometimes risky to use as it would replace matching text in whole XML. Example- To rename Column Name "Color"