Deployments
UAT_PCR_Deployment
Reports
Report Name: Daily Health Data Check Dashboard-No Invalid
Overview

  • Queries: 34

    Layouts: 1

  • Model: /PCR/PCR Deployment/PCR Packages/packagePCR-RCP/ name: model
Queries
  • Queries 34
    Expressions:
  • Model: /PCR/PCR Deployment/PCR Packages/packagePCR-RCP/ name: model
  • Query
    Data Load
    Data Items
    3
    ID
    maximum ([Presentation].[Data Load Archive Alias].[ID])
    Valid
    [Presentation].[Data Load Archive Alias].[VALID]
    Latest Valid Data Load Date
    [Presentation].[Data Load Archive Alias].[Latest Valid Data Load Date]
  • Query
    Cases in Currernt
    Data Items
    1
    Case Count
    [Presentation].[Case].[Case Count]
    Aggregate
    count count
  • Query
    Current Team
    Data Items
    2
    Data Load ID
    [Presentation].[VW_STG_CURRENT_TEAM].[DATA_LOAD_ID]
    Version Date
    [Presentation].[VW_STG_CURRENT_TEAM].[VER_DATE]
    • Detail Filters
      1
    • Required
      [Data Load ID] > 0
  • Query
    Num of Hist Recs with Date of Action for the previous day
    Data Items
    1
    Number of records with Prev day date of Action
    count([Presentation].[VW_STG_HISTORY].[DBID])
    • Detail Filters
      1
    • Required
      [Presentation].[VW_STG_HISTORY].[ACTION_TIMESTAMP_EST] = _add_days( current_date, -1)
  • Query
    Total number of History records
    Data Items
    1
    Total Num of Hist records
    count([Presentation].[VW_STG_HISTORY].[DBID])
  • Query
    Team
    Data Items
    1
    Number of records on Team
    count([Presentation].[VW_RPT_Team].[TEAM_NAME])
  • Query
    Previous Day
    Data Items
    1
    Previous day
    _add_days(current_date, -1)
  • Query
    New Daily snapshot
    Data Items
    2
    Calc Queue Incl Work Done
    [Presentation].[Daily_Snapshot].[CALC_QUEUE_INCL_WORK_DONE]
    Aggregate
    total total
    Version Date
    [Presentation].[Daily_Snapshot].[VER_DATE]
    • Detail Filters
      1
    • Required
      [Version Date] = maximum ([Presentation].[Daily_Snapshot].[VER_DATE])
  • Query
    PreCases in Current
    Data Items
    1
    PreCase Count
    [Presentation].[VW_PCR_MART_PRECASE].[PreCase Count]
    Aggregate
    count count
  • Query
    Backlog
    Data Items
    2
    Measure
    [Presentation].[Case].[Case Count]
    Category
    'Backlog'
    • Detail Filters
      2
    • Required
      ([Presentation].[Case].[PROCESSING_CENTRE] contains
      [Presentation].[VW_CMT_POD_LOOKUP].[POD_TAG]
      or
      [Presentation].[Case].[CMT_AGE] >[Presentation].[Sub Type].[SERVICE_STANDARD])
      and
      [Presentation].[State].[NAME] not in ('Bring_Forward', 'Cancelled', 'Closed')
    • Required
      [Presentation].[Pod 0] or [Presentation].[Pod 1] or [Presentation].[Pod 2] or[Presentation].[Pod 3] or [Presentation].[Pod 4] or [Presentation].[Pod 5] or [Presentation].[Pod 6] or [Presentation].[Pod 7] or [Presentation].[Pod 8] or
      [Presentation].[Pod 9] or [Presentation].[Pod 10] or [Presentation].[Pod 11] or
      [Presentation].[Pod 12] or [Presentation].[Pod 13] or [Presentation].[Pod 14] or [Presentation].[Pod 15] or [Presentation].[Pod 16] or [Presentation].[Pod 17] or [Presentation].[Pod 18]
  • Query
    Baseline
    Data Items
    2
    Measure
    [Presentation].[Case].[Case Count]
    Category
    'Baseline'
    • Detail Filters
      2
    • Required
      [Presentation].[Case].[PROCESSING_CENTRE] contains
      [Presentation].[VW_CMT_POD_LOOKUP].[POD_TAG]
      and
      [Presentation].[State].[NAME] not in ('Bring_Forward', 'Cancelled', 'Closed')
    • Required
      [Presentation].[Pod 0] or [Presentation].[Pod 1] or [Presentation].[Pod 2] or[Presentation].[Pod 3] or [Presentation].[Pod 4] or [Presentation].[Pod 5] or [Presentation].[Pod 6] or [Presentation].[Pod 7] or [Presentation].[Pod 8] or
      [Presentation].[Pod 9] or [Presentation].[Pod 10] or [Presentation].[Pod 11] or
      [Presentation].[Pod 12] or [Presentation].[Pod 13] or [Presentation].[Pod 14] or [Presentation].[Pod 15] or [Presentation].[Pod 16] or [Presentation].[Pod 17] or [Presentation].[Pod 18]
  • Query
    Queue
    Data Items
    2
    Measure
    [Presentation].[Case].[Case Count]
    Category
    'Queue'
    • Detail Filters
      2
    • Required

      [Presentation].[State].[NAME] not in ('Bring_Forward', 'Cancelled', 'Closed')

    • Required
      [Presentation].[Pod 0] or [Presentation].[Pod 1] or [Presentation].[Pod 2] or[Presentation].[Pod 3] or [Presentation].[Pod 4] or [Presentation].[Pod 5] or [Presentation].[Pod 6] or [Presentation].[Pod 7] or [Presentation].[Pod 8] or
      [Presentation].[Pod 9] or [Presentation].[Pod 10] or [Presentation].[Pod 11] or
      [Presentation].[Pod 12] or [Presentation].[Pod 13] or [Presentation].[Pod 14] or [Presentation].[Pod 15] or [Presentation].[Pod 16] or [Presentation].[Pod 17] or [Presentation].[Pod 18]
  • Query
    Dashboard - POD
    Join
    Query Reference
    Backlog
    Query Reference
    Baseline
    Query Reference
    Queue
    • Projected Data Items
    • Measure
    • Category
    Data Items
    2
    Measure
    [Union1].[Measure]
    Aggregate
    total total
    Category
    [Union1].[Category]
  • Query
    POD count Bring Forward
    Data Items
    2
    POD
    [Presentation].[Case].[Case Count]
    Category
    'Bring Forward'
    • Detail Filters
      1
    • Required
      ([Presentation].[Case].[PROCESSING_CENTRE] contains
      [Presentation].[VW_CMT_POD_LOOKUP].[POD_TAG])
      and
      ([Presentation].[State].[(en-zw) Case Category] = 'Bring Forward')
  • Query
    POD Count Closed and Cancelled
    Data Items
    2
    POD
    [Presentation].[Case].[Case Count]
    Category
    'Cancelled and Closed'
    • Detail Filters
      1
    • Required
      [Presentation].[Case].[PROCESSING_CENTRE] contains
      [Presentation].[VW_CMT_POD_LOOKUP].[POD_TAG]
      and
      [Presentation].[State].[(en-zw) Case Category] in ('Cancelled', 'Closed')
  • Query
    POD Count Unassigned
    Data Items
    2
    POD
    [Presentation].[Case].[Case Count]
    Category
    'Unassigned'
    • Detail Filters
      1
    • Required
      [Presentation].[Case].[PROCESSING_CENTRE] contains
      [Presentation].[VW_CMT_POD_LOOKUP].[POD_TAG]
      and
      [Presentation].[State].[(en-zw) Case Category] = 'Unassigned'
  • Query
    POD Count WIP
    Data Items
    2
    POD
    [Presentation].[Case].[Case Count]
    Category
    'Work in Progress'
    • Detail Filters
      1
    • Required
      [Presentation].[Case].[PROCESSING_CENTRE] contains
      [Presentation].[VW_CMT_POD_LOOKUP].[POD_TAG]
      and
      [Presentation].[State].[(en-zw) Case Category] = 'Work in Progress'
  • Query
    POD
    Join
    Query Reference
    POD count Bring Forward
    Query Reference
    POD Count Closed and Cancelled
    Query Reference
    POD Count Unassigned
    Query Reference
    POD Count WIP
    • Projected Data Items
    • POD
    • Category
    Data Items
    2
    Category
    [Union1].[Category]
    POD
    [Union1].[POD]
    Aggregate
    total total
  • Query
    Non POD count Bring Forward
    Data Items
    2
    Non POD
    [Presentation].[Case].[Case Count]
    Category
    'Bring Forward'
    • Detail Filters
      1
    • Required
      ([Presentation].[Case].[PROCESSING_CENTRE] not contains
      [Presentation].[VW_CMT_POD_LOOKUP].[POD_TAG])
      and
      ([Presentation].[State].[(en-zw) Case Category] = 'Bring Forward')
  • Query
    Non POD Count Closed and Cancelled
    Data Items
    2
    Non POD
    [Presentation].[Case].[Case Count]
    Category
    'Cancelled and Closed'
    • Detail Filters
      1
    • Required
      [Presentation].[Case].[PROCESSING_CENTRE] not contains
      [Presentation].[VW_CMT_POD_LOOKUP].[POD_TAG]
      and
      [Presentation].[State].[(en-zw) Case Category] in ('Cancelled', 'Closed')
  • Query
    Non POD Count Unassigned
    Data Items
    2
    Non POD
    [Presentation].[Case].[Case Count]
    Category
    'Unassigned'
    • Detail Filters
      1
    • Required
      [Presentation].[Case].[PROCESSING_CENTRE] not contains
      [Presentation].[VW_CMT_POD_LOOKUP].[POD_TAG]
      and
      [Presentation].[State].[(en-zw) Case Category] = 'Unassigned'
  • Query
    Non POD Count WIP
    Data Items
    2
    Non POD
    [Presentation].[Case].[Case Count]
    Category
    'Work in Progress'
    • Detail Filters
      1
    • Required
      [Presentation].[Case].[PROCESSING_CENTRE] not contains
      [Presentation].[VW_CMT_POD_LOOKUP].[POD_TAG]
      and
      [Presentation].[State].[(en-zw) Case Category] = 'Work in Progress'
  • Query
    Non POD
    Join
    Query Reference
    Non POD count Bring Forward
    Query Reference
    Non POD Count Closed and Cancelled
    Query Reference
    Non POD Count Unassigned
    Query Reference
    Non POD Count WIP
    • Projected Data Items
    • Non POD
    • Category
    Data Items
    2
    Category
    [Union2].[Category]
    Non POD
    [Union2].[Non POD]
    Aggregate
    total total
  • Query
    POD and Non POD
    Join 
    [POD].[Category] = [Non POD].[Category]
    refQuery
    POD
    1:1
    refQuery
    Non POD
    1:1
    Data Items
    3
    Category
    [Non POD].[Category]
    POD
    [POD].[POD]
    Non POD
    [Non POD].[Non POD]
  • Query
    Cases Created for Previous Day
    Data Items
    2
    Cases
    [Presentation].[Case].[Case Count]
    Aggregate
    count count
    Category
    'Created Y''Day'
    • Detail Filters
      1
    • Required
      [Presentation].[Case].[DATE_OPEN_EST] = _add_days(current_date, -1)
  • Query
    Cases Closed for Previous Day
    Data Items
    2
    Cases
    [Presentation].[Case].[Case Count]
    Aggregate
    count count
    Category
    'Closed Y''Day'
    • Detail Filters
      1
    • Required
      cast([Presentation].[Case].[DATE_CLOSED_EST],date) = _add_days(current_date, -1)
  • Query
    Cases Modified for Previous Day
    Data Items
    2
    Cases
    [Presentation].[Case].[Case Count]
    Aggregate
    count count
    Category
    'Modified Y''Day'
    • Detail Filters
      1
    • Required
      [Presentation].[Case].[DATE_MODIFIED_EST] = _add_days(current_date, -1)
  • Query
    Cases for Yday action
    Join
    Query Reference
    Cases Created for Previous Day
    Query Reference
    Cases Closed for Previous Day
    Query Reference
    Cases Modified for Previous Day
    • Projected Data Items
    • Cases
    • Category
    Data Items
    2
    Category
    [Union1].[Category]
    Cases
    [Union1].[Cases]
  • Query
    Precases Created for Previous Day
    Data Items
    2
    PreCases
    [Presentation].[VW_PCR_MART_PRECASE].[PreCase Count]
    Aggregate
    count count
    Category
    'Created Y''Day'
    • Detail Filters
      1
    • Required
      [Presentation].[VW_PCR_MART_PRECASE].[DATE_OPEN_EST] = _add_days(current_date, -1)
  • Query
    Precases Modified for Previous Day
    Data Items
    2
    PreCases
    [Presentation].[VW_PCR_MART_PRECASE].[PreCase Count]
    Aggregate
    count count
    Category
    'Modified Y''Day'
    • Detail Filters
      1
    • Required
      [Presentation].[VW_PCR_MART_PRECASE].[LAST_MODIFIED_EST] = _add_days(current_date, -1)
  • Query
    Precases Closed for Previous Day
    Data Items
    2
    PreCases
    [Presentation].[VW_PCR_MART_PRECASE].[PreCase Count]
    Aggregate
    count count
    Category
    'Closed Y''Day'
    • Detail Filters
      1
    • Required
      [Presentation].[VW_PCR_MART_PRECASE].[DATE_CLOSED_EST] = _add_days(current_date, -1)
  • Query
    Precases for Yday action
    Join
    Query Reference
    Precases Created for Previous Day
    Query Reference
    Precases Modified for Previous Day
    Query Reference
    Precases Closed for Previous Day
    • Projected Data Items
    • PreCases
    • Category
    Data Items
    2
    Category
    [Union2].[Category]
    PreCases
    [Union2].[PreCases]
  • Query
    CasesPrecasesActivity
    Join 
    [Cases for Yday action].[Category] = [Precases for Yday action].[Category]
    refQuery
    Cases for Yday action
    1:N
    refQuery
    Precases for Yday action
    1:N
    Data Items
    3
    Category
    [Cases for Yday action].[Category]
    Cases
    [Cases for Yday action].[Cases]
    Aggregate
    total total
    PreCases
    [Precases for Yday action].[PreCases]
    Aggregate
    total total
  • Query
    For Conditional Display
    Data Items
    3
    Latest Valid Data Load Date
    [Presentation].[Data Load Archive Alias].[Latest Valid Data Load Date]
    todate
    cast([Latest Valid Data Load Date], date)
    Days between ydate and LastLoaddate
    _days_between([todate], _add_days(current_date, -1))
Layouts