Location: User Guide
Please click on the desired help section.
 |
1.1 General Introduction | |||||||||||||
|
1.2 Search Criteria | |||||||||||||
|
1.3 Field Selections | |||||||||||||
|
1.4 Report Changes | |||||||||||||
|
1.5 Sub Report Selection | |||||||||||||
|
1.6 Generated Reports | |||||||||||||
|
1.7 Download Format Options | |||||||||||||
|
1.8 Change History | |||||||||||||
1.1 General Introduction The Data Mart System is part of the enhancement project of the Mandatory Price Reporting System (MPR). The Data Mart system will provide public access to the Livestock MPR system's aggregated or "over time" report data through a web-based interface with the ability to search and download selected report data. Top of Page |
||||||||||||||
1.2 Search Criteria Users can use search criteria drop down boxes or list boxes to generate reports based on specific search criteria. Each search criteria drop down or list box contains a list of options to choose from. Users are allowed to choose only one item from a drop down box and multiple items from a list box. Choosing specific options from the list allows the user to filter information that will be shown in the generated report. Below is an example of a search criteria drop down box. Within the box there is a drop down list with 5 options (as shown in Figure 1.2.1). These options are used to help users to filter out the data that they don't need.  Figure 1.2.1 Filter Criteria OptionsWhen selecting the All option, all information related to the Field Name is searched upon.NOTE: When selecting the All option for a date field (Report Start Date), the start date will be set to a default start date of 4/1/2001. When selecting Equal To, Less Than, or Greater than option, an additional text box is displayed (as shown in Figure 1.2.2) for user's input. Users can search by a specific date (for date field) or a number.  Figure 1.2.2 Equal To CriteriaWhen selecting the Between option, 2 additional text boxes are displayed (as shown in Figure 1.2.3) for user's inputs. Users can search by a range of dates (for date field) or numbers. Figure 1.2.3 Between CriteriaBy selecting the calendar icon located on the right of Date Field users can select search dates by selecting dates with the use of a calendar (as shown in Figure 1.2.4). Figure 1.2.4 CalendarDepending on the Field Name field search criteria drop down boxes may contain different selection options. Figure 1.2.5 Other Search Criteria Drop Down BoxesBelow is an example of a search criteria list box. Users can choose one or more items from the list. If nothing is selected from the list, meaning nothing is highlighted in blue, then all options will be included in the generated report. Figure 1.2.6 Search Criteria List BoxTo select multiple consecutive items, click on the first item and drag down to the last item. The selected items should be highlighted in blue. Figure 1.2.7 Select Multiple Consecutive ItemsTo select multiple non-consecutive items, click on the first item and hold down the Ctrl key before clicking on the other items. Figure 1.2.8 Select Multiple Non-Consecutive ItemsTop of Page |
||||||||||||||
1.3 Field Selections Users can choose a field that they would like to have displayed in there result set by placing a check in the Include in Results check box that appears directly to the right of the reports Field Name. For each Field Name, there is an Include in Results check box (as shown in Figure 1.3.1). By selecting this check box the user is able to filter fields that they do not wish to have in there reports by selecting which fields they would like included in their generated report. By default some fields have already been pre selected to appear in the generated report. Users are able to unselect and change which field to be displayed by unselecting the Include in Results check box, which appears next to the Field Name. Users are able to create customized generated reports to fit their individual needs by choosing which fields they would like included in the report result set.  Figure 1.3.1 Include in Results SelectionTop of Page |
||||||||||||||
1.4 Report Changes USDA may at times, posts notices to the public concerning specific changes to a report. These changes may range from simply layout changes to more complex algorithm changes that effect the aggregated data. USDA will post changes to effected reports so that public users may be made aware of these changes. If a change to a report has been detected - a hyperlink similar to the one listed below will be displayed.  Important report changes have been found for this report. Please review
Details on the changes can be reviewed by clicking on that link. A separate browser window will open and display (as shown in Figure 1.4.1). Any changes detected within the date range you have selected will be shown sorted by most recent first.  Figure 1.4.1 Detailed Report ChangesTop of Page |
||||||||||||||
1.5 Sub Report Selection Users have the ability to select which sub report(s) that they want to generate simply by check or uncheck the check boxes. By default, all of the sub reports are checked (as shown in Figure 1.5.1).  Figure 1.5.1 Sub Report Selection Default ScreenTo uncheck a sub report, click on the check box once (as shown in Figure 1.5.2). Figure 1.5.2 Sub Report Selected by UserTop of Page |
||||||||||||||
1.6 Generated Reports Users have the ability to generate a single or multiple sub reports. Please refer to Section 1.5 on sub report selection. For a single sub report, at the sub report selection screen (as shown in Figure 1.6.1) enter a specific report start and end date.  Figure 1.6.1 Generating a Summary Report for a specific dateClick on the Continue button. The Summary Search Criteria screen is displayed (as shown in Figure 1.6.2). Figure 1.6.2 Summary Search Criteria ScreenClick on the Generate Report button. A Report Header is displayed (as shown in Figure 1.6.2.5). Figure 1.6.2.5 Report HeaderClicking on the report date displays the Summary sub report (as shown in Figure 1.6.3). Figure 1.6.3 Single Generated ReportFor multiple sub reports, more than one sub report need to be checked (as shown in Figure 1.6.4). Once the Continue button is clicked, the Search Criteria screen for all selected sub reports is displayed (as shown in Figure 1.6.5). When all of the search criteria have been set, click on the Generate Report button. All sub reports are displayed (as shown in Figure 1.6.6). Figure 1.6.4 Multiple Sub Reports Figure 1.6.5 Search Criteria Screen for Multiple Sub Reports Figure 1.6.6 Multiple Generated Sub ReportsTop of Page |
||||||||||||||
1.7 Download Format Options Once a report is generated, the user has the option to export their result set in one of three different formats (as shown in Figure 1.7.1).  Figure 1.7.1 Exporting Generated ReportWhen exporting a generated report in the Data Mart Default XML format, result set will be saved to as a XML file. The data contained within the file can then be viewed with the use of a Note Pad application. Figure 1.7.2 XML formatWhen exporting a generated report in a CSV (Comma Separated Value) format or a Fixed Width format, a separate window will be displayed showing different sub reports that can be exported (as shown in Figure 1.7.3). Users have the ability to select which sub report to export. Figure 1.7.3 Exporting Sub Reports ScreenOnce a sub report is selected, result set will be saved as a CSV file. The data contained within the file can then be sorted and viewed with the use of The Microsoft Excel application. Figure 1.7.4 CSV (Comma Separated Value) formatOnce a sub report is select, result set will be saved to as a Fixed Width Test document. The data contained within the file can then be viewed with the use of a Note Pad application. Figure 1.7.5 Fixed Width FormatTop of Page |
||||||||||||||
1.8 Change History
Top of Page |
||||||||||||||
|
Home | |||||||||||||
|
Data Dictionary | |||||||||||||