Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 44 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 278 Oracle Analytics and AI News
- 54 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 103 Oracle Analytics and AI Trainings
- 19 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Modify Filter value in Report
Hi All,
I have a requirement to modify the filter, BINNED, and prompted particular value.
Like replace "ABC" with "XYZ" in all reports where ABC is used as the filter, BINNED, and prompted.
We have more than 5000 reports and 1500 reports might have ABC used as filter or in BIN section or Prompt.
Using XML search and replace we may be able to search and modify one file at a time, using Notepad ++ ,, but there is a danger we may change the folder name or title or column name it self which we dont want to.
Please let us know if any one performed this activity and provide steps.
Thanks
Answers
-
Hi,
"XML Search and Replace" in Catalog Manager is what you look for as it will do all the job in one step (ok, maybe 2 or 3 for safety...).
Of course do not try to be smarter than what the tool is, doing a "search for 'ABC' and replace by 'XYZ' " because as you said it will replace it everywhere without really looking at what is ABC.
It's up to you to define the good search syntax, so searching for more than just ABC but maybe looking for a longer string which will clearly identify and match only the required things (and here is why I said 2 or 3 steps for safety as you better want to first look to replace only filters etc. by using a really strong matching string).
0 -
+1 to Gianni. XMLSearch&Replace can do that for the whole catalog as well, not just object by object
0
