Hello,
I have access to create reports with a data source of ‘Free-hand SQL’, however, once I’ve written the initial SQL query and hit ‘OK’ and it has created the query, I am unable to edit the SQL in the query script editor window (I can view it but I can’t change it at all and the ‘undo’, ‘validate’ and ‘ok’ buttons are all greyed out).
The system admin thinks it may be to do with how the connections for free hand SQL are set up.
There’s a SAP note which mentions this behaviour I think, but I’m unable to access it. 3134694 - Cannot edit the SQL of an existing webi report based on a Free Hand SQL in BI 4.3 SP02 | SAP Knowledge Base Article