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.

CPOR

Data source: gpsinsightsascrm

EVALUATE
SUMMARIZECOLUMNS
(
'Partner Attach Type'[Partner Attach Type],
'Customer'[TPID],
'Customer'[TPName],
'Customer'[EOU],
'Customer Geography'[Customer Area],
'Customer Geography'[Customer Subsidiary],
'Customer Segment'[Summary Sub Segment (Custom)],
'Customer Segment'[Customer Segment Name],
'Customer Segment'[Customer Sub Segment],
'Tenant'[Tenant ID],
'Tenant'[Tenant Name],
'Reporting PartnerOne'[PartnerOne ID],
'Reporting PartnerOne'[PartnerOne Name],
'UnifiedPartner'[Partner ID],
'UnifiedPartner'[Partner Name],
'UnifiedPartner'[MPN PartnerName ID],
'Workload'[Workload],
'Time'[Fiscal Month],
Filter('Partner Attach Type','Partner Attach Type'[Partner Attach Type]<>"Non CPOR Attached"),
Filter('Time','Time'[Fiscal Year]>="FY21"),
"Active Usage (Partner Attached)",[Active Usage (Partner Attached)],
"Qualified Usage (Partner Attached)",[Qualified Usage (Partner Attached)]
)