EAS - Release Notes 2010-07-27

Release Date Case Number Description of Change Affected BQY File Affected SQL Server Version? Affected Oracle Version?
Jan 10 3/8/2010 18311 Resize command button to fit on Limits dashboard Sales by Product ID Demand - Job.bqy, Sales by Product ID Demand Fiscal - Job.bqy, Sales by Product ID Ship - Job.bqy, Sales by Product ID Ship Fiscal - Job.bqy Y Y
Jun 10 3/26/2010 18405 Add new query to EAS  Net Sales by Ship-To State.bqy Y Y
Jun 10 3/31/2010 18198 Changed field names to use meta data names.  Change topic names to use meta data names Sales by Product Id.bqy. Sales by Product ID Demand - Job.bqy, Sales by Product ID Demand Fiscal - Job.bqy, Sales by Product ID Ship - Job.bqy, Sales by Product ID Ship Fiscal - Job.bqy Y Y
Jun 10 3/31/2010 18247 Changed width of number of columns to prevent numbers from being cut off Sales by Product Id.bqy. Sales by Product ID Demand - Job.bqy, Sales by Product ID Demand Fiscal - Job.bqy, Sales by Product ID Ship - Job.bqy, Sales by Product ID Ship Fiscal - Job.bqy Y Y
Jun 10 3/31/2010 18248 Fixed shading in report for sec ctrs Sales by Product Id.bqy. Sales by Product ID Demand - Job.bqy, Sales by Product ID Demand Fiscal - Job.bqy, Sales by Product ID Ship - Job.bqy, Sales by Product ID Ship Fiscal - Job.bqy Y Y
Jun 10 3/31/2010 18208 Removed orders and customer from pivots.  The count distinct caused performance issues.  Changed logic to get customer/order in results sets without having to use count distinct include in State, Sec Ctr, Customer Type, Offer and Use, and Date pivots.  Lines used in Item, Category, and Style pivot.  Added totals to sec ctr pivot. Sales by Product Id.bqy. Sales by Product ID Demand - Job.bqy, Sales by Product ID Demand Fiscal - Job.bqy, Sales by Product ID Ship - Job.bqy, Sales by Product ID Ship Fiscal - Job.bqy Y Y
Jun 10 4/1/2010 18405 Add new query to EAS  Summary Net Sales by Ship-To State.bqy Y Y
Jun 10 4/14/2010 18446 Rebuilt with meta data for drilldown fields.  Changed to be database independent.  Add new columns for PO visiblility.  Add vendor data.  Add display to show current selection criteria. Back orders.bqy Y Y
Jun 10 4/19/2010 18447 Modified columns names to use metadata names.  Added new selection criteria for vendor, buyer, and product category.  Add PO data.  Add product category descriptions.  Add PO information into reports.  Renamed results sets to have meaningful names. Back orders by vendor and buyer.bqy Y Y
Jun 10 4/26/2010 18445 Modified field names to use meta data names. Added more selection criteria to allow overdue or soon to be overdue receipts and allow selection by both buyer and vendor.  Added lead time and added SV_MACITM_VEND_ORD_TEL) Open purchase orders.bqy Y Y
Jun 10 5/3/2010 18595 Modified field names to use meta data names.  Added vendor to selection criteria.  Added vendor contact information (Added SV_MACITM_VEND_ORD_FROM, SV_MACITM_VEND_ORD_TEL).  Added buyer to buyer report.  Added to buy to pivots. Forecast to Buy.bqy Y Y
Jun 10 5/3/2010 18693 Excluded orders whose status are PQ or P4. (Added SV_MACORD_PROCESS_ORDER) Forecast to Buy.bqy Y Y
Jun 10 5/3/2010 18694 Excluded future orders and added column to call these out separately. Forecast to Buy.bqy Y Y
Jun 10 5/3/2010 18694 Add new future order units to reports Forecast to Buy.bqy Y Y
Jun 10 6/7/2010 Renamed query from Customer Service Dashboard to Customer Service Review Customer Service Review Customer Service Dashboard.bqy
Jun 10 6/7/2010 18865 Added order comments to the customer service dashboard.  Replaced mail date with order entry date what customers expect.  Changed join to customer query to left outer join. Customer Service Review.bqy Y Y