Categories
- All Categories
- Oracle Analytics Learning Hub
- 30 Oracle Analytics Sharing Center
- 18 Oracle Analytics Lounge
- 238 Oracle Analytics News
- 45 Oracle Analytics Videos
- 16K Oracle Analytics Forums
- 6.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 88 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations 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
