Analytics

To see On Order (OO) movement from a Distribution Center (DC) or Warehouse, utilize the "Add View Filter Condition" feature along with the following metrics in Performance Analytics: 

SPS_Location_Type = Shows Brick &amp; Mortar (STORE), eCommerce (INTERNET) and Distribution Center/ DC/ Warehouse channels (OTHER/DC/WAREHOUSE).

TY WTD UNITS OO = This Year Week-to-Date Units On Order.

TY WTD UNITS SLS = This Year Week-to-Date Unit Sales.

- SPS_Location_Type = Shows Brick &amp; Mortar (STORE), eCommerce (INTERNET) and Distribution Center/ DC/ Warehouse channels (OTHER/DC/WAREHOUSE).
- TY WTD UNITS OO = This Year Week-to-Date Units On Order.
- TY WTD UNITS SLS = This Year Week-to-Date Unit Sales.

___________________________________________________________

Add View Filter Conditions using the Best Practice Inventory Opportunities report

In Performance Analytics, open the Dashboards folder &gt; Best Practice Reports folder &gt; Inventory Opportunities Report.

Select any desired filters (Ex: which Retailer(s) to show data for in the report) in the prompt screen and run the report.

Open the DATA drop-down menu &gt; Add View Filter Condition.

Select the metric to filter the report to. 

Select the condition (Ex: Greater than), type in the amount (Ex: 0), and click Apply.

1. To add any additional filter(s), click Add Condition and follow the above steps three and four again.
    
   
    
   Ex: Add in TY WTD UNITS OO greater than 0.
    
   
    
    

Right click on the "SPS_Location_Type" &gt; Add to Grid

Locate the "SPS_Location_Type" attribute that is now in your report body &gt; Right click on it &gt; Move &gt; To Page-By Axis.

If not in the first position already, move the SPS_Location_Type to be the first attribute in the PAGE-BY axis section.

Click on the drop-down menu and select "OTHER","WAREHOUSE" or "DC" to see Distribution Center Sales. 

1. In Performance Analytics, open the Dashboards folder &gt; Best Practice Reports folder &gt; Inventory Opportunities Report.
2. Select any desired filters (Ex: which Retailer(s) to show data for in the report) in the prompt screen and run the report.
3. Open the DATA drop-down menu &gt; Add View Filter Condition.
 
 
 
4. Select the metric to filter the report to. 
 
 Ex: TY WTD UNITS SLS. ​
 
 
5. Select the condition (Ex: Greater than), type in the amount (Ex: 0), and click Apply.
 
 
 
 1. To add any additional filter(s), click Add Condition and follow the above steps three and four again.
 
 
 
 Ex: Add in TY WTD UNITS OO greater than 0.
 
 
 
 
6. Right click on the "SPS_Location_Type" &gt; Add to Grid
 
 
7. Locate the "SPS_Location_Type" attribute that is now in your report body &gt; Right click on it &gt; Move &gt; To Page-By Axis.
 
 
 
8. If not in the first position already, move the SPS_Location_Type to be the first attribute in the PAGE-BY axis section.
 
 
9. Click on the drop-down menu and select "OTHER","WAREHOUSE" or "DC" to see Distribution Center Sales.

Click on the "REPORT HOME" drop-down menu to export the DC report. 

💡We recommend downloading via "Excel with Formatting."

1. Click on the "REPORT HOME" drop-down menu to export the DC report. 
   💡We recommend downloading via "Excel with Formatting."

On Order (OO) movements from a Distribution Center (DC) or Warehouse can now be viewed and exported.

Continue to "Page-By" the other SPS_Location_Type's (E.g., STORE or INTERNET) to review, then export and compare performance via those channels as well.

If you have any additional questions regarding Performance Analytics, please reach out to our Analytics Support team at:

✉️ <a href="mailto:AnalyticsSupport@spscommerce.com" rel="nofollow noopener noreferrer" target="_blank">AnalyticsSupport@spscommerce.com</a>

Use the Add View Filter Condition and SPS_Location_Type to See DC/Warehouse On Orders in Performance Analytics

Metrics:

Add View Filter Conditions using the Best Practice Inventory Opportunities report

⛑️ SPS Analytics Support