search

carsonlau / ANZ_BI

To store all the report relative material.
0 stars 0 forks source link

Petcare draft Forecast (Report) - Detail (Tab): The forecast data is different with Petcare Demand Planning report_20180903 #13

Open carsonlau opened 6 years ago

carsonlau commented 6 years ago

[INC0865621](https://marsprod.service-now.com/nav_to.do?uri=%2Fincident.do%3Fsys_id%3D785fb5f8dbbf5b04872dca7e3b96198b%26sysparm_record_list%3Dactive%253dtrue%255eassigned_to%253djavascript%253agetMyAssignments()%255ecompany%253dd4287b0c37561304985d8ff1b3990e92%255eORcompany%253d%255eORDERBYu_incident_due_date%26sysparm_record_row%3D1%26sysparm_record_rows%3D7%26sysparm_record_target%3Dincident%26sysparm_view%3Dnormal_incident%26sysparm_view_forced%3Dtrue) Thorpe, Paul

Paul found that the 2018 P9-P13 data for the planning group - 'Woolworths Demand Group - Pet' is different from the data in Petcare demand planning report. And Paul is sure that the result in demand planning is correct. Need to check why this happen.

carsonlau commented 6 years ago

All the draft planning data is calling from: D:\Qlikview_QVD\FlatFiles\DemandFinancials\Current\dmdfcst_0196.dat

Check what cause different about these two report.

carsonlau commented 6 years ago

This two data is calling from same source data and no any more processing in the report to reduce the data. The root cause for this issue is the filter in the report selection. image Some of the ‘FCST Type’ = Override data is with the brand ‘Not Applicable’. So If you unselect this brand, the data would be less than in the demand planning report.

carsonlau commented 6 years ago

After test, find new issue that petcare demand planning not update the draft fcst data. Still need to check why could not refresh.