Non-Administrator User groups having issue while "Viewing the query" for existing report based on "Free Hand SQL" of build type "Webi". but can refresh the reports successfully without any issues.
Error : "This query cannot be edited"
Followed the below steps but still same issue.
- Login to Central Management Console(CMC)
- Navigate to Applications > Web Intelligence > User Security
- Select desired User/User group > Assign security > Advanced > Add/Remove rights
- Grant the following rights: General: Edit this object, Reporting - enable formatting and Desktop Interface - Enable Local Data Provider
- Select Application > Web Intelligence from the left pane
- Grant: Documents – enable creation, Query Script - enable editing (SQL, MDX..) and Query Script - enable viewing (SQL, MDX..)
- Click Apply >> OK