Taurus Software
Measures for Ecomedate
10/2/2014
| Modification Date | Case Number | Description of Change | Affected BQY File | Affected SQL Server Version? | Affected Oracle Version? |
|---|---|---|---|---|---|
| 11/14/2012 | 23980 | Corrected problem where BO-Cancels were being picked up multiple times if the same item was canceled on multiple line items | Cancellation Analysis.bqy | Y | Y |
| 12/17/2013 | 25508 | Added AU to action search filter in append query | UnShipped Orders by Status.bqy, UnShipped Orders by Status-Job.bqy | Y | Y |
| 2/6/2014 | 25926 | Add visibility into inventory figures. Add inventory data to query | Back orders.bqy | Y | Y |
| 3/20/2014 | 25822 | Enhanced query to include more kinds of cancels that had not been picked up before. NOTE: this version requires the table SV_MACORD_BO_HISTORY and the view BACKORDER_HISTORY | Cancellation Analysis.bqy | Y | Y |
| 4/21/2014 | 25730 | Change joins between Returns and Order Header and Order Line Items to left joins to account for POS returns | Net Product Sales Analysis NEW.bqy | Y | Y |
| 4/23/2014 | 25986 | Change "if" logic for Cancel Date to better attribute actual date the line items were canceled | Cancellation Analysis.bqy | Y | Y |
| 5/1/2014 | 26020 | Query kept causing IR client plug-in to crash. Removed then added back in the Item Status filter. Removed extra code that populated the Item Status list box a second time. | Net Product Sales Analysis NEW.bqy | Y | Y |
| 5/2/2014 | 26059 | Query kept causing IR client plug-in to crash. Removed then added back in the Co Cd and Div Cd filters. | Inventory Adjustments.bqy | Y | Y |
| 6/5/2014 | 26237 | Query timing out; change the order of tables, making RETURNS the driving table of the append query. Change join between Returns and Returns Order Header back to simple equal join. Change relationship of Returns Offers and Returns Sources - join them directly to RETURNS instead of Order Header. Also - remove the redundant RefreshAvailableValues in the Document Startup Script | Net Product Sales Analysis NEW.bqy | Y | Y |
| 6/19/2014 | 21792 | Add style and vendor pivots to the query | Cancellation Analysis.bqy | Y | Y |
| 6/26/2014 | 26259 | Add new scheduled version of job. | Net Product Sales Analysis - Shipped Sales - Job.bqy | Y | Y |
| 6/26/2014 | 26279 | Add new scheduled version of job. | Net Product Sales Analysis - Demand Sales - Job.bqy | Y | Y |
| 7/1/2014 | 26390 | Add new documentation to product | Scheduling EAS Queries.doc | ||
| 7/9/2014 | 25408 | Change column/drill-down names to English/metadata names | UnShipped Orders by Status.bqy | Y | Y |
| 7/9/2014 | 25409 | Change column/drill-down names to English/metadata names | UnShipped Orders by Status - Job.bqy | Y | Y |
| 7/10/2014 | 16242 | Exclude price adjustments and miscellaneous credits from the returns numbers | Demand vs Shipped Sales NEW.bqy | Y | Y |
| 7/10/2014 | 19907 | Change Style Name - populate with item description for items that are not part of a style | Demand vs Shipped Sales NEW.bqy | Y | Y |
| 7/10/2014 | 22480 | Add a text box on selection criteria screen to provide entry of a comma-separated list of Offer Codes | Demand vs Shipped Sales NEW.bqy | Y | Y |
| 7/10/2014 | 22484 | Add sort drop-down list to each tab | Demand vs Shipped Sales NEW.bqy | Y | Y |
| 7/10/2014 | 25622 | Add "Net Units" column to each pivot table | Demand vs Shipped Sales NEW.bqy | Y | Y |
| 7/10/2014 | 26419 | Correct script on "Export this Pivot" button to work in HTML mode | Demand vs Shipped Sales NEW.bqy | Y | Y |
| 7/10/2014 | 26521 | Remove all report sections: pivots do not fit on page. Customers mostly use "Export" functionality | Demand vs Shipped Sales NEW.bqy | Y | Y |
| 7/14/2014 | 22284 | Add capability to specify a list of offer codes on the selection criteria dashboard and limit query results to those specified. | Net Product Sales Analysis NEW.bqy | Y | Y |
| 7/14/2014 | 23391 | Replace Sales by Sectional Center tab and pivot with Sales by Zip Code | Net Product Sales Analysis NEW.bqy, Net Product Sales Analysis - Shipped Sales - Job.bqy, Net Product Sales Analysis - Demand Sales - Job.bqy | Y | Y |
| 7/14/2014 | 26359 | Change script on "Export This Pivot" button to work in HTML mode | Net Product Sales Analysis NEW.bqy, Net Product Sales Analysis - Shipped Sales - Job.bqy, Net Product Sales Analysis - Demand Sales - Job.bqy | Y | Y |
| 7/14/2014 | 26423 | Add enhanced sort drop-down, allowing sort by all facts and row labels | Net Product Sales Analysis NEW.bqy, Net Product Sales Analysis - Shipped Sales - Job.bqy, Net Product Sales Analysis - Demand Sales - Job.bqy | Y | Y |
| 7/14/2014 | 26431 | Add Usable Inventory Quantity, On Order Quantity, and Backorder Quantity to list of drill-down fields, and as facts on Sales by Item Pivot. On Hand Quantity is usable only. Add Primary Vendor Number, Primary Vendor Item Number, and Primary Vendor Unit Cost to list of drill-down fields. | Net Product Sales Analysis NEW.bqy, Net Product Sales Analysis - Shipped Sales - Job.bqy, Net Product Sales Analysis - Demand Sales - Job.bqy | Y | Y |
| 7/14/2014 | 26457 | Add Country, Primary Vendor Name, Primary Vendor Telephone Number, Buyer Code, Buyer to list of drill-down fields | Net Product Sales Analysis NEW.bqy, Net Product Sales Analysis - Shipped Sales - Job.bqy, Net Product Sales Analysis - Demand Sales - Job.bqy | Y | Y |
| 7/14/2014 | 22167 | Allow the user to analyze back by either a number of weeks or by specifying a start and end date | Forecast to Buy.bqy | Y | Y |
| 7/14/2014 | 24283 | Add Next PO Number, Next PO Quantity, Next PO Due Date to the query | Forecast to Buy.bqy | Y | Y |
| 7/14/2014 | 26443 | Renamed some of the column names and reordered the drill down order | Forecast to Buy.bqy | Y | Y |
| 7/15/2014 | 25631 | Add On Hand Quantity, Store On Hand Quantity, and Warehouse On Hand Quantity to the query. Add the first two to the summary pivot. | Back orders.bqy | Y | Y |
| 7/15/2014 | 23386 | Add Available Quantity and In Process Quantity. | Back orders.bqy | Y | Y |
| 7/16/2014 | 20498 | Add Item Status and Item Status Description fields to query | Forecast to Buy.bqy | Y | Y |
| 7/16/2014 | 20027 | Add Offer Name, Use Description, Primary Vendor Number, Primary Vendor Name, Primary Vendor Vendor Telephone Number, Primary Vendor Item Number, Buyer Code, and Buyer name as drill-down fields. | 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 |
| 7/16/2014 | 20319 | Add capability to specify customer numbers on the selection criteria dashboard and limit query results to those specified. | 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 |
| 7/16/2014 | 22268 | Add Country Code and Country as drill-down fields | 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 |
| 7/16/2014 | 23046 | Add capability to specify a list of offer codes on the selection criteria dashboard and limit query results to those specified. | Sales by Product ID.bqy | Y | Y |
| 7/16/2014 | 23389 | Replace Sales by Sectional Center tab and pivot with Sales by Zip Code tab | 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 |
| 7/16/2014 | 26421 | Remove all report sections and report pivots: pivots do not fit on page. Customers mostly use "Export" functionality | 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 |
| 7/16/2014 | 26424 | Add enhanced sort drop-down, allowing sort by all facts and row labels | Sales by Product ID.bqy | Y | Y |
| 7/16/2014 | 26438 | Add Available Inventory Quantity, On Order Quantity, and Backorder Quantity to list of drill-down fields, and as facts in Sales by Item tab | 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 |
| 7/16/2014 | 26355 | Change script on "Export This Pivot" button to work in HTML mode | Sales by Product ID Demand Fiscal - Job.bqy | Y | Y |
| 7/16/2014 | 26425 | Add enhanced sort drop-down, allowing sort by all facts and row labels | Sales by Product ID Demand Fiscal - Job.bqy | Y | Y |
| 7/16/2014 | 26356 | Change script on "Export This Pivot" button to work in HTML mode | Sales by Product ID Demand - Job.bqy | Y | Y |
| 7/16/2014 | 26426 | Add enhanced sort drop-down, allowing sort by all facts and row labels | Sales by Product ID Demand - Job.bqy | Y | Y |
| 7/16/2014 | 26351 | Correct the expression for "Sales Date" - use Shipment Date instead of Mail Date | Sales by Product ID Ship Fiscal - Job.bqy | Y | Y |
| 7/16/2014 | 26357 | Change script on "Export This Pivot" button to work in HTML mode | Sales by Product ID Ship Fiscal - Job.bqy | Y | Y |
| 7/16/2014 | 26427 | Add enhanced sort drop-down, allowing sort by all facts and row labels | Sales by Product ID Ship Fiscal - Job.bqy | Y | Y |
| 7/16/2014 | 26350 | Correct the expression for "Sales Date" - use Shipment Date instead of Mail Date | Sales by Product ID Ship - Job.bqy | Y | Y |
| 7/16/2014 | 26358 | Change script on "Export This Pivot" button to work in HTML mode | Sales by Product ID Ship - Job.bqy | Y | Y |
| 7/16/2014 | 26428 | Add enhanced sort drop-down, allowing sort by all facts and row labels | Sales by Product ID Ship - Job.bqy | Y | Y |
| 7/16/2014 | 24642 | Add query name to the top of 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 |
| 7/16/2014 | 24643 | Change title on Selection Criteria screen from "Product Sales Analysis" to "Sales by Product ID" | Sales by Product ID.bqy | Y | Y |
| 7/17/2014 | 22478 | Add capability to specify a list of offer codes on the selection criteria dashboard and limit query results to those specified. | Item Summary Sales NEW.bqy | Y | Y |
| 7/17/2014 | 22360 | Change script on "Export This Pivot" button to work in HTML mode | Item Summary Sales NEW.bqy | Y | Y |
| 7/17/2014 | 26464 | Add enhanced sort drop-down, allowing sort by all facts and row labels | Item Summary Sales NEW.bqy | Y | Y |
| 7/17/2014 | 26468 | Add selection criteria for: Customer Type, Customer Status, Customer Action, list of Customer Numbers | Item Summary Sales NEW.bqy | Y | Y |
| 7/17/2014 | 26469 | Add drill-down columns to match Sales by Product ID and Net Product Sales:Offer Name, Use Description, Primary Vendor Unit Cost, Buyer Code, Buyer, Primary Vendor Telephone Number, Available Inventory Quantity, On Order Quantity, Backorder Quantity, L1 Code, L2 Code, L3 Code, L1 Description, L2 Description, and L3 Description. Change "Vendor xxx" column names to "Primary Vendor xxx". | Item Summary Sales NEW.bqy | Y | Y |
| 7/17/2014 | 26472 | Create separate versions of query for Oracle and SQL Server | Item Summary Sales NEW.bqy | Y | Y |
| 7/18/2014 | 22479 | Add capability to supply comma-separate list of offer codes as selection criteria | Customer Summary Sales.bqy | Y | Y |
| 7/18/2014 | 23383 | Add company name to list of drill-down fields. Add country name | Customer Summary Sales.bqy | Y | Y |
| 7/18/2014 | 25626 | Add customer type description as drill down field and as row label on Sales by Customer Type Pivot | Customer Summary Sales.bqy | Y | Y |
| 7/18/2014 | 26361 | Change scripts on "Export This Pivot" so they will work in HTML | Customer Summary Sales.bqy | Y | Y |
| 7/18/2014 | 26474 | Add enhanced sorting so all pivots can be sorted by all row labels on any fact, ascending or descending | Customer Summary Sales.bqy | Y | Y |
| 7/18/2014 | 26475 | Add additional selection criteria to match Net Product Sales and Sales by Product ID | Customer Summary Sales.bqy | Y | Y |
| 7/18/2014 | 26476 | Replace Sales by Sectional Center tab and pivot with Sales by Zip Code tab | Customer Summary Sales.bqy | Y | Y |
| 7/18/2014 | 26480 | Remove all report sections | Customer Summary Sales.bqy | Y | Y |
| 7/21/2014 | 19997 | Add Buyer Email Address, Buyer Day Telephone Number, and Buyer Night Telephone Number to list of drill-down fields | Net Sales by Ship-To State.bqy | Y | Y |
| 7/21/2014 | 26486 | Change scripts on "Export This Pivot" so they will work in HTML | Net Sales by Ship-To State.bqy | Y | Y |
| 7/21/2014 | 18708 | Correct expression for "Age Category". Bucket 2 was showing "2 - 5 Days" instead of "3 - 5 Days" | Drop-Ship Exception Analysis.bqy | Y | Y |
| 7/21/2014 | 21343 | Exclude stock balance returns and voided POS orders - Order Status "SR" and "VD" | Item Demand Analysis NEW.bqy | Y | Y |
| 7/21/2014 | 26488 | Change scripts on "Export This Pivot" so they will work in HTML | Item Demand Analysis NEW.bqy | Y | Y |
| 7/21/2014 | 26489 | Add enhanced sorting so all pivots can be sorted by all row labels on any fact, ascending or descending | Item Demand Analysis NEW.bqy | Y | Y |
| 7/22/2014 | 21276 | Add new computed item "Return Lag Time", which is Return Date minus Ship Date. Add this column to all pivots, using the "Non-null Average" data function, with the title "Average Return Lag Time" | Sales versus Returns Analysis NEW.bqy | Y | Y |
| 7/22/2014 | 22481 | Add capability to provide a comma-separated list of Offer Codes as part of the Selection Criteria, allow wildcards. | Sales versus Returns Analysis NEW.bqy | Y | Y |
| 7/22/2014 | 23412 | Move the "Clear Select Criteria" button to the bottom of the screen, with the other buttons | Sales versus Returns Analysis NEW.bqy | Y | Y |
| 7/22/2014 | 26494 | Add enhanced sorting so all pivots can be sorted by all row labels on any fact, ascending or descending | Sales versus Returns Analysis NEW.bqy | Y | Y |
| 7/22/2014 | 26495 | Add Line Item Status Code table to data model and connect to Order Line Items. Change expression for "Line Item Status" to select from this table. | Sales versus Returns Analysis NEW.bqy | Y | Y |
| 7/22/2014 | 25653 | Add filters by Item Status Code, Buyer Code, Vendor Number, and a filter to select items with no inventory, inventory, or items with open POs. | Inventory Position Analysis.bqy | Y | Y |
| 7/23/2014 | 26501 | Add enhanced sorting to allow all pivots to be sorted by all facts, ascending or descending; reorganize results and table section, then add quick-filters on Company, Division, Item Status, Buyer, Major Category, and Primary Vendor. | Inventory Position Analysis.bqy | Y | Y |
| 7/23/2014 | 15876 | Correct divide by zero error on Projected Demand per Million Circ | Merchandise Performance Analysis NEW.bqy | Y | Y |
| 7/23/2014 | 16245 | Exclude price adjustments and miscellaneous credits from returns portion of query | Merchandise Performance Analysis NEW.bqy | Y | Y |
| 7/23/2014 | 26451 | Corrected category descriptions being selected from wrong fields | Merchandise Performance Analysis NEW.bqy | Y | Y |
| 7/23/2014 | 26503 | Change column names to English/metadata names | Merchandise Performance Analysis NEW.bqy | Y | Y |
| 7/23/2014 | 26505 | Correct script associated with "Export This Pivot" button to work in HTML | Merchandise Performance Analysis NEW.bqy | Y | Y |
| 7/23/2014 | 26504 | Add enhanced sorting so all pivots can be sorted by all row labels on any fact, ascending or descending | Merchandise Performance Analysis NEW.bqy | Y | Y |
| 7/24/2014 | 16247 | Exclude price adjustments and miscellaneous credits from returns portion of query | Spread Performance Analysis NEW.bqy | Y | Y |
| 7/24/2014 | 22938 | Correct sort in results section so all items appear correctly in pivots | Spread Performance Analysis NEW.bqy | Y | Y |
| 7/24/2014 | 26508 | Add enhanced sorting so all pivots can be sorted by all row labels on any fact, ascending or descending | Spread Performance Analysis NEW.bqy | Y | Y |
| 7/24/2014 | 26506 | Change column names to English/metadata names | Spread Performance Analysis NEW.bqy | Y | Y |
| 7/24/2014 | 26507 | Correct script associated with "Export This Pivot" button to work in HTML | Spread Performance Analysis NEW.bqy | Y | Y |
| 7/24/2014 | 17780 | Exclude price adjustments from Vendor Returns Analysis NEW | Vendor returns analysis NEW.bqy | Y | Y |
| 7/24/2014 | 20033 | Need Limit on Vendor Preference in Vendor Returns Analysis Query | Vendor returns analysis NEW.bqy | Y | Y |
| 7/24/2014 | 26506 | Change column names to English/metadata names | Vendor returns analysis NEW.bqy | Y | Y |
| 7/24/2014 | 26512 | Add Enhanced Sorting Capability to Pivot Table | Vendor returns analysis NEW.bqy | Y | Y |
| 7/24/2014 | 26513 | Add Quick Filters to enhance usability. Filter on: Primary Vendor, Buyer, Major Category, Item Status, and Return Reason | Vendor returns analysis NEW.bqy | Y | Y |
| 7/25/2014 | 26465 | corrected category descriptions being selected from wrong fields | Price Range Analysis.bqy | Y | Y |
| 7/25/2014 | 26503 | Change column names to English/metadata names | Price Range Analysis.bqy | Y | Y |
| 7/25/2014 | 26515 | correct script associated with "Export" buttons to work in HTML | Price Range Analysis.bqy | Y | Y |
| 7/28/2014 | 26530 | Add quick filters on Company, Division, State, Country, Customer Type, Customer Status, Customer Action | Customer Summary Sales.bqy | Y | Y |
| 7/28/2014 | 26527 | Add quick filters on Company, Division, Major Category, Item Status, Offer, and Primary Vendor | Item Demand Analysis NEW.bqy | Y | Y |
| 7/28/2014 | 26557 | Add quick filters on Company, Division, Major Category, Item Status, Offer, and Primary Vendor | Demand vs Shipped Sales NEW.bqy | Y | Y |
| 7/28/2014 | 26523 | Add quick filters on Company, Division, Major Category, Item Status, Offer, and Primary Vendor | Item Summary Sales NEW.bqy | Y | Y |
| 7/29/2014 | 26525 | Add quick filters on Company, Division, Major Category, Item Status, Offer, and Primary Vendor | Net Product Sales Analysis NEW.bqy, Net Product Sales Analysis - Shipped Sales - Job.bqy, Net Product Sales Analysis - Demand Sales - Job.bqy | Y | Y |
| 7/29/2014 | 26526 | Add quick filters on Company, Division, Return Reason, Item Status, Major Category, and Offer | Returns Analysis NEW.bqy, Returns Analysis - Job NEW.bqy | Y | Y |
| 7/29/2014 | 26528 | Add enhanced sorting so all pivots can be sorted by all row labels on any fact, ascending or descending | Returns Analysis NEW.bqy, Returns Analysis - Job NEW.bqy | Y | Y |
| 7/29/2014 | 26529 | Change column names to English/metadata names | Returns Analysis NEW.bqy, Returns Analysis - Job NEW.bqy | Y | Y |
| 7/29/2014 | 26544 | Remove report sections | Returns Analysis NEW.bqy, Returns Analysis - Job NEW.bqy | Y | Y |
| 7/29/2014 | 26546 | Changed column names and script references from 'Open PO' to 'On Order' to match standard naming conventions. Also changed text at bottom of dashboards to match naming conventions. | Inventory Position Analysis.bqy | Y | Y |
| 7/30/2014 | 26556 | Remove report sections from the query | Inventory Position Analysis.bqy | Y | Y |
| 8/4/2014 | 26575 | Standardize additional column names and logic and button titles. Add style data in drilldown fields. | Inventory Position Analysis.bqy | Y | Y |
| 8/4/2014 | 25653 | Add more selection criteria to query: Item Status, Buyer, Vendor, Category, Available Inventory, Open POs | Inventory Position Analysis.bqy | Y | Y |
| 8/4/2014 | 26501 | Add enhanced sorting to allow all pivots to be sorted by all facts, ascending or descending; reorganize results and table section, then add quick-filters on Company, Division, Item Status, Buyer, Major Category, and Primary Vendor. | Inventory Position Analysis.bqy | Y | Y |
| 8/4/2014 | 25638 | Add new job for Inventory Position Analysis query | Inventory Position Analysis - Job.bqy | Y | Y |
| 8/6/2014 | 25632 | Add total order value to list of orders returned by customer. Add new query section to achieve this. | Customer Service Review.bqy | Y | Y |
| 8/7/2014 | 26577 | Add enhanced sorting to allow all pivots to be sorted by all facts, ascending or descending; reorganize results and table section, then add quick-filters on Company, Division, Item Status, Buyer, Major Category, and Primary Vendor. Add item status, buyer, style information as drilldown fields. | Inventory Value.bqy | Y | Y |
| 8/7/2014 | 26580 | Change column names, scripts, and buttons to match standards | Inventory Value.bqy | Y | Y |
| 8/7/2014 | 26581 | Remove report sections from the query | Inventory Value.bqy | Y | Y |
| 8/7/2014 | 25654 | Add filters by Item Status Code, Buyer Code, Vendor Number, and Product Category | Inventory Value.bqy | Y | Y |
| 8/8/2014 | 26603 | Add export buttons to the dashboards | Inventory Value.bqy | Y | Y |
| 8/13/2014 | 26622 | Add export buttons to the dashboards | Forecast to Buy.bqy | Y | Y |
| 8/13/2014 | 26621 | Change column names, scripts, and buttons to match standards | Forecast to Buy.bqy | Y | Y |
| 8/13/2014 | 26623 | Add enhanced sorting to allow all pivots to be sorted by all facts, ascending or descending; reorganize results and table section, then add quick-filters on Item Status, Buyer, Major Category, and Primary Vendor. | Forecast to Buy.bqy | Y | Y |
| 8/13/2014 | 26624 | Change scripting to modify table join if user specifies a vendor number limit | Forecast to Buy.bqy | Y | Y |
| 8/13/2014 | 26461 | Add customer PO number to the customer table on the selection criteria dashboard, as a filter on the selection criteria dashboard, and also include it on the display dashboard. | Customer Service Review.bqy | Y | Y |
| 8/13/2014 | 26466 | Zero fill the customer number value when the user filters by that field on the Selection Criteria Dashboard so that users don't have to type in the correct number of preceding zeroes in the Cust Nr filter text box. | Customer Service Review.bqy | Y | Y |
| 8/13/2014 | 26627 | Remove the email address fields and tables from the query to prevent duplicate record results. | Customer Service Review.bqy | Y | Y |
| 8/15/2014 | 18864 | Modify script to calculate recency based on the minimum weeks for the customer, not each order | RFM Analysis.bqy | Y | Y |
| 8/15/2014 | 26330 | Change column names to meta data names from physical names | RFM Analysis.bqy | Y | Y |
| 8/15/2014 | 20028 | Add product category codes and descriptions. Add customer email address. | RFM Analysis.bqy | Y | Y |
| 8/18/2014 | 26634 | Change column names to English/metadata names. Add buyer name and po line status description as drilldown fields. | Vendor Performance Analysis.bqy | Y | Y |
| 8/18/2014 | 26638 | Change query filter so it does not include only Open POs and Drop-Ship POs | Vendor Performance Analysis.bqy | Y | Y |
| 8/18/2014 | 16890 | Add a check-box to allow user to specify whether or not to include Drop-Ship POs in the analysis | Vendor Performance Analysis.bqy | Y | Y |
| 8/18/2014 | 22474 | Add a check-box to each dashboard to allow user to change date-based calculations from Due Date to Original Due Date | Vendor Performance Analysis.bqy | Y | Y |
| 8/18/2014 | 21271 | Add capability to select by Zip Code ranges, with wildcard support | Top X Customers.bqy | Y | Y |
| 8/18/2014 | 25628 | Add in returns data and net amounts to results and pivots. Add country names and style data as drillown fields. | Top X Customers.bqy | Y | Y |
| 8/18/2014 | 26640 | Change column names to English/metadata names | Top X Customers.bqy | Y | Y |
| 8/18/2014 | 26641 | Change logic for E-Mail address to get MIN(), so only one e-mail address is returned | Top X Customers.bqy | Y | Y |
| 8/18/2014 | 26642 | Selection by state was not working - must use only the first 2 positions of the selected entry. Added in "FN" for non-USA/Canada and all Canadian provinces | Top X Customers.bqy | Y | Y |
| 8/18/2014 | 26643 | Replace "Print This Pivot" button with "Export This Pivot" button, and remove corresponding report sections | Top X Customers.bqy | Y | Y |
| 8/20/2014 | 17781 | Add filter to exclude price adjustments and miscellaneous credits from returns data | LTV Analysis NEW.bqy | Y | Y |
| 8/20/2014 | 23298 | Add named range "PromotionHistory" to work with newer ODBC drivers | Promotion History.xls | ||
| 8/21/2014 | 16911 | Days in Warehouse was not displaying in the detail report section | Orders in the Warehouse.bqy | Y | Y |
| 8/21/2014 | 18024 | Charts overlapped each other, causing data labels to be truncated | Orders in the Warehouse.bqy | Y | Y |
| 8/21/2014 | 26653 | Create universal version of query by moving query computed items to the results section | Orders in the Warehouse.bqy | Y | Y |
| 8/21/2014 | 21273 | Add backorder quantity to results and Expected Receipts by Item Pivot | Expected Weekly PO Receipts.bqy | Y | Y |
| 8/21/2014 | 26654 | Modify column names, computed item expressions, and section names / button names to meet standards. Add buyer name, purchase order reason descriptions, merchandise category descriptions, item status description and style names as drilldown fields. | Expected Weekly PO Receipts.bqy | Y | Y |
| 8/21/2014 | 26658 | Add cut-off date to selection criteria, defaulting to current date next year | Expected Weekly PO Receipts.bqy | Y | Y |
| 8/21/2014 | 26659 | Add a section showing Expected Receipts by Vendor | Expected Weekly PO Receipts.bqy | Y | Y |
| 8/21/2014 | 26660 | Add sorting capability to Expected Receipts by Item and Vendor, and export buttons to all dashboards | Expected Weekly PO Receipts.bqy | Y | Y |
| 8/22/2014 | 26311 | Modify Item Status list box so values are sorted alphabetically | Item Analysis.bqy | Y | Y |
| 8/22/2014 | 26664 | Modify column names, computed items, and section names to match standards. Add buyer name, style and vendor information as drilldown fields. | Item Analysis.bqy | Y | Y |
| 8/22/2014 | 26666 | Add quick filters on Company, Division, Item Status, Major Category, Buyer, and Primary Vendor; change "Print This Pivot" buttons to "Export This Pivot" buttons | Item Analysis.bqy | Y | Y |
| 8/22/2014 | 26667 | Add a section showing Items by Primary Vendor | Item Analysis.bqy | Y | Y |
| 8/26/2014 | 15499 | Remove stray table from Pick Lot Query section | Pick Velocity.bqy | Y | Y |
| 8/26/2014 | 26678 | Change column names to English/metadata names; add in standard item attribute columns | Pick Velocity.bqy | Y | Y |
| 8/26/2014 | 26679 | Add enhanced sorting and export buttons; remove report section | Pick Velocity.bqy | Y | Y |
| 8/26/2014 | 15440 | Change "Units Per Hour" to be a computed item in the results section, providing persistence of the data | Receiving Staffing Requirements.bqy | Y | Y |
| 8/26/2014 | 23243 | Change cut-off date to include next year in the year drop-down; default the cut-off date to this date next year | Receiving Staffing Requirements.bqy | Y | Y |
| 8/26/2014 | 26680 | Implement naming standards; add standard item attribute fields; remove report section and add Export button | Receiving Staffing Requirements.bqy | Y | Y |
| 8/26/2014 | 19942 | Add in Ship Method Description, create computed item comprised of Ship Method Code, " - ", and Ship Method Description. Use new field in pivots and charts | Shipping charge analysis.bqy | Y | Y |
| 8/26/2014 | 23385 | Add Offer Code, Offer Name, Use Code, and Use Description to results and drill-down fields | Shipping charge analysis.bqy | Y | Y |
| 8/26/2014 | 26681 | Change column names to English/metadata names; add buttons for exporting pivots; add Quick Filters on Company, Division, Warehouse Number, State, Ship Method, and Offer | Shipping charge analysis.bqy | Y | Y |
| 8/27/2014 | 26683 | Add new query, Current Backorders Analysis, to combine features of Backorders.bqy and Backorders by Buyer and Vendor.bqy | Current Backorders Analysis.bqy | Y | Y |
| 8/27/2014 | 26683 | Remove query | Back orders.bqy | Y | Y |
| 8/27/2014 | 26683 | Remove query | Back orders by vendor and buyer.bqy | Y | Y |
| 9/15/2014 | NA | Corrected issue which caused transactions codes not to appear in the drop list for selection. For best results, use mappng for SV_MACACT_MACS_ACCOUNT_DTL and macros dated Sept2014. | GL Trans.bqy | Y | Y |
| 9/15/2014 | 26735 | Change limits on all query sections to only include Fin_Trans_Sta_Lgcy_Cd of "N" or "P" | GL Trans.bqy | Y | Y |
| 9/15/2014 | 26736 | Change final two append query sections to "Union All" instead of "Union" | GL Trans.bqy | Y | Y |
| 9/15/2014 | 26737 | Change column names to English/metadata names | GL Trans.bqy | Y | Y |
| 9/15/2014 | 26738 | Change document startup script to populate year drop-downs to match current standards | GL Trans.bqy | Y | Y |
| 9/15/2014 | 26739 | Add periods 32 thru 53 to StartFiscalCode and EndFiscalCode drop-down lists | GL Trans.bqy | Y | Y |
| 9/15/2014 | 26740 | Change script on "Process Query" button to handle the table join changes to current standards | GL Trans.bqy | Y | Y |
| 9/15/2014 | 26741 | Change the joins to Sv_Macact_Macs_Accounts_Dtl in all 12 subqueries; remove extra join to Sv_Macact_Macs_Accounts_Dtl table | GL Trans.bqy | Y | Y |
| 9/15/2014 | 26742 | Change query version information to "Universal" instead of database-specific. Deleted version specific versions. | GL Trans.bqy | Y | Y |
| 9/16/2014 | 26749 | Redesign query to provide a summary level analysis, instead of a detail level analysis | Shipping Charge Summary.bqy | Y | Y |
| 9/16/2014 | 26756 | Add more item fields as drilldowns; add 6-month orders/units/dollars and 12-month orders/units/dollars | Inventory Position Analysis.bqy, Inventory Position Analysis - Job.bqy | Y | Y |
| 9/24/2014 | 26792 | Remove PO Details from query - eliminates possible duplicate entries | Inventory Receiving Analysis.bqy | Y | Y |
| 9/24/2014 | 26793 | Change query to "Universal" instead of database-specific. Moved computed items from query request to results section | Inventory Receiving Analysis.bqy | Y | Y |
| 9/24/2014 | 26794 | Implement naming standards; add standard item attribute fields; and add Export Pivot button | Inventory Receiving Analysis.bqy | Y | Y |
| 9/25/2014 | 26804 | Update Ecomedate Analysis Suite Roadmap to include new columns: Appropriate Functional Area and Measures Displayed. Updated other columns for those queries which have changed. | Ecomedate Analysis Suite Roadmap.xls | Y | Y |
| 10/1/2014 | 26824 | Add joins on SLOTID column between all "FIN" tables and their corresponding "FIN_AMT" tables. Eliminates possibility of duplicate records in the results. | GL Trans - Open Systems.bqy | Y | Y |