phase-3 设计方案
2021-08-13 10:07:12 1 举报登录查看完整内容
增加mp_sku指标
作者其他创作
大纲/内容
sbs_mart.ads_inventory_expiry_report_1d_{cid}
dim_shop_{cid}
sbs_mart.ads_sales_non_atp_{cid}
ADS
dim_shop_mt_relationship
mp_sku_id
item_mart_dim_model
mt_sku_id
sales Performance
isc_mart.dim_sku_mapping_relationship_{cid}
isc_mart.dim_mt_mp_sku_relation
Financial Performance
sbs_mart.ads_inventory_aging_report_1d_{cid}
sbs_mart.dws_purchasable_days_mp_sku_1d_{cid}
dim_mp_sku_{cid}
isc_mart.dws_inventory_batch_1d_{cid}
sbs_mart.dws_purchasable_days_sku_1d_{cid}
mt_mp_sku_relation_tab
sbs_mart.ads_financial_avg_value_cogs_1d_{cid}
order_mart_dwd_order_item_all_event_final_status_df
sku_mapping_relationship_tab
sbs_mart.dwd_purchasable_days_mp_sku_1d_{cid}
sbs_mart.dws_frontend_order_sku_1d_{cid}
Procurement Performance
isc_mart.dws_outbound_request_outbound_sku_1d_{cid}
shopee.shopee_bi_sbs_mart
order_mart_dws_sku_gmv_1d
DIM&DWD
sbs_mart.ads_financial_avg_payables_1d_{cid}
sbs_mart.dws_frontend_order_mp_sku_1d_{cid}
isc_mart.dws_general_stock_flow_1d_{cid}
ODS
DWS
dim_sku_{cid}
isc_mart.dws_outbound_request_whs_sku_1d_{cid}
isc_mart.dws_inventory_batch_sku_whs_supplier_1d_{cid}
MT level
shopee.shopee_bd_sbs_mart
MP level
sbs_mart.dws_b2c_fbs_inbound_sku_1d_{cid}
order_mart_dwd_order_item_all_ent_di
sbs_mart.ads_financial_l90d_indicator_{cid}
isc_mart.dws_inbound_request_inbound_sku_1d_{cid}
sbs_mart.dwd_frontend_order_sku_di_{cid}
sbs_mart.ads_financial_avg_payables_inbound_detail_1d_{cid}
sbs_mart.ads_sales_sku_detail_1d_{cid}
sbs_mart.ads_inventory_health_1d_{cid}
sbs_mart.ads_sales_mp_sku_detail_1d_{cid}
收藏
0 条评论
回复 删除
下一页
