---
# System prepended metadata

title: SO

---

# SO 
---
### Sources

##### TCM CSIS AMS Query
###### http://g4w8095.houston.hpecorp.net/CSISAMS/exportdata/getdata?Format=CSV&QueryID=367781
- This query contains FY20, partitions by year to improve performance, contains following exclusions from root:
Field: "Buyer Channel Segment" 
Exclusions: "Original Equipment Manufact., System Integrator, System Integrators"
RS Subregion 2 : "Canada Subregion, United States Subregion" 
Once per week on tuesdays.


##### Roster
###### 

- Once a month, cross with Active Contract File.
```sql=1
[ROSTER].[dbo].[USROSTER] 
```

##### MINERVA\EMO_US Tables
```sql=1

[SO].[dbo].[ExclusionNewNew] 
(Exclusions, non var, etc)
[PL_Roster].[dbo].[Roster_PL_FY19] (Strategys, BU's) 
```
##### g4w9655.houston.hpecorp.net,20486
```sql=1
[AMS_CSSO_BI].[FY20].[CustomerExclusions]  
Compute without MCS, T1 only
```

#### Link to Excel file

:arrow_right: [:link:][File]

[File]: https://hpe-my.sharepoint.com/:x:/p/carlo-efren_gonzalez-nuncio/EaHtNt-0Yh9Pi5KirEjv0ckBJuHfydfmO4QYIKqUa6NHBw?e=98r8Cb

--- 
 
### SO Versions Comparative

| Exceptions / Filters    |Forecast    |Disty    |WW    |Performance    |my comp    |
| ----------------- |:----------------------- |:----------------------- |:----------------------- |:----------------------- |:----------------------- |
| Membership| CSIS (Lisa's file once a month)|CSIS|||||
| Buyer EG Membership|Exclude Business Partner Candidate |Exclude Business Partner Candidate |||||
| SP T1 |Comp. and S.Comp from [AMS_CSSO_BI].[FY20].[CustomerExclusions]|From CustomerExclusions (Still defining strategy mapping)|||||
| RS Channel Segment| Remove Original Equipment Manufacturer||||||
| RS Subregion2|UNITED STATES SUBREGION| |||||
| Exclusionlist|from Minerva ExclusionNewNew| |||||
| Seller|Include all (main 5 and the rest as "other"| |||||
| PL Name|No 7A, -1| |||||
| Source|No PCS (AS),no Annuity| |Include Annuity||||
| Role|FED iPBM, iPBM, Not Rostered, P.Sales, Sr.iPBM | |||||
| Aruba|Included| |||||



