DARTS : Exercise: Modify GL Query Exercise (Easy to moderate)

This exercise will help you learn the functions of the PS query by modifying an existing query. You need Query Manager access.

Please use the query in FNPRD, UMS_DTS_REVENUE_EXPENSE, and do these 10 exercises.

Exercise:

1. Log into FNPRD MaineStreet and search the query, UMS_DTS_REVENUE_EXPENSE. Click “Edit”.
2. Save the query as “UMS_DTS_REVENUE_EXPENSE_TEST” (as private)
3. Delete “BUSINESS_UNIT” field
4. Change the column name: “FUND_CODE” to “Fund”
5. Change the order of the column: Move FISCAL_YEAR to be the last column
6. Add new criteria: FUND_CODE=’00’
7. Add criteria for aggregated field: “BUDGET_BALANCE” is greater than 0
8. Add prompt for “CLASS_FLD”
9. Run the query
10. Delete the query you just created

Answer Key:

1. Running Reports with Query Viewer & Query Manager
2. Saving & Organizing Queries
3. Editing Queries#Deleteafield
4. Editing Queries#ChangeHeadingText(field name)
5. Editing Queries#columnorderColumnOrder
6. Changing a Selection for Variables in a Criteria#UsingCriteria
7. Changing a Selection for Variables in a Criteria#UsingCriteria
   Please note that the criteria will be shown under "Having" page, not the "Criteria" page.
   
8. Adding a New Prompt
9. Click "Run" page and the prompt screen will show up automatically. Enter values on prompts if you like then click OK.
   
10. Saving & Organizing Queries#DeletingQueries