View Data (Query Results) and Metadata (Columns) in the View
The Data button will return the query results of the view (essentially, a preview of the report results, without any user entered parameters).
The Metadata button will return all of the columns in the view. The Metadata button will return the definition of the columns: names, type and labels of the columns used in the view. For example:
To view query results
- In Administration Mode, go to the Company Workspace tab and click Company > Data Structure Setup > Data Views in the left Navigator. The User-Defined Data Views log opens.
- Select a view in the User-Defined Data Views log.
- Click the Data button. The results window will display the query results.
To view columns
- Select a view in the User-Defined Data Views log.
- Click the Metadata button. The results window will return all of the columns in the view.
If the Data View is in Draft status, then the metadata that you see will be based on the last Published data. If the Data View has not been published before, then no data is displayed.
You can delete a Data View that was included in the configuration package, indirectly.
Note: Although deletion of a Data View is possible, if a Data View has been used in a UDR, Custom BI Publisher report, or Data Cube that was included in a configuration package, then the configuration package creation will fail because of the missing data views.
See Also
Grant Permissions for Data View Creation
Create and Publish Data Views and Metadata
View Data View Usage in Reports and Data Cubes
Review Database Table Structure
Last Published Monday, August 28, 2023