Deployments
UAT_PCR_Deployment
Reports
Report Name: CSB Cases Closed or Cancelled (All Teams)
Overview

  • Queries: 2

    Layouts: 1

  • Model: /PCR/PCR Deployment/PCR Packages/packagePCR-RCP/ name: model
Queries
  • Queries 2
    Expressions:
  • Model: /PCR/PCR Deployment/PCR Packages/packagePCR-RCP/ name: model
  • Query
    Main
    Data Items
    15
    Case Number
    [Presentation].[Case].[ID]
    PRI
    [Presentation].[Case].[PRI]
    Work Type Name
    [Presentation].[Work Type].[NAME]
    Sub Type Name
    [Presentation].[Sub Type].[NAME]
    Assigned To
    [Presentation].[Case].[ASSIGNEE_CURR]
    label
    Agent
    Date Closed
    [Presentation].[Case].[DATE_CLOSED]
    Date Closed Est
    _add_hours ( [Date Closed], -5 )
    State Name
    [Presentation].[State].[NAME]
    label
    Action / Nom d'action
    Date Cancelled
    [Presentation].[Case].[Date Cancelled]
    Date Cancelled Est
    _add_hours ([Date Cancelled], -5 )
    Date Closed or Date Cancelled
    [Presentation].[Case].[Date Closed or Date Cancelled]
    date Closed or cancelled Est
    _add_hours ([Date Closed or Date Cancelled] , -5 )
    Yesterday
    _add_days(current_date, -1)
    Date range display
    if (?Param-Date-Daily? ='1') then
    ([Yesterday])
    else (' ')
    NAME
    [Presentation].[VW_STG_PARENT_CHILD_LINKS_Alias_For_Groups_VW_STG_GROUPS].[NAME]
    • Detail Filters
      3
    • Required
      if (?Param-Date-Daily? = 0) then
      (cast([date Closed or cancelled Est], date) in_range ?Param_Date_Closed?)
      else if (?Param-Date-Daily? = 1) then
      ( cast([date Closed or cancelled Est], date) = [Yesterday])
      else (0)
    • Required
      [State Name] in ( 'Closed', 'Cancelled')
    • Required
      [NAME] in ('Compensation-Advisor-19', 'Compensation-Advisor-83', 'Compensation-Advisor-84', 'Compensation-Advisor-85', 'Compensation-Advisor-86', 'Compensation-Advisor-87', 'Compensation-Advisor-88', 'Compensation-Advisor-89', 'Compensation-Advisor-90', 'Compensation-Advisor-91', 'Compensation-Advisor-92', 'Compensation-Advisor-93')
  • Query
    Last Valid Date
    Data Items
    1
    Latest Valid Load Date
    [Presentation].[Data Load Archive].[Latest Valid Data Load Date]
Layouts