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 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
- Go to the Company Workspace tab and switch to Admin mode.
- In the left Navigator, click Data Structure Setup > Data Views.
The User-Defined Data Views log opens.
- Select a view.
- In the toolbar, click Data.
The results window will display the query results.
To view columns
- Go to the Company Workspace tab and switch to Admin mode.
- In the left Navigator, click Data Structure Setup > Data Views.
The User-Defined Data Views log opens.
- Select a view.
- In the toolbar, click Metadata.
The results window will return all the columns in the view.
If the Data View is in Draft status, the metadata that you see will be based on the last Published data. If the Data View has not been published before, 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 Oracle Business Intelligence Publisher (BI Publisher) or Oracle Analytics Publisher report, or Data Cube that was included in a configuration package, 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 Thursday, December 14, 2023