# 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| |||||