Product inventory levels at the Store, or Warehouse/Distribution Center (DC) level can be seen in Performance Analytics by adding two On Hand metrics in just a few steps!
💡The TY UNITS OH STORE (This Year Units On Hand - Stored at Brick and Mortar Stores) and TY UNITS OH WAREHOUSE (This Year Units On Hand - Stored at the Warehouse or Distribution Center) metrics are only available in a To-Date style of report in Performance Analytics.
Below are the full steps when creating a To-Date report from scratch as a Power User.
Step | Instruction | Image |
1 | Open a To-Date report. | 
|
2 | After making selections on the prompt screen and running the report, open the Location Folder and add in Retailer and SPS_Location_Type to the PAGE-BY axis. | 
|
3 | Open the To-Date Analysis Metrics folder > Week to Date folder > This Year folder | 
|
4 | Scroll down and click on Next 60 items. | 
|
5 | Double-click to add in:
| 
|
6 | Add in any other metrics or attributes desired for your report.
(Ex: Style, Style Description and UPC). | 
|
7 | Click on the Spreadsheet with Lightning Bolt Icon in the upper left-hand corner to run the report. | 
|
8 | To see TY UNITS OH STORE, update the SPS_Location_Type to STORE. | 
|
9 | To see TY UNITS OH WAREHOUSE, update the SPS_Location_Type to any option different than STORE.
E.g., WAREHOUSE, DISTRIBUTION CENTER, INTERNET or OTHER. | 
|
⛑️ SPS Analytics Support
If you have any additional questions regarding Performance Analytics, please reach out to our Analytics Support team at:
☎️ 888-739-3232, Option 2