We cannot seem to edit FHSQL webi reports promoted from development and user acceptance environments using BI4.2 SP7. The query cannot be edited due to a missing connection. We are not allowed cross staging in our BI env hence we use lcmbiar files for promoting content.
FHSQL has a lot of drawbacks; difficulty in migrating between environments is one. It's not really intended for use in production reports.
Not sure if this will work, but it might be worth a try: