Manage SQL Queries

You can edit the pre-loaded data mart queries or add a custom query to the drop-down list of queries. To manage queries, use the buttons from the Query group in the Query Tools ribbon tab.

Add Query - Adds a new query to the data source. Clicking this button invokes the Query Editor dialog that allows you to create a new query by pasting in the text of SQL statement or by invoking the Query Builder.

Edit - Modifies the selected query using the Query Editor.

Rename - Renames the selected query.

Filter - Filters the selected query. To learn more, see the Filter Queries topic.

Delete - Removes the selected query.