Note: This content is automatically generated by the ETL tool. Last build time is 2024-03-19 13:44:37. Please contact MWS Insights Data Infrastructure for the query.

GSIOpportunity

Data source: gpsmart.database.windows.net

SELECT DISTINCT
Oppty.[CRMOpportunityID] as CRMOpportunityID,
[SuperRevSumDivisionName] as SuperRevSumDivision,
[OpportunityDueFiscalYear] as DueDateFiscalYear
FROM [crm].[vw_Dim_Opportunity] as Oppty
left join [crm].[vw_Fact_Opportunity] as FOppty on Oppty.[OpportunityKey] = FOppty.[OpportunityKey]
left join [crm].[vw_Dim_ReportingPartnerOne] as Par on FOppty.[PartnerOneReportingKey] = Par.[PartnerOneReportingKey]
left join [crm].[vw_Dim_RevSumDivision] as RevSum on FOppty.[RevSumDivisionKey] = RevSum.[RevSumDivisionKey]
where [OpportunityDueFiscalYear] in ('FY21','FY22','FY23','FY24')
AND ([SuperRevSumDivisionName] IN ('Dynamics OnPrem','Dynamics 365','Power Platform Excl PBI','LinkedIn') OR [SuperRevSumDivisionName] like 'D365%')
and [IsGSI] like 'Yes'