Release Date Case Number Description of Change Affected BQY File Affected SQL Server Version? Affected Oracle Version?
Mar 09 3/17/2009 15902 Made changes to increase performance improvements Sales by Product ID.bqy Y Y
Sep 09 9/4/2009 Created new meta data to support version 10 of Ecometry
Dec 09 12/30/2009 Stopped supporting all queries using old returns structures Demand vs Shipped Sales.bqy Y Y
Dec 09 12/30/2009 Stopped supporting all queries using old returns structures Item Demand Analysis.bqy Y Y
Dec 09 12/30/2009 Stopped supporting all queries using old returns structures Item Summary Sales.bqy Y Y
Dec 09 12/30/2009 Stopped supporting all queries using old returns structures LTV Analysis.bqy Y Y
Dec 09 12/30/2009 Stopped supporting all queries using old returns structures Merchandise Performance Analysis.bqy Y Y
Dec 09 12/30/2009 Stopped supporting all queries using old returns structures Net Product Sales Analysis.bqy Y Y
Dec 09 12/30/2009 Stopped supporting all queries using old returns structures Open RAs.bqy Y Y
Dec 09 12/30/2009 Stopped supporting all queries using old returns structures Returns Analysis.bqy Y Y
Dec 09 12/30/2009 Stopped supporting all queries using old returns structures Returns Analysis - job.bqy Y Y
Dec 09 12/30/2009 Stopped supporting all queries using old returns structures Sales versus Returns Analysis.bqy Y Y
Dec 09 12/30/2009 Stopped supporting all queries using old returns structures Spread Performance Analysis.bqy Y Y
Dec 09 12/30/2009 Stopped supporting all queries using old returns structures Vendor returns analysis.bqy Y Y
Dec 09 12/1/2009 17621 Replaced static dates in pull down selection menus Pick Velocity.bqy Y Y
Dec 09 12/2/2009 17609 Replaced static dates in pull down selection menus All Orders by Status.bqy Y Y
Dec 09 12/3/2009 17611 Replaced static dates in pull down selection menus Demand vs Shipped NEW.bqy Y Y
Dec 09 12/3/2009 17615 Replaced static dates in pull down selection menus Item Demand Analysis NEW.bqy Y Y
Dec 09 12/3/2009 17613 Replaced static dates in pull down selection menus Inventory Adjustments.bqy Y Y
Dec 09 12/3/2009 17617 Replaced static dates in pull down selection menus LTV Analysis NEW.bqy Y Y
Dec 09 12/3/2009 17619 Replaced static dates in pull down selection menus Net Product Sales New.bqy Y Y
Dec 09 12/4/2009 17622 Replaced static dates in pull down selection menus Price Overrides.bqy Y Y
Dec 09 12/4/2009 17623 Replaced static dates in pull down selection menus Price Range Analysis.bqy Y Y
Dec 09 12/4/2009 17624 Replaced static dates in pull down selection menus Receiving Staffing Requirements.bqy Y Y
Dec 09 12/4/2009 17625 Replaced static dates in pull down selection menus Repeat Buyer Analysis.bqy Y Y
Dec 09 12/4/2009 17626 Replaced static dates in pull down selection menus Returns Analysis NEW.bqy Y Y
Dec 09 12/4/2009 17667 Reporting heading date updated when report run. Returns Analysis NEW.bqy Y Y
Dec 09 12/4/2009 17627 Replaced static dates in pull down selection menus.  Fixed default values for selection menu for recency, frequency, and monetary choices. RFM Analysis.bqy Y Y
Dec 09 12/7/2009 17610 Replaced static dates in pull down selection menus Customer Summary Sales.bqy Y Y
Dec 09 12/8/2009 17672 Corrected code to put item description in style name when style is null Price Range Analysis.bqy Y Y
Dec 09 12/8/2009 17628 Replaced static dates in pull down selection menus Sales vs Returns Analysis NEW.bqy Y Y
Dec 09 12/8/2009 17629 Replaced static dates in pull down selection menus Shipping charge analysis.bqy Y Y
Dec 09 12/8/2009 17630 Replaced static dates in pull down selection menus Shipping Charge Summary.bqy Y Y
Dec 09 12/8/2009 17631 Replaced static dates in pull down selection menus Spread Performance Analysis NEW.bqy Y Y
Dec 09 12/8/2009 17671 Corrected code to put item description in style name when style is null Spread Performance Analysis NEW.bqy Y Y
Dec 09 12/8/2009 17633 Replaced static dates in pull down selection menus Vendor expenditures by year and category.bqy Y Y
Dec 09 12/8/2009 17634 Replaced static dates in pull down selection menus Vendor Performance Analysis.bqy Y Y
Dec 09 12/8/2009 17635 Replaced static dates in pull down selection menus Vendor returns analysis.bqy Y Y
Dec 09 12/9/2009 17614 Replaced static dates in pull down selection menus Inventory Receiving Analysis.bqy Y Y
Dec 09 12/9/2009 17618 Replaced static dates in pull down selection menus Merchandise Performance Analysis NEW.bqy Y Y
Dec 09 12/9/2009 17616 Replaced static dates in pull down selection menus Item Summary Sales NEW.bqy Y Y
Dec 09 12/9/2009 17620 Replaced static dates in pull down selection menus P and H Overrides.bqy Y Y
Dec 09 12/9/2009 17179 Replaced static dates in pull down selection menus Sales by Product ID.bqy Y Y
Dec 09 12/16/2009 17728 Corrected code to put item description in style name when style is null Item Summary Sales NEW.bqy Y Y
Dec 09 12/16/2009 17729 Corrected code to put item description in style name when style is null Net Product Sales New.bqy Y Y
Dec 09 12/16/2009 17728 Corrected code to put item description in style name when style is null Item Summary Sales NEW.bqy Y Y
Dec 09 12/16/2009 17632 Replaced static dates in pull down selection menus Top X Customers.bqy Y Y
Dec 09 12/16/2009 17679 Fixed margin issue on display and change gm% to show 2 decimal points Top X Customers.bqy Y Y
Dec 09 12/21/2009 17677 Corrected code to put item description in style name when style is null Merchandise Performance Analysis NEW.bqy Y Y
Dec 09 12/21/2009 17731 Corrected code to put item description in style name when style is null Sales vs Returns Analysis NEW.bqy Y Y
Dec 09 12/21/2009 17730 Corrected code to put item description in style name when style is null Sales by Product ID.bqy Y Y
Dec 09 12/30/2009 17787 Changed report to pull data from results set instead of pivot table.  Fixed po link to pull only for items that are related to returns.   Turned into universal query. Item Summary Sales NEW.bqy Y Y
Jan 10 1/6/2010 17782 and 17783 Changed version number to keep in sync with changes to jobs Sales by Product ID.bqy Y Y
Jan 10 1/6/2010 17786 Missing limits dashboard replaced.  Fixed filtering Voided POS orders Sales by Product ID Ship - Job.bqy, Sales by Product ID Ship Fiscal - Job.bqy, Sales by Demand - Job.bqy, Sales by Demand Fiscal - Job.bqy Y Y
Jan 10 1/6/2010 17782 Scripts processing fixed to behave appropriately to be scheduled. Sales by Product ID Ship - Job.qy, Sales by Demand Fiscal - Job.bqy Y Y
Jan 10 1/6/2010 17783 Resets limit values appropriately Sales by Product ID Ship - Job.qy, Sales by Demand Fiscal - Job.bqy Y Y
Jan 10 1/18/2010 17876 Add new query to EAS  Inventory Position Analysis.bqy Y Y
Jan 10 1/20/2010 17848 Add new query to EAS  Customer Service Dashboard.bqy Y Y
Jan 10 1/26/2010 17913 Fixed calculation error in gross margin introduced during development.   Fixed other issues related document startup scripts. Item Summary Sales NEW.bqy Y Y