Create a Data Query Based on an Existing One

You can create a new query based on an existing query for all types of data sources in CDM. You must already have a data query that points to a relational database and specifies the database type.

1. In CDM, do either of the following to open the Data Queries tab in the work area:
   • Click the File tab, then navigate to Administration > External Data > Data Queries.
   • Click the Home tab, then in the Navigation Pane, click Administration and double-click Data Queries under External Data.
2. In the data query list, right-click the query you want to use and click Copy into New.
3. Edit the query name, server type, connection, or comments as required.
   • An OLAP data query and an external Microsoft™ Excel data query can both be edited in the query wizard.
   • A relational database query can be edited in the Query Builder window.
4. Ensure the correct reports are associated with the data query
5. Click Finish.