Deployments
UAT_PCR_Deployment
Reports
Report Name: Dashboard Complete Daily Summary – Closures and Cancellations
Overview

  • Queries: 3

    Layouts: 1

  • Model: /PCR/PCR Deployment/PCR Packages/packagePCR-RCP/ name: model
Queries
  • Queries 3
    Expressions:
  • Model: /PCR/PCR Deployment/PCR Packages/packagePCR-RCP/ name: model
  • Query
    Previous Day’ Closures and Cancellations List
    Data Items
    19
    Case Number
    [Presentation].[Case].[ID]
    Age
    [Presentation].[Case].[CMT_AGE]
    Work Type Name
    [Presentation].[Work Type].[NAME]
    Sub Type Name
    [Presentation].[Sub Type].[NAME]
    Date Open
    [Presentation].[Case].[DATE_OPEN]
    Department
    [Presentation].[Case].[DEPARTMENT]
    Classification
    [Presentation].[Case].[CLASSIFICATION]
    PRI
    [Presentation].[Case].[PRI]
    Group Name
    [Presentation].[VW_STG_GROUPS].[NAME]
    Date Closed
    [Presentation].[Case].[DATE_CLOSED]
    Full Date
    cast([Presentation].[Date Closed and Cancelled Dim].[FullDate], date)
    Day Of Week
    _day_of_week ([Today Date],1)
    Day Name Of Week
    CASE [Day Of Week]
    WHEN 1 THEN 'Monday'
    WHEN 2 THEN 'Tuesday'
    WHEN 3 THEN 'Wednesday'
    WHEN 4 THEN 'Thursday'
    WHEN 5 THEN 'Friday'
    WHEN 6 THEN 'Saturday'
    WHEN 7 THEN 'Sunday'
    END
    Date Range
    IF ( [Day Of Week] > 1 ) THEN
    ( 'Only Prior Day Data' )
    ELSE
    ( ' Last Friday, Saturday and Sunday Data' )
    Start Date
    IF ( [Day Of Week] > 1 ) THEN
    (_add_days (cast([Today Date],date), -1) )
    ELSE
    (_add_days (cast([Today Date],date), -3) )
    End Date
    IF ( [Day Of Week] > 1 ) THEN
    (_add_days (cast([Today Date],date), -1) )
    ELSE
    (_add_days (cast([Today Date],date), -1) )
    Today Date
    current_date
    Assigned To
    [Presentation].[Case].[ASSIGNEE_CURR]
    Date Cancelled
    [Presentation].[Case].[Date Cancelled]
    • Detail Filters
      2
    • Required
      [Full Date] between [Start Date] and [End Date]
    • Required
      #/* Compensation Advisor FILTER
      JIRA Defect: BICCABC-2176
      By: R. Peters
      Change Details:
      Replaced original hard-coded FILTER Expression
      ie.
      [Group Name] in
      ('Compensation-Advisor-1','Compensation-Advisor-2',
      'Compensation-Advisor-3', 'Compensation-Advisor-4',
      ...
      'Compensation-Advisor-99', 'Compensation-Advisor-100',
      'Compensation-Advisor-OGD')
      With FILTER from package:
      [Presentation].[Compensation Advisor]
      */#
      [Presentation].[Compensation Advisor]

  • Query
    Previous Day Closures and Cancellations Chart
    Data Items
    14
    Group Name
    [Presentation].[VW_STG_GROUPS].[NAME]
    GroupName_Sort
    character_length ([Group Name])
    Closure Count
    coalesce (total(count(Case
    when [Presentation].[State].[NAME] = 'Closed' then 1
    else null
    end) for [Group Name]), 0)
    Cancellation Count
    coalesce (total(count(Case
    when [Presentation].[State].[NAME] = 'Cancelled' then 1
    else null
    end) for [Group Name]), 0)
    Full Date
    cast([Presentation].[Date Closed and Cancelled Dim].[FullDate], date)
    Day Of Week
    _day_of_week ([Today Date],1)
    Day Name Of Week
    CASE [Day Of Week]
    WHEN 1 THEN 'Monday'
    WHEN 2 THEN 'Tuesday'
    WHEN 3 THEN 'Wednesday'
    WHEN 4 THEN 'Thursday'
    WHEN 5 THEN 'Friday'
    WHEN 6 THEN 'Saturday'
    WHEN 7 THEN 'Sunday'
    END
    Date Range
    IF ( [Day Of Week] > 1 ) THEN
    ( 'Only Prior Day Data' )
    ELSE
    ( ' Last Friday, Saturday and Sunday Data' )
    Start Date
    IF ( [Day Of Week] > 1 ) THEN
    (_add_days (cast([Today Date],date), -1) )
    ELSE
    (_add_days (cast([Today Date],date), -3) )
    End Date
    IF ( [Day Of Week] > 1 ) THEN
    (_add_days (cast([Today Date],date), -1) )
    ELSE
    (_add_days (cast([Today Date],date), -1) )
    Today Date
    current_date
    Sorting_Location
    IF ( [Group Name] is null ) THEN
    ( 2 )
    ELSE
    ( 1 )
    Location_Description
    IF ( [Presentation].[VW_STG_GROUPS].[NAME] is null ) THEN
    ( ' { Blank }' )
    ELSE
    ( [Presentation].[VW_STG_GROUPS].[NAME] )
    Grand Total
    [Closure Count]+[Cancellation Count]
    • Detail Filters
      2
    • Required
      [Full Date] between [Start Date] and [End Date]
    • Required
      #/* Compensation Advisor FILTER
      JIRA Defect: BICCABC-2176
      By: R. Peters
      Change Details:
      Replaced original hard-coded FILTER Expression
      ie.
      [Group Name] in
      ('Compensation-Advisor-1','Compensation-Advisor-2',
      'Compensation-Advisor-3', 'Compensation-Advisor-4',
      ...
      'Compensation-Advisor-99', 'Compensation-Advisor-100',
      'Compensation-Advisor-OGD')
      With FILTER from package:
      [Presentation].[Compensation Advisor]
      */#
      [Presentation].[Compensation Advisor]

  • Query
    Load Last Date Query
    Data Items
    1
    Latest Valid Data Load Date
    [Presentation].[Data Load Archive].[Latest Valid Data Load Date]
Layouts