Edit Data Views
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.
See Also
Grant Permissions for Data View Creation
Create and Publish Data Views and Metadata
View Data (Query Results) and Metadata (Columns) in the View
View Data View Usage in Reports and Data Cubes
Review Database Table Structure
Last Published Monday, August 28, 2023