问题排查流程

寻找计算逻辑

从数据库确认数据库

结果展示

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 ;