Queries

• 4
  Expressions:

  

  Data Items

  

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

• 

  

  CAI PA Progress Details

  

  [Raw Data].[Assigned To User ID] = [Team].[Team ID]

  

  Raw Data

  1:N

  

  Team

  0:1

  Data Items

  27

  Date Open	[Raw Data].[Date Open]
  Date Modified	[Raw Data].[Date Modified]
  Case Number	[Raw Data].[Case Number]
  State Name	[Raw Data].[State Name]
  Project Label	[Raw Data].[Project Label]
  Contact Info	[Raw Data].[Contact Info]
  Assigned To	[Raw Data].[Assigned To]
  Team Name	[Team].[Team Name]
  Transaction Type	[Raw Data].[Transaction Type]
  Work Type Name	[Raw Data].[Work Type Name]
  Work Type Code	[Raw Data].[Work Type Code]
  Sub Type Code	[Raw Data].[Sub Type Code]
  Sub Type Name	[Raw Data].[Sub Type Name]
  PRI	[Raw Data].[PRI]
  Language	[Raw Data].[Language]
  Business Unit	[Raw Data].[Business Unit]
  Classification	[Raw Data].[Classification]
  Awaiting Calc	[Raw Data].[Awaiting Calc]
  Awaiting Confirm	[Raw Data].[Awaiting Confirm]
  Awaiting Off Cycle	[Raw Data].[Awaiting Off Cycle]
  Awaiting pay sheet creation	[Raw Data].[Awaiting pay sheet creation]
  Date Awaiting Calc Selected - Date Time	[Raw Data].[Date Awaiting Calc Selected - Date Time]
  Date Awaiting Confirm Selected - Date Time	[Raw Data].[Date Awaiting Confirm Selected - Date Time]
  Date Awaiting Off Cycle Selected - Date Time	[Raw Data].[Date Awaiting Off Cycle Selected - Date Time]
  Date Awaiting Pay Sheet Creation Selected - Date Time	[Raw Data].[Date Awaiting Pay Sheet Creation Selected - Date Time]
  Production	[Raw Data].[Production]
  User ID	[Raw Data].[User ID]

• 

  

  Raw Data

  Data Items

  27

  Date Open	[Presentation].[Case].[DATE_OPEN_EST]
  Date Modified	[Presentation].[Case].[DATE_MODIFIED_EST]
  Case Number	[Presentation].[Case].[ID]
  State Name	[Presentation].[State].[NAME]
  Project Label	[Presentation].[Case].[PROJECT_LABEL]
  Contact Info	[Presentation].[Case].[CONTACT_INFO]
  Assigned To	[Presentation].[Case].[ASSIGNEE_CURR]
  Assigned To User ID	[Presentation].[Case].[ASSIGNEE_CURR_ID]
  Transaction Type	[Presentation].[Sub Type].[TRANSACTION_TYPE]
  Work Type Name	[Presentation].[Work Type].[NAME]
  Work Type Code	[Presentation].[Work Type].[WORK_TYPE_CODE]
  Sub Type Code	[Presentation].[Sub Type].[SUB_TYPE_CODE]
  Sub Type Name	[Presentation].[Sub Type].[NAME]
  PRI	[Presentation].[Case].[PRI]
  Language	[Presentation].[Case].[LANG]
  Business Unit	[Presentation].[VW_STG_DEPARTMENT].[CODE]
  Classification	[Presentation].[Case].[CLASSIFICATION]
  Awaiting Calc	[Presentation].[Case].[AWAITING_CALC]
  Awaiting Confirm	[Presentation].[Case].[AWAITING_CONFIRM]
  Awaiting Off Cycle	[Presentation].[Case].[AWAITING_OFF_CYCLE]
  Awaiting pay sheet creation	[Presentation].[Case].[AWAITING_PAY_SHEET_CREAT]
  Date Awaiting Calc Selected - Date Time	[Presentation].[Case].[TIME_IN_ASSIGNED_EST_DATE_TIME]
  Date Awaiting Confirm Selected - Date Time	[Presentation].[Case].[TIME_OUT_ASSIGNED_EST_DATE_TIME]
  Date Awaiting Off Cycle Selected - Date Time	[Presentation].[Case].[TIME_IN_REASSIGNED_EST_DATE_TIME]
  Date Awaiting Pay Sheet Creation Selected - Date Time	[Presentation].[Case].[TIME_OUT_REASSIGNED_EST_DATE_TIME]
  Production	[Presentation].[VW_STG_DAILY_CAI_PROGRESS_DETAIL].[PRODUCTION_VALUE]
  User ID	[Presentation].[VW_STG_USERS].[LOGIN_NAME]

  • Detail Filters
    2
  • 

    [Presentation].[Sub Type].[SUB_TYPE_CODE] in ('ST-986')
    
  • 

    [Presentation].[VW_STG_DAILY_CAI_PROGRESS_DETAIL].[CAI_GROUP]='EX'
    
• 

  

  Team

  Data Items

  2

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

• 

  

  Query1

Layouts