Deployments
UAT_PCR_Deployment
Reports
Report Name: Dashboard Complete Daily Summary - Work in Progress
Overview

  • Queries: 3

    Layouts: 1

  • Model: /PCR/PCR Deployment/PCR Packages/packagePCR-RCP/ name: model
Queries
  • Queries 3
    Expressions:
  • Model: /PCR/PCR Deployment/PCR Packages/packagePCR-RCP/ name: model
  • Query
    Raw Data Cast List
    Data Items
    24
    Case ID
    [Presentation].[Case].[ID]
    PRI
    [Presentation].[Case].[PRI]
    Department
    [Presentation].[Case].[DEPARTMENT]
    Name
    [Presentation].[Case].[NAME]
    Age
    [Presentation].[Case].[CMT_AGE]
    Transaction Type
    [Presentation].[Sub Type].[TRANSACTION_TYPE]
    Work Type Code
    [Presentation].[Work Type].[WORK_TYPE_CODE]
    Work Type Name
    [Presentation].[Work Type].[NAME]
    Sub Type Code
    [Presentation].[Sub Type].[SUB_TYPE_CODE]
    Sub Type Name
    [Presentation].[Sub Type].[NAME]
    Priority
    [Presentation].[Sub Type].[PRIORITY]
    State Name
    [Presentation].[State].[NAME]
    Date Received
    [Presentation].[Case].[DATE_RECEIVED]
    Date Effective From
    [Presentation].[Case].[DATE_EFFECTIVE_FROM]
    Awaiting Calc
    [Presentation].[Case].[AWAITING_CALC]
    TIME_IN_ASSIGNED_CALC
    [Presentation].[Case].[TIME_IN_ASSIGNED]
    Awaiting Confirm
    [Presentation].[Case].[AWAITING_CONFIRM]
    Time Out Assigned Confirm
    [Presentation].[Case].[TIME_OUT_ASSIGNED]
    Pending Reason
    [Presentation].[Case].[PENDING_REASON]
    Time In Pending
    [Presentation].[Case].[TIME_IN_PENDING]
    Assignee Curr
    [Presentation].[Case].[ASSIGNEE_CURR]
    Group Name
    [Presentation].[VW_STG_GROUPS].[NAME]
    Date Modified
    [Presentation].[Case].[DATE_MODIFIED]
    Date Verified
    [Presentation].[Case].[VERIFIED_DATE]
    • Detail Filters
      2
    • Required
      [Presentation].[Dashboard Completed]
    • Required
      #/* Compensation Advisor FILTER
      JIRA Defect: BICCABC-2176
      By: R. Peters
      Change Details:
      Replaced original hard-coded FILTER Expression
      ie.
      [Group Name] in
      ('Compensation-Advisor-1','Compensation-Advisor-2',
      'Compensation-Advisor-3', 'Compensation-Advisor-4',
      ...
      'Compensation-Advisor-99', 'Compensation-Advisor-100',
      'Compensation-Advisor-OGD')
      With FILTER from package:
      [Presentation].[Compensation Advisor]
      */#
      [Presentation].[Compensation Advisor]

  • Query
    Row Data Case Chart
    Data Items
    12
    Assigned Count
    total(count(Case
    when [Presentation].[State].[NAME] = ('Assigned') then 1
    else null
    end) for [Group Name])
    Group Name
    [Presentation].[VW_STG_GROUPS].[NAME]
    GroupName_Sort
    character_length ([Group Name])
    State Name
    [Presentation].[State].[NAME]
    Open Count
    total(count(Case
    when [Presentation].[State].[NAME] = ('Open')
    then 1
    else null
    end) for [Group Name])
    Pending Count
    total(count(Case
    when [Presentation].[State].[NAME] = ('Pending')
    then 1
    else null
    end) for [Group Name])
    Ready_To_Verify
    total(count(Case
    when [Presentation].[State].[NAME] =('Ready_To_Verify')
    then 1
    else null
    end) for [Group Name])
    Reassigned
    total(count(Case
    when [Presentation].[State].[NAME] = 'Reassigned' then 1
    else null
    end) for [Group Name])
    Verified
    total(count(Case
    when [Presentation].[State].[NAME] = 'Verified' then 1
    else null
    end) for [Group Name])
    Grand Total
    [Assigned Count]+[Open Count]+[Pending Count]+[Ready_To_Verify]+[Reassigned]+[Verified]
    Sorting_Location
    IF ( [Group Name] is null ) THEN
    ( 2 )
    ELSE
    ( 1 )
    Location_Description
    IF ( [Presentation].[VW_STG_GROUPS].[NAME] is null ) THEN
    ( ' { Blank }' )
    ELSE
    ( [Presentation].[VW_STG_GROUPS].[NAME] )
    • Detail Filters
      2
    • Required
      [Presentation].[Dashboard Completed]
    • Required
      #/* Compensation Advisor FILTER
      JIRA Defect: BICCABC-2176
      By: R. Peters
      Change Details:
      Replaced original hard-coded FILTER Expression
      ie.
      [Group Name] in
      ('Compensation-Advisor-1','Compensation-Advisor-2',
      'Compensation-Advisor-3', 'Compensation-Advisor-4',
      ...
      'Compensation-Advisor-99', 'Compensation-Advisor-100',
      'Compensation-Advisor-OGD')
      With FILTER from package:
      [Presentation].[Compensation Advisor]
      */#
      [Presentation].[Compensation Advisor]

  • Query
    Load Last Date Query
    Data Items
    1
    Latest Valid Data Load Date
    [Presentation].[Data Load Archive].[Latest Valid Data Load Date]
Layouts