Once the report is saved, it will be listed in the Queries section.
Each query listing comes with several options on the right:
Run Now: This option runs the query. By default, all the queries are saved in the ElasticStore so every time, this option is chosen, the query is executed against the warehouse. If chosen otherwise, the query is executed real-time against the database.
Edit: This option lets you edit the queries and save them again.
Data Management: This option tells you data management of the query.
Add a linked Dataset: This option allows you to create new linked queries and datasets from the data. The original dataset will be the parent and the new one will be from it. Applicable for data stored in ElasticStore.
Data Diagram: Click this to see a visual mapping of how widgets are related to datasets and their associated queries
Share: Lets you share the query report with other user groups or users.
Clone: Lets you build a query, using the existing query as a baseline.
History: Lets you view the change history for this query. Note: you must have edit privileges for the query.
- Additional query revert button is available as soon as any historical item is expanded.
- Refresh will refresh the query with any subsequent changes that may have been made whilst on that page
Delete: Deletes a query. You can opt to remove all widgets/visualizations associated with the particular query.
Cancel (Beta): Cancel a currently running query. The behavior of this action depends on datasource type of the running query. the thread that is executing the query will be interrupted, thereby allowing it to disconnect and return. A new run of the same query can then be executed.
Click on Download Queries button if you want to download the queries (to track in your source control).