The underlying column in one of my models has been dropped and another column has been added which I'd like to replace in the model.
The model is giving the error that the old column can't be found - which is understandable
However, when I try to update the model query, it only gives the visual query editor which doesn't allow me to remove the old column from the SQL Query
For now, it seems like I'd have to create a new model which is going to make my life a lot difficult because I'd have to update hundreds of reports which use that model.
PLIZ HELP.
What do you mean by only gives the visual query editor ... You should be able to edit the Model definition, is this an SQL or GUI question?