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 |
|
|
|
|
|
|
|