问题排查流程
2022-01-07 13:31:41 0 举报
问题排查流程
作者其他创作
大纲/内容
寻找计算逻辑
从数据库确认数据库
结果展示
KPI: At Glance-Stock Cover
KPI 文档
SELECT * FROM NESZ_SDM_BFL.BF_CustomerDC_Inventory where Customer_UniId='1000000KIDSWANTGROUP' and Data_Dt>='2021-06-01' and Data_Dt<='2021-06-30';
文档阅读理解
和金额有关
select top(2) * from NESZ_SDM_AL.INVENTORY_Warehouse_Product_D where Customer_UniId='1000000KIDSWANTGROUP' and Data_date>='2021-06-01' and Data_date<='2021-06-30' and CustomerWarehouse_Type_Cd=2 ;
2. 右侧的右方为Customer Stock Cover rolling 12个月的Customer Stock Cover (雀巢逻辑,大仓+门店叠加)的堆积图;受filter中的Category(IMF、Baby Food)、Brand影响
10.236.108.9 10.236.108.7(代码存放位置)10.236.75.204
结束
问题:At Glance-Stock Cover : 12月,1月 大仓周转天数为0
实现逻辑
找到页面和库,表对应关系
1. 左侧是MTD的Customer Stock Cover (孩子王的计算逻辑);单位weeks
wyeth 孩子王
和问题无关
查询文档
SELECT * FROM NESZ_SDM_BFL.BF_CustomerDC_Inventory where Customer_UniId='1000000KIDSWANTGROUP' and Data_Dt>='2021-06-01' and Data_Dt<='2021-06-30'; select top(2) * from NESZ_SDM_AL.INVENTORY_Warehouse_Product_D where Customer_UniId='1000000KIDSWANTGROUP' and Data_date>='2021-06-01' and Data_date<='2021-06-30' and CustomerWarehouse_Type_Cd=2 ;
0 条评论
下一页
为你推荐
查看更多