Deployments
UAT_PCR_Deployment
Reports
Report Name: Completed Productivity for Non-backlog cases and Satellite backlog cases - Summary Reports
Overview

  • Queries: 5

    Layouts: 1

  • Model: /PCR/PCR Deployment/PCR Packages/packagePCR-RCP/ name: model
Queries
  • Queries 5
    Expressions:
  • Model: /PCR/PCR Deployment/PCR Packages/packagePCR-RCP/ name: model
  • Query
    Query Page 1
    Data Items
    8
    Case Number
    [Presentation].[Case].[ID]
    Processing Location
    if ( [Presentation].[VW_STG_CURRENT_TEAM].[PAY_PROCESSING_CENTRE] is null )
    then (if (#sq($runLocale)# = 'fr') then ('inconnu') else ('unknown'))
    else ( [Presentation].[VW_STG_CURRENT_TEAM].[PAY_PROCESSING_CENTRE] )
    Total Backlog Cases
    total (Case
    when [Processing Centre] like '%ORIG-SAT%' or [Processing Centre] like '%SATELLITE%'
    then 1
    else 0
    end for [Processing Location])
    Rollup
    total total
    Total Non-Backlog Cases
    total (Case
    when ([Processing Centre] not like '%ORIG-SAT%' and [Processing Centre] not like '%SATELLITE%'
    or [Processing Centre] is null)
    then 1
    else 0
    end for [Processing Location])
    Rollup
    total total
    Total All Backlog
    [Total Backlog Cases] + [Total Non-Backlog Cases]
    Aggregate
    total total
    Processing Centre
    [Presentation].[Case].[PROCESSING_CENTRE]
    Date Closed or Date Cancelled
    [Presentation].[Case].[Date Closed or Date Cancelled EST]
    Current Date-1
    _add_days(current_date, -1)
    • Detail Filters
      3
    • Required
      [Presentation].[State].[NAME] in ('Closed', 'Cancelled')
    • Required
      if (?Param-Date-Daily? = 0) then
      (cast([Date Closed or Date Cancelled], date) in_range ?Param-Date-Range?)
      else if (?Param-Date-Daily? = 1) then
      (cast([Date Closed or Date Cancelled], date) = [Current Date-1])
      else (0)
    • Required
      [Processing Location] in ?Param-Processing-Centre?
  • Query
    Query Page 2
    Data Items
    9
    Case Number
    [Presentation].[Case].[ID]
    Processing Location
    if ( [Presentation].[VW_STG_CURRENT_TEAM].[PAY_PROCESSING_CENTRE] is null )
    then (if (#sq($runLocale)# = 'fr') then ('inconnu') else ('unknown'))
    else ( [Presentation].[VW_STG_CURRENT_TEAM].[PAY_PROCESSING_CENTRE] )
    Team
    If ( [Presentation].[VW_STG_CURRENT_TEAM].[Team_Name] is null )
    then (if (#sq($runLocale)# = 'fr') then ('inconnu') else ('unknown'))
    else ( [Presentation].[VW_STG_CURRENT_TEAM].[Team_Name] )
    Total Backlog Cases
    total (Case
    when [Processing Centre] like '%ORIG-SAT%' or [Processing Centre] like '%SATELLITE%'
    then 1
    else 0
    end for [Processing Location], [Team])
    Rollup
    total total
    Total Non-Backlog Cases
    total (Case
    when ([Processing Centre] not like '%ORIG-SAT%' and [Processing Centre] not like '%SATELLITE%'
    or [Processing Centre] is null)
    then 1
    else 0
    end for [Processing Location], [Team])
    Rollup
    total total
    Total All Backlog
    [Total Backlog Cases] + [Total Non-Backlog Cases]
    Aggregate
    total total
    Processing Centre
    [Presentation].[Case].[PROCESSING_CENTRE]
    Date Closed or Date Cancelled
    [Presentation].[Case].[Date Closed or Date Cancelled EST]
    Current Date-1
    _add_days(current_date, -1)
    • Detail Filters
      4
    • Required
      [Presentation].[State].[NAME] in ('Closed', 'Cancelled')
    • Required
      if (?Param-Date-Daily? = 0) then
      (cast([Date Closed or Date Cancelled], date) in_range ?Param-Date-Range?)
      else if (?Param-Date-Daily? = 1) then
      (cast([Date Closed or Date Cancelled], date) = [Current Date-1])
      else (0)
    • Required
      [Processing Location] in ?Param-Processing-Centre?
    • Required
      [Team] in ?Param-Team-Name?
  • Query
    Query Page 3
    Data Items
    10
    Case Number
    [Presentation].[Case].[ID]
    Processing Location
    if ( [Presentation].[VW_STG_CURRENT_TEAM].[PAY_PROCESSING_CENTRE] is null )
    then (if (#sq($runLocale)# = 'fr') then ('inconnu') else ('unknown'))
    else ( [Presentation].[VW_STG_CURRENT_TEAM].[PAY_PROCESSING_CENTRE] )
    Team
    If ( [Presentation].[VW_STG_CURRENT_TEAM].[Team_Name] is null )
    then (if (#sq($runLocale)# = 'fr') then ('inconnu') else ('unknown'))
    else ( [Presentation].[VW_STG_CURRENT_TEAM].[Team_Name] )
    Assignee
    [Presentation].[VW_STG_USERS].[FULLNAME]
    Total Backlog Cases
    total (Case
    when [Processing Centre] like '%ORIG-SAT%' or [Processing Centre] like '%SATELLITE%'
    then 1
    else 0
    end for [Processing Location], [Team], [Assignee])
    Rollup
    total total
    Total Non-Backlog Cases
    total (Case
    when ([Processing Centre] not like '%ORIG-SAT%' and [Processing Centre] not like '%SATELLITE%'
    or [Processing Centre] is null)
    then 1
    else 0
    end for [Processing Location], [Team], [Assignee])
    Rollup
    total total
    Total All Backlog
    [Total Backlog Cases] + [Total Non-Backlog Cases]
    Aggregate
    total total
    Processing Centre
    [Presentation].[Case].[PROCESSING_CENTRE]
    Date Closed or Date Cancelled
    [Presentation].[Case].[Date Closed or Date Cancelled EST]
    Current Date-1
    _add_days(current_date, -1)
    • Detail Filters
      4
    • Required
      [Presentation].[State].[NAME] in ('Closed', 'Cancelled')
    • Required
      if (?Param-Date-Daily? = 0) then
      (cast([Date Closed or Date Cancelled], date) in_range ?Param-Date-Range?)
      else if (?Param-Date-Daily? = 1) then
      (cast([Date Closed or Date Cancelled], date) = [Current Date-1])
      else (0)
    • Required
      [Processing Location] in ?Param-Processing-Centre?
    • Required
      [Team] in ?Param-Team-Name?
  • Query
    Load Last Date Query
    Data Items
    1
    Latest Valid Data Load Date
    [Presentation].[Data Load Archive].[Latest Valid Data Load Date]
  • Query
    Query-Prompt
    Data Items
    2
    Pay Processing Centre
    if ( [Presentation].[VW_STG_CURRENT_TEAM].[PAY_PROCESSING_CENTRE] is null )
    then (if (#sq($runLocale)# = 'fr') then ('inconnu') else ('unknown'))
    else ( [Presentation].[VW_STG_CURRENT_TEAM].[PAY_PROCESSING_CENTRE] )
    Team Name
    If ( [Presentation].[VW_STG_CURRENT_TEAM].[Team_Name] is null )
    then (if (#sq($runLocale)# = 'fr') then ('inconnu') else ('unknown'))
    else ( [Presentation].[VW_STG_CURRENT_TEAM].[Team_Name] )
Layouts