Update column formula in multiple reports at one shot

Question

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..?

Pedro F · Answer

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.

Martin van Donselaar · Answer

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.

Joel Acha · Answer

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.