Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 211 Oracle Analytics News
- 42 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Update column formula in multiple reports at one shot
How can we update a column formula in all reports wherever that column is used.
Let us say we have some X_Val column with formula (rep_col1 + rep_col2 + qty) in report001, report002,report003,report004,report005,....reportN.
I want to replace that column formula to (rep_col1 + rep_col2 + rep_col3 + qty) in one shot.
Is this possible..?
Answers
-
You can do an XML search and replace in the catalog manager. Before you do this, i do strongly suggest backing up your catalog in case things go wrong.
0 -
If you need this in multiple analyses / Dashboards then you should really consider moving logic to the RPD, or preferably to your ETL process so you won't have to calculate the same every time.
0 -
Not much to add to what Joel and Martin said. However, just adding another option that despite not as good as Martin's, can be a valid one. In 12c (you don't mention the version you're using...), you can save a column with a formula you define. By doing that, you're then able to use that column in multiple analysis which means that if in the future you need to change the formula, you'll only need to change it in one place avoiding the situation you currently have.
0
