- Contents
Dashboard Help
Add a Saved Query Data Source
Use the Add Data Source dialog box to add a Saved Query data source.
To add a Saved Query data source
-
Do one of the following:
-
To open an existing dashboard, in the toolbar, click the tab of the dashboard to open and then click Edit. The dashboard displays in edit mode.
-
To add a dashboard, click the plus sign (+) tab. The dashboard displays in add mode.
-
In the Data Sources box, click the plus sign (+).
The Add Data Source dialog box appears.
-
In the toolbar, click SavedQuery.
-
In the Select a Database list box, click the database to query. The "Default" option represents the database specified in the connection string in the Dashboard Web.config file.
-
In the Select a User list box, click the user for whom to display saved queries. Dashboard populates the Select a Saved Query list box with the queries that the specified user created.
-
In the Select a Saved Query list box, click the saved query to use to retrieve data.
-
To limit the query results to reflect the management role of the selected user, select the check box.
-
In the Name box, type a name for the data source and then click Add. Dashboard adds the Saved Query data source to the Data Sources section.