寻找计算逻辑
从数据库确认数据库
结果展示
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 ;
