Warning
All
ByName
aka:WMM_APA|||Select r.STORE_NBR, i.DEPT_NBR As OD, Sum((r.SAT_QTY * c.SAT_MULT) + (r.SUN_QTY * c.SUN_MULT) + (r.MON_QTY * c.MON_MULT) + (r.TUE_QTY * c.TUE_MULT) + (r.WED_QTY * c.WED_MULT) + (r.THU_QTY * c.THU_MULT) + (r.FRI_QTY * c.FRI_MULT)) As Volume, Sum((c.SAT_MULT * r.SAT_SALES_AMT) + (c.SUN_MULT * r.SUN_SALES_AMT) + (c.MON_MULT * r.MON_SALES_AMT) + (c.TUE_MULT * r.TUE_SALES_AMT) + (c.WED_MULT * r.WED_SALES_AMT) + (c.THU_MULT * r.THU_SALES_AMT) + (c.FRI_MULT * r.FRI_SALES_AMT)) As Sales From gb_wm_vm.sku_dly_pos r, gb_wm_vm.item i, gb_wm_vm.calendar_day c Where r.ITEM_NBR = i.ITEM_NBR And c.WM_YR_WK = r.WM_YR_WK And c.GREGORIAN_DATE Between Date '2019-04-01' And Date - 1 And i.OLD_NBR In (3805266) Group By 1, 2 Order By 1, 2
True
False
Quoted
False
aka:WMM_APA
Table=Select r.STORE_NBR, i.DEPT_NBR As OD, Sum((r.SAT_QTY * c.SAT_MULT) + (r.SUN_QTY * c.SUN_MULT) + (r.MON_QTY * c.MON_MULT) + (r.TUE_QTY * c.TUE_MULT) + (r.WED_QTY * c.WED_MULT) + (r.THU_QTY * c.THU_MULT) + (r.FRI_QTY * c.FRI_MULT)) As Volume, Sum((c.SAT_MULT * r.SAT_SALES_AMT) + (c.SUN_MULT * r.SUN_SALES_AMT) + (c.MON_MULT * r.MON_SALES_AMT) + (c.TUE_MULT * r.TUE_SALES_AMT) + (c.WED_MULT * r.WED_SALES_AMT) + (c.THU_MULT * r.THU_SALES_AMT) + (c.FRI_MULT * r.FRI_SALES_AMT)) As Sales From gb_wm_vm.sku_dly_pos r, gb_wm_vm.item i, gb_wm_vm.calendar_day c Where r.ITEM_NBR = i.ITEM_NBR And c.WM_YR_WK = r.WM_YR_WK And c.GREGORIAN_DATE Between Date '2019-04-01' And Date - 1 And i.OLD_NBR In (3805266) Group By 1, 2 Order By 1, 2
C:\Users\ewilcox\AppData\Local\Temp\Engine_8472_3eb5898f5dd543d194ee7760874271e7_\Engine_4452_0f54664e62a144a0a83b60a96229ca5e_.yxdb
Single
Profile
aka:WMM_APA|||Select r.STORE_NBR, i.DEPT_NBR As OD, Sum((r.SAT_QTY * c.SAT_MULT) + (r.SUN_QTY * c.SUN_MULT) + (r.MON_QTY * c.MON_MULT) + (r.TUE_QTY * c.TUE_MULT) + (r.WED_QTY * c.WED_MULT) + (r.THU_QTY * c.THU_MULT) + (r.FRI_QTY * c.FRI_MULT)) As Volume, Sum((c.SAT_MULT * r.SAT_SALES_AMT) + (c.SUN_MULT * r.SUN_SALES_AMT) + (c.MON_MULT * r.MON_SALES_AMT) + (c.TUE_MULT * r.TUE_SALES_AMT) + (c.WED_MULT * r.WED_SALES_AMT) + (c.THU_MULT * r.THU_SALES_AMT) + (c.FRI_MULT * r.FRI_SALES_AMT)) As Sales From gb_wm_vm.sku_dly_pos r, gb_wm_vm.item i, gb_wm_vm.calendar_day c Where r.ITEM_NBR = i.ITEM_NBR And c.WM_YR_WK = r.WM_YR_WK And c.GREGORIAN_DATE Between Date '2018-04-01' And Date - 365 And i.OLD_NBR In (3805266) Group By 1, 2 Order By 1, 2
True
False
Quoted
False
aka:WMM_APA
Table=Select r.STORE_NBR, i.DEPT_NBR As OD, Sum((r.SAT_QTY * c.SAT_MULT) + (r.SUN_QTY * c.SUN_MULT) + (r.MON_QTY * c.MON_MULT) + (r.TUE_QTY * c.TUE_MULT) + (r.WED_QTY * c.WED_MULT) + (r.THU_QTY * c.THU_MULT) + (r.FRI_QTY * c.FRI_MULT)) As Volume, Sum((c.SAT_MULT * r.SAT_SALES_AMT) + (c.SUN_MULT * r.SUN_SALES_AMT) + (c.MON_MULT * r.MON_SALES_AMT) + (c.TUE_MULT * r.TUE_SALES_AMT) + (c.WED_MULT * r.WED_SALES_AMT) + (c.THU_MULT * r.THU_SALES_AMT) + (c.FRI_MULT * r.FRI_SALES_AMT)) As Sales From gb_wm_vm.sku_dly_pos r, gb_wm_vm.item i, gb_wm_vm.calendar_day c Where r.ITEM_NBR = i.ITEM_NBR And c.WM_YR_WK = r.WM_YR_WK And c.GREGORIAN_DATE Between Date '2018-04-01' And Date - 365 And i.OLD_NBR In (3805266) Group By 1, 2 Order By 1, 2
Horizontal
New Workflow - YTD