Data Extracts Data Extracts is designed to provide you with an easy intuitive

Data extracts data extracts is designed to provide

This preview shows page 23 - 25 out of 38 pages.

Data Extracts Data Extracts is designed to provide you with an easy, intuitive method to select data elements to include in an extract, enter various search criteria, extract the data in a format that is compatible with Microsoft EXCEL, and download the extract to your PC. Users of this function will need to perform three steps prior to generating a data extract – select data elements to include in the spreadsheet, select data elements to use to limit the query, & enter information for the query itself. Last Updated: 11/02/2006 Page 23 of 38
Image of page 23
Financial Data Warehouse Training Guide Data Extracts Selecting Query Criteria: 1.From the page, "Please select the columns you want to appear in the spreadsheet" select the data elements to include in the extract for presentation. The choice "DEFAULT COLUMNSwill already be highlighted. Default columns are those data element names preceded by an asterisk. Additional or different data elements may be selected.To select data elements in addition to the defaults, while holding the CTRL key on the keypad down, point to a data element name with the mouse pointer and click the left mouse button. Thiswill highlight the selected field and leave "DEFAULT COLUMNS" selected. Additional data elements may be selected by continuing this same process.To select data elements other than all of the "DEFAULT COLUMNS", point to a data element name with the mouse pointer and click the left mouse button. This will highlight the selected data element and will de-select the "DEFAULT COLUMNS" option. To select additional data elements, while holding the CTRL key on the keypad down, point to a data element name with the mouse pointer and click the left mouse button. This will highlight the selected field and leave all previously selected fields highlighted.2.From the page, "Please select the columns you want in the selection criteria" the user selects those data elements that are to be used to limit those data records selected for the extract. The choice "DEFAULT COLUMNS" will already be highlighted. Default columns are those data element names preceded by an asterisk. Additional or different data elements may be selected.To select data elements in addition to the defaults, while holding the CTRL key on the keypad down, point to a data element name with the mouse pointer and click the left mouse button. Thiswill highlight the selected field and leave "DEFAULT COLUMNS" selected. Additional data elements may be selected by continuing this same process.To select specific data elements and not select all of the "DEFAULT COLUMNS", point to a data element name with the mouse pointer and click the left mouse button. This will highlight the selected data element and will de-select the "DEFAULT COLUMNS" option. To select additional data elements, while holding the CTRL key on the keypad down, point to a data element name with the mouse pointer and click the left mouse button. This will highlight the selected field and leave all previously selected fields highlighted. "
Image of page 24
Image of page 25

You've reached the end of your free preview.

Want to read all 38 pages?

  • Spring '18
  • Dr. Moez
  • Fiscal Year, Purchase order

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture