I have created a report and everything working fine but after that I got a requirement to change the 10 column names in the RPD.I have changed in the BMM layer and reflected in presentation layer. How can I reflect the change in the report for multiple renamed columns smartly without doing one by one manually?
Search / Replace in Catalog Manager
Just double check what you are going to do and do a backup first as it's common the first time you try a search / replace to just broke your analysis because doing it wrong ...
And once done remove the aliases in the presentation layer, in that way you will easily find out if you forget 1 analysis as it will not work anymore (or deploy the SampleApp web cat analysis scripts doing that kind of checks).