Edit Data Views

Data views must be in draft mode to edit.

To edit data views:

Go to the Company Workspace tab, and switch to Admin mode.
In the left Navigator, select Data Structure Setup, and then select Data Views.
The User-Defined Data Views log opens.
Select a view.
From the toolbar, select Status, and select Draft.
To access the SQL statement, select Open.
Edit the SQL statement, and select Apply or OK to save changes.
Select the data view again, select Status, and select Publish to make the data view available for use in user defined reports, data cubes, and custom reports.