Requirements for a Manufacturing Productivity SAS Reporting Application

This document should serve as preliminary requirements for an application to display various charts and graphs for reject and scrap data for a manufacturing customer. The application should be a one-screen interface with the majority of the screen displaying the chart. Radio buttons (or list boxes with selectable items) and drop-down box controls should appear on a small portion of the right-hand side of the screen.

The data to feed the charts will be one pre-joined table that will exist as part of the SAS data warehouse and will be updated nightly. See the sample mock-up for a functional example of this application. Listed below are individual specifications:

  1. The user should be able to click on radio buttons or a list box to specify classification variables for the generation of bar charts. The values in the radio buttons or list box should be populated from a static table. The charts should display total pounds of reject/retreat material as the analysis variable. As of now, the table to populate the radio-buttons or list-box selections should contain the following values:

·        Cost Center

·        Gage

·        Width

·        Customer

·        Side (Top or Bottom)

·        Edge (Drive or Operator)

·        Finish

·        Coating

·        Product

·        Band Vendor

·        Band Width

·        Band Gage

·        Manufacturing Type

·        Defect Category

·        Defect Group

  1. The user should be able to break down the bars into a stacked bar chart by selecting a second variable from the above list. The sections of each bar will be color-coded and the chart will display a legend of the color codes. It would also be nice if a ‘float-over’ could be used to display the description of each section of the chart.
  1. The user should be able to subset by a time variable. The user should be able to specify a date/time range as small as an 8-hour shift.
  1. There should be a trending component to the application. The user should be able to choose from a list any one of classification variables from the list above. After choosing a variable, a second list box will be populated with distinct values of that variable to allow the user to select one or multiple distinct values. When the user selects distinct value(s), the trending chart will have a where clause applied on that value(s).
  1. The trending component of the application should have a button to allow the user to select the top 20 distinct values
  1. The user should be able to use a drop-down box of check-box to select whether to display reject or retreat data. The underlying records in the source data will be marked as reject or retreat and thus this switch will really just control a where-clause applied to the data.
  1. In addition to a bar chart, the user should be able to take the same underlying data and choose to have the chart display as a pie-chart or scatter-plot.
  1. For bar charts, the bars should be sorted descending based on total pounds and the user should be able to choose how many bars display on the chart.
  1. The user should be able to click a button and get an Excel (or text file) extract of the data that makes up a given chart.
  1. The user should be able to print the chart.
  1. If possible, allow a user to save and rerun a given chart/graph without needing to re-specify each of the individual switches/buttons.