Queries

• 12
  Expressions:

  

  Data Items

  

  Detail Filters
• Model: /PCR/PCR Deployment/PCR Packages/packagePCR-RCP/ name: model

• 

  

  POD Backlog

  

  

  PODS Cases

  

  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
  Progress on Baseline	[Union1].[Progress on Baseline]	Aggregate summarize label Current #
  Backlog	[Union1].[Backlog]	Aggregate summarize label Current #
  Queue	[Union1].[Queue]	Aggregate summarize label Current #
  Outstanding Intake - Over SS	[Union1].[Outstanding Intake - Over SS]	Aggregate summarize
  Outstanding Intake - Within SS	[Union1].[Outstanding Intake - Within SS]	Aggregate summarize Rollup summarize
  Backlog Variant	[Baseline] - [Backlog]	Aggregate summarize label Variant
  Backlog Reduction	[Backlog Variant]/[Baseline]	Aggregate summarize label Reduction
  Queue Variant	[Baseline] - [Queue]	Aggregate summarize label Variant
  Queue Reduction	[Queue Variant] / [Baseline]	Aggregate summarize label Reduction
  Progress Variant	[Baseline] - [Progress on Baseline]	Aggregate summarize label Variant
  Progress Reduction	[Progress Variant] / [Baseline]	Aggregate summarize label Reduction

• 

  

  Active Workload

  • queryHints
  • crossProductAllowed: allow

  Data Items

  14

  Case Category	[Presentation].[State].[(en-zw) Case Category]
  Case Number	[Presentation].[Case].[ID]
  State Name	[Presentation].[State].[NAME]
  Age	[Presentation].[Case].[CMT_AGE]
  Age Group	[Presentation].[Case].[Age Group]
  PRI	[Presentation].[Case].[PRI]
  Work Type Name	[Presentation].[Work Type].[NAME]
  Sub Type Name	[Presentation].[Sub Type].[NAME]
  Business Unit	[Presentation].[VW_STG_DEPARTMENT].[CODE]
  Unique Class	[Presentation].[Case].[Subject]
  Date Open	[Presentation].[Case].[DATE_OPEN_EST]
  BF Date	[Presentation].[Case].[DATE_BF_EST]
  Processing Centre	[Presentation].[Case].[PROCESSING_CENTRE]
  Language	[Presentation].[Case].[LANG]

  • Detail Filters
    3
  • 

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

    [Presentation].[Pod EX]
    
  • 

    [Presentation].[Case].[PROCESSING_CENTRE] contains [EX Lookup Query].[POD_TAG]
    
• 

  

  Baseline Cases Closed to Date

  • queryHints
  • crossProductAllowed: allow

  Data Items

  15

  Case Category	[Presentation].[State].[(en-zw) Case Category]
  Case Number	[Presentation].[Case].[ID]
  State Name	[Presentation].[State].[NAME]
  Date Closed	[Presentation].[Case].[DATE_CLOSED_EST]
  Age	[Presentation].[Case].[CMT_AGE]
  Age Group	[Presentation].[Case].[Age Group]
  PRI	[Presentation].[Case].[PRI]
  Work Type Name	[Presentation].[Work Type].[NAME]
  Sub Type Name	[Presentation].[Sub Type].[NAME]
  Business Unit	[Presentation].[VW_STG_DEPARTMENT].[CODE]
  Unique Class	[Presentation].[Case].[Subject]
  Date Open	[Presentation].[Case].[DATE_OPEN_EST]
  BF Date	[Presentation].[Case].[DATE_BF_EST]
  Processing Centre	[Presentation].[Case].[PROCESSING_CENTRE]
  Language	[Presentation].[Case].[LANG]

  • Detail Filters
    4
  • 

    [Presentation].[Pod EX]
    
  • 

    [Presentation].[Case].[PROCESSING_CENTRE] contains [EX Lookup Query].[POD_TAG]
    
  • 

    [Presentation].[State].[NAME] = 'Closed'
    
  • 

    [Presentation].[Case].[DATE_CLOSED_EST] > [EX Lookup Query].[POD Start Date] and [Presentation].[Case].[DATE_CLOSED_EST] < cast(getdate (),date)
    
• 

  

  Baseline Raw Data

  • queryHints
  • crossProductAllowed: allow

  Data Items

  14

  Case Category	[Presentation].[State].[(en-zw) Case Category]
  Case Number	[Presentation].[Case].[ID]
  State Name	[Presentation].[State].[NAME]
  Age	[Presentation].[Case].[CMT_AGE]
  Age Group	[Presentation].[Case].[Age Group]
  PRI	[Presentation].[Case].[PRI]
  Work Type Name	[Presentation].[Work Type].[NAME]
  Sub Type Name	[Presentation].[Sub Type].[NAME]
  Business Unit	[Presentation].[VW_STG_DEPARTMENT].[CODE]
  Unique Class	[Presentation].[Case].[Subject]
  Date Open	[Presentation].[Case].[DATE_OPEN_EST]
  BF Date	[Presentation].[Case].[DATE_BF_EST]
  Processing Centre	[Presentation].[Case].[PROCESSING_CENTRE]
  Language	[Presentation].[Case].[LANG]

  • Detail Filters
    3
  • 

    [Presentation].[Pod EX]
    
  • 

    [Presentation].[Case].[PROCESSING_CENTRE] contains [EX Lookup Query].[POD_TAG]
    
  • 

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

  

  POD START DT

  Data Items

  1

  POD_START_DT	[Presentation].[VW_CMT_POD_LOOKUP].[POD_START_DT]

  • Detail Filters
    1
  • 

    [Presentation].[VW_CMT_POD_LOOKUP].[ID]=40
    
• 

  

  Case Counts PODS

  • queryHints
  • crossProductAllowed: allow

  Data Items

  4

  Measure Category	if (#sq($runLocale )#<> 'fr') then ( 'Cases' ) else ( 'Cas' )
  Baseline	[EX Lookup Query].[BASELINE_POD_CASE_CNT]
  Backlog	if ( [Presentation].[State].[NAME] not in ('Bring_Forward', 'Cancelled', 'Closed') and ([Presentation].[Case].[CMT_AGE] >cast([Presentation].[Sub Type].[SERVICE_STANDARD],integer) or [Presentation].[Case].[PROCESSING_CENTRE] contains ([EX Lookup Query].[POD_TAG]) ) ) then ( [Presentation].[Case].[ID] ) else (null)	Aggregate count
  Queue	if ( [Presentation].[State].[NAME] not in ('Bring_Forward', 'Cancelled', 'Closed') ) then ( [Presentation].[Case].[ID] ) else (null)	Aggregate count

  • Detail Filters
    1
  • 

    [Presentation].[Pod EX]
    
• 

  

  Cases Baseline and Intake PODS

  • queryHints
  • crossProductAllowed: allow

  Data Items

  4

  Measure Category	if (#sq($runLocale )#<> 'fr') then ( 'Cases' ) else ( 'Cas' )
  Progress on Baseline	if ( [Presentation].[Case].[PROCESSING_CENTRE] contains ([EX Lookup Query].[POD_TAG]) and [Presentation].[State].[NAME] not in ('Bring_Forward', 'Cancelled', 'Closed') ) then ( [Presentation].[Case].[ID] ) else ( null )	Aggregate count
  Outstanding Intake - Over SS	if ( ( [Presentation].[Case].[PROCESSING_CENTRE] not contains ([EX Lookup Query].[POD_TAG]) or [Presentation].[Case].[PROCESSING_CENTRE] is null ) and [Presentation].[State].[NAME] not in ('Bring_Forward', 'Cancelled', 'Closed') and [Presentation].[Case].[CMT_AGE]>cast([Presentation].[Sub Type].[SERVICE_STANDARD],integer) and ( ( [Presentation].[Case].[DATE_OPEN_EST] >cast([EX Lookup Query].[POD Start Date],date) and [Presentation].[Case].[DATE_BF_EST] is null ) or [Presentation].[Case].[DATE_BF_EST] >cast([EX Lookup Query].[POD Start Date],date) ) ) then ( [Presentation].[Case].[ID] ) else ( null )	Aggregate count
  Outstanding Intake - Within SS	if ( ( [Presentation].[Case].[PROCESSING_CENTRE] not contains ([EX Lookup Query].[POD_TAG]) or [Presentation].[Case].[PROCESSING_CENTRE] is null ) and [Presentation].[State].[NAME] not in ('Bring_Forward', 'Cancelled', 'Closed') and [Presentation].[Case].[CMT_AGE]<=cast([Presentation].[Sub Type].[SERVICE_STANDARD],integer) and ( ( [Presentation].[Case].[DATE_OPEN_EST] >cast([EX Lookup Query].[POD Start Date],date) and [Presentation].[Case].[DATE_BF_EST] is null ) or [Presentation].[Case].[DATE_BF_EST]>cast([EX Lookup Query].[POD Start Date],date) ) ) then ( [Presentation].[Case].[ID] ) else ( null )	Aggregate count

  • Detail Filters
    1
  • 

    [Presentation].[Pod EX]
    
• 

  

  PRI Distinct Counts PODS

  • queryHints
  • crossProductAllowed: allow

  Data Items

  4

  Measure Category	if (#sq($runLocale )#<> 'fr') then ( 'PRI''s' ) else ( 'CIDP' )
  Baseline	[EX Lookup Query].[BASELINE_POD_PRI_CNT]
  Backlog	if ( [Presentation].[State].[NAME] not in ('Bring_Forward', 'Cancelled', 'Closed') and ([Presentation].[Case].[CMT_AGE] >cast([Presentation].[Sub Type].[SERVICE_STANDARD],integer) or [Presentation].[Case].[PROCESSING_CENTRE] contains ([EX Lookup Query].[POD_TAG]) ) ) then ( [Presentation].[Case].[PRI] ) else (null)	Aggregate countDistinct
  Queue	if ( [Presentation].[State].[NAME] not in ('Bring_Forward', 'Cancelled', 'Closed') ) then ( [Presentation].[Case].[PRI] ) else (null)	Aggregate countDistinct

  • Detail Filters
    1
  • 

    [Presentation].[Pod EX]
    
• 

  

  PRI Baseline and Intake PODS

  • queryHints
  • crossProductAllowed: allow

  Data Items

  4

  Measure Category	if (#sq($runLocale )#<> 'fr') then ( 'PRI''s' ) else ( 'CIDP' )
  Progress on Baseline	if ( [Presentation].[Case].[PROCESSING_CENTRE] contains ([EX Lookup Query].[POD_TAG]) and [Presentation].[State].[NAME] not in ('Bring_Forward', 'Cancelled', 'Closed') ) then ( [Presentation].[Case].[PRI] ) else ( null )	Aggregate countDistinct
  Outstanding Intake - Over SS	if ( ( [Presentation].[Case].[PROCESSING_CENTRE] not contains ([EX Lookup Query].[POD_TAG]) or [Presentation].[Case].[PROCESSING_CENTRE] is null ) and [Presentation].[State].[NAME] not in ('Bring_Forward', 'Cancelled', 'Closed') and [Presentation].[Case].[CMT_AGE]>cast([Presentation].[Sub Type].[SERVICE_STANDARD],integer) and ( ( [Presentation].[Case].[DATE_OPEN_EST] >cast([EX Lookup Query].[POD Start Date],date) and [Presentation].[Case].[DATE_BF_EST] is null ) or [Presentation].[Case].[DATE_BF_EST] >cast([EX Lookup Query].[POD Start Date],date) ) ) then ( [Presentation].[Case].[PRI] ) else ( null )	Aggregate countDistinct
  Outstanding Intake - Within SS	if ( ( [Presentation].[Case].[PROCESSING_CENTRE] not contains ([EX Lookup Query].[POD_TAG]) or [Presentation].[Case].[PROCESSING_CENTRE] is null ) and [Presentation].[State].[NAME] not in ('Bring_Forward', 'Cancelled', 'Closed') and [Presentation].[Case].[CMT_AGE]<=cast([Presentation].[Sub Type].[SERVICE_STANDARD],integer) and ( ( [Presentation].[Case].[DATE_OPEN_EST] >cast([EX Lookup Query].[POD Start Date],date) and [Presentation].[Case].[DATE_BF_EST] is null ) or [Presentation].[Case].[DATE_BF_EST] >cast([EX Lookup Query].[POD Start Date],date) )) then ( [Presentation].[Case].[PRI] ) else ( null )	Aggregate countDistinct

  • Detail Filters
    1
  • 

    ( ( [Presentation].[Case].[Unique Class] = 'EX' OR [Presentation].[Sub Type].[Sub Type Code] in ('ST-185', 'ST-187', 'ST-186', 'ST-520', 'ST-331', 'ST-299', 'ST-321', 'ST-605', 'ST-609', 'ST-301', 'ST-323', 'ST-071', 'ST-150', 'ST-521', 'ST-516', 'ST-207', 'ST-107', 'ST-271') ) AND [Presentation].[Work Type].[Work Type Code] <> 'WT-058' AND ( [Presentation].[Case].[Date Closed or Date Cancelled EST] is null OR [Presentation].[Case].[Date Closed or Date Cancelled EST] >2019-02-27 ) )
    
• 

  

  PODS Cases

  

  [Case Counts PODS].[Measure Category] = [Cases Baseline and Intake PODS].[Measure Category]

  

  Case Counts PODS

  1:N

  

  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)

• 

  

  PODS PRI

  

  [PRI Distinct Counts PODS].[Measure Category] = [PRI Baseline and Intake PODS].[Measure Category]

  

  PRI Distinct Counts PODS

  1:N

  

  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)

• 

  

  EX Lookup Query

  Data Items

  10

  ID	[Presentation].[VW_CMT_POD_LOOKUP].[ID]
  POD_NO	[Presentation].[VW_CMT_POD_LOOKUP].[POD_NO]
  POD Name	[Presentation].[VW_CMT_POD_LOOKUP].[POD Name]
  DEPT_CODE	[Presentation].[VW_CMT_POD_LOOKUP].[DEPT_CODE]
  POD Start Date	[Presentation].[VW_CMT_POD_LOOKUP].[POD_START_DT]
  POD_TAG	[Presentation].[VW_CMT_POD_LOOKUP].[POD_TAG]
  BASELINE_POD_CASE_CNT	[Presentation].[VW_CMT_POD_LOOKUP].[BASELINE_POD_CASE_CNT]
  BASELINE_POD_PRI_CNT	[Presentation].[VW_CMT_POD_LOOKUP].[BASELINE_POD_PRI_CNT]
  BASELINE_DEPT_CASE_CNT	[Presentation].[VW_CMT_POD_LOOKUP].[BASELINE_DEPT_CASE_CNT]
  BASELINE_DEPT_PRI_CNT	[Presentation].[VW_CMT_POD_LOOKUP].[BASELINE_DEPT_PRI_CNT]

  • Detail Filters
    1
  • 

    [ID]=40
    

Layouts