Release Date Case Number Description of Change Affected BQY File Affected SQL Server Version? Affected Oracle Version?
May 11 6/4/2010 18821 Correct the logic that groups Order levels that have a status of "In the Warehouse" All Orders by Status.bqy Y Y
May 11 6/4/2010 18822 Changed the column header of the 2nd fact column from "Order Level Count" to "Pct of Order Levels" All Orders by Status.bqy Y Y
May 11 8/17/2010 19306 Modified query to use the base table name on SV_MACITM_VENDOR_ITEMS instead of the numbered version Back orders.bqy Y Y
May 11 12/17/2010 15692 Added Adjustment Reason Code filter to the selection criteria dashboard Inventory Adjustments.bqy Y Y
May 11 12/17/2010 19885 Added Adjustment Reason description to pivots/reports Inventory Adjustments.bqy Y Y
May 11 12/17/2010 20031 Moved the Vendor Preference Limit from the query to the results section and added Include Nulls Inventory Adjustments.bqy Y Y
May 11 12/17/2010 20043 Updated all fields in the query request lines to use business names (metadata) instead of table column names Inventory Adjustments.bqy Y Y
May 11 12/17/2010 20053 Added ability to sort reports at the group level based on the field in the group and by Item number at the detail level. Adjustments by Reason / User reports sorted by Transaction Date. Inventory Adjustments.bqy Y Y
May 11 1/4/2011 15673 Corrected a logic bug that was preventing dashboard filter values from being applied to query limits. Standardized the formatting of dollar, date and amount fields Aged Open AR.bqy Y Y
May 11 1/4/2011 18563 Add a filter to the main dashboard that allows entry of customer numbers Aged Open AR.bqy Y Y
May 11 1/4/2011 19551 Corrected a logic bug that was preventing the correct age range title from being calculated for the age group Aged Open AR.bqy Y Y
May 11 1/4/2011 19552 Updated limit on AR_STAT to be consistent with Ecometry's values of Open and Partially Open Aged Open AR.bqy Y Y
May 11 1/4/2011 19751 Updated the formula that determines the age of the receivable to use the due date if present, otherwise use the transaction date. Aged Open AR.bqy Y Y
May 11 1/4/2011 19911 Add a filter to the main dashboard that allows entry of transaction type Aged Open AR.bqy Y Y
May 11 1/4/2011 20064 Updated all fields in the query request lines to use business names (metadata) instead of table column names Aged Open AR.bqy Y Y
May 11 1/4/2011 16243 Added limit to query to exclude price adjustments (codes M, P) Item Summary Sales NEW.bqy Y Y
May 11 1/4/2011 16268 Added vendor data into query Item Summary Sales NEW.bqy Y Y
May 11 1/4/2011 17178 Modified the OPEN RA limit to include null values Item Summary Sales NEW.bqy Y Y
May 11 1/4/2011 18199 Updated all fields in the query request lines to use business names (metadata) instead of table column names Item Summary Sales NEW.bqy Y Y
May 11 1/28/2011 20176 Add new query to EAS  Top X Sales Analysis.bqy Y Y
May 11 2/17/2011 16889 Updated the names of the Pivot tables and their related dashboards to match eachother. Added a new Dashboard for Pivot by Pay Method and navigation command buttons to access it from the other dashboards Aged Orders in the Warehouse.bqy Y Y
May 11 2/17/2011 18016 Updated the Ship method bar chart so that each Pay Method / Ship Method bar group is a different color Aged Orders in the Warehouse.bqy Y Y
May 11 2/17/2011 18046 Updated left side labels in the Pivots by Ship Method and Age to show the correct default labels Aged Orders in the Warehouse.bqy Y Y
May 11 2/17/2011 18406 Updated the Age Category ranges to be < 2 Days, 2 – 3 Days, 4 – 5 Days, 5 – 7 Days, and > 7 Days Aged Orders in the Warehouse.bqy Y Y
May 11 2/17/2011 18702 Updated formula that calculates warehouse value in Combined Results to properly extract and build the correct two digits Aged Orders in the Warehouse.bqy Y Y
May 11 2/24/2011 13781 Update the Query Summary Documentation to further explain why Cost of goods are overstated when kit components are included and provide an example Sales by Product ID Query Summary Document Y Y
May 11 2/24/2011 16145 Remove Continuity Line Code from limit from Ship versions of JOB to make it consistent with ad-hoc version of query Sales by Product ID Ship Job.bqy, Sales by Product ID Ship Fiscal Job.bqy Y Y
May 11 2/24/2011 16335 Update Query Summary Documentation to further explain where reported numbers match Ecometry values Sales by Product ID Query Summary Document Y Y
May 11 2/24/2011 19894 Enhance criteria selection on item number to enter multiple item number values separated by commas Sales by Product ID.bqy Y Y
May 11 2/24/2011 20590 Change coding script on Export This Pivot command buttons so they work in a web environment Sales by Product ID.bqy Y Y
May 11 2/28/2011 11515 Add new query to EAS  Cancellation Analysis.bqy Y Y
May 11 2/28/2011 20609 Modified query to make pivot  tables active in web environment Cancellation Analysis.bqy Y Y
May 11 2/28/2011 20610 Modify query to retain database logon information across multiple clicks of the Process Query command button. Cancellation Analysis.bqy Y Y
May 11 3/14/2011 16240 Added limit to query to exclude price adjustments (codes M, P) Net Product Sales Analysis NEW.bqy Y Y
May 11 3/14/2011 19930 Add product category descriptions to query. Added the Major Category description as a default left-side label to the Sales by Category pivot. Net Product Sales Analysis NEW.bqy Y Y
May 11 3/14/2011 20320 Add capability to specify customer numbers on the selection criteria dashboard and limit query results to those specified. Net Product Sales Analysis NEW.bqy Y Y
May 11 3/14/2011 20664 Modify query to sort contents of item status list box main dashboard. Populate list box with values from Item Type Codes instead of Item Master so they are present when metadata is missing Net Product Sales Analysis NEW.bqy Y Y
May 11 4/6/2011 18043 Modified query to make pivot  tables active in web environment Inventory Position Analysis.bqy Y Y
May 11 4/6/2011 19940 Add vendor number, vendor name,vendor item number to the item query section Inventory Position Analysis.bqy Y Y
May 11 4/7/2011 16241 Added limit to query to exclude price adjustments (codes M, P) Item Demand Analysis NEW.bqy Y Y
May 11 4/7/2011 19929 Updated query to add vendor number to dashboard selection criteria and add vendor item number to query so users can drill down to it. Updated query to use business names (metadata) instead of table column names. Item Demand Analysis NEW.bqy Y Y
May 11 4/7/2011 20181 Modified query to have Top X radio buttons to point to the Item Demand Analysis Selection Criteria Dashboard instead of the Performance Activity dashboard. Item Demand Analysis NEW.bqy Y Y
May 11 4/7/2011 20197 Modified query to display the correct names for the Major, Minor, Sub Major and Sub Minor category descriptions Item Demand Analysis NEW.bqy Y Y
May 11 4/7/2011 20198 Updated Top X Items command button to navigate to the Vendor Dashboard and changed the name of the vendor dashboard to Analysis by Vendor Item Demand Analysis NEW.bqy Y Y
May 11 4/7/2011 20199 Changed the sort dropdown on the Vendor Dashboard to sort by vendor and not item number Item Demand Analysis NEW.bqy Y Y
May 11 4/7/2011 20821 Fix Selection Criteria command button on the Offer Dashboard to branch to the main dashboard when clicked. Item Demand Analysis NEW.bqy Y Y