Edit Data Views

Data views must be in draft mode to edit.

To edit data views

  1. 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.
  2. Select a data view in the User-Defined Data Views log.
  3. Click Status and select Draft.
  4. Click the Open button to access the SQL statement.
  5. Edit the SQL statement and click Apply or OK to save changes.
  6. Highlight the data view and click Status.
  7. Select Publish to make the data view available for use in user defined reports, data cubes, and custom reports.

See Also

Creating Data Views

Grant Permissions for Data View Creation

Create and Publish Data Views and Metadata

View Data (Query Results) and Metadata (Columns) in the View

Export Data (Query Results)

View Data View Usage in Reports and Data Cubes

Delete Data Views

Review Database Table Structure


Last Published Saturday, July 12, 2025