Deployments
UAT_PCR_Deployment
Reports
Report Name: Performance by Location
Overview

  • Queries: 4

    Layouts: 1

  • Model: /PCR/PCR Deployment/PCR Packages/packagePCR-RCP/ name: model
Queries
  • Queries 4
    Expressions:
  • Model: /PCR/PCR Deployment/PCR Packages/packagePCR-RCP/ name: model
  • Query
    Manual Cnt Query
    Data Items
    2
    Location
    [Presentation].[VW_RPT_Team].[TEAM_NAME_CENTRE]
    Manual Cnt
    case
    when (?Param-team-lead? = 2)
    then (Total(count((Case
    when ([Presentation].[Case].[Auto Process Indicator] is null and [Presentation].[VW_RPT_Team].[Team Lead ID] = 0)
    then 1
    else null
    end) for [Location]) for [Location]))
    else (Total(count((Case
    when ([Presentation].[Case].[Auto Process Indicator] is null)
    then 1
    else null
    end) for [Location]) for [Location]))
    end
    label
    Manual
    • Detail Filters
      4
    • Required
      [Presentation].[State].[NAME] in ('Closed', 'Cancelled')
    • Required
      [Presentation].[VW_RPT_Team].[TEAM_NAME] not in ('Team031', 'Team032')
    • Required
      [Presentation].[VW_STG_USERS].[FULLNAME] is not null
    • Required
      ((cast(cast (_add_hours ([Presentation].[Case].[DATE_CLOSED], -4), timestamp), date) in_range ?Param-Range?))
      or
      ((cast(cast (_add_hours([Presentation].[Case].[Date Cancelled], -4), timestamp), date) in_range ?Param-Range?))
  • Query
    Login Cnt Query
    Data Items
    3
    Location
    [Presentation].[VW_RPT_Team].[TEAM_NAME_CENTRE]
    Login-cnt
    Case
    when (?Param-team-lead? = 2)
    then Total(Count(Distinct(case
    when ([Presentation].[VW_RPT_Team].[Team Lead ID] = 0)
    then 1
    Else Null
    end)
    for [Presentation].[VW_STG_USERS].[LOGIN_NAME], [Location]))
    else Total(Count (Distinct(case
    when ([Presentation].[VW_RPT_Team].[Team Lead ID] >= 0)
    then 1
    Else Null
    end)
    for [Presentation].[VW_STG_USERS].[LOGIN_NAME], [Location]))
    end
    Day Count
    total(count(distinct(Case
    when [Presentation].[Start Date Open LM Dim].[WeekdayWeekend]='Weekday'
    then 1
    when [Presentation].[Start Date Open LM Dim].[WeekdayWeekend]='Jour de la semaine'
    then 1
    else null
    end) for [Presentation].[Start Date Open LM Dim].[FullDate] )for report)
    • Detail Filters
      2
    • Required
      cast([Presentation].[Start Date Open LM Dim].[FullDate], date) in_range ?Param-Range?
    • Required
      [Presentation].[VW_RPT_Team].[TEAM_NAME] not in ('Team031', 'Team032')
  • Query
    Man-Log-Query
    Join 
    [Manual Cnt Query].[Location] = [Login Cnt Query].[Location]
    refQuery
    Manual Cnt Query
    1:1
    refQuery
    Login Cnt Query
    1:1
    Data Items
    7
    Location
    [Manual Cnt Query].[Location]
    Manual Cnt
    [Manual Cnt Query].[Manual Cnt]
    label
    Closed+Cancelled Manual
    Login-cnt
    [Login Cnt Query].[Login-cnt]
    label
    Unique CMT Logins in the period
    Man-Log-Calc
    ([Manual Cnt] / [Login-cnt]) / [Day Count]
    label
    Productivity/ unique CMT Login
    Day Count
    [Login Cnt Query].[Day Count]
    Date-Range-prompt
    ?Param-Range?
    Man-Log-Total
    ([Total(Manual Cnt)] / [Total(Login-cnt)]) / [Day Count]
  • Query
    Load Last Date Query
    Data Items
    1
    Latest Valid Data Load Date
    [Presentation].[Data Load Archive].[Latest Valid Data Load Date]
Layouts