Say we have 100+ reports where we need to replace the subject area from
PA_Production to SA_Production
Open the catalog in off-line mode.
Select folder which contains the reports you want to change:
goto Tools > XML Search and Replace
Do the replace:
Press Refresh:
Check the result:
Till Next Time
John:
ReplyDeleteMy 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.
@bitloo
ReplyDeleteplease 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
@John:
ReplyDeleteI apologize. I have posted it on your Questions page.
Hi John,
ReplyDeleteUsing 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.
@Hemanth
ReplyDeleteI'm not sure I understand your question, can you elaborate?
@John,
ReplyDeletePop-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"