• DW structure changes
  
  • new tables:
    • D_AgentGroup
    • D_BPGroup
    • D_AgentGroupAssignments
    • D_BPGroupAssignments
• Users structure changes
  • new tables:
    • dbo.OrganizationGrowth
• New SQL Server Agent Job
  • Add_Job_Scheduler_User_To_DW
• 4.01 Detailed Business Entity:
  
  • Report_DetailedBusinessEntity, new fields:
    • BusinessProcessNameInt
  • Report_DetailedBusinessEntity_SubDs, new fields:
    • BusinessProcessNameInt

LOGIC CHANGES:

• ETL db changes:
  • changes procedures:
    • dbo.Upload_D_Agent
    • dbo.Upload_D_BusinessProcess
• DBA db procedures changes:
  • changes procedures:
    • dbo.UpdateSubscriptionsMissingAgent
    • dbo.UpdateSubscriptionsMissingBP
• new Users db procedures:
  • dbo.spGet_Agent
  • dbo.spGet_AgentGroup
  • dbo.spGet_AgentGroupAssignments
  • dbo.spGet_BPGroup
  • dbo.spGet_BPGroupAssignments
  • dbo.spGet_BusinessProcess
  • dbo.spSet_AgentGroup
  • dbo.spSet_BPGroup
• Admin. Growth:
  • procedures changed:
    • DW.spRpt_Growth
  • Total logged in Supervisors:  
    • Previous:

      • count(distinct case when isnull(D_agent.IsSupervisor, 0) = 1 then F_AgentBpTime.AgentId else null end)

    •  Current:

      • count(distinct case when isnull(D_agent.IsSupervisor, 0) = 1 then F_AgentLife.AgentId else null end) 

• 2.03 Agent Scoring:
  • procedures changed:
    • DW.spRpt_AgentScoring
    • DW.spRpt_AgentScoring_SubDs1
    • DW.spRpt_AgentScoring_SubDs2
  • BP Name filter: 
    • Previous:
      • F_InteractionSegments.BusinessProcessID → D_BusinessProcess.BusinessProcessID → D_BusinessProcess.BusinessProcessName
    •  Current:

      • F_Interactions.BusinessProcessId → D_BusinessProcess.BusinessProcessID → D_BusinessProcess.BusinessProcessName

• 4.01 Detailed Business Entity:
  • procedures changed:
    • DW.spRpt_DetailedBusinessEntity
    • DW.spRpt_DetailedBusinessEntity_SubDs1
  • BP Name: 
    • Previous:
      • F_InteractionSegments.BusinessProcessID → D_BusinessProcess.BusinessProcessID → D_BusinessProcess.BusinessProcessName
    •  Current:

      • F_Interactions.BusinessProcessId → D_BusinessProcess.BusinessProcessID → D_BusinessProcess.BusinessProcessName

• 4.03 Interaction Disposition Codes:
  • procedures changed:
    • DW.spRpt_InteractionDispositionCodes
  • BP Name filter and grouping: 
    • Previous:
      • F_InteractionSegments.BusinessProcessID → D_BusinessProcess.BusinessProcessID → D_BusinessProcess.BusinessProcessName
    •  Current:

      • F_Interactions.BusinessProcessId → D_BusinessProcess.BusinessProcessID → D_BusinessProcess.BusinessProcessName

• 4.10 Inbound Interactions Distribution:
  • procedures changed:
    • DW.spRpt_InboundInteractionDistribution
  • BP Name filter: 
    • Previous:
      • F_InteractionSegments.BusinessProcessID → D_BusinessProcess.BusinessProcessID → D_BusinessProcess.BusinessProcessName
    •  Current:

      • F_Interactions.BusinessProcessId → D_BusinessProcess.BusinessProcessID → D_BusinessProcess.BusinessProcessName

• 4.11 Interactions Analysis:
  • procedures changed:
    • DW.spRpt_InteractionsAnalysis
  • BP Name filter: 
    • Previous:
      • F_InteractionSegments.BusinessProcessID → D_BusinessProcess.BusinessProcessID → D_BusinessProcess.BusinessProcessName
    •  Current:

      • F_Interactions.BusinessProcessId → D_BusinessProcess.BusinessProcessID → D_BusinessProcess.BusinessProcessName

• 4.13 Disposition Codes Distribution:
  • procedures changed:
    • DW.spRpt_DispositionCodesDistribution
  • BP Name filter: 
    • Previous:
      • F_InteractionSegments.BusinessProcessID → D_BusinessProcess.BusinessProcessID → D_BusinessProcess.BusinessProcessName
    •  Current:

      • F_Interactions.BusinessProcessId → D_BusinessProcess.BusinessProcessID → D_BusinessProcess.BusinessProcessName