What is the stable process for changes to freehandsql in stored procedure appearing within WEBI?

[carla_rogers]

Sometimes, when I make a report in webi, I do not anticipate every single field that is needed for the report.    In my shop, that means, the field needs to be added to the stored procedure that provides the data to webi.

Once the stored procedure referenced by the webi report has been updated to contain a new field, there is no reliable way I an find for the field becoming available for use in the webi

I 

I was able to make the fields appear, by changing the name of the stored procedure.  Unfortunately, there is an unwelcome side-effect of preventing the report from being able to display data.  The report runs without stopping for more than 10 times longer than it was taking to run, but no data is ever displayed.  So, it looks like the whole report has to be remade.  This is a productivity killer.

[nachtaktiv]

... instead of using "select * from" you have to work with the exact fieldnames, so FHSQL can recognize that something has changed

... and btw.  it is never recommended to use "*" in the final/productive SQL-statement

[nachtaktiv]

did you logoff from WebI and restart the browser ?

[carla_rogers]

The only repeatable result I have is any change to the sql in the stored procedure requires start developing the report in webi all over from the start.  I have seen some changes not cause that, but I don't know where the line is.