Edit Data Views

Data views must be in draft mode to edit.

To edit data views

  1. Go to the Company Workspace tab and switch to Admin mode.
  2. In the left Navigator, click Data Structure Setup > Data Views.

    The User-Defined Data Views log opens.

  3. Select a view.
  4. In the toolbar, click Status and select Draft.
  5. Click the Open button to access the SQL statement.
  6. Edit the SQL statement and click Apply or OK to save changes.
  7. Select the data view again, click Status and 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 Thursday, December 14, 2023