Queries

• 5
  Expressions:

  

  Data Items

  

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

• 

  

  All Transactions

  • queryHints
  • crossProductAllowed: allow

  Data Items

  9

  Case Number	[Presentation].[Case].[ID]
  TRANSACTION_TYPE	[Presentation].[Sub Type].[TRANSACTION_TYPE]
  Month	cast(year( [Presentation].[Case].[DATE_RECEIVED] ),varchar(4)) + '-'+ right('00'+cast(month( [Presentation].[Case].[DATE_RECEIVED] ),varchar(2)),2)
  Date Received	[Presentation].[Case].[DATE_RECEIVED]
  Date Effective From	[Presentation].[Case].[DATE_EFFECTIVE_FROM]
  Department	[Presentation].[Case].[DEPARTMENT]
  Delayed Flag	if (cast([Presentation].[Case].[DATE_RECEIVED], date)<=cast([Presentation].[Case].[DATE_EFFECTIVE_FROM], date)) then ('On Time') else ('Late')
  Case Count Total	count([Presentation].[Case].[Case Count])	Rollup total
  Total Department Days of Delay	_days_between([Presentation].[Case].[DATE_RECEIVED],[Presentation].[Case].[DATE_EFFECTIVE_FROM])	Aggregate total Rollup average

  • Detail Filters
    7
  • 

    [Presentation].[Case].[DEPARTMENT] in ('AGR', 'AHS', 'CAP', 'CDC', 'CES', 'CGC', 'COP', 'CSD', 'DFO', 'DND', 'DOE', 'DUS', 'DVA', 'ESO', 'EXT', 'FIN', 'GSS', 'IAN', 'ICA', 'IMC', 'IRB', 'JUS', 'NED', 'NFB', 'NHW', 'NPB', 'PCH', 'PCO', 'PEN', 'PPD', 'PSC', 'PSP', 'PXR', 'RCM', 'RSN', 'RTC', 'SIR', 'SVC', 'TBD')
    
  • 

    [Presentation].[Case].[DATE_EFFECTIVE_FROM] between 2017-01-01 and 2022-12-31
    
  • 

    [Presentation].[Sub Type].[SUB_TYPE_CODE] not in ('ST-024', 'ST-037', 'ST-041', 'ST-042', 'ST-050', 'ST-071', 'ST-072', 'ST-082', 'ST-083', 'ST-086', 'ST-089', 'ST-092', 'ST-093', 'ST-094', 'ST-095', 'ST-097', 'ST-098', 'ST-100', 'ST-118', 'ST-121', 'ST-122', 'ST-123', 'ST-124', 'ST-125', 'ST-132', 'ST-147', 'ST-149', 'ST-150', 'ST-153', 'ST-154', 'ST-155', 'ST-161', 'ST-162', 'ST-163', 'ST-167', 'ST-169', 'ST-170', 'ST-171', 'ST-182', 'ST-183', 'ST-188', 'ST-189', 'ST-191', 'ST-192', 'ST-193', 'ST-194', 'ST-195', 'ST-196', 'ST-197', 'ST-198', 'ST-199', 'ST-200', 'ST-201', 'ST-209', 'ST-210', 'ST-211', 'ST-212', 'ST-213', 'ST-214', 'ST-215', 'ST-216', 'ST-217', 'ST-222', 'ST-223', 'ST-224', 'ST-225', 'ST-232', 'ST-233', 'ST-234', 'ST-235', 'ST-236', 'ST-240', 'ST-241', 'ST-247', 'ST-262', 'ST-268', 'ST-269', 'ST-273', 'ST-280', 'ST-306', 'ST-504', 'ST-330', 'ST-505', 'ST-508', 'ST-509', 'ST-517', 'ST-518', 'ST-525', 'ST-526', 'ST-527', 'ST-538', 'ST-540', 'ST-611')
    
  • 

    [Presentation].[Case].[CREATED_BY] = ?Created By?
    
  • 

    (?Department? = 'All' and 1=1)
    or
    [Presentation].[Case].[DEPARTMENT] = ?Department?
    
  • 

    [Presentation].[Sub Type].[TRANSACTION_TYPE] in (?Transaction Type?)
    
  • 

    [Month] = ?Month?
    
• 

  

  pq_Created_By

  Data Items

  1

  CREATED_BY	[Presentation].[Case].[CREATED_BY]

  • Detail Filters
    1
  • 

    [Presentation].[Case].[CREATED_BY] in ( 'CRCD / DCRC', 'Worklist / Liste de travail')
    
• 

  

  pq_Department

  Data Items

  2

  DEPARTMENT	[Presentation].[Case].[DEPARTMENT]
  DEPT_NAME	[DEPARTMENT] +' - '+ [Presentation].[Case].[DEPT_NAME]	sort ascending

  • Detail Filters
    1
  • 

    [Presentation].[Case].[DEPARTMENT] in ('AGR', 'AHS', 'CAP', 'CDC', 'CES', 'CGC', 'COP', 'CSD', 'DFO', 'DND', 'DOE', 'DUS', 'DVA', 'ESO', 'EXT', 'FIN', 'GSS', 'IAN', 'ICA', 'IMC', 'IRB', 'JUS', 'NED', 'NFB', 'NHW', 'NPB', 'PCH', 'PCO', 'PEN', 'PPD', 'PSC', 'PSP', 'PXR', 'RCM', 'RSN', 'RTC', 'SIR', 'SVC', 'TBD')
    
• 

  

  pq_Transaction_Type

  Data Items

  1

  Transaction Type	[Presentation].[Sub Type].[TRANSACTION_TYPE]

• 

  

  pq_Month

  Data Items

  1

  Month	cast(year( [Presentation].[Case].[DATE_RECEIVED] ),varchar(4)) + '-'+ right('00'+cast(month( [Presentation].[Case].[DATE_RECEIVED] ),varchar(2)),2)	sort ascending

  • Detail Filters
    1
  • 

    [Presentation].[Case].[DATE_EFFECTIVE_FROM] between 2017-01-01 and 2022-12-31
    

Layouts