Queries

• 3
  Expressions:

  

  Data Items

  

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

• 

  

  Query1

  Data Items

  16

  State Name	CASE when [Presentation].[State].[NAME] = ('Bring_Forward ') then ('Bring Forward / Rappel') else [Presentation].[State].[NAME] End
  Business Unit	[Presentation].[VW_STG_DEPARTMENT].[CODE]
  Current date Run	current_date
  Department Name	[Presentation].[VW_STG_DEPARTMENT].[NAME_1]
  Pay Period Year	[Presentation].[Case].[PAY_PERIOD_YEAR_1]
  Pay Period Year for label	[Presentation].[Case].[PAY_PERIOD_YEAR_1]
  Pay Period	cast([Presentation].[Case].[PAY_PERIOD_1]as int)
  Pay Period for label	[Presentation].[Case].[PAY_PERIOD_1]
  Pay Period Start Date	cast(_add_hours ( [Presentation].[VW_STG_PAY_PERIOD_CALENDAR].[PAY_PERIOD_START_DATE],-4 ),date)
  Pay Period Start Date for label	'="' + cast(_add_hours ( [Presentation].[VW_STG_PAY_PERIOD_CALENDAR].[PAY_PERIOD_START_DATE],-4 ),varchar(19)) + '"'
  Pay Period End Date	cast(_add_hours ( [Presentation].[VW_STG_PAY_PERIOD_CALENDAR].[PAY_PERIOD_END_DATE],-4 ),date)
  Pay Period End Date for lable	'="' + cast(_add_hours ( [Presentation].[VW_STG_PAY_PERIOD_CALENDAR].[PAY_PERIOD_END_DATE],-4 ),varchar(19)) + '"'
  Processing Date	cast(_add_hours ( [Presentation].[VW_STG_PAY_PERIOD_CALENDAR].[PROCESSING_DATE],-4 ),date)
  Processing Date for label	'="' + cast(_add_hours ( [Presentation].[VW_STG_PAY_PERIOD_CALENDAR].[PROCESSING_DATE],-4 ),varchar(19)) + '"'
  Number of BF Cases	[Presentation].[Case].[Case Count]
  Case Number	[Presentation].[Case].[ID]

  • Detail Filters
    2
  • 

    
    [Business Unit] = (?para_dept_code?)
    
    
  • 

    [State Name] = 'Bring Forward / Rappel'
    
• 

  

  Query2

  Data Items

  2

  Business Unit	[Presentation].[VW_STG_DEPARTMENT].[CODE]
  Department Name	[Presentation].[VW_STG_DEPARTMENT].[NAME_1]

• 

  

  Load Last Date Query

  Data Items

  1

  Latest Valid Data Load Date	[Presentation].[Data Load Archive].[Latest Valid Data Load Date]

Layouts