Deployments
UAT_PCR_Deployment
Reports
Report Name: POD Backlog Summary
Overview

  • Queries: 21

    Layouts: 1

  • Model: /PCR/PCR Deployment/PCR Packages/packagePCR-RCP/ name: model
Queries
  • Queries 21
    Expressions:
  • Model: /PCR/PCR Deployment/PCR Packages/packagePCR-RCP/ name: model
  • Query
    POD Backlog
    Join
    Query Reference
    PODS Cases
    Query Reference
    PODS PRI
    • Projected Data Items
    • Measure Category
    • Baseline
    • Progress on Baseline
    • Backlog
    • Queue
    • Outstanding Intake - Over SS
    • Outstanding Intake - Within SS
    Data Items
    13
    Measure Category
    [Union1].[Measure Category]
    Baseline
    [Union1].[Baseline]
    Aggregate
    summarize summarize
    Progress on Baseline
    [Union1].[Progress on Baseline]
    Aggregate
    summarize summarize
    label
    Current #
    Backlog
    [Union1].[Backlog]
    Aggregate
    summarize summarize
    label
    Current #
    Queue
    [Union1].[Queue]
    Aggregate
    summarize summarize
    label
    Current #
    Outstanding Intake - Over SS
    [Union1].[Outstanding Intake - Over SS]
    Aggregate
    summarize summarize
    Outstanding Intake - Within SS
    [Union1].[Outstanding Intake - Within SS]
    Aggregate
    summarize summarize
    Rollup
    summarize summarize
    Backlog Variant
    [Baseline] - [Backlog]
    Aggregate
    summarize summarize
    label
    Variant
    Backlog Reduction
    [Backlog Variant]/[Baseline]
    Aggregate
    summarize summarize
    label
    Reduction
    Queue Variant
    [Baseline] - [Queue]
    Aggregate
    summarize summarize
    label
    Variant
    Queue Reduction
    [Queue Variant] / [Baseline]
    Aggregate
    summarize summarize
    label
    Reduction
    Progress Variant
    [Baseline] - [Progress on Baseline]
    Aggregate
    summarize summarize
    label
    Variant
    Progress Reduction
    [Progress Variant] / [Baseline]
    Aggregate
    summarize summarize
    label
    Reduction
  • Query
    DEPT Backlog
    Join
    Query Reference
    Dept Cases
    Query Reference
    Dept PRI
    • Projected Data Items
    • DEPARTMENT CODE
    • Measure Category
    • Baseline
    • Progress on Baseline
    • Backlog
    • Queue
    • Outstanding Intake - Over SS
    • Outstanding Intake - Within SS
    Data Items
    15
    DEPARTMENT CODE
    [Union2].[DEPARTMENT CODE]
    label
    Business Unit
    DEPARTMENT CODE Sort
    if ( [DEPARTMENT CODE] = ?DEPT? ) then ('_' + [DEPARTMENT CODE] ) else ( [DEPARTMENT CODE] )
    label
    Business Unit
    Measure Category
    [Union2].[Measure Category]
    Baseline
    [Union2].[Baseline]
    Aggregate
    summarize summarize
    Progress on Baseline
    [Union2].[Progress on Baseline]
    Aggregate
    summarize summarize
    label
    Current #
    Backlog
    [Union2].[Backlog]
    Aggregate
    summarize summarize
    label
    Current #
    Queue
    [Union2].[Queue]
    Aggregate
    summarize summarize
    label
    Current #
    Outstanding Intake - Over SS
    [Union2].[Outstanding Intake - Over SS]
    Aggregate
    summarize summarize
    Outstanding Intake - Within SS
    [Union2].[Outstanding Intake - Within SS]
    Aggregate
    summarize summarize
    Backlog Variant
    [Baseline] - [Backlog]
    label
    Variant
    Backlog Reduction
    [Backlog Variant]/[Baseline]
    label
    Reduction
    Queue Variant
    [Baseline] - [Queue]
    label
    Variant
    Queue Reduction
    [Queue Variant] / [Baseline]
    label
    Reduction
    Progress Variant
    [Baseline] - [Progress on Baseline]
    label
    Variant
    Progress Reduction
    [Progress Variant] / [Baseline]
    label
    Reduction
  • Query
    Appendix C
    Data Items
    7
    Case Category
    [Presentation].[State].[(en-zw) Case Category]
    Case Number
    [Presentation].[Case].[ID]
    Age
    [Presentation].[Case].[CMT_AGE]
    PRI
    [Presentation].[Case].[PRI]
    Sub Type Name
    [Presentation].[Sub Type].[NAME]
    Business Unit
    [Presentation].[VW_STG_DEPARTMENT].[CODE]
    Age Group
    [Presentation].[Case].[Age Group]
    • Detail Filters
      3
    • Required
      ?POD? = 0 and [Presentation].[Pod 0] Or
      ?POD? =1 and [Presentation].[Pod 1] Or
      ?POD? = 2 and [Presentation].[Pod 2] Or
      ?POD? = 3 and [Presentation].[Pod 3] Or
      ?POD? = 4 and [Presentation].[Pod 4] Or
      ?POD? = 5 and [Presentation].[Pod 5] Or
      ?POD? = 6 and [Presentation].[Pod 6] Or
      ?POD? = 7 and [Presentation].[Pod 7] Or
      ?POD? = 8 and [Presentation].[Pod 8] Or
      ?POD? = 9 and [Presentation].[Pod 9] Or
      ?POD? = 10 and [Presentation].[Pod 10] Or
      ?POD? = 11 and [Presentation].[Pod 11] Or
      ?POD? = 12 and [Presentation].[Pod 12] Or
      ?POD? = 13 and [Presentation].[Pod 13] Or
      ?POD? = 14 and [Presentation].[Pod 14] Or
      ?POD? = 15 and [Presentation].[Pod 15] Or
      ?POD? = 16 and [Presentation].[Pod 16] Or
      ?POD? = 17 and [Presentation].[Pod 17] Or
      ?POD? = 18 and [Presentation].[Pod 18]

    • Required
      [Presentation].[State].[NAME] not in ('Bring_Forward', 'Cancelled', 'Closed', 'Invalid')
    • Required
      [Presentation].[VW_STG_DEPARTMENT].[CODE] = ?DEPT?
  • Query
    Appendix D
    Data Items
    7
    Case Number
    [Presentation].[Case].[ID]
    Age
    [Presentation].[Case].[CMT_AGE]
    Language
    [Presentation].[Case].[LANG]
    State Name
    [Presentation].[State].[NAME]
    Business Unit
    [Presentation].[VW_STG_DEPARTMENT].[CODE]
    Sub Type Name
    [Presentation].[Sub Type].[NAME]
    PRI
    [Presentation].[Case].[PRI]
    • Detail Filters
      4
    • Required
      ?POD? = 0 and [Presentation].[Pod 0] Or
      ?POD? =1 and [Presentation].[Pod 1] Or
      ?POD? = 2 and [Presentation].[Pod 2] Or
      ?POD? = 3 and [Presentation].[Pod 3] Or
      ?POD? = 4 and [Presentation].[Pod 4] Or
      ?POD? = 5 and [Presentation].[Pod 5] Or
      ?POD? = 6 and [Presentation].[Pod 6] Or
      ?POD? = 7 and [Presentation].[Pod 7] Or
      ?POD? = 8 and [Presentation].[Pod 8] Or
      ?POD? = 9 and [Presentation].[Pod 9] Or
      ?POD? = 10 and [Presentation].[Pod 10] Or
      ?POD? = 11 and [Presentation].[Pod 11] Or
      ?POD? = 12 and [Presentation].[Pod 12] Or
      ?POD? = 13 and [Presentation].[Pod 13] Or
      ?POD? = 14 and [Presentation].[Pod 14] Or
      ?POD? = 15 and [Presentation].[Pod 15] Or
      ?POD? = 16 and [Presentation].[Pod 16] Or
      ?POD? = 17 and [Presentation].[Pod 17] Or
      ?POD? = 18 and [Presentation].[Pod 18]
    • Required
      [Presentation].[VW_STG_DEPARTMENT].[CODE] in ?DEPT?
    • Required
      [Presentation].[Case].[PROCESSING_CENTRE] contains [Presentation].[VW_CMT_POD_LOOKUP].[POD_TAG]
    • Required
      [Presentation].[State].[NAME] = 'Closed'
  • Query
    Appendix E
    Data Items
    7
    Case Category
    [Presentation].[State].[(en-zw) Case Category]
    Case Number
    [Presentation].[Case].[ID]
    Age
    [Presentation].[Case].[CMT_AGE]
    PRI
    [Presentation].[Case].[PRI]
    Sub Type Name
    [Presentation].[Sub Type].[NAME]
    Business Unit
    [Presentation].[VW_STG_DEPARTMENT].[CODE]
    Age Group
    [Presentation].[Case].[Age Group]
    • Detail Filters
      4
    • Required
      ?POD? = 0 and [Presentation].[Pod 0] Or
      ?POD? =1 and [Presentation].[Pod 1] Or
      ?POD? = 2 and [Presentation].[Pod 2] Or
      ?POD? = 3 and [Presentation].[Pod 3] Or
      ?POD? = 4 and [Presentation].[Pod 4] Or
      ?POD? = 5 and [Presentation].[Pod 5] Or
      ?POD? = 6 and [Presentation].[Pod 6] Or
      ?POD? = 7 and [Presentation].[Pod 7] Or
      ?POD? = 8 and [Presentation].[Pod 8] Or
      ?POD? = 9 and [Presentation].[Pod 9] Or
      ?POD? = 10 and [Presentation].[Pod 10] Or
      ?POD? = 11 and [Presentation].[Pod 11] Or
      ?POD? = 12 and [Presentation].[Pod 12] Or
      ?POD? = 13 and [Presentation].[Pod 13] Or
      ?POD? = 14 and [Presentation].[Pod 14] Or
      ?POD? = 15 and [Presentation].[Pod 15] Or
      ?POD? = 16 and [Presentation].[Pod 16] Or
      ?POD? = 17 and [Presentation].[Pod 17] Or
      ?POD? = 18 and [Presentation].[Pod 18]
    • Required
      [Presentation].[VW_STG_DEPARTMENT].[CODE] in ?DEPT?
    • Required
      [Presentation].[Case].[PROCESSING_CENTRE] contains [Presentation].[VW_CMT_POD_LOOKUP].[POD_TAG]
    • Required
      [Presentation].[State].[NAME] not in ('Closed', 'Cancelled', 'Bring_Forward')
  • Query
    POD START DT
    Data Items
    1
    POD_START_DT
    [Presentation].[VW_CMT_POD_LOOKUP].[POD_START_DT]
    • Detail Filters
      1
    • Required
      [Presentation].[VW_CMT_POD_LOOKUP].[POD_NO] = ?POD?
  • Query
    Case Counts PODS
    Data Items
    4
    Measure Category
    if (#sq($runLocale )#<> 'fr') then ( 'Cases' ) else ( 'Cas' )
    Baseline
    [Presentation].[VW_CMT_POD_LOOKUP].[BASELINE_POD_CASE_CNT]
    Backlog
    if (
    [Presentation].[State].[NAME] not in ('Bring_Forward', 'Cancelled', 'Closed', 'Invalid')
    and
    ([Presentation].[Case].[CMT_AGE] >[Presentation].[Sub Type].[SERVICE_STANDARD]
    or
    [Presentation].[Case].[PROCESSING_CENTRE] contains [Presentation].[VW_CMT_POD_LOOKUP].[POD_TAG]
    )
    ) then ( [Presentation].[Case].[ID] ) else (null)
    Aggregate
    count count
    Queue
    if (
    [Presentation].[State].[NAME] not in ('Bring_Forward', 'Cancelled', 'Closed', 'Invalid')
    ) then ( [Presentation].[Case].[ID] ) else (null)
    Aggregate
    count count
    • Detail Filters
      2
    • Required
      ?POD? = 0 and [Presentation].[Pod 0] Or
      ?POD? =1 and [Presentation].[Pod 1] Or
      ?POD? = 2 and [Presentation].[Pod 2] Or
      ?POD? = 3 and [Presentation].[Pod 3] Or
      ?POD? = 4 and [Presentation].[Pod 4] Or
      ?POD? = 5 and [Presentation].[Pod 5] Or
      ?POD? = 6 and [Presentation].[Pod 6] Or
      ?POD? = 7 and [Presentation].[Pod 7] Or
      ?POD? = 8 and [Presentation].[Pod 8] Or
      ?POD? = 9 and [Presentation].[Pod 9] Or
      ?POD? = 10 and [Presentation].[Pod 10] Or
      ?POD? = 11 and [Presentation].[Pod 11] Or
      ?POD? = 12 and [Presentation].[Pod 12] Or
      ?POD? = 13 and [Presentation].[Pod 13] Or
      ?POD? = 14 and [Presentation].[Pod 14] Or
      ?POD? = 15 and [Presentation].[Pod 15] Or
      ?POD? = 16 and [Presentation].[Pod 16] Or
      ?POD? = 17 and [Presentation].[Pod 17] Or
      ?POD? = 18 and [Presentation].[Pod 18]
    • Required
      [Presentation].[VW_CMT_POD_LOOKUP].[POD_NO] = ?POD?
  • Query
    Cases Baseline and Intake PODS
    Data Items
    4
    Measure Category
    if (#sq($runLocale )#<> 'fr') then ( 'Cases' ) else ( 'Cas' )
    Progress on Baseline
    if (
    [Presentation].[Case].[PROCESSING_CENTRE] contains [Presentation].[VW_CMT_POD_LOOKUP].[POD_TAG]
    and [Presentation].[State].[NAME] not in ('Bring_Forward', 'Cancelled', 'Closed', 'Invalid')
    )
    then ( [Presentation].[Case].[ID] )
    else ( null )
    Aggregate
    count count
    Outstanding Intake - Over SS
    if (
    (
    [Presentation].[Case].[PROCESSING_CENTRE] not contains [Presentation].[VW_CMT_POD_LOOKUP].[POD_TAG]
    or
    [Presentation].[Case].[PROCESSING_CENTRE] is null
    )
    and
    [Presentation].[State].[NAME] not in ('Bring_Forward', 'Cancelled', 'Closed', 'Invalid')
    and
    [Presentation].[Case].[CMT_AGE]>cast([Presentation].[Sub Type].[SERVICE_STANDARD],integer)
    and
    (
    (
    [Presentation].[Case].[DATE_OPEN_EST]>[Presentation].[VW_CMT_POD_LOOKUP].[POD_START_DT]
    and [Presentation].[Case].[DATE_BF] is null
    )
    or [Presentation].[Case].[DATE_BF_EST]>[Presentation].[VW_CMT_POD_LOOKUP].[POD_START_DT]
    )
    )
    then ( [Presentation].[Case].[ID] )
    else ( null )
    Aggregate
    count count
    Outstanding Intake - Within SS
    if (
    (
    [Presentation].[Case].[PROCESSING_CENTRE] not contains [Presentation].[VW_CMT_POD_LOOKUP].[POD_TAG]
    or
    [Presentation].[Case].[PROCESSING_CENTRE] is null
    )
    and
    [Presentation].[State].[NAME] not in ('Bring_Forward', 'Cancelled', 'Closed', 'Invalid')
    and
    [Presentation].[Case].[CMT_AGE]<=[Presentation].[Sub Type].[SERVICE_STANDARD]
    and
    (
    (
    [Presentation].[Case].[DATE_OPEN_EST] >[Presentation].[VW_CMT_POD_LOOKUP].[POD_START_DT]
    and [Presentation].[Case].[DATE_BF] is null
    )
    or [Presentation].[Case].[DATE_BF_EST]>[Presentation].[VW_CMT_POD_LOOKUP].[POD_START_DT]
    )
    )
    then ( [Presentation].[Case].[ID] )
    else ( null )
    Aggregate
    count count
    • Detail Filters
      1
    • Required
      ?POD? = 0 and [Presentation].[Pod 0] Or
      ?POD? =1 and [Presentation].[Pod 1] Or
      ?POD? = 2 and [Presentation].[Pod 2] Or
      ?POD? = 3 and [Presentation].[Pod 3] Or
      ?POD? = 4 and [Presentation].[Pod 4] Or
      ?POD? = 5 and [Presentation].[Pod 5] Or
      ?POD? = 6 and [Presentation].[Pod 6] Or
      ?POD? = 7 and [Presentation].[Pod 7] Or
      ?POD? = 8 and [Presentation].[Pod 8] Or
      ?POD? = 9 and [Presentation].[Pod 9] Or
      ?POD? = 10 and [Presentation].[Pod 10] Or
      ?POD? = 11 and [Presentation].[Pod 11] Or
      ?POD? = 12 and [Presentation].[Pod 12] Or
      ?POD? = 13 and [Presentation].[Pod 13] Or
      ?POD? = 14 and [Presentation].[Pod 14] Or
      ?POD? = 15 and [Presentation].[Pod 15] Or
      ?POD? = 16 and [Presentation].[Pod 16] Or
      ?POD? = 17 and [Presentation].[Pod 17] Or
      ?POD? = 18 and [Presentation].[Pod 18]
  • Query
    PRI Distinct Counts PODS
    Data Items
    4
    Measure Category
    if (#sq($runLocale )#<> 'fr') then ( 'PRI''s' ) else ( 'CIDP' )
    Baseline
    [Presentation].[VW_CMT_POD_LOOKUP].[BASELINE_POD_PRI_CNT]
    Backlog
    if (
    [Presentation].[State].[NAME] not in ('Bring_Forward', 'Cancelled', 'Closed', 'Invalid')
    and
    ([Presentation].[Case].[CMT_AGE] >[Presentation].[Sub Type].[SERVICE_STANDARD]
    or
    [Presentation].[Case].[PROCESSING_CENTRE] contains [Presentation].[VW_CMT_POD_LOOKUP].[POD_TAG]
    )
    ) then ( [Presentation].[Case].[PRI] ) else (null)
    Aggregate
    countDistinct countDistinct
    Queue
    if (
    [Presentation].[State].[NAME] not in ('Bring_Forward', 'Cancelled', 'Closed', 'Invalid')
    ) then ( [Presentation].[Case].[PRI] ) else (null)
    Aggregate
    countDistinct countDistinct
    • Detail Filters
      2
    • Required
      ?POD? = 0 and [Presentation].[Pod 0] Or
      ?POD? =1 and [Presentation].[Pod 1] Or
      ?POD? = 2 and [Presentation].[Pod 2] Or
      ?POD? = 3 and [Presentation].[Pod 3] Or
      ?POD? = 4 and [Presentation].[Pod 4] Or
      ?POD? = 5 and [Presentation].[Pod 5] Or
      ?POD? = 6 and [Presentation].[Pod 6] Or
      ?POD? = 7 and [Presentation].[Pod 7] Or
      ?POD? = 8 and [Presentation].[Pod 8] Or
      ?POD? = 9 and [Presentation].[Pod 9] Or
      ?POD? = 10 and [Presentation].[Pod 10] Or
      ?POD? = 11 and [Presentation].[Pod 11] Or
      ?POD? = 12 and [Presentation].[Pod 12] Or
      ?POD? = 13 and [Presentation].[Pod 13] Or
      ?POD? = 14 and [Presentation].[Pod 14] Or
      ?POD? = 15 and [Presentation].[Pod 15] Or
      ?POD? = 16 and [Presentation].[Pod 16] Or
      ?POD? = 17 and [Presentation].[Pod 17] Or
      ?POD? = 18 and [Presentation].[Pod 18]
    • Required
      [Presentation].[VW_CMT_POD_LOOKUP].[POD_NO] = ?POD?
  • Query
    PRI Baseline and Intake PODS
    Data Items
    4
    Measure Category
    if (#sq($runLocale )#<> 'fr') then ( 'PRI''s' ) else ( 'CIDP' )
    Progress on Baseline
    if (
    [Presentation].[Case].[PROCESSING_CENTRE] contains [Presentation].[VW_CMT_POD_LOOKUP].[POD_TAG]
    and [Presentation].[State].[NAME] not in ('Bring_Forward', 'Cancelled', 'Closed', 'Invalid')
    )
    then ( [Presentation].[Case].[PRI] )
    else ( null )
    Aggregate
    countDistinct countDistinct
    Outstanding Intake - Over SS
    if (
    (
    [Presentation].[Case].[PROCESSING_CENTRE] not contains [Presentation].[VW_CMT_POD_LOOKUP].[POD_TAG]
    or
    [Presentation].[Case].[PROCESSING_CENTRE] is null
    )
    and
    [Presentation].[State].[NAME] not in ('Bring_Forward', 'Cancelled', 'Closed', 'Invalid')
    and
    [Presentation].[Case].[CMT_AGE]>[Presentation].[Sub Type].[SERVICE_STANDARD]
    and
    (
    [Presentation].[Case].[DATE_OPEN_EST]>[Presentation].[VW_CMT_POD_LOOKUP].[POD_START_DT] or [Presentation].[Case].[DATE_BF_EST]>[Presentation].[VW_CMT_POD_LOOKUP].[POD_START_DT]
    )
    )
    then ( [Presentation].[Case].[PRI] )
    else ( null )
    Aggregate
    countDistinct countDistinct
    Outstanding Intake - Within SS
    if (
    (
    [Presentation].[Case].[PROCESSING_CENTRE] not contains [Presentation].[VW_CMT_POD_LOOKUP].[POD_TAG]
    or
    [Presentation].[Case].[PROCESSING_CENTRE] is null
    )
    and
    [Presentation].[State].[NAME] not in ('Bring_Forward', 'Cancelled', 'Closed', 'Invalid')
    and
    [Presentation].[Case].[CMT_AGE]<=[Presentation].[Sub Type].[SERVICE_STANDARD]
    and
    (
    [Presentation].[Case].[DATE_OPEN_EST] >[Presentation].[VW_CMT_POD_LOOKUP].[POD_START_DT] or [Presentation].[Case].[DATE_BF_EST] >[Presentation].[VW_CMT_POD_LOOKUP].[POD_START_DT]
    )
    )
    then ( [Presentation].[Case].[PRI] )
    else ( null )
    Aggregate
    countDistinct countDistinct
    • Detail Filters
      1
    • Required
      ?POD? = 0 and [Presentation].[Pod 0] Or
      ?POD? =1 and [Presentation].[Pod 1] Or
      ?POD? = 2 and [Presentation].[Pod 2] Or
      ?POD? = 3 and [Presentation].[Pod 3] Or
      ?POD? = 4 and [Presentation].[Pod 4] Or
      ?POD? = 5 and [Presentation].[Pod 5] Or
      ?POD? = 6 and [Presentation].[Pod 6] Or
      ?POD? = 7 and [Presentation].[Pod 7] Or
      ?POD? = 8 and [Presentation].[Pod 8] Or
      ?POD? = 9 and [Presentation].[Pod 9] Or
      ?POD? = 10 and [Presentation].[Pod 10] Or
      ?POD? = 11 and [Presentation].[Pod 11] Or
      ?POD? = 12 and [Presentation].[Pod 12] Or
      ?POD? = 13 and [Presentation].[Pod 13] Or
      ?POD? = 14 and [Presentation].[Pod 14] Or
      ?POD? = 15 and [Presentation].[Pod 15] Or
      ?POD? = 16 and [Presentation].[Pod 16] Or
      ?POD? = 17 and [Presentation].[Pod 17] Or
      ?POD? = 18 and [Presentation].[Pod 18]
  • Query
    PODS Cases
    Join 
    [Case Counts PODS].[Measure Category] = [Cases Baseline and Intake PODS].[Measure Category]
    refQuery
    Case Counts PODS
    1:N
    refQuery
    Cases Baseline and Intake PODS
    1:N
    Data Items
    7
    Measure Category
    [Case Counts PODS].[Measure Category]
    Baseline
    cast([Case Counts PODS].[Baseline], integer)
    Progress on Baseline
    cast([Cases Baseline and Intake PODS].[Progress on Baseline], integer)
    Backlog
    cast([Case Counts PODS].[Backlog], integer)
    Queue
    cast([Case Counts PODS].[Queue], integer)
    Outstanding Intake - Over SS
    cast([Cases Baseline and Intake PODS].[Outstanding Intake - Over SS], integer)
    Outstanding Intake - Within SS
    cast([Cases Baseline and Intake PODS].[Outstanding Intake - Within SS], integer)
  • Query
    PODS PRI
    Join 
    [PRI Distinct Counts PODS].[Measure Category] = [PRI Baseline and Intake PODS].[Measure Category]
    refQuery
    PRI Distinct Counts PODS
    1:N
    refQuery
    PRI Baseline and Intake PODS
    1:N
    Data Items
    7
    Measure Category
    [PRI Distinct Counts PODS].[Measure Category]
    Baseline
    cast([PRI Distinct Counts PODS].[Baseline], integer)
    Progress on Baseline
    cast([PRI Baseline and Intake PODS].[Progress on Baseline], integer)
    Backlog
    cast([PRI Distinct Counts PODS].[Backlog], integer)
    Queue
    cast([PRI Distinct Counts PODS].[Queue], integer)
    Outstanding Intake - Over SS
    cast([PRI Baseline and Intake PODS].[Outstanding Intake - Over SS], integer)
    Outstanding Intake - Within SS
    cast([PRI Baseline and Intake PODS].[Outstanding Intake - Within SS], integer)
  • Query
    Case Counts DEPT
    Data Items
    5
    DEPARTMENT CODE
    [Presentation].[VW_STG_DEPARTMENT].[CODE]
    Measure Category
    if (#sq($runLocale )#<> 'fr') then ( 'Cases' ) else ( 'Cas' )
    Baseline
    [Presentation].[VW_CMT_POD_LOOKUP].[BASELINE_DEPT_CASE_CNT]
    Backlog
    if (
    [Presentation].[State].[NAME] not in ('Bring_Forward', 'Cancelled', 'Closed', 'Invalid')
    and
    ([Presentation].[Case].[CMT_AGE] >[Presentation].[Sub Type].[SERVICE_STANDARD]
    or
    [Presentation].[Case].[PROCESSING_CENTRE] contains [Presentation].[VW_CMT_POD_LOOKUP].[POD_TAG]
    )
    ) then ( [Presentation].[Case].[ID] ) else (null)
    Aggregate
    count count
    Queue
    if (
    [Presentation].[State].[NAME] not in ('Bring_Forward', 'Cancelled', 'Closed', 'Invalid')
    ) then ( [Presentation].[Case].[ID] ) else (null)
    Aggregate
    count count
    • Detail Filters
      2
    • Required
      ?POD? = 0 and [Presentation].[Pod 0] Or
      ?POD? =1 and [Presentation].[Pod 1] Or
      ?POD? = 2 and [Presentation].[Pod 2] Or
      ?POD? = 3 and [Presentation].[Pod 3] Or
      ?POD? = 4 and [Presentation].[Pod 4] Or
      ?POD? = 5 and [Presentation].[Pod 5] Or
      ?POD? = 6 and [Presentation].[Pod 6] Or
      ?POD? = 7 and [Presentation].[Pod 7] Or
      ?POD? = 8 and [Presentation].[Pod 8] Or
      ?POD? = 9 and [Presentation].[Pod 9] Or
      ?POD? = 10 and [Presentation].[Pod 10] Or
      ?POD? = 11 and [Presentation].[Pod 11] Or
      ?POD? = 12 and [Presentation].[Pod 12] Or
      ?POD? = 13 and [Presentation].[Pod 13] Or
      ?POD? = 14 and [Presentation].[Pod 14] Or
      ?POD? = 15 and [Presentation].[Pod 15] Or
      ?POD? = 16 and [Presentation].[Pod 16] Or
      ?POD? = 17 and [Presentation].[Pod 17] Or
      ?POD? = 18 and [Presentation].[Pod 18]
    • Required
      [Presentation].[VW_STG_DEPARTMENT].[CODE] = ?DEPT?
  • Query
    Cases Baseline and Intake DEPT
    Data Items
    5
    Business Unit
    [Presentation].[VW_STG_DEPARTMENT].[CODE]
    Measure Category
    if (#sq($runLocale )#<> 'fr') then ( 'Cases' ) else ( 'Cas' )
    Progress on Baseline
    if (
    [Presentation].[Case].[PROCESSING_CENTRE] contains [Presentation].[VW_CMT_POD_LOOKUP].[POD_TAG]
    and [Presentation].[State].[NAME] not in ('Bring_Forward', 'Cancelled', 'Closed', 'Invalid')
    )
    then ( [Presentation].[Case].[ID] )
    else ( null )
    Aggregate
    count count
    Outstanding Intake - Over SS
    if (
    (
    [Presentation].[Case].[PROCESSING_CENTRE] not contains [Presentation].[VW_CMT_POD_LOOKUP].[POD_TAG]
    or
    [Presentation].[Case].[PROCESSING_CENTRE] is null
    )
    and
    [Presentation].[State].[NAME] not in ('Bring_Forward', 'Cancelled', 'Closed', 'Invalid')
    and
    [Presentation].[Case].[CMT_AGE]>cast([Presentation].[Sub Type].[SERVICE_STANDARD],integer)
    and
    (
    (
    [Presentation].[Case].[DATE_OPEN_EST] >[Presentation].[VW_CMT_POD_LOOKUP].[POD_START_DT]
    and [Presentation].[Case].[DATE_BF] is null
    )
    or [Presentation].[Case].[DATE_BF_EST] >[Presentation].[VW_CMT_POD_LOOKUP].[POD_START_DT]
    )
    )
    then ( [Presentation].[Case].[ID] )
    else ( null )
    Aggregate
    count count
    Outstanding Intake - Within SS
    if (
    (
    [Presentation].[Case].[PROCESSING_CENTRE] not contains [Presentation].[VW_CMT_POD_LOOKUP].[POD_TAG]
    or
    [Presentation].[Case].[PROCESSING_CENTRE] is null
    )
    and
    [Presentation].[State].[NAME] not in ('Bring_Forward', 'Cancelled', 'Closed', 'Invalid')
    and
    [Presentation].[Case].[CMT_AGE]<=[Presentation].[Sub Type].[SERVICE_STANDARD]
    and
    (
    (
    [Presentation].[Case].[DATE_OPEN_EST] >[Presentation].[VW_CMT_POD_LOOKUP].[POD_START_DT]
    and [Presentation].[Case].[DATE_BF] is null
    )
    or [Presentation].[Case].[DATE_BF_EST] >[Presentation].[VW_CMT_POD_LOOKUP].[POD_START_DT]
    )
    )
    then ( [Presentation].[Case].[ID] )
    else ( null )
    Aggregate
    count count
    • Detail Filters
      2
    • Required
      ?POD? = 0 and [Presentation].[Pod 0] Or
      ?POD? =1 and [Presentation].[Pod 1] Or
      ?POD? = 2 and [Presentation].[Pod 2] Or
      ?POD? = 3 and [Presentation].[Pod 3] Or
      ?POD? = 4 and [Presentation].[Pod 4] Or
      ?POD? = 5 and [Presentation].[Pod 5] Or
      ?POD? = 6 and [Presentation].[Pod 6] Or
      ?POD? = 7 and [Presentation].[Pod 7] Or
      ?POD? = 8 and [Presentation].[Pod 8] Or
      ?POD? = 9 and [Presentation].[Pod 9] Or
      ?POD? = 10 and [Presentation].[Pod 10] Or
      ?POD? = 11 and [Presentation].[Pod 11] Or
      ?POD? = 12 and [Presentation].[Pod 12] Or
      ?POD? = 13 and [Presentation].[Pod 13] Or
      ?POD? = 14 and [Presentation].[Pod 14] Or
      ?POD? = 15 and [Presentation].[Pod 15] Or
      ?POD? = 16 and [Presentation].[Pod 16] Or
      ?POD? = 17 and [Presentation].[Pod 17] Or
      ?POD? = 18 and [Presentation].[Pod 18]
    • Required
      [Presentation].[VW_STG_DEPARTMENT].[CODE] = ?DEPT?
  • Query
    PRI Distinct Counts DEPT
    Data Items
    5
    Business Unit
    [Presentation].[VW_STG_DEPARTMENT].[CODE]
    Measure Category
    if (#sq($runLocale )#<> 'fr') then ( 'PRI''s' ) else ( 'CIDP' )
    Baseline
    [Presentation].[VW_CMT_POD_LOOKUP].[BASELINE_DEPT_PRI_CNT]
    Backlog
    if (
    [Presentation].[State].[NAME] not in ('Bring_Forward', 'Cancelled', 'Closed', 'Invalid')
    and
    ([Presentation].[Case].[CMT_AGE] >[Presentation].[Sub Type].[SERVICE_STANDARD]
    or
    [Presentation].[Case].[PROCESSING_CENTRE] contains [Presentation].[VW_CMT_POD_LOOKUP].[POD_TAG]
    )
    ) then ( [Presentation].[Case].[PRI] ) else (null)
    Aggregate
    countDistinct countDistinct
    Queue
    if (
    [Presentation].[State].[NAME] not in ('Bring_Forward', 'Cancelled', 'Closed', 'Invalid')
    ) then ( [Presentation].[Case].[PRI] ) else (null)
    Aggregate
    countDistinct countDistinct
    • Detail Filters
      3
    • Required
      ?POD? = 0 and [Presentation].[Pod 0] Or
      ?POD? =1 and [Presentation].[Pod 1] Or
      ?POD? = 2 and [Presentation].[Pod 2] Or
      ?POD? = 3 and [Presentation].[Pod 3] Or
      ?POD? = 4 and [Presentation].[Pod 4] Or
      ?POD? = 5 and [Presentation].[Pod 5] Or
      ?POD? = 6 and [Presentation].[Pod 6] Or
      ?POD? = 7 and [Presentation].[Pod 7] Or
      ?POD? = 8 and [Presentation].[Pod 8] Or
      ?POD? = 9 and [Presentation].[Pod 9] Or
      ?POD? = 10 and [Presentation].[Pod 10] Or
      ?POD? = 11 and [Presentation].[Pod 11] Or
      ?POD? = 12 and [Presentation].[Pod 12] Or
      ?POD? = 13 and [Presentation].[Pod 13] Or
      ?POD? = 14 and [Presentation].[Pod 14] Or
      ?POD? = 15 and [Presentation].[Pod 15] Or
      ?POD? = 16 and [Presentation].[Pod 16] Or
      ?POD? = 17 and [Presentation].[Pod 17] Or
      ?POD? = 18 and [Presentation].[Pod 18]
    • Required
      [Presentation].[VW_CMT_POD_LOOKUP].[POD_NO] = ?POD?
    • Required
      [Presentation].[VW_STG_DEPARTMENT].[CODE] = ?DEPT?
  • Query
    PRI Baseline and Intake DEPT
    Data Items
    5
    Business Unit
    [Presentation].[VW_STG_DEPARTMENT].[CODE]
    Measure Category
    if (#sq($runLocale )#<> 'fr') then ( 'PRI''s' ) else ( 'CIDP' )
    Progress on Baseline
    if (
    [Presentation].[Case].[PROCESSING_CENTRE] contains [Presentation].[VW_CMT_POD_LOOKUP].[POD_TAG]
    and [Presentation].[State].[NAME] not in ('Bring_Forward', 'Cancelled', 'Closed', 'Invalid')
    )
    then ( [Presentation].[Case].[PRI] )
    else ( null )
    Aggregate
    countDistinct countDistinct
    Outstanding Intake - Over SS
    if (
    (
    [Presentation].[Case].[PROCESSING_CENTRE] not contains [Presentation].[VW_CMT_POD_LOOKUP].[POD_TAG]
    or
    [Presentation].[Case].[PROCESSING_CENTRE] is null
    )
    and
    [Presentation].[State].[NAME] not in ('Bring_Forward', 'Cancelled', 'Closed', 'Invalid')
    and
    [Presentation].[Case].[CMT_AGE]>[Presentation].[Sub Type].[SERVICE_STANDARD]
    and
    (
    [Presentation].[Case].[DATE_OPEN_EST] >[Presentation].[VW_CMT_POD_LOOKUP].[POD_START_DT] or [Presentation].[Case].[DATE_BF_EST] >[Presentation].[VW_CMT_POD_LOOKUP].[POD_START_DT]
    )
    )
    then ( [Presentation].[Case].[PRI] )
    else ( null )
    Aggregate
    countDistinct countDistinct
    Outstanding Intake - Within SS
    if (
    (
    [Presentation].[Case].[PROCESSING_CENTRE] not contains [Presentation].[VW_CMT_POD_LOOKUP].[POD_TAG]
    or
    [Presentation].[Case].[PROCESSING_CENTRE] is null
    )
    and
    [Presentation].[State].[NAME] not in ('Bring_Forward', 'Cancelled', 'Closed', 'Invalid')
    and
    [Presentation].[Case].[CMT_AGE]<=[Presentation].[Sub Type].[SERVICE_STANDARD]
    and
    (
    [Presentation].[Case].[DATE_OPEN_EST] >[Presentation].[VW_CMT_POD_LOOKUP].[POD_START_DT] or [Presentation].[Case].[DATE_BF_EST] >[Presentation].[VW_CMT_POD_LOOKUP].[POD_START_DT]
    )
    )
    then ( [Presentation].[Case].[PRI] )
    else ( null )
    Aggregate
    countDistinct countDistinct
    • Detail Filters
      2
    • Required
      ?POD? = 0 and [Presentation].[Pod 0] Or
      ?POD? =1 and [Presentation].[Pod 1] Or
      ?POD? = 2 and [Presentation].[Pod 2] Or
      ?POD? = 3 and [Presentation].[Pod 3] Or
      ?POD? = 4 and [Presentation].[Pod 4] Or
      ?POD? = 5 and [Presentation].[Pod 5] Or
      ?POD? = 6 and [Presentation].[Pod 6] Or
      ?POD? = 7 and [Presentation].[Pod 7] Or
      ?POD? = 8 and [Presentation].[Pod 8] Or
      ?POD? = 9 and [Presentation].[Pod 9] Or
      ?POD? = 10 and [Presentation].[Pod 10] Or
      ?POD? = 11 and [Presentation].[Pod 11] Or
      ?POD? = 12 and [Presentation].[Pod 12] Or
      ?POD? = 13 and [Presentation].[Pod 13] Or
      ?POD? = 14 and [Presentation].[Pod 14] Or
      ?POD? = 15 and [Presentation].[Pod 15] Or
      ?POD? = 16 and [Presentation].[Pod 16] Or
      ?POD? = 17 and [Presentation].[Pod 17] Or
      ?POD? = 18 and [Presentation].[Pod 18]
    • Required
      [Presentation].[VW_STG_DEPARTMENT].[CODE] = ?DEPT?
  • Query
    Dept Cases
    Join 
    [Case Counts DEPT].[Measure Category] = [Cases Baseline and Intake DEPT].[Measure Category] and
[Case Counts DEPT].[DEPARTMENT CODE] = [Cases Baseline and Intake DEPT].[Business Unit]
    refQuery
    Case Counts DEPT
    1:N
    refQuery
    Cases Baseline and Intake DEPT
    1:N
    Data Items
    8
    DEPARTMENT CODE
    [Case Counts DEPT].[DEPARTMENT CODE]
    Measure Category
    [Case Counts DEPT].[Measure Category]
    Baseline
    cast([Case Counts DEPT].[Baseline], integer)
    Progress on Baseline
    cast([Cases Baseline and Intake DEPT].[Progress on Baseline], integer)
    Backlog
    cast([Case Counts DEPT].[Backlog], integer)
    Queue
    cast([Case Counts DEPT].[Queue], integer)
    Outstanding Intake - Over SS
    cast([Cases Baseline and Intake DEPT].[Outstanding Intake - Over SS], integer)
    Outstanding Intake - Within SS
    cast([Cases Baseline and Intake DEPT].[Outstanding Intake - Within SS], integer)
  • Query
    Dept PRI
    Join 
    [PRI Distinct Counts DEPT].[Measure Category] = [PRI Baseline and Intake DEPT].[Measure Category] and
[PRI Distinct Counts DEPT].[Business Unit] = [PRI Baseline and Intake DEPT].[Business Unit]
    refQuery
    PRI Distinct Counts DEPT
    1:N
    refQuery
    PRI Baseline and Intake DEPT
    1:N
    Data Items
    8
    Business Unit
    [PRI Distinct Counts DEPT].[Business Unit]
    Measure Category
    [PRI Distinct Counts DEPT].[Measure Category]
    Baseline
    cast([PRI Distinct Counts DEPT].[Baseline], integer)
    Progress on Baseline
    cast([PRI Baseline and Intake DEPT].[Progress on Baseline], integer)
    Backlog
    cast([PRI Distinct Counts DEPT].[Backlog], integer)
    Queue
    cast([PRI Distinct Counts DEPT].[Queue], integer)
    Outstanding Intake - Over SS
    cast([PRI Baseline and Intake DEPT].[Outstanding Intake - Over SS], integer)
    Outstanding Intake - Within SS
    cast([PRI Baseline and Intake DEPT].[Outstanding Intake - Within SS], integer)
  • Query
    pq_POD
    Data Items
    1
    POD_NO
    [Presentation].[VW_CMT_POD_LOOKUP].[POD_NO]
    • Detail Filters
      1
    • Required
      [POD_NO] is not null
  • Query
    pq_DEPT
    Data Items
    1
    DEPT_CODE
    [Presentation].[VW_CMT_POD_LOOKUP].[DEPT_CODE]
    • Detail Filters
      1
    • Required
      [Presentation].[VW_CMT_POD_LOOKUP].[POD_NO]=?POD?
  • Query
    Business Unit Prompt Title
    Data Items
    1
    Business Unit
    [Presentation].[VW_STG_DEPARTMENT].[CODE]
Layouts