Queries

• 58
  Expressions:

  

  Data Items

  

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

• 

  

  Current Variance POD

  

  [Current POD].[Measure Category] = [Baseline POD].[Measure Category]

  

  Current POD

  1:N

  

  Baseline POD

  1:1

  Data Items

  9

  Measure Category Sort	[Current POD].[Measure Category Sort]
  Measure Category	[Current POD].[Measure Category]
  Measure Category - short label	if ( #sq($runLocale)# <>'fr' ) then ( case [Measure Category Sort] when 1 then 'Queue (cases)' when 2 then 'Queue (PRIs)' when 3 then 'Backlog (cases)' when 4 then 'Backlog (PRIs)' when 5 then 'Baseline (cases)' when 6 then 'Baseline (PRIs)' end ) else ( case [Measure Category Sort] when 1 then 'File d’attente (cas)' when 2 then 'File d’attente (CIDP)' when 3 then 'Arriéré (cas)' when 4 then 'Arriéré (CIDP)' when 5 then 'Référence (cas)' when 6 then 'Référence (CIDP)' end )
  Baseline Date	[Baseline POD].[VERSION DATE]
  Current Date	[Current POD].[VERSION DATE]
  Baseline	[Baseline POD].[Measure]	Aggregate total
  Current	[Current POD].[Measure]	Aggregate total
  Variance	[Current] - [Baseline]	Aggregate calculated Rollup calculated
  Change	[Variance] / [Baseline]	Aggregate calculated Rollup calculated

• 

  

  Current Variance DEPT

  

  [Current DEPT].[Measure Category] = [Baseline DEPT].[Measure Category] and
  [Current DEPT].[Business Unit] = [Baseline DEPT].[Business Unit]

  

  Current DEPT

  1:N

  

  Baseline DEPT

  1:N

  Data Items

  11

  Business Unit	[Current DEPT].[Business Unit]
  Department Name	[Current DEPT].[Department Name]
  Measure Category	[Current DEPT].[Measure Category]
  Measure Category Sort	[Current DEPT].[Measure Category Sort]
  Measure Category - short label	if ( #sq($runLocale)# <>'fr' ) then ( case [Measure Category Sort] when 1 then 'Queue (cases)' when 2 then 'Queue (PRIs)' when 3 then 'Backlog (cases)' when 4 then 'Backlog (PRIs)' when 5 then 'Baseline (cases)' when 6 then 'Baseline (PRIs)' end ) else ( case [Measure Category Sort] when 1 then 'File d’attente (cas)' when 2 then 'File d’attente (CIDP)' when 3 then 'Arriéré (cas)' when 4 then 'Arriéré (CIDP)' when 5 then 'Référence (cas)' when 6 then 'Référence (CIDP)' end )
  Baseline Date	[Baseline DEPT].[VERSION DATE]
  Current Date	cast( [Current DEPT].[VERSION DATE], date )
  Baseline	[Baseline DEPT].[Measure]	Aggregate total
  Current	[Current DEPT].[Measure]	Aggregate total
  Variance	[Current] - [Baseline]	Aggregate calculated Rollup calculated
  Change	[Variance] / [Baseline]	Aggregate calculated Rollup calculated

• 

  

  Intake POD

  • queryHints
  • crossProductAllowed: allow

  Data Items

  9

  Period Start Date	[Pod and Pay Dates - One Line].[Period Start]
  Pay Period End Date	[Pod and Pay Dates - One Line].[Period End]
  Open	if (/* open date in the last pay period */ [Presentation].[Case].[DATE_OPEN_EST] >= [Pod and Pay Dates - One Line].[Period Start] and [Presentation].[Case].[DATE_OPEN_EST]<=[Pod and Pay Dates - One Line].[Period End] and /* BF Date isnt populated to avoid double counting in BF calc */ [Presentation].[Case].[DATE_BF_EST] is missing ) then ( [Presentation].[Case].[Case Count] ) else ( null )	Aggregate count Rollup total
  Bring Forward	if (/* BF date in the last pay period */ [Presentation].[Case].[DATE_BF_EST] >= [Pod and Pay Dates - One Line].[Period Start] and [Presentation].[Case].[DATE_BF_EST]<=[Pod and Pay Dates - One Line].[Period End] ) then ( [Presentation].[Case].[Case Count] ) else ( null )	Aggregate count Rollup total
  Closed	if (/* date closed in the last pay period */ [Presentation].[Case].[DATE_CLOSED_EST] >= [Period Start Date] and [Presentation].[Case].[DATE_CLOSED_EST]<= [Pay Period End Date] ) then ( [Presentation].[Case].[Case Count] ) else ( null )	Aggregate count Rollup total
  Cancelled	if (/* date closed in the last pay period */ [Presentation].[Case].[DATE_CANCELLED_EST] >= [Period Start Date] and [Presentation].[Case].[DATE_CANCELLED_EST] <= [Pay Period End Date] ) then ( [Presentation].[Case].[Case Count] ) else ( null )	Aggregate count Rollup total
  Cases Unassigned	if ( [Presentation].[State].[NAME] in ('Open', 'Reassigned', 'Invalid') ) then ( [Presentation].[Case].[Case Count] ) else ( null )	Aggregate count Rollup total
  Cases In Progress	if (/* state is not closed */ [Presentation].[State].[NAME] not in ('Open', 'Bring_Forward', 'Cancelled', 'Closed', 'Invalid', 'Reassigned') ) then ( [Presentation].[Case].[Case Count] ) else ( null )	Aggregate count Rollup total
  Total Active Workload	count([Cases Unassigned]) + count([Cases In Progress])	Aggregate total label Active Workload

  • Detail Filters
    1
  • 

    ?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]
    
• 

  

  Intake DEPT

  • queryHints
  • crossProductAllowed: allow

  Data Items

  11

  Period Start Date	[Pod and Pay Dates - One Line].[Period Start]
  Pay Period End Date	[Pod and Pay Dates - One Line].[Period End]
  Open	if (/* open date in the last pay period */ [Presentation].[Case].[DATE_OPEN_EST] >= [Pod and Pay Dates - One Line].[Period Start] and [Presentation].[Case].[DATE_OPEN_EST] <= [Pod and Pay Dates - One Line].[Period End] and /* BF Date isnt populated to avoid double counting in BF calc */ [Presentation].[Case].[DATE_BF_EST] is missing ) then ( [Presentation].[Case].[Case Count] ) else ( null )	Aggregate count Rollup total
  Bring Forward	if (/* BF date in the last pay period */ [Presentation].[Case].[DATE_BF_EST] >= [Pod and Pay Dates - One Line].[Period Start] and [Presentation].[Case].[DATE_BF_EST] <= [Pod and Pay Dates - One Line].[Period End] ) then ( [Presentation].[Case].[Case Count] ) else ( null )	Aggregate count Rollup total
  Closed	if (/* date closed in the last pay period */ [Presentation].[Case].[DATE_CLOSED_EST] >= [Period Start Date] and [Presentation].[Case].[DATE_CLOSED_EST] <= [Pay Period End Date] ) then ( [Presentation].[Case].[Case Count] ) else ( null )	Aggregate count Rollup total
  Cancelled	if (/* date closed in the last pay period */ [Presentation].[Case].[DATE_CANCELLED_EST] >= [Period Start Date] and [Presentation].[Case].[DATE_CANCELLED_EST] <= [Pay Period End Date] ) then ( [Presentation].[Case].[Case Count] ) else ( null )	Aggregate count Rollup total
  Cases Unassigned	if ( [Presentation].[State].[NAME] in ('Open', 'Reassigned', 'Invalid') ) then ( [Presentation].[Case].[Case Count] ) else ( null )	Aggregate count Rollup total
  Cases In Progress	if (/* state is not closed */ [Presentation].[State].[NAME] not in ('Open', 'Bring_Forward', 'Cancelled', 'Closed', 'Invalid', 'Reassigned') ) then ( [Presentation].[Case].[Case Count] ) else ( null )	Aggregate count Rollup total
  Total Active Workload	count([Cases Unassigned]) + count([Cases In Progress])	Aggregate total label Active Workload
  Business Unit	[Presentation].[VW_STG_DEPARTMENT].[CODE]
  Department Name	[Presentation].[VW_STG_DEPARTMENT].[NAME_1]

  • Detail Filters
    2
  • 

    ?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]
    
  • 

    [Presentation].[VW_STG_DEPARTMENT].[CODE] = ?Dept?
    
• 

  

  Queue Age Count POD

  • queryHints
  • crossProductAllowed: allow

  Data Items

  3

  Age Sort	case when [Presentation].[Case].[CMT_AGE] <=9 then 1 when [Presentation].[Case].[CMT_AGE] between 10 and 20 then 2 when [Presentation].[Case].[CMT_AGE] >20 then 3 else 99 end	sort ascending
  Age	case when [Presentation].[Case].[CMT_AGE] <=9 then ' 0 - 9' when [Presentation].[Case].[CMT_AGE] between 10 and 20 then ' 10 - 20' when [Presentation].[Case].[CMT_AGE] >20 then ' +20' else cast([Presentation].[Case].[CMT_AGE], varchar(4)) end
  Case Count	[Presentation].[Case].[Case Count]	Aggregate count

  • Detail Filters
    2
  • 

    ?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]
    
  • 

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

  

  Queue Age Count DEPT

  • queryHints
  • crossProductAllowed: allow

  Data Items

  5

  Age Sort	case when [Presentation].[Case].[CMT_AGE] <=9 then 1 when [Presentation].[Case].[CMT_AGE] between 10 and 20 then 2 when [Presentation].[Case].[CMT_AGE] >20 then 3 else 99 end	sort ascending
  Age	case when [Presentation].[Case].[CMT_AGE] <=9 then ' 0 - 9' when [Presentation].[Case].[CMT_AGE] between 10 and 20 then ' 10 - 20' when [Presentation].[Case].[CMT_AGE] >20 then ' +20' else cast([Presentation].[Case].[CMT_AGE], varchar(4)) end
  Case Count	[Presentation].[Case].[Case Count]	Aggregate count
  Business Unit	[Presentation].[VW_STG_DEPARTMENT].[CODE]
  Department Name	[Presentation].[VW_STG_DEPARTMENT].[NAME_1]

  • Detail Filters
    3
  • 

    ?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]
    
  • 

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

    [Presentation].[VW_STG_DEPARTMENT].[CODE] = ?Dept?
    
• 

  

  Prior Variance POD

  

  [Prior POD].[Measure Category] = [Baseline POD].[Measure Category]

  

  Prior POD

  1:N

  

  Baseline POD

  1:N

  Data Items

  8

  Measure Category Sort	[Prior POD].[Measure Category Sort]
  Measure Category	[Prior POD].[Measure Category]
  Baseline Date	[Baseline POD].[VERSION DATE]
  Prior Date	[Prior POD].[VERSION DATE]
  Baseline	[Baseline POD].[Measure]	Aggregate total
  Prior	[Prior POD].[Measure]	Aggregate total
  Variance	[Prior] - [Baseline]	Aggregate calculated Rollup calculated
  Change	[Variance] / [Baseline]	Aggregate calculated Rollup calculated

• 

  

  Prior Variance DEPT

  

  [Prior DEPT].[Business Unit] = [Baseline DEPT].[Business Unit] and
  [Prior DEPT].[Measure Category] = [Baseline DEPT].[Measure Category]

  

  Prior DEPT

  1:N

  

  Baseline DEPT

  1:N

  Data Items

  10

  Business Unit	[Prior DEPT].[Business Unit]
  Department Name	[Prior DEPT].[Department Name]
  Measure Category	[Prior DEPT].[Measure Category]
  Measure Category Sort	[Prior DEPT].[Measure Category Sort]
  Baseline Date	[Baseline DEPT].[VERSION DATE]
  Prior Date	[Prior DEPT].[VERSION DATE]
  Prior	[Prior DEPT].[Measure]	Aggregate total
  Baseline	[Baseline DEPT].[Measure]	Aggregate total
  Variance	[Prior] - [Baseline]	Aggregate calculated Rollup calculated
  Change	[Variance] / [Baseline]	Aggregate calculated Rollup calculated

• 

  

  Current POD

  

  

  PRI Queue Current POD

  

  PRI Backlog Current POD

  

  PRI Baseline Current POD

  

  Case Queue Current POD

  

  Case Backlog Current POD

  

  Case Baseline Current POD

  • Projected Data Items
  • VERSION DATE
  • Measure
  • Measure Category
  • Measure Category Sort

  Data Items

  4

  VERSION DATE	[Union1].[VERSION DATE]
  Measure	[Union1].[Measure]	Aggregate total
  Measure Category	[Union1].[Measure Category]
  Measure Category Sort	[Union1].[Measure Category Sort]

• 

  

  Current DEPT

  

  

  PRI Queue Current DEPT

  

  PRI Backlog Current DEPT

  

  PRI Baseline Current DEPT

  

  Case Queue Current DEPT

  

  Case Backlog Current DEPT

  

  Case Baseline Current DEPT

  • Projected Data Items
  • Business Unit
  • Department Name
  • VERSION DATE
  • Measure
  • Measure Category
  • Measure Category Sort

  Data Items

  6

  Business Unit	[Union6].[Business Unit]
  Department Name	[Union6].[Department Name]
  VERSION DATE	[Union6].[VERSION DATE]
  Measure	[Union6].[Measure]	Aggregate total
  Measure Category	[Union6].[Measure Category]
  Measure Category Sort	[Union6].[Measure Category Sort]

• 

  

  Prior POD

  

  

  PRI Queue Prior POD

  

  PRI Backlog Prior POD

  

  PRI Baseline Prior POD

  

  Case Queue Prior POD

  

  Case Backlog Prior POD

  

  Case Baseline Prior POD

  • Projected Data Items
  • VERSION DATE
  • Measure
  • Measure Category
  • Measure Category Sort

  Data Items

  4

  VERSION DATE	[Union3].[VERSION DATE]
  Measure	[Union3].[Measure]	Aggregate total
  Measure Category	[Union3].[Measure Category]
  Measure Category Sort	[Union3].[Measure Category Sort]

• 

  

  Prior DEPT

  

  

  PRI Queue Prior DEPT

  

  PRI Backlog Prior DEPT

  

  PRI Baseline Prior DEPT

  

  Case Queue Prior DEPT

  

  Case Backlog Prior DEPT

  

  Case Baseline Prior DEPT

  • Projected Data Items
  • Business Unit
  • Department Name
  • VERSION DATE
  • Measure
  • Measure Category
  • Measure Category Sort

  Data Items

  6

  Business Unit	[Union5].[Business Unit]
  Department Name	[Union5].[Department Name]
  VERSION DATE	[Union5].[VERSION DATE]
  Measure	[Union5].[Measure]	Aggregate total
  Measure Category	[Union5].[Measure Category]
  Measure Category Sort	[Union5].[Measure Category Sort]

• 

  

  Baseline POD

  

  

  PRI Queue Baseline POD

  

  PRI Backlog Baseline POD

  

  PRI Baseline Baseline POD

  

  Case Queue Baseline POD

  

  Case Backlog Baseline POD

  

  Case Baseline Baseline POD

  • Projected Data Items
  • VERSION DATE
  • Measure
  • Measure Category

  Data Items

  3

  VERSION DATE	[Union2].[VERSION DATE]
  Measure	[Union2].[Measure]	Aggregate total
  Measure Category	[Union2].[Measure Category]

• 

  

  Baseline DEPT

  

  

  PRI Queue Baseline DEPT

  

  PRI Backlog Baseline DEPT

  

  PRI Baseline Baseline DEPT

  

  Case Queue Baseline DEPT

  

  Case Backlog Baseline DEPT

  

  Case Baseline Baseline DEPT

  • Projected Data Items
  • Business Unit
  • Department Name
  • VERSION DATE
  • Measure
  • Measure Category

  Data Items

  5

  Business Unit	[Union4].[Business Unit]
  Department Name	[Union4].[Department Name]
  VERSION DATE	[Union4].[VERSION DATE]
  Measure	[Union4].[Measure]
  Measure Category	[Union4].[Measure Category]

• 

  

  Pod and Pay Dates - One Line

  • queryHints
  • crossProductAllowed: allow

  Data Items

  7

  POD_NO	[Presentation].[VW_CMT_POD_LOOKUP].[POD_NO]
  POD_NAME_EN	[Presentation].[VW_CMT_POD_LOOKUP].[POD_NAME_EN]
  POD_NAME_FR	[Presentation].[VW_CMT_POD_LOOKUP].[POD_NAME_FR]
  POD_START_DT	[Presentation].[VW_CMT_POD_LOOKUP].[POD_START_DT]
  Period Start	[Pay Period Dates].[Pay Period Start Date]
  Period End	[Pay Period Dates].[Pay Period End Date]
  Prior End	cast(_add_days([Pay Period Dates].[Pay Period End Date], -14), date)

  • Detail Filters
    1
  • 

    [POD_NO]=?POD?
    
• 

  

  Depts in POD

  Data Items

  2

  POD_NO	[Presentation].[VW_CMT_POD_LOOKUP].[POD_NO]
  DEPT_CODE	[Presentation].[VW_CMT_POD_LOOKUP].[DEPT_CODE]

  • Detail Filters
    1
  • 

    [Presentation].[VW_CMT_POD_LOOKUP].[POD_NO] = ?POD?
    
• 

  

  Pay Period Dates

  Data Items

  2

  Pay Period Start Date	cast([Presentation].[VW_STG_PAY_PERIOD_CALENDAR].[PAY_PERIOD_START_DATE], date)	Aggregate maximum
  Pay Period End Date	cast(_add_hours ( [Presentation].[VW_STG_PAY_PERIOD_CALENDAR].[PAY_PERIOD_END_DATE], -5 ), date)	Aggregate maximum sort descending

  • Detail Filters
    1
  • 

    [Pay Period End Date] < current_date
    
• 

  

  PRI Queue Current POD

  • queryHints
  • crossProductAllowed: allow

  Data Items

  4

  VERSION DATE	cast( [Pod and Pay Dates - One Line].[Period End], date)
  Measure	[Presentation].[Case].[PRI]	Aggregate countDistinct Rollup summarize
  Measure Category	if ( #sq($runLocale)# <>'fr' ) then ( 'Pod Queue (affected PRIs)' ) else ( 'File d’attente (CIDP touchés)' )
  Measure Category Sort	2

  • Detail Filters
    3
  • 

    ?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]
    
  • 

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

    [Presentation].[VW_CMT_POD_LOOKUP].[POD_NO] = ?POD?
    
• 

  

  PRI Backlog Current POD

  • queryHints
  • crossProductAllowed: allow

  Data Items

  4

  VERSION DATE	[Pod and Pay Dates - One Line].[Period End]
  Measure	[Presentation].[Case].[PRI]	Aggregate countDistinct Rollup summarize
  Measure Category	if ( #sq($runLocale)# <>'fr' ) then ( 'Pod Backlog (affected PRIs)' ) else ( 'Arriéré (CIDP touchés)' )
  Measure Category Sort	4

  • Detail Filters
    3
  • 

    ?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]
    
  • 

    [Presentation].[State].[NAME] not in ('Bring_Forward', 'Cancelled', 'Closed')
    and
    (
    [Presentation].[Case].[CMT_AGE] >[Presentation].[Sub Type].[SERVICE_STANDARD]
    or
    [Presentation].[Case].[PROCESSING_CENTRE] contains [Presentation].[VW_CMT_POD_LOOKUP].[POD_TAG]
    )
    
  • 

    [Presentation].[VW_CMT_POD_LOOKUP].[POD_NO] = ?POD?
    
• 

  

  PRI Baseline Current POD

  • queryHints
  • crossProductAllowed: allow

  Data Items

  4

  VERSION DATE	[Pod and Pay Dates - One Line].[Period End]
  Measure	[Presentation].[Case].[PRI]	Aggregate countDistinct Rollup summarize
  Measure Category	if ( #sq($runLocale)# <>'fr' ) then ( 'Pod Baseline (affected PRIs)' ) else ( 'Référence (CIDP touchés)' )
  Measure Category Sort	6

  • Detail Filters
    3
  • 

    ?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]
    
  • 

    [Presentation].[State].[NAME] not in ('Bring_Forward', 'Cancelled', 'Closed')
    and
    [Presentation].[Case].[PROCESSING_CENTRE] contains [Presentation].[VW_CMT_POD_LOOKUP].[POD_TAG]
    
  • 

    [Presentation].[VW_CMT_POD_LOOKUP].[POD_NO] = ?POD?
    
• 

  

  PRI Queue Prior POD

  • queryHints
  • crossProductAllowed: allow

  Data Items

  4

  VERSION DATE	_add_days([Pod and Pay Dates - One Line].[Period Start], -1)
  Measure	[Presentation].[VW_CMT_LAST_PAY_PERIOD_TICKET].[PRI]	Aggregate countDistinct Rollup summarize
  Measure Category	if ( #sq($runLocale)# <>'fr' ) then ( 'Pod Queue (affected PRIs)' ) else ( 'File d’attente (CIDP touchés)' )
  Measure Category Sort	2

  • Detail Filters
    2
  • 

    [Presentation].[VW_CMT_LAST_PAY_PERIOD_TICKET].[pl_POD_NO] = ?POD?
    
  • 

    [Presentation].[VW_CMT_LAST_PAY_PERIOD_TICKET].[sd_NAME] not in ('Bring_Forward', 'Cancelled', 'Closed')
    
• 

  

  PRI Backlog Prior POD

  • queryHints
  • crossProductAllowed: allow

  Data Items

  4

  VERSION DATE	_add_days([Pod and Pay Dates - One Line].[Period Start], -1)
  Measure	[Presentation].[VW_CMT_LAST_PAY_PERIOD_TICKET].[PRI]	Aggregate countDistinct Rollup summarize
  Measure Category	if ( #sq($runLocale)# <>'fr' ) then ( 'Pod Backlog (affected PRIs)' ) else ( 'Arriéré (CIDP touchés)' )
  Measure Category Sort	4

  • Detail Filters
    2
  • 

    [Presentation].[VW_CMT_LAST_PAY_PERIOD_TICKET].[pl_POD_NO] = ?POD?
    
  • 

    [Presentation].[VW_CMT_LAST_PAY_PERIOD_TICKET].[sd_NAME] not in ('Bring_Forward', 'Cancelled', 'Closed')
    and
    (
    [Presentation].[VW_CMT_LAST_PAY_PERIOD_TICKET].[CMT_AGE] >[Presentation].[VW_CMT_LAST_PAY_PERIOD_TICKET].[lt_VALUE_EN]
    or
    [Presentation].[VW_CMT_LAST_PAY_PERIOD_TICKET].[PROCESSING_CENTRE] contains [Presentation].[VW_CMT_LAST_PAY_PERIOD_TICKET].[pl_POD_TAG]
    )
    
• 

  

  PRI Baseline Prior POD

  • queryHints
  • crossProductAllowed: allow

  Data Items

  4

  VERSION DATE	_add_days([Pod and Pay Dates - One Line].[Period Start], -1)
  Measure	[Presentation].[VW_CMT_LAST_PAY_PERIOD_TICKET].[PRI]	Aggregate countDistinct Rollup summarize
  Measure Category	if ( #sq($runLocale)# <>'fr' ) then ( 'Pod Baseline (affected PRIs)' ) else ( 'Référence (CIDP touchés)' )
  Measure Category Sort	6

  • Detail Filters
    2
  • 

    [Presentation].[VW_CMT_LAST_PAY_PERIOD_TICKET].[pl_POD_NO] = ?POD?
    
  • 

    [Presentation].[VW_CMT_LAST_PAY_PERIOD_TICKET].[sd_NAME] not in ('Bring_Forward', 'Cancelled', 'Closed')
    and
    [Presentation].[VW_CMT_LAST_PAY_PERIOD_TICKET].[PROCESSING_CENTRE] contains [Presentation].[VW_CMT_LAST_PAY_PERIOD_TICKET].[pl_POD_TAG]
    
• 

  

  PRI Queue Baseline POD

  • queryHints
  • crossProductAllowed: allow

  Data Items

  3

  VERSION DATE	[Pod and Pay Dates - One Line].[POD_START_DT]
  Measure	[Presentation].[VW_CMT_POD_LOOKUP].[BASELINE_POD_PRI_CNT]	Rollup summarize
  Measure Category	if ( #sq($runLocale)# <>'fr' ) then ( 'Pod Queue (affected PRIs)' ) else ( 'File d’attente (CIDP touchés)' )

  • Detail Filters
    1
  • 

    [Presentation].[VW_CMT_POD_LOOKUP].[POD_NO] = ?POD?
    
• 

  

  PRI Backlog Baseline POD

  • queryHints
  • crossProductAllowed: allow

  Data Items

  3

  VERSION DATE	[Pod and Pay Dates - One Line].[POD_START_DT]
  Measure	[Presentation].[VW_CMT_POD_LOOKUP].[BASELINE_POD_PRI_CNT]	Rollup summarize
  Measure Category	if ( #sq($runLocale)# <>'fr' ) then ( 'Pod Backlog (affected PRIs)' ) else ( 'Arriéré (CIDP touchés)' )

  • Detail Filters
    1
  • 

    [Presentation].[VW_CMT_POD_LOOKUP].[POD_NO] = ?POD?
    
• 

  

  PRI Baseline Baseline POD

  • queryHints
  • crossProductAllowed: allow

  Data Items

  3

  VERSION DATE	[Pod and Pay Dates - One Line].[POD_START_DT]
  Measure	[Presentation].[VW_CMT_POD_LOOKUP].[BASELINE_POD_PRI_CNT]	Rollup summarize
  Measure Category	if ( #sq($runLocale)# <>'fr' ) then ( 'Pod Baseline (affected PRIs)' ) else ( 'Référence (CIDP touchés)' )

  • Detail Filters
    1
  • 

    [Presentation].[VW_CMT_POD_LOOKUP].[POD_NO] = ?POD?
    
• 

  

  Case Queue Current POD

  • queryHints
  • crossProductAllowed: allow

  Data Items

  4

  VERSION DATE	cast( [Pod and Pay Dates - One Line].[Period End], date)
  Measure	[Presentation].[Case].[ID]	Aggregate count Rollup total
  Measure Category	if ( #sq($runLocale)# <>'fr' ) then ( 'Pod Queue (# cases)' ) else ( 'File d’attente (nombre de cas)' )
  Measure Category Sort	1

  • Detail Filters
    3
  • 

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

    ?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]
    
  • 

    [Presentation].[VW_CMT_POD_LOOKUP].[POD_NO] = ?POD?
    
• 

  

  Case Backlog Current POD

  • queryHints
  • crossProductAllowed: allow

  Data Items

  4

  VERSION DATE	[Pod and Pay Dates - One Line].[Period End]
  Measure	[Presentation].[Case].[ID]	Aggregate count Rollup total
  Measure Category	if ( #sq($runLocale)# <>'fr' ) then ( 'Pod Backlog (# cases)' ) else ( 'Arriéré (nombre de cas)' )
  Measure Category Sort	3

  • Detail Filters
    3
  • 

    [Presentation].[State].[NAME] not in ('Bring_Forward', 'Cancelled', 'Closed')
    and
    (
    [Presentation].[Case].[CMT_AGE] >[Presentation].[Sub Type].[SERVICE_STANDARD]
    or
    [Presentation].[Case].[PROCESSING_CENTRE] contains [Presentation].[VW_CMT_POD_LOOKUP].[POD_TAG]
    )
    
  • 

    ?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]
    
  • 

    [Presentation].[VW_CMT_POD_LOOKUP].[POD_NO] = ?POD?
    
• 

  

  Case Baseline Current POD

  • queryHints
  • crossProductAllowed: allow

  Data Items

  4

  VERSION DATE	[Pod and Pay Dates - One Line].[Period End]
  Measure	[Presentation].[Case].[ID]	Aggregate count Rollup total
  Measure Category	if ( #sq($runLocale)# <>'fr' ) then ( 'Pod Baseline (# cases)' ) else ( 'Référence (nombre de cas)' )
  Measure Category Sort	5

  • Detail Filters
    3
  • 

    [Presentation].[State].[NAME] not in ('Bring_Forward', 'Cancelled', 'Closed')
    and
    [Presentation].[Case].[PROCESSING_CENTRE] contains [Presentation].[VW_CMT_POD_LOOKUP].[POD_TAG]
    
  • 

    ?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]
    
  • 

    [Presentation].[VW_CMT_POD_LOOKUP].[POD_NO] = ?POD?
    
• 

  

  Case Queue Baseline POD

  • queryHints
  • crossProductAllowed: allow

  Data Items

  3

  VERSION DATE	[Presentation].[VW_CMT_POD_LOOKUP].[POD_START_DT]
  Measure	[Presentation].[VW_CMT_POD_LOOKUP].[BASELINE_POD_CASE_CNT]	Rollup total
  Measure Category	if ( #sq($runLocale)# <>'fr' ) then ( 'Pod Queue (# cases)' ) else ( 'File d’attente (nombre de cas)' )

  • Detail Filters
    1
  • 

    [Presentation].[VW_CMT_POD_LOOKUP].[POD_NO] = ?POD?
    
• 

  

  Case Backlog Baseline POD

  • queryHints
  • crossProductAllowed: allow

  Data Items

  3

  VERSION DATE	[Presentation].[VW_CMT_POD_LOOKUP].[POD_START_DT]
  Measure	[Presentation].[VW_CMT_POD_LOOKUP].[BASELINE_POD_CASE_CNT]	Rollup total
  Measure Category	if ( #sq($runLocale)# <>'fr' ) then ( 'Pod Backlog (# cases)' ) else ('Arriéré (nombre de cas)')

  • Detail Filters
    1
  • 

    [Presentation].[VW_CMT_POD_LOOKUP].[POD_NO] = ?POD?
    
• 

  

  Case Baseline Baseline POD

  • queryHints
  • crossProductAllowed: allow

  Data Items

  3

  VERSION DATE	[Presentation].[VW_CMT_POD_LOOKUP].[POD_START_DT]
  Measure	[Presentation].[VW_CMT_POD_LOOKUP].[BASELINE_POD_CASE_CNT]	Rollup total
  Measure Category	if ( #sq($runLocale)# <>'fr' ) then ( 'Pod Baseline (# cases)' ) else ('Référence (nombre de cas)')

  • Detail Filters
    1
  • 

    [Presentation].[VW_CMT_POD_LOOKUP].[POD_NO] = ?POD?
    
• 

  

  Case Queue Prior POD

  • queryHints
  • crossProductAllowed: allow

  Data Items

  4

  VERSION DATE	_add_days([Pod and Pay Dates - One Line].[Period Start], -1)
  Measure	[Presentation].[VW_CMT_LAST_PAY_PERIOD_TICKET].[ID]	Aggregate count Rollup total
  Measure Category	if ( #sq($runLocale)# <>'fr' ) then ( 'Pod Queue (# cases)' ) else ( 'File d’attente (nombre de cas)' )
  Measure Category Sort	1

  • Detail Filters
    2
  • 

    [Presentation].[VW_CMT_LAST_PAY_PERIOD_TICKET].[pl_POD_NO] = ?POD?
    
  • 

    [Presentation].[VW_CMT_LAST_PAY_PERIOD_TICKET].[sd_NAME] not in ('Bring_Forward', 'Cancelled', 'Closed')
    
• 

  

  Case Backlog Prior POD

  • queryHints
  • crossProductAllowed: allow

  Data Items

  4

  VERSION DATE	_add_days([Pod and Pay Dates - One Line].[Period Start], -1)
  Measure	[Presentation].[VW_CMT_LAST_PAY_PERIOD_TICKET].[ID]	Aggregate count Rollup total
  Measure Category	if ( #sq($runLocale)# <>'fr' ) then ( 'Pod Backlog (# cases)' ) else ( 'Arriéré (nombre de cas)' )
  Measure Category Sort	3

  • Detail Filters
    2
  • 

    [Presentation].[VW_CMT_LAST_PAY_PERIOD_TICKET].[pl_POD_NO] = ?POD?
    
  • 

    [Presentation].[VW_CMT_LAST_PAY_PERIOD_TICKET].[sd_NAME] not in ('Bring_Forward', 'Cancelled', 'Closed')
    and
    (
    [Presentation].[VW_CMT_LAST_PAY_PERIOD_TICKET].[CMT_AGE] >[Presentation].[VW_CMT_LAST_PAY_PERIOD_TICKET].[lt_VALUE_EN]
    or
    [Presentation].[VW_CMT_LAST_PAY_PERIOD_TICKET].[PROCESSING_CENTRE] contains [Presentation].[VW_CMT_LAST_PAY_PERIOD_TICKET].[pl_POD_TAG]
    )
    
• 

  

  Case Baseline Prior POD

  • queryHints
  • crossProductAllowed: allow

  Data Items

  4

  VERSION DATE	_add_days([Pod and Pay Dates - One Line].[Period Start], -1)
  Measure	[Presentation].[VW_CMT_LAST_PAY_PERIOD_TICKET].[ID]	Aggregate count Rollup total
  Measure Category	if ( #sq($runLocale)# <>'fr' ) then ( 'Pod Baseline (# cases)' ) else ( 'Référence (nombre de cas)' )
  Measure Category Sort	5

  • Detail Filters
    2
  • 

    [Presentation].[VW_CMT_LAST_PAY_PERIOD_TICKET].[pl_POD_NO] = ?POD?
    
  • 

    [Presentation].[VW_CMT_LAST_PAY_PERIOD_TICKET].[sd_NAME] not in ('Bring_Forward', 'Cancelled', 'Closed')
    and
    [Presentation].[VW_CMT_LAST_PAY_PERIOD_TICKET].[PROCESSING_CENTRE] contains [Presentation].[VW_CMT_LAST_PAY_PERIOD_TICKET].[pl_POD_TAG]
    
• 

  

  PRI Queue Current DEPT

  • queryHints
  • crossProductAllowed: allow

  Data Items

  6

  Business Unit	[Presentation].[VW_STG_DEPARTMENT].[CODE]
  Department Name	[Presentation].[VW_STG_DEPARTMENT].[NAME_1]
  VERSION DATE	[Pod and Pay Dates - One Line].[Period End]
  Measure	[Presentation].[Case].[PRI]	Aggregate countDistinct Rollup summarize
  Measure Category	if ( #sq($runLocale)# <>'fr' ) then ( [Business Unit]+' Queue (affected PRIs)' ) else ( [Business Unit]+' - file d’attente (CIDP touchés)' )
  Measure Category Sort	2

  • Detail Filters
    3
  • 

    ?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]
    
  • 

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

    [Business Unit] = ?Dept?
    
• 

  

  PRI Backlog Current DEPT

  • queryHints
  • crossProductAllowed: allow

  Data Items

  6

  Business Unit	[Presentation].[VW_STG_DEPARTMENT].[CODE]
  Department Name	[Presentation].[VW_STG_DEPARTMENT].[NAME_1]
  VERSION DATE	[Pod and Pay Dates - One Line].[Period End]
  Measure	[Presentation].[Case].[PRI]	Aggregate countDistinct Rollup summarize
  Measure Category	if ( #sq($runLocale)# <>'fr' ) then ( [Business Unit]+' Backlog (affected PRIs)' ) else ( [Business Unit]+' - arriéré (CIDP touchés)' )
  Measure Category Sort	4

  • Detail Filters
    3
  • 

    ?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]
    
  • 

    [Presentation].[State].[NAME] not in ('Bring_Forward', 'Cancelled', 'Closed')
    and
    (
    [Presentation].[Case].[CMT_AGE] >[Presentation].[Sub Type].[SERVICE_STANDARD]
    or
    [Presentation].[Case].[PROCESSING_CENTRE] contains [Presentation].[VW_CMT_POD_LOOKUP].[POD_TAG]
    )
    
  • 

    [Business Unit] = ?Dept?
    
• 

  

  PRI Baseline Current DEPT

  • queryHints
  • crossProductAllowed: allow

  Data Items

  6

  Business Unit	[Presentation].[VW_STG_DEPARTMENT].[CODE]
  Department Name	[Presentation].[VW_STG_DEPARTMENT].[NAME_1]
  VERSION DATE	[Pod and Pay Dates - One Line].[Period End]
  Measure	[Presentation].[Case].[PRI]	Aggregate countDistinct Rollup summarize
  Measure Category	if ( #sq($runLocale)# <>'fr' ) then ( [Business Unit]+' Baseline (affected PRIs)' ) else ( [Business Unit]+' - référence (CIDP touchés)' )
  Measure Category Sort	6

  • Detail Filters
    3
  • 

    ?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]
    
  • 

    [Presentation].[State].[NAME] not in ('Bring_Forward', 'Cancelled', 'Closed')
    and
    [Presentation].[Case].[PROCESSING_CENTRE] contains [Presentation].[VW_CMT_POD_LOOKUP].[POD_TAG]
    
  • 

    [Business Unit] = ?Dept?
    
• 

  

  PRI Queue Prior DEPT

  • queryHints
  • crossProductAllowed: allow

  Data Items

  6

  Business Unit	[Presentation].[VW_CMT_LAST_PAY_PERIOD_TICKET].[CODE]
  Department Name	[Presentation].[VW_CMT_LAST_PAY_PERIOD_TICKET].[NAME_1]
  VERSION DATE	_add_days([Pod and Pay Dates - One Line].[Period Start], -1)
  Measure	[Presentation].[VW_CMT_LAST_PAY_PERIOD_TICKET].[PRI]	Aggregate countDistinct Rollup summarize
  Measure Category	if ( #sq($runLocale)# <>'fr' ) then ( [Business Unit]+' Queue (affected PRIs)' ) else ( [Business Unit]+' - file d’attente (CIDP touchés)' )
  Measure Category Sort	2

  • Detail Filters
    3
  • 

    [Presentation].[VW_CMT_LAST_PAY_PERIOD_TICKET].[pl_POD_NO]=?POD?
    
  • 

    [Presentation].[VW_CMT_LAST_PAY_PERIOD_TICKET].[sd_NAME] not in ('Bring_Forward', 'Cancelled', 'Closed')
    
  • 

    [Business Unit] = ?Dept?
    
• 

  

  PRI Backlog Prior DEPT

  • queryHints
  • crossProductAllowed: allow

  Data Items

  6

  Business Unit	[Presentation].[VW_CMT_LAST_PAY_PERIOD_TICKET].[CODE]
  Department Name	[Presentation].[VW_CMT_LAST_PAY_PERIOD_TICKET].[NAME_1]
  VERSION DATE	_add_days([Pod and Pay Dates - One Line].[Period Start], -1)
  Measure	[Presentation].[VW_CMT_LAST_PAY_PERIOD_TICKET].[PRI]	Aggregate countDistinct Rollup summarize
  Measure Category	if ( #sq($runLocale)# <>'fr' ) then ( [Business Unit]+' Backlog (affected PRIs)' ) else ( [Business Unit]+' - arriéré (CIDP touchés)' )
  Measure Category Sort	4

  • Detail Filters
    3
  • 

    [Presentation].[VW_CMT_LAST_PAY_PERIOD_TICKET].[pl_POD_NO]=?POD?
    
  • 

    [Presentation].[VW_CMT_LAST_PAY_PERIOD_TICKET].[sd_NAME] not in ('Bring_Forward', 'Cancelled', 'Closed')
    and
    (
    [Presentation].[VW_CMT_LAST_PAY_PERIOD_TICKET].[CMT_AGE] >[Presentation].[VW_CMT_LAST_PAY_PERIOD_TICKET].[lt_VALUE_EN]
    or
    [Presentation].[VW_CMT_LAST_PAY_PERIOD_TICKET].[PROCESSING_CENTRE] contains [Presentation].[VW_CMT_LAST_PAY_PERIOD_TICKET].[pl_POD_TAG]
    )
    
  • 

    [Business Unit] = ?Dept?
    
• 

  

  PRI Baseline Prior DEPT

  • queryHints
  • crossProductAllowed: allow

  Data Items

  6

  Business Unit	[Presentation].[VW_CMT_LAST_PAY_PERIOD_TICKET].[CODE]
  Department Name	[Presentation].[VW_CMT_LAST_PAY_PERIOD_TICKET].[NAME_1]
  VERSION DATE	_add_days([Pod and Pay Dates - One Line].[Period Start], -1)
  Measure	[Presentation].[VW_CMT_LAST_PAY_PERIOD_TICKET].[PRI]	Aggregate countDistinct Rollup summarize
  Measure Category	if ( #sq($runLocale)# <>'fr' ) then ( [Business Unit]+' Baseline (affected PRIs)' ) else ( [Business Unit]+' - référence (CIDP touchés)' )
  Measure Category Sort	6

  • Detail Filters
    3
  • 

    [Presentation].[VW_CMT_LAST_PAY_PERIOD_TICKET].[pl_POD_NO]=?POD?
    
  • 

    [Presentation].[VW_CMT_LAST_PAY_PERIOD_TICKET].[sd_NAME] not in ('Bring_Forward', 'Cancelled', 'Closed')
    and
    [Presentation].[VW_CMT_LAST_PAY_PERIOD_TICKET].[PROCESSING_CENTRE] contains [Presentation].[VW_CMT_LAST_PAY_PERIOD_TICKET].[pl_POD_TAG]
    
  • 

    [Business Unit] = ?Dept?
    
• 

  

  PRI Queue Baseline DEPT

  • queryHints
  • crossProductAllowed: allow

  Data Items

  5

  Business Unit	[Presentation].[VW_STG_DEPARTMENT].[CODE]
  Department Name	[Presentation].[VW_STG_DEPARTMENT].[NAME_1]
  VERSION DATE	[Pod and Pay Dates - One Line].[POD_START_DT]
  Measure	[Presentation].[VW_CMT_POD_LOOKUP].[BASELINE_DEPT_PRI_CNT]	Rollup summarize
  Measure Category	if ( #sq($runLocale)# <>'fr' ) then ( [Business Unit]+' Queue (affected PRIs)' ) else ( [Business Unit]+' - file d’attente (CIDP touchés)' )

  • Detail Filters
    2
  • 

    [Presentation].[VW_CMT_POD_LOOKUP].[POD_NO] = ?POD?
    
  • 

    [Business Unit] = ?Dept?
    
• 

  

  PRI Backlog Baseline DEPT

  • queryHints
  • crossProductAllowed: allow

  Data Items

  5

  Business Unit	[Presentation].[VW_STG_DEPARTMENT].[CODE]
  Department Name	[Presentation].[VW_STG_DEPARTMENT].[NAME_1]
  VERSION DATE	[Pod and Pay Dates - One Line].[POD_START_DT]
  Measure	[Presentation].[VW_CMT_POD_LOOKUP].[BASELINE_DEPT_PRI_CNT]	Rollup summarize
  Measure Category	if ( #sq($runLocale)# <>'fr' ) then ( [Business Unit]+' Backlog (affected PRIs)' ) else ( [Business Unit]+' - arriéré (CIDP touchés)' )

  • Detail Filters
    2
  • 

    [Presentation].[VW_CMT_POD_LOOKUP].[POD_NO] = ?POD?
    
  • 

    [Business Unit] = ?Dept?
    
• 

  

  PRI Baseline Baseline DEPT

  • queryHints
  • crossProductAllowed: allow

  Data Items

  5

  Business Unit	[Presentation].[VW_STG_DEPARTMENT].[CODE]
  Department Name	[Presentation].[VW_STG_DEPARTMENT].[NAME_1]
  VERSION DATE	[Pod and Pay Dates - One Line].[POD_START_DT]
  Measure	[Presentation].[VW_CMT_POD_LOOKUP].[BASELINE_DEPT_PRI_CNT]	Rollup summarize
  Measure Category	if ( #sq($runLocale)# <>'fr' ) then ( [Business Unit]+' Baseline (affected PRIs)' ) else ( [Business Unit]+' - référence (CIDP touchés)' )

  • Detail Filters
    2
  • 

    [Presentation].[VW_CMT_POD_LOOKUP].[POD_NO] = ?POD?
    
  • 

    [Business Unit] = ?Dept?
    
• 

  

  Case Queue Current DEPT

  • queryHints
  • crossProductAllowed: allow

  Data Items

  6

  DEPARTMENT CODE	[Presentation].[VW_STG_DEPARTMENT].[CODE]
  DEPARTMENT NAME	[Presentation].[VW_STG_DEPARTMENT].[NAME_1]
  VERSION DATE	[Pod and Pay Dates - One Line].[Period End]
  Measure	[Presentation].[Case].[ID]	Aggregate count Rollup total
  Measure Category	if ( #sq($runLocale)# <>'fr' ) then ( [DEPARTMENT CODE]+' Queue (# cases)' ) else ( [DEPARTMENT CODE]+' - file d’attente (nombre de cas)' )
  Measure Category Sort	1

  • Detail Filters
    3
  • 

    ?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]
    
  • 

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

    [DEPARTMENT CODE] = ?Dept?
    
• 

  

  Case Backlog Current DEPT

  • queryHints
  • crossProductAllowed: allow

  Data Items

  6

  DEPARTMENT CODE	[Presentation].[VW_STG_DEPARTMENT].[CODE]
  DEPARTMENT NAME	[Presentation].[VW_STG_DEPARTMENT].[NAME_1]
  VERSION DATE	[Pod and Pay Dates - One Line].[Period End]
  Measure	[Presentation].[Case].[ID]	Aggregate count Rollup total
  Measure Category	if ( #sq($runLocale)# <>'fr' ) then ( [DEPARTMENT CODE]+' Backlog (# cases)' ) else ( [DEPARTMENT CODE]+' - arriéré (nombre de cas)' )
  Measure Category Sort	3

  • Detail Filters
    3
  • 

    ?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]
    
  • 

    [Presentation].[State].[NAME] not in ('Bring_Forward', 'Cancelled', 'Closed')
    and
    (
    [Presentation].[Case].[CMT_AGE] >[Presentation].[Sub Type].[SERVICE_STANDARD]
    or
    [Presentation].[Case].[PROCESSING_CENTRE] contains [Presentation].[VW_CMT_POD_LOOKUP].[POD_TAG]
    )
    
  • 

    [DEPARTMENT CODE] = ?Dept?
    
• 

  

  Case Baseline Current DEPT

  • queryHints
  • crossProductAllowed: allow

  Data Items

  6

  DEPARTMENT CODE	[Presentation].[VW_STG_DEPARTMENT].[CODE]
  DEPARTMENT NAME	[Presentation].[VW_STG_DEPARTMENT].[NAME_1]
  VERSION DATE	[Pod and Pay Dates - One Line].[Period End]
  Measure	[Presentation].[Case].[ID]	Aggregate count Rollup total
  Measure Category	if ( #sq($runLocale)# <>'fr' ) then ( [DEPARTMENT CODE]+' Baseline (# cases)' ) else ( [DEPARTMENT CODE]+' - référence (nombre de cas)' )
  Measure Category Sort	5

  • Detail Filters
    3
  • 

    ?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]
    
  • 

    [Presentation].[State].[NAME] not in ('Bring_Forward', 'Cancelled', 'Closed')
    and
    [Presentation].[Case].[PROCESSING_CENTRE] contains [Presentation].[VW_CMT_POD_LOOKUP].[POD_TAG]
    
  • 

    [DEPARTMENT CODE] = ?Dept?
    
• 

  

  Case Queue Baseline DEPT

  • queryHints
  • crossProductAllowed: allow

  Data Items

  5

  DEPARTMENT CODE	[Presentation].[VW_CMT_POD_LOOKUP].[DEPT_CODE]
  DEPARTMENT NAME	[Presentation].[VW_STG_DEPARTMENT].[NAME_1]
  VERSION DATE	[Pod and Pay Dates - One Line].[POD_START_DT]
  Measure	[Presentation].[VW_CMT_POD_LOOKUP].[BASELINE_DEPT_CASE_CNT]	Rollup total
  Measure Category	if ( #sq($runLocale)# <>'fr' ) then ( [DEPARTMENT CODE]+' Queue (# cases)' ) else ( [DEPARTMENT CODE]+' - file d’attente (nombre de cas)' )

  • Detail Filters
    3
  • 

    [Presentation].[Department].[DEPARTMENT_CODE]=[Presentation].[Pod Lookup].[DEPT_CODE]
    
  • 

    [Presentation].[VW_CMT_POD_LOOKUP].[POD_NO] = ?POD?
    
  • 

    [DEPARTMENT CODE] = ?Dept?
    
• 

  

  Case Backlog Baseline DEPT

  • queryHints
  • crossProductAllowed: allow

  Data Items

  5

  DEPARTMENT CODE	[Presentation].[VW_CMT_POD_LOOKUP].[DEPT_CODE]
  DEPARTMENT NAME	[Presentation].[VW_STG_DEPARTMENT].[NAME_1]
  VERSION DATE	[Pod and Pay Dates - One Line].[POD_START_DT]
  Measure	[Presentation].[VW_CMT_POD_LOOKUP].[BASELINE_DEPT_CASE_CNT]	Rollup total
  Measure Category	if ( #sq($runLocale)# <>'fr' ) then ( [DEPARTMENT CODE]+' Backlog (# cases)' ) else ( [DEPARTMENT CODE]+' - arriéré (nombre de cas)' )

  • Detail Filters
    3
  • 

    [Presentation].[VW_STG_DEPARTMENT].[CODE]=[Presentation].[VW_CMT_POD_LOOKUP].[DEPT_CODE]
    
  • 

    [Presentation].[VW_CMT_POD_LOOKUP].[POD_NO] = ?POD?
    
  • 

    [DEPARTMENT CODE] = ?Dept?
    
• 

  

  Case Baseline Baseline DEPT1

  • queryHints
  • crossProductAllowed: allow

  Data Items

  3

  DEPARTMENT CODE	[Presentation].[VW_CMT_POD_LOOKUP].[DEPT_CODE]
  DEPARTMENT NAME	[Presentation].[VW_STG_DEPARTMENT].[NAME_1]
  VERSION DATE	[Pod and Pay Dates - One Line].[POD_START_DT]

  • Detail Filters
    3
  • 

    [Presentation].[VW_STG_DEPARTMENT].[CODE]=[Presentation].[VW_CMT_POD_LOOKUP].[DEPT_CODE]
    
  • 

    [Presentation].[VW_CMT_POD_LOOKUP].[POD_NO] = ?POD?
    
  • 

    [DEPARTMENT CODE] = ?Dept?
    
• 

  

  Case Baseline Baseline DEPT

  • queryHints
  • crossProductAllowed: allow

  Data Items

  5

  Business Unit	[Presentation].[VW_STG_DEPARTMENT].[CODE]
  Department Name	[Presentation].[VW_STG_DEPARTMENT].[NAME_1]
  VERSION DATE	[Pod and Pay Dates - One Line].[POD_START_DT]
  Measure	[Presentation].[VW_CMT_POD_LOOKUP].[BASELINE_DEPT_CASE_CNT]	Rollup summarize
  Measure Category	if ( #sq($runLocale)# <>'fr' ) then ( [Business Unit]+' Baseline (# cases)' ) else ([Business Unit]+' - référence (nombre de cas)')

  • Detail Filters
    2
  • 

    [Presentation].[VW_CMT_POD_LOOKUP].[POD_NO] = ?POD?
    
  • 

    [Business Unit] = ?Dept?
    
• 

  

  Case Queue Prior DEPT

  • queryHints
  • crossProductAllowed: allow

  Data Items

  6

  DEPARTMENT CODE	[Presentation].[VW_CMT_LAST_PAY_PERIOD_TICKET].[CODE]
  DEPARTMENT NAME	[Presentation].[VW_CMT_LAST_PAY_PERIOD_TICKET].[NAME_1]
  VERSION DATE	_add_days([Pod and Pay Dates - One Line].[Period Start], -1)
  Measure	[Presentation].[VW_CMT_LAST_PAY_PERIOD_TICKET].[ID]	Aggregate count Rollup total
  Measure Category	if ( #sq($runLocale)# <>'fr' ) then ( [DEPARTMENT CODE]+' Queue (# cases)' ) else ( [DEPARTMENT CODE]+' - file d’attente (nombre de cas)' )
  Measure Category Sort	1

  • Detail Filters
    3
  • 

    [Presentation].[VW_CMT_LAST_PAY_PERIOD_TICKET].[pl_POD_NO]=?POD?
    
  • 

    [Presentation].[VW_CMT_LAST_PAY_PERIOD_TICKET].[sd_NAME] not in ('Bring_Forward', 'Cancelled', 'Closed')
    
  • 

    [DEPARTMENT CODE] = ?Dept?
    
• 

  

  Case Backlog Prior DEPT

  • queryHints
  • crossProductAllowed: allow

  Data Items

  6

  DEPARTMENT CODE	[Presentation].[VW_CMT_LAST_PAY_PERIOD_TICKET].[CODE]
  DEPARTMENT NAME	[Presentation].[VW_CMT_LAST_PAY_PERIOD_TICKET].[NAME_1]
  VERSION DATE	_add_days([Pod and Pay Dates - One Line].[Period Start], -1)
  Measure	[Presentation].[VW_CMT_LAST_PAY_PERIOD_TICKET].[ID]	Aggregate count Rollup total
  Measure Category	if ( #sq($runLocale)# <>'fr' ) then ( [DEPARTMENT CODE]+' Backlog (# cases)' ) else ( [DEPARTMENT CODE]+' - arriéré (nombre de cas)' )
  Measure Category Sort	3

  • Detail Filters
    3
  • 

    [Presentation].[VW_CMT_LAST_PAY_PERIOD_TICKET].[pl_POD_NO] = ?POD?
    
  • 

    [Presentation].[VW_CMT_LAST_PAY_PERIOD_TICKET].[sd_NAME] not in ('Bring_Forward', 'Cancelled', 'Closed')
    and
    (
    [Presentation].[VW_CMT_LAST_PAY_PERIOD_TICKET].[CMT_AGE] >[Presentation].[VW_CMT_LAST_PAY_PERIOD_TICKET].[lt_VALUE_EN]
    or
    [Presentation].[VW_CMT_LAST_PAY_PERIOD_TICKET].[PROCESSING_CENTRE] contains [Presentation].[VW_CMT_LAST_PAY_PERIOD_TICKET].[pl_POD_TAG]
    )
    
  • 

    [DEPARTMENT CODE] = ?Dept?
    
• 

  

  Case Baseline Prior DEPT

  • queryHints
  • crossProductAllowed: allow

  Data Items

  6

  DEPARTMENT CODE	[Presentation].[VW_CMT_LAST_PAY_PERIOD_TICKET].[CODE]
  DEPARTMENT NAME	[Presentation].[VW_CMT_LAST_PAY_PERIOD_TICKET].[NAME_1]
  VERSION DATE	_add_days([Pod and Pay Dates - One Line].[Period Start], -1)
  Measure	[Presentation].[VW_CMT_LAST_PAY_PERIOD_TICKET].[ID]	Aggregate count Rollup total
  Measure Category	if ( #sq($runLocale)# <>'fr' ) then ( [DEPARTMENT CODE]+' Baseline (# cases)' ) else ( [DEPARTMENT CODE]+' - référence (nombre de cas)' )
  Measure Category Sort	5

  • Detail Filters
    3
  • 

    [Presentation].[VW_CMT_LAST_PAY_PERIOD_TICKET].[pl_POD_NO] = ?POD?
    
  • 

    [Presentation].[VW_CMT_LAST_PAY_PERIOD_TICKET].[sd_NAME] not in ('Bring_Forward', 'Cancelled', 'Closed')
    and
    [Presentation].[VW_CMT_LAST_PAY_PERIOD_TICKET].[PROCESSING_CENTRE] contains [Presentation].[VW_CMT_LAST_PAY_PERIOD_TICKET].[pl_POD_TAG]
    
  • 

    [DEPARTMENT CODE] = ?Dept?
    
• 

  

  Dept per POD

  Data Items

  1

  DEPT_CODE	[Presentation].[VW_CMT_POD_LOOKUP].[DEPT_CODE]	Aggregate count

  • Detail Filters
    1
  • 

    [Presentation].[VW_CMT_POD_LOOKUP].[POD_NO] = ?POD?
    
• 

  

  pq_POD

  Data Items

  2

  POD_NO	[Presentation].[VW_CMT_POD_LOOKUP].[POD_NO]
  POD_NO1	[Presentation].[VW_CMT_POD_LOOKUP].[POD_NO]	sort ascending

  • Detail Filters
    1
  • 

    [POD_NO1] is not null
    
• 

  

  pq_Dept

  • queryHints
  • crossProductAllowed: allow

  Data Items

  2

  DEPARTMENT_CODE	[Presentation].[VW_STG_DEPARTMENT].[CODE]
  DEPARTMENT NAME	[Presentation].[VW_STG_DEPARTMENT].[NAME_1]

  • Detail Filters
    1
  • 

    [Presentation].[VW_CMT_POD_LOOKUP].[POD_NO] = ?POD?
    
• 

  

  Dept Label

  Data Items

  1

  Department Name	[Presentation].[VW_STG_DEPARTMENT].[NAME_1]

Layouts