Queries

• 4
  Expressions:

  

  Data Items

  

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

• 

  

  POD Progress Raw Data

  • queryHints
  • crossProductAllowed: allow

  Data Items

  31

  Case Number	[Presentation].[Case].[ID]
  CMT Age	[Presentation].[Case].[CMT_AGE]
  PRI	[Presentation].[Case].[PRI]
  POD_NO	[Presentation].[VW_CMT_POD_LOOKUP].[POD_NO]
  Language	[Presentation].[Case].[LANG]
  Business Unit	[Presentation].[VW_STG_DEPARTMENT].[CODE]
  Current_Team	[Presentation].[VW_STG_CURRENT_TEAM].[Team_Name]
  Assignee_Curr	[Presentation].[VW_STG_USERS].[FULLNAME]
  ca_user_id	[Presentation].[VW_STG_USERS].[LOGIN_NAME]
  Date Open	[Presentation].[Case].[DATE_OPEN_EST]
  Date BF	[Presentation].[Case].[DATE_BF_EST]
  Date Closed	[Presentation].[Case].[DATE_CLOSED_EST]
  Date Cancelled	[Presentation].[Case].[DATE_CANCELLED_EST]
  Date Closed or Date Cancelled	[Presentation].[Case].[Date Closed or Date Cancelled EST]
  State Name	[Presentation].[State].[NAME]
  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]
  Auto Process Indicator	[Presentation].[Case].[Auto Process Indicator]
  Processing Centre	[Presentation].[Case].[PROCESSING_CENTRE]
  Service Standard Days	[Presentation].[Sub Type].[SERVICE_STANDARD]
  Intake	coalesce ( [Open], [Bring Forward] )	Aggregate count Rollup total
  Open	if ( [Date Open] >= [Start Date] and [Date Open] <= [End Date] and [Date BF] is null ) then ([Presentation].[Case].[Case Count]) else ( null )	Aggregate count Rollup total
  Bring Forward	if ( [Date BF] >= [Start Date] and [Date BF] <= [End Date] ) then ([Presentation].[Case].[Case Count]) else ( null )	Aggregate count Rollup total
  Output	if ( [Date Closed or Date Cancelled] >= [Start Date] and [Date Closed or Date Cancelled] <= [End Date] ) then ([Presentation].[Case].[Case Count]) else ( null )	Aggregate count
  Pay Period Start Date	[Pay Period Dates].[Pay Period Start Date]
  Pay Period End Date	[Pay Period Dates].[Pay Period End Date]
  Start Date	case when ( ?Param_Date_Choice? =1 ) then ( [Pay Period Start Date] ) when ( ?Param_Date_Choice? =0 ) then ( ?Param_Selected_Start_Date? ) else null end
  End Date	case when ( ?Param_Date_Choice? =1 ) then ( [Pay Period End Date] ) when ( ?Param_Date_Choice? =0) then ( ?Param_Selected_End_Date? ) else null end

  • Detail Filters
    5
  • 

    (
    [Date Open] >= [Start Date] and
    [Date Open] <= [End Date] and
    [Date BF] is null
    )
    or
    (
    [Date BF] >= [Start Date] and
    [Date BF] <= [End Date]
    )
    or
    (
    [Date Closed] >= [Start Date] and
    [Date Closed] <= [End Date]
    )
    or
    (
    [Date Cancelled] >= [Start Date] and
    [Date Cancelled] <= [End Date]
    )
    
    
  • 

    [POD_NO] in (?Param-POD?)
    
  • 

    [Current_Team] in (?Param_Team?)
    
  • 

    [Business Unit] is not null
    
  • 

    [Work Type Code] <> 'WT-058'
    
• 

  

  pq_POD

  Data Items

  1

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

  • Detail Filters
    1
  • 

    [POD_NO] is not missing
    
• 

  

  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

  • Detail Filters
    1
  • 

    [Pay Period End Date] < current_date
    
• 

  

  pq_TeamName

  Data Items

  1

  Team Name	[Presentation].[VW_STG_CURRENT_TEAM].[Team_Name]

Layouts