Deployments
UAT_PCR_Deployment
Reports
Report Name: POD Queue Dynamics
Overview

  • Queries: 5

    Layouts: 1

  • Model: /PCR/PCR Deployment/PCR Packages/packagePCR-RCP/ name: model
Queries
  • Queries 5
    Expressions:
  • Model: /PCR/PCR Deployment/PCR Packages/packagePCR-RCP/ name: model
  • Query
    Pod Selector
    Data Items
    3
    Pod Number
    [Presentation].[Pod Lookup].[POD_NO]
    Department Code
    [Presentation].[Pod Lookup].[DEPT_CODE]
    POD Start Date
    [Presentation].[Pod Lookup].[POD_START_DT]
    • Detail Filters
      1
    • Required
      [Presentation].[Pod Lookup].[POD_NO] = ?POD?
  • Query
    Baseline Query
    • queryHints
    • crossProductAllowed: allow
    Data Items
    6
    Transaction Type
    right( '00'+cast([Presentation].[Sub_Type].[TRANSACTION_TYPE_CODE], varchar(2)),2)+': '+[Presentation].[Sub_Type].[TRANSACTION_TYPE_NAME]
    SUB TYPE CODE
    [Presentation].[Sub_Type].[SUB_TYPE_NAME] +' ( ' + [Presentation].[Sub_Type].[SUB_TYPE_CODE] +' )'
    POD Start Date
    [Presentation].[Daily_Snapshot].[VER_DATE]
    Baseline Queue
    [Presentation].[Daily_Snapshot].[COUNT_SUB_TYPE_TOTAL]-
    [Presentation].[Daily_Snapshot].[COUNT_CANCELLED]-
    [Presentation].[Daily_Snapshot].[COUNT_INVALID] -
    [Presentation].[Daily_Snapshot].[COUNT_BRING_FORWARD] - [Presentation].[Daily_Snapshot].[COUNT_CLOSED]
    Aggregate
    total total
    Baseline Intake
    [Presentation].[Daily_Snapshot].[COUNT_SUB_TYPE_TOTAL] -
    [Presentation].[Daily_Snapshot].[COUNT_BRING_FORWARD] -
    [Presentation].[Daily_Snapshot].[COUNT_INVALID]
    Aggregate
    total total
    Baseline Output
    [Presentation].[Daily_Snapshot].[COUNT_CANCELLED] + [Presentation].[Daily_Snapshot].[COUNT_CLOSED]
    Aggregate
    total total
    • Detail Filters
      3
    • Required
      [Presentation].[Daily_Snapshot].[VER_DATE] = [Pod Selector].[POD Start Date]
    • Required
      [Presentation].[Department].[DEPARTMENT_CODE] = [Pod Selector].[Department Code]
    • Required
      [Presentation].[Work_Type].[WORK_TYPE_CODE] <> 'WT-058'
  • Query
    Comp Date Query
    • queryHints
    • crossProductAllowed: allow
    Data Items
    6
    Transaction Type
    right( '00'+cast([Presentation].[Sub_Type].[TRANSACTION_TYPE_CODE], varchar(2)),2)+': '+[Presentation].[Sub_Type].[TRANSACTION_TYPE_NAME]
    SUB TYPE CODE
    [Presentation].[Sub_Type].[SUB_TYPE_NAME]+' ( '+[Presentation].[Sub_Type].[SUB_TYPE_CODE] +' )'
    Comparison Date
    [Presentation].[Daily_Snapshot].[VER_DATE]
    Comparison Queue
    [Presentation].[Daily_Snapshot].[COUNT_SUB_TYPE_TOTAL]-
    [Presentation].[Daily_Snapshot].[COUNT_CANCELLED]-
    [Presentation].[Daily_Snapshot].[COUNT_INVALID] -
    [Presentation].[Daily_Snapshot].[COUNT_BRING_FORWARD] - [Presentation].[Daily_Snapshot].[COUNT_CLOSED]
    Aggregate
    total total
    Comparison Intake
    [Presentation].[Daily_Snapshot].[COUNT_SUB_TYPE_TOTAL] -
    [Presentation].[Daily_Snapshot].[COUNT_BRING_FORWARD] -
    [Presentation].[Daily_Snapshot].[COUNT_INVALID]
    Aggregate
    total total
    Comparison Output
    [Presentation].[Daily_Snapshot].[COUNT_CANCELLED] + [Presentation].[Daily_Snapshot].[COUNT_CLOSED]
    Aggregate
    total total
    • Detail Filters
      3
    • Required
      [Presentation].[Daily_Snapshot].[VER_DATE] = ?Comparison Date?
    • Required
      [Presentation].[Department].[DEPARTMENT_CODE] = [Pod Selector].[Department Code]
    • Required
      [Presentation].[Work_Type].[WORK_TYPE_CODE] <> 'WT-058'
  • Query
    Comparison
    Join 
    [Comp Date Query].[Transaction Type] = [Baseline Query].[Transaction Type] and
[Comp Date Query].[SUB TYPE CODE] = [Baseline Query].[SUB TYPE CODE]
    refQuery
    Comp Date Query
    0:1
    refQuery
    Baseline Query
    0:1
    Data Items
    11
    Transaction Type
    coalesce( [Comp Date Query].[Transaction Type] ,[Baseline Query].[Transaction Type] )
    SUB TYPE CODE
    coalesce( [Comp Date Query].[SUB TYPE CODE], [Baseline Query].[SUB TYPE CODE] )
    POD Start Date
    [Baseline Query].[POD Start Date]
    Comparison Date
    [Comp Date Query].[Comparison Date]
    Baseline
    coalesce([Baseline Query].[Baseline Queue], 0)
    Aggregate
    total total
    Rollup
    total total
    Intake
    coalesce( [Comp Date Query].[Comparison Intake], 0 ) - coalesce( [Baseline Query].[Baseline Intake], 0 )
    Aggregate
    total total
    Rollup
    total total
    label
    Intake Snapshot
    Output
    coalesce( [Baseline Query].[Baseline Output], 0 ) - coalesce( [Comp Date Query].[Comparison Output], 0 )
    Aggregate
    total total
    Rollup
    total total
    label
    Output Snapshot
    Comparison Queue
    coalesce( [Comp Date Query].[Comparison Queue], 0 )
    Aggregate
    total total
    Rollup
    total total
    label
    Queue on Chosen Date
    Progress
    ([Comparison Queue] / [Baseline])-1
    Aggregate
    calculated calculated
    Rollup
    calculated calculated
    Summary(Transaction Type)
    aggregate(currentMeasure within detail [Transaction Type])
    solveOrder
    1
    label
    Summary
    Summary(SUB TYPE CODE)
    aggregate(currentMeasure within detail [SUB TYPE CODE])
    solveOrder
    1
  • Query
    pq_POD
    Data Items
    1
    POD_NO
    [Presentation].[Pod Lookup].[POD_NO]
Layouts