X 5.4.4

• New common Dataset Common_InteractionVariablesList_DW, fields:
  • • InteractionVariableName   
• Dataset Common_InteractionVariablesList_DW, parameters:
  • • @DWDBName
    • @Current_User

• Admin. Growth: 

  • Dataset Report_Growth, new fields:
    • PeriodId
    • PeriodName
    • TotalNewOrgs
    • TotalActiveOrgs
    • TotalDuration
    • TotalLoggedAgents
    • TotalLoggedSupervisors
  • Dataset Report_Growth, removed fields:
    • org
    • subtotal
    • active_orgs
    • duration
    • onlineAgent
    • onlineSupervisor
  • Dataset Report_Growth, parameters removed:
    • @Subtotal
• 2.01 Detailed Agent Interactions:
  • Dataset Report_DetailedAgentInteractions, new fields:
    • InteractionVariables
  • Dataset Report_DetailedAgentInteractions, new parameters (optional):
    • InteractionVariables
• 3.04 Interactions Detail Record:
  • Dataset Report_InteractionsDetailRecord, new fields:
    • InteractionVariables
  • Dataset Report_InteractionsDetailRecord, new parameters (optional):
    • InteractionVariables
• 4.01 Detailed Business Entity:
  • Dataset Report_DetailedBusinessEntity, new fields:
    • InteractionVariables
  • Dataset Report_DetailedBusinessEntity_SubDs, new fields:
    • InteractionVariables
  • Dataset Report_DetailedBusinessEntity, new parameters (optional):
    • InteractionVariables
  • Dataset Report_DetailedBusinessEntity_SubDs, new parameters (optional):
    • InteractionVariables
• 4.02 Destination Trace:
  • Dataset Report_DestinationTrace, new fields:
    • InteractionVariables
  • Dataset Report_DestinationTrace, new parameters (optional):
    • InteractionVariables

LOGIC CHANGES:

• ETL db changes:
  • changes procedures:
    • dbo.Upload_F_AgentLife
    • dbo.Upload_F_Interactions
• DBA db procedures changes:
  • changes procedures:
    • dbo.DropDatabaseOnAO
• Users new db procedures:
  • dbo.spUpload_OrganizationGrowth
  • DW.spRpt_Common_Prm_InteractionVariables
• Users db procedures changed:
  • dbo.spRpt_GetInteractionsDataset

• 1.01 Detailed Agent Activity:
  • procedures changed:
    • DW.spRpt_DetailedAgentActivity
• 2.01 Detailed Agent Interactions:
  • procedures changed:
    • DW.spRpt_DetailedAgentInteractions
  • Interaction Variables: 
    • Previous:
      • -
    •  Current:

      • F_Interactions.InteractionVariables

• 3.04 Interactions Detail Record:
  • procedures changed:
    • DW.spRpt_InteractionsDetailRecord
  • Interaction Variables: 
    • Previous:
      • -
    •  Current:

      • F_Interactions.InteractionVariables

• 4.01 Detailed Business Entity:
  • procedures changed:
    • DW.spRpt_DetailedBusinessEntity
    • DW.spRpt_DetailedBusinessEntity_SubDs1
  • Interaction Variables: 
    • Previous:
      • -
    •  Current:

      • F_Interactions.InteractionVariables

• 4.02 Destination Trace:
  • procedures changed:
    • DW.spRpt_DestinationTrace
  • Interaction Variables: 
    • Previous:
      • -
    •  Current:

      • F_Interactions.InteractionVariables

• 9.01 PCS Detail:
  • procedures changed:
    • DW.spRpt_PCSDetail
  • Agent:  
    • Previous:
      • Join(F_Interactions.Survey(json).handlingAgents.handlingAgents_name)
    •  Current:

      • Join('(' + rownumber() over(order by F_Interactions.Survey(json).handlingAgents.key + ') ' + F_Interactions.Survey(json).handlingAgents.handlingAgents_name + ';')

• Admin. Growth:
  • procedures changed:
    • DW.spRpt_Growth
  • Period:  
    • Previous:

      • All period;

        D_TimeSlice.Year + '-' + D_TimeSlice.Month;

        D_TimeSlice.Year + ' w' + D_TimeSlice.Week

    •  Current:

      • Users.dbo.OrganizationGrowth.PeriodID

  • Total Active Orgs:  
    • Previous:

      • SUM(case when

        sum(isnull(F_Interactions.Duration, 0)) > 0
        where isnull(F_Interactions.Duration, 0) > 0  
        then 1 else 0 end)

    •  Current:

      • Users.dbo.OrganizationGrowth.TotalNewOrgs

  • Total Duration:  
    • Previous:

      • sum(isnull(F_Interactions.Duration, 0)) > 0
        where isnull(F_Interactions.Duration, 0) > 0 

    •  Current:

      • Users.dbo.OrganizationGrowth.TotalDuration

  • Total logged in agents:  
    • Previous:

      • count(distinct F_AgentBpTime.AgentId)

    •  Current:

      • Users.dbo.OrganizationGrowth.TotalLoggedAgents

  • Total logged in Supervisors:  
    • Previous:

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

    •  Current:

      • Users.dbo.OrganizationGrowth.TotalLoggedSupervisors