I have a Transformer model that is not built from an FM model. It is built using SQL extracts that provide the flat files needed for the cube.
I need to make a modification to this cube to add some levels into one of the dimensions. How can I go about determining the impact on existing reports based on this change?
I can look at the Audit files anh determine the reports being run against the cube. But then i would still need to look at each report individually to determine if that reports uses the dimension being changed.
In FM model it is relatively easy to determine model changes. Is there an easier way for Transformer?