Merchandising will be making additional hierarchy changes for Departments 5, 7, and 87 between Monday, February 23 and Friday, February 27. Additional hierarchy changes for fashion departments will begin on Monday, March 2 and last for up to 8 weeks. The above hierarchy changes will be reflected in Channel Performance on a daily basis, pulling in changes each morning from the day before. If you have any pre-built reports utilizing hierarchy filters, you may need to clear these filters and recreate them with the new hierarchies. Shopper Behavior, Customer Perception, Digital Landscapes, and Insights Activation will reflect all Departments 5, 7, and 87 hierarchy changes on Monday, March 9. Fashion hierarchy changes for Shopper Behavior, Customer Perception, Digital Landscapes, and Insights Activation will also begin to be reflected on Monday, March 9 and will continue to update on a weekly cadence each Monday.

SSI Details

The Scintilla BI Link pre-joined SSI table delivers week-level aggregated data across nine source tables—Backroom Adjusted Inventory, Inventory Adjustments, MTR, MUMD, Store Customer Returns, Store Fulfillment (OPD), Store Inventory, Store Returns, and Store Sales—in a single pre-compiled dataset. Because the data is aggregated at the week grain, users should carefully review aggregations and calculations to ensure analytical accuracy.

*Note: We high encourage and recommend users to include the wm_yr_wk_nbr in queries and tables to improve runtime and performance.

The following provides SSI table details.

Specification	Details
Table Type	Fact Table
Refresh Frequency	Daily
Target Refresh Time	Monday - Friday: 3:00 PM CST. Saturday, and Sunday: 11:30 PM CST
Data Grain	catlg_item_id rpt_cd store_nbr wm_item_nbr wm_yr_wk_nbr
Table Name	wmt-dv-bi-link-prod.dv_psp.ssi