Taurus Software
Measures for CommercialWare
12/20/2012
| File Name | Change Date | Case Number | Description | Affected Field |
| Measures for CW.xls | 9/21/2011 | 21920 | Changed CW_REF_ITEM_CLASS_LGCY_CD table name | Demand Sales Analysis.bqy |
| Measures for CW.xls | 10/19/2011 | 21907 | Resized columns | Demand Sales Analysis.bqy |
| Measures for CW.xls | 10/21/2011 | 21916 | Renamed units and dollars columns | Demand Sales Analysis.bqy |
| Measures for CW.xls | 11/1/2011 | 21971 | Multiple QA changes | Demand Sales Analysis.bqy |
| Measures for CW.xls | 11/2/2011 | 21986 | Changing formatting of date chart | Demand Sales Analysis.bqy |
| Measures for CW.xls | 11/7/2011 | 21987 | New query | Returns Analysis.bqy |
| Measures for CW.xls | 11/8/2011 | 21908 | Changed sources table to join to order header table and offers to join to sources table and modified where we pulled source and offer code fields | Returns Analysis.bqy |
| Measures for CW.xls | 11/8/2011 | 21907 | Changed where we pulled source and offer code fields | Demand Sales Analysis.bqy |
| Measures for CW.xls | 11/9/2011 | 21907 | Changed sources table to join to order header table and offers to join to sources table | Demand Sales Analysis.bqy |
| Measures for CW.xls | 3/19/2012 | 22776 | Change query section to select Item Status Code from SKUs table instead of Items table | Cancels Analysis.bqy |
| Measures for CW.xls | 10/4/2012 | 23804 | New query | Shipped Sales Analysis.bqy |
| Measures for CW.xls | 10/9/2012 | 23789 | Correct internal issue with joins | Cancels Analysis.bqy |
| Measures for CW.xls | 10/9/2012 | 23790 | Correct internal issue with joins | Demand Sales Analysis.bqy |
| Measures for CW.xls | 10/9/2012 | 23788 | Correct internal issue with joins | Returns Analysis.bqy |
| Measures for CW.xls | 10/9/2012 | 23795 | Changed where we pulled source and offer code fields | Returns Analysis.bqy |
| Measures for CW.xls | 10/9/2012 | 20099 | Add item class to all pivots as drilldown field | Returns Analysis.bqy |
| Measures for CW.xls | 10/9/2012 | 23796 | Changed where we pulled source and offer code fields | Shipped Sales Analysis.bqy |
| Measures for CW.xls | 10/9/2012 | 23785 | Correct internal issue with joins | Shipped Sales Analysis.bqy |
| Measures for CW.xls | 10/22/2012 | 23865 | Add source to top filters | Demand Sales Analysis.bqy |
| Measures for CW.xls | 10/22/2012 | 23854 | Change Rank columns to match other queries | Demand Sales Analysis.bqy |
| Measures for CW.xls | 10/22/2012 | 23878 | Change column name from Total Cost to Demand Cost | Demand Sales Analysis.bqy |
| Measures for CW.xls | 10/22/2012 | 23861 | Added Source and Order Type to Top Filters | Shipped Sales Analysis.bqy |
| Measures for CW.xls | 10/22/2012 | 23855 | Changed all measure fields beginning with Rank to match names in all other queries | Shipped Sales Analysis.bqy |
| Measures for CW.xls | 10/22/2012 | 23845 | Changed drilldown field name from Freight Amount to Freight Dollars | Shipped Sales Analysis.bqy |
| Measures for CW.xls | 10/22/2012 | 23875 | Changed drilldown field name from Tax Amount to Tax Dollars | Shipped Sales Analysis.bqy |
| Measures for CW.xls | 10/22/2012 | 23846 | Changed drilldown field name from Handling Amount to Handling Dollars | Shipped Sales Analysis.bqy |
| Measures for CW.xls | 10/22/2012 | 23859 | Changed order of drilldown fields to be grouped by subject | Shipped Sales Analysis.bqy |
| Measures for CW.xls | 10/22/2012 | 23872 | Changed handling of null value of status | Shipped Sales Analysis.bqy |
| Measures for CW.xls | 10/22/2012 | 23860 | Changed expression to check for divide by zero for Gross Margin calculation | Shipped Sales Analysis.bqy |
| Measures for CW.xls | 10/22/2012 | 23877 | Changed quick slice field name from Week of to Week | Shipped Sales Analysis.bqy |
| Measures for CW.xls | 10/24/2012 | 23873 | Corrected definition of item status | Cancels Analysis.bqy |
| Measures for CW.xls | 10/24/2012 | 23851 | Remove date entered as a drilldown field | Cancels Analysis.bqy |
| Measures for CW.xls | 10/24/2012 | 23850 | Remove prefix field as a drilldown field | Cancels Analysis.bqy |
| Measures for CW.xls | 10/24/2012 | 23840 | Get status for sku instead of item | Cancels Analysis.bqy |
| Measures for CW.xls | 10/24/2012 | 23866 | Corrected format of revision date | Returns Analysis.bqy |
| Measures for CW.xls | 10/24/2012 | 23857 | Changed column name from Rank GM $ to Rank Gross Margin Dollars | Returns Analysis.bqy |
| Measures for CW.xls | 10/24/2012 | 23856 | Changed abbreviation in column name of GM to Gross Margin | Returns Analysis.bqy |
| Measures for CW.xls | 10/24/2012 | 23843 | Removed sort option in date pivot | Returns Analysis.bqy |
| Measures for CW.xls | 10/24/2012 | 23863 | Added Source and Order Type to Top Filters | Returns Analysis.bqy |
| Measures for CW.xls | 10/24/2012 | 23900 | Changed column name which begin with Return Exchange to Return & Exchange | Returns Analysis.bqy |
| Measures for CW.xls | 10/26/2012 | 23915 | Changed source for unit cost to deal with corner cases in demand sales | Demand Sales Analysis.bqy, Demand Summary Sales.bqy, Demand Summary Sales - Job.bqy |
| Measures for CW.xls | 10/26/2012 | 23914 | Add item number to quick slices where appropriate | Cancels Analysis.bqy |
| Measures for CW.xls | 10/29/2012 | 23832 | Add demand summary job | Demand Summary Sales - Job.bqy |
| Measures for CW.xls | 10/29/2012 | 23805 | New query | Demand Summary Sales.bqy |
| Measures for CW.xls | 10/29/2012 | 23833 | Add shipped summary job | Shipped Sales Summary - Job.bqy |
| Measures for CW.xls | 10/29/2012 | 23804 | New query | Shipped Sales Summary.bqy |
| Measures for CW.xls | 10/29/2012 | 23900 | Change sort names from Return Exchange to Return & Exchange | Returns Analysis.bqy |
| Measures for CW.xls | 11/5/2012 | 23927 | Make missing section headers visible | Shipped Sales Summary.bqy |
| Measures for CW.xls | 11/6/2012 | 23879 | Improved performance of query | Shipped Sales Summary.bqy |
| Measures for CW.xls | 11/6/2012 | 23916 | Added Item Number as quick slice to Demand Sales by SKU tab | Demand Sales Analysis.bqy |
| Measures for CW.xls | 11/6/2012 | 23915 | Updated formula for Unit Cost | Demand Sales Analysis.bqy |
| Measures for CW.xls | 11/6/2012 | 23928 | Make missing section headers visible | Shipped Sales Summary - Job.bqy |
| Measures for CW.xls | 11/8/2012 | Clear selection criteria and changed titles on main dashboard | Shipped Sales Summary - Job.bqy | |
| Measures for CW.xls | 11/8/2012 | Clear selection criteria and changed titles on main dashboard | Demand Summary Sales - Job.bqy | |
| Measures for CW.xls | 12/6/2012 | 24042 | New query | Offer Source Performance Analysis.bqy, Offer Source Performance Analysis - Job.bqy |