Deployments
UAT_PCR_Deployment
Reports
Report Name: test
Overview

  • Queries: 1

    Layouts: 1

  • Model: /CMT/CMT Deployment/CMT Packages/packageADHOC-CMT-DATA-MART/ name: model
Queries
  • Queries 1
    Expressions:
  • Model: /CMT/CMT Deployment/CMT Packages/packageADHOC-CMT-DATA-MART/ name: model
  • Query
    Query1
    Data Items
    11
    DEPARTMENT_NAME_EN
    [Development].[Department].[DEPARTMENT_NAME_EN]
    COUNT_ASSIGNED
    [Development].[Daily_Snapshot].[COUNT_ASSIGNED]
    Aggregate
    total total
    VER_DATE
    [Development].[Daily_Snapshot].[VER_DATE]
    TRANSACTION_TYPE
    [Development].[Daily_Snapshot].[TRANSACTION_TYPE]
    COUNT_CLOSED
    [Development].[Daily_Snapshot].[COUNT_CLOSED]
    Aggregate
    total total
    COUNT_OPEN_STATE
    [Development].[Daily_Snapshot].[COUNT_OPEN_STATE]
    Aggregate
    total total
    DEPARTMENT
    [Development].[Daily_Snapshot].[DEPARTMENT]
    COUNT_TRANS_IN_SS_GC
    [Development].[Daily_Snapshot].[COUNT_TRANS_IN_SS_GC]
    Aggregate
    total total
    COUNT_INCLUDE_STATES
    [Development].[Daily_Snapshot].[COUNT_INCLUDE_STATES]
    Aggregate
    total total
    Queue
    if ( [Development].[Daily_Snapshot].[WORK_TYPE_CODE] = 'WT-006') then ( 0 )
    else ( [Development].[Daily_Snapshot].[COUNT_ADJUSTED] )
    COUNT_ADJUSTED
    [Development].[Daily_Snapshot].[COUNT_ADJUSTED]
    Aggregate
    total total
    • Detail Filters
      2
    • Required
      [DEPARTMENT_NAME_EN] in ( Public Works and Government Services Canada,)
    • Required
      [VER_DATE] = 2017-06-15T00:00:00.000
Layouts