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.

PartnerWorkshop

Data source: WWFAPPAS

EVALUATE
SUMMARIZECOLUMNS
(
'Customer'[Customer ID],
'DimTenant'[TenantID],
'Customer'[Customer Name],
'Customer Geography'[Area],
'Customer Geography'[Subsidiary],
'Workshop Type'[Workshop Group],
'Workshop Type'[Workshop Type],
'Workshop Type'[Workshop Name],
'Workshop Status'[Workshop Detailed Status],
'Workshop Status'[Workshop Status],
'Partner'[PartnerOne ID],
'Partner'[PartnerOne Name],
'Partner'[Partner Name],
'Partner'[Partner ID],
'Partner'[Partner Type],
'Workshop'[Workshop ID],
'Workshop'[Request Date],
'Workshop'[Eligible Date],
'Workshop'[Approval Date],
'Workshop'[Completion Date],
'Workshop'[Cancelled Date],
'Workshop Status'[Workshop Custom Status],
'Partner Geography'[Area],
'Partner Geography'[Subsidiary],
'Workshop'[Funding Type],
'Workshop'[Funding Committed],
'Workshop'[Incentive Amount],
'Workshop'[Partner Payment Profile Status],
'Workshop'[POE Status],
'Workshop'[POE Completion Date],
'Workshop'[Customer POE Survey Status],
'Workshop'[Partner POE Survey Status],
'Workshop'[POE DOC Status],
'Workshop'[POE Invoice Status],
'Workshop'[MS Invoice Date],
'Workshop'[Customer POE Survey Date],
'Workshop'[Partner POE Survey Date],
'Workshop'[POE DOC Submitted Date],
'Workshop'[Customer Ack Doc Status],
'Workshop'[Day 30 Expiration Date],
'Workshop'[Day 90 Expiration Date],
'Workshop'[Program Year],
'Workshop'[Event Area],
'Workshop'[Event Start Month],
'Workshop'[Completion Month],
"# of Completed Events",[# of Completed Events],
"# of Workshops",[# of Workshops]
)