Skip to Content
0
Jan 21, 2020 at 01:31 PM

Can't view queries for existing reports based on Free Hand SQL build type Webi.

523 Views Last edit Jan 21, 2020 at 01:34 PM 2 rev

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.

  1. Login to Central Management Console(CMC)
  2. Navigate to Applications > Web Intelligence > User Security
  3. Select desired User/User group > Assign security > Advanced > Add/Remove rights
  4. Grant the following rights: General: Edit this object, Reporting - enable formatting and Desktop Interface - Enable Local Data Provider
  5. Select Application > Web Intelligence from the left pane
  6. Grant: Documents – enable creation, Query Script - enable editing (SQL, MDX..) and Query Script - enable viewing (SQL, MDX..)
  7. Click Apply >> OK