Data views must be in draft mode to edit.
To edit data views
- In Administration Mode, go to the Company Workspace tab and click Data Structure Setup > Data Views in the left Navigator. The user defined Data Views log opens.
- Select a data view in the User-Defined Data Views log.
- Click Status and select Draft.
- Click the Open button to access the SQL statement.
- Edit the SQL statement and click Apply or OK to save changes.
- Highlight the data view and click Status.
- Select Publish to make the data view available for use in user defined reports, data cubes, and custom reports.