Now, let's organize our queries by grouping queries together. In this case, we will create groups for our active and intermediate queries.
To do this, we will use the following steps:
- Right-click the Hours query and select Move To Group and then New Group. The New Group dialog will be displayed, as shown in the following screenshot:
Figure 22: New Group dialog
- For Name, enter Active and, in the Description, enter Queries that become tables in the data model.
- Click the OK button. Note that two folders are created, an Active folder and an Other Queries folder.
- Select the Budgets and Forecasts query and right-click the query.
- Choose Move To Group and then Active.
- Repeat this process for the People query.
We now have our queries organized into Active queries and Other Queries.