Unica Marketing Operations and Campaign Cognos Framework Manager Model Specification

Business View

Namespace/Folder	Query Subject	Query Item	Type	Usage	Ref Obj/Expr.
Namespace/Folder Query Subject Query Item Type Usage Ref Obj/Expr. Namespace/Folder Query Subject Query Item Type Usage Ref Obj/Expr. Common User User ID float64 identifier [MarketingOperationsMV].[User].[User ID]  Last Name characterLength16 attribute [MarketingOperationsMV].[User].[Last Name]  First Name characterLength16 attribute [MarketingOperationsMV].[User].[First Name]  Email Address characterLength16 attribute [MarketingOperationsMV].[User].[Email Address]  User Full Name - First Last characterLength16 attribute [MarketingOperationsMV].[User].[User Full Name - First Last]  User Full Name - Last, First characterLength16 attribute [MarketingOperationsMV].[User].[User Full Name - Last, First]  Last Modified Date dateTime identifier [MarketingOperationsMV].[User].[Last Modified Date]  Login ID characterLength16 attribute [MarketingOperationsMV].[User].[Login ID]  Status Code characterLength16 attribute [MarketingOperationsMV].[User].[Status Code]  Status Status Code characterLength16 identifier [MarketingOperationsMV].[Status].[Status Code]  Status characterLength16 attribute [MarketingOperationsMV].[Status].[Status]  Users Roles user_id float64 identifier [MarketingOperationsMV].[Users Roles].[user_id]  role_id float64 identifier [MarketingOperationsMV].[Users Roles].[role_id]  role_name characterLength16 attribute [MarketingOperationsMV].[Users Roles].[role_name]  Team Team ID float64 identifier [MarketingOperationsMV].[Team Member].[Team ID]  Team Name characterLength16 attribute [MarketingOperationsMV].[Team].[Team Name]  Team Description characterLength16 attribute [MarketingOperationsMV].[Team].[Team Description]  Team Member ID float64 identifier [MarketingOperationsMV].[User].[User ID]  Team Member Name - First Last characterLength16 attribute [MarketingOperationsMV].[User].[User Full Name - First Last]  Team Member Type ID float64 identifier [MarketingOperationsMV].[Member Type].[Member Type ID]  Team Member Type Name characterLength16 attribute [MarketingOperationsMV].[Member Type].[Member Type Name]  List Definitions Vendor Vendor ID float64 identifier [MarketingOperationsMV].[Vendor].[Vendor ID]  Vendor Code characterLength16 attribute [MarketingOperationsMV].[Vendor].[Vendor Code]  Vendor Name characterLength16 attribute [MarketingOperationsMV].[Vendor].[Vendor Name]  Vendor Display characterLength16 attribute [MarketingOperationsMV].[Vendor].[Vendor Display]  Cost Category Cost Category ID float64 identifier [MarketingOperationsMV].[Cost Category].[Cost Category ID]  Cost Category Code characterLength16 attribute [MarketingOperationsMV].[Cost Category].[Cost Category Code]  Cost Category Name characterLength16 attribute [MarketingOperationsMV].[Cost Category].[Cost Category Name]  Cost Category Display characterLength16 attribute [MarketingOperationsMV].[Cost Category].[Cost Category Display]  Projects Project Project ID float64 identifier [MarketingOperationsMV].[Project].[Project ID]  Project Name characterLength16 attribute [MarketingOperationsMV].[Project].[Project Name]  Project Code characterLength16 attribute [MarketingOperationsMV].[Project].[Project Code]  Project Description characterLength16 attribute [MarketingOperationsMV].[Project].[Project Description]  Project Start Date dateTime attribute [MarketingOperationsMV].[Project].[Project Start Date]  Project End Date dateTime attribute [MarketingOperationsMV].[Project].[Project End Date]  Project Actual Start Date dateTime identifier [MarketingOperationsMV].[Project].[Project Actual Start Date]  Project Actual End Date dateTime identifier [MarketingOperationsMV].[Project].[Project Actual End Date]  Status characterLength16 attribute [MarketingOperationsMV].[Project Status].[Status]   Project Name (Code) characterLength16 attribute [MarketingOperationsMV].[Project].[Project Name (Code)]  Project URL characterLength16 attribute [MarketingOperationsMV].[Project].[Project URL]  Project Request Flag characterLength16 attribute [MarketingOperationsMV].[Project].[Project Request Flag]  Template Name characterLength16 attribute [MarketingOperationsMV].[Project].[Template Name]  Template Display characterLength16 attribute [MarketingOperationsMV].[Project Template].[Template Display]  Template Instance Display characterLength16 attribute [MarketingOperationsBV].[Project Template].[Template Instance Display]  Project Requests Project ID float64 identifier [MarketingOperationsMV].[Project Requests].[Project ID]  Project Name characterLength16 attribute [MarketingOperationsMV].[Project Requests].[Project Name]  Project Code characterLength16 attribute [MarketingOperationsMV].[Project Requests].[Project Code]  Project Description characterLength16 attribute [MarketingOperationsMV].[Project Requests].[Project Description]  Project Start Date dateTime identifier [MarketingOperationsMV].[Project Requests].[Project Start Date]  Project End Date dateTime identifier [MarketingOperationsMV].[Project Requests].[Project End Date]  Project Actual Start Date dateTime identifier [MarketingOperationsMV].[Project Requests].[Project Actual Start Date]  Project Actual End Date dateTime identifier [MarketingOperationsMV].[Project Requests].[Project Actual End Date]  Project Request Status characterLength16 attribute [MarketingOperationsMV].[Project Requests].[Project Request Status]  Project Request URL characterLength16 attribute [MarketingOperationsMV].[Project Requests].[Project Request URL]  Project Name (Code) characterLength16 attribute [MarketingOperationsMV].[Project Requests].[Project Name (Code)]  Project Request Flag characterLength16 attribute [MarketingOperationsMV].[Project Requests].[Project Request Flag]  Project Request ID float64 identifier [MarketingOperationsMV].[Project Requests].[Project Request ID]  Request Submit Date dateTime identifier [MarketingOperationsMV].[Project Requests].[Request Submit Date]  Request Complete Date dateTime identifier [MarketingOperationsMV].[Project Requests].[Request Complete Date]  Template Name characterLength16 attribute [MarketingOperationsMV].[Project Requests].[Template Name]  Project Owner Project ID float64 identifier [MarketingOperationsMV].[Project Owner].[Project ID]  User ID float64 identifier [MarketingOperationsMV].[Project Owner].[User ID]  User Full Name - First Last characterLength16 attribute [MarketingOperationsMV].[Project User][MarketingOperationsMV].[User].[User Full Name - First Last]  User Full Name - Last, First characterLength16 attribute [MarketingOperationsMV].[Project User][MarketingOperationsMV].[User].[User Full Name - Last, First]  Email Address characterLength16 attribute [MarketingOperationsMV].[Project User][MarketingOperationsMV].[User].[Email Address]  First Name characterLength16 attribute [MarketingOperationsMV].[Project User][MarketingOperationsMV].[User].[First Name]  Last Name characterLength16 attribute [MarketingOperationsMV].[Project User][MarketingOperationsMV].[User].[Last Name]  Project Member Project ID float64 identifier [MarketingOperationsMV].[Project Member].[Project ID]  User ID float64 identifier [MarketingOperationsMV].[Project Member].[User ID]  Member Type ID float64 identifier [MarketingOperationsMV].[Project Member].[Member Type ID]  Project Approval Project ID float64 fact [MarketingOperationsMV].[Project Approval].[Project ID]  Approval ID float64 identifier [MarketingOperationsMV].[Project Approval].[Approval ID]  Approval Name characterLength16 attribute [MarketingOperationsMV].[Project Approval].[Approval Name]  Approval Description characterLength16 attribute [MarketingOperationsMV].[Project Approval].[Approval Description]  Workflow Task ID float64 fact [MarketingOperationsMV].[Project Approval].[Workflow Task ID]  Approval Date dateTime attribute [MarketingOperationsMV].[Project Approval].[Approval Date]  Task Number Name characterLength16 attribute [MarketingOperationsMV].[Shortcut to Task][MarketingOperationsMV].[Task].[Task Number Name]  Approval Status Code characterLength16 identifier [MarketingOperationsMV].[Approval Status].[Approval Status Code]  Approval Status characterLength16 attribute [MarketingOperationsMV].[Approval Status].[Approval Status]  Approval URL characterLength16 attribute #sq($[Environment]{'URL'})# + 'type=approval&id=' + cast([MarketingOperationsBV].[Project Approval].[Approval ID],varchar(10))  Project Template Template Name characterLength16 attribute [MarketingOperationsMV].[Project Template].[Template Name]  Template Display characterLength16 attribute [MarketingOperationsMV].[Project Template].[Template Display]  Template Instance Display characterLength16 attribute [MarketingOperationsMV].[Project Template].[Template Instance Display]  Project Status Status Code characterLength16 identifier [MarketingOperationsMV].[Project Status].[Status Code]  Status characterLength16 attribute [MarketingOperationsMV].[Project Status].[Status]  Namespace/Folder Query Subject Query Item Type Usage Ref Obj/Expr. Workflow Task Task ID float64 identifier [MarketingOperationsMV].[Task].[Task ID]  Task Number characterLength16 attribute [MarketingOperationsMV].[Task].[Task Number]  Task Name characterLength16 attribute [MarketingOperationsMV].[Task].[Task Name]  % Complete float64 attribute [MarketingOperationsMV].[Task].[% Complete]  Forecast/Actual Start dateTime attribute [MarketingOperationsMV].[Task].[Forecast/Actual Start]  Forecast/Actual End dateTime attribute [MarketingOperationsMV].[Task].[Forecast/Actual End]  Actual Duration float64 attribute [MarketingOperationsMV].[Task].[Actual Duration]  Actual Duration String characterLength16 attribute [MarketingOperationsMV].[Task].[Actual Duration String]  Anchor? characterLength16 attribute [MarketingOperationsMV].[Task].[Anchor?]  Start Date dateTime attribute [MarketingOperationsMV].[Task].[Start Date]  End Date dateTime attribute [MarketingOperationsMV].[Task].[End Date]  Duration float64 attribute [MarketingOperationsMV].[Task].[Duration]  Duration String characterLength16 attribute [MarketingOperationsMV].[Task].[Duration String]  Notes characterLength16 attribute [MarketingOperationsMV].[Task].[Notes]  Milestone characterLength16 attribute [MarketingOperationsMV].[Milestone].[Milestone]  Project ID float64 attribute [MarketingOperationsMV].[Task].[Project ID]  Status characterLength16 attribute [MarketingOperationsMV].[Task Status].[Status]  Project Name characterLength16 attribute [MarketingOperationsMV].[Task Parent Project][MarketingOperationsMV].[Project].[Project Name]  Project Code characterLength16 attribute [MarketingOperationsMV].[Task Parent Project][MarketingOperationsMV].[Project].[Project Code]  Project URL characterLength16 attribute [MarketingOperationsMV].[Task Parent Project][MarketingOperationsMV].[Project].[Project URL]  Effort float64 fact [MarketingOperationsMV].[Task].[Effort]  Effort String characterLength16 attribute [MarketingOperationsMV].[Task].[Effort String]  Forecast/Actual Effort float64 fact [MarketingOperationsMV].[Task].[Forecast/Actual Effort]  Forecast/Actual Effort String characterLength16 attribute [MarketingOperationsMV].[Task].[Forecast/Actual Effort String]  Link Object characterLength16 attribute [MarketingOperationsMV].[Task].[Link Object]  Task URL characterLength16 attribute [MarketingOperationsMV].[Task].[Task URL]  Stage Stage ID float64 identifier [MarketingOperationsMV].[Stage].[Stage ID]  Stage Number float64 attribute [MarketingOperationsMV].[Stage].[Stage Number]  Stage Name characterLength16 attribute [MarketingOperationsMV].[Stage].[Stage Name]  Project ID float64 attribute [MarketingOperationsMV].[Stage].[Project ID]  Project Name characterLength16 attribute [MarketingOperationsMV].[Stage Parent Project][MarketingOperationsMV].[Project].[Project Name]  Project Code characterLength16 attribute [MarketingOperationsMV].[Stage Parent Project][MarketingOperationsMV].[Project].[Project Code]  Task Member Task ID float64 identifier [MarketingOperationsMV].[Task Member].[Task ID]  User ID float64 identifier [MarketingOperationsMV].[Task Member].[User ID]  User Full Name - First Last characterLength16 attribute [MarketingOperationsMV].[Task User][MarketingOperationsMV].[User].[User Full Name - First Last]  User Full Name - Last, First characterLength16 attribute [MarketingOperationsMV].[Task User][MarketingOperationsMV].[User].[User Full Name - Last, First]  Email Address characterLength16 attribute [MarketingOperationsMV].[Task User][MarketingOperationsMV].[User].[Email Address]  Task Status Status Code characterLength16 identifier [MarketingOperationsMV].[Task Status].[Status Code]  Status characterLength16 attribute [MarketingOperationsMV].[Task Status].[Status]  Project Budgets Project Budget Budget ID float64 identifier [MarketingOperationsMV].[Project Budget].[Budget ID]  Project ID float64 identifier [MarketingOperationsMV].[Project Budget].[Project ID]  Budget Total float64 fact [MarketingOperationsMV].[Project Budget].[Budget Total]  Forecast Total float64 fact [MarketingOperationsMV].[Project Budget].[Forecast Total]  Actual Total float64 fact [MarketingOperationsMV].[Project Budget].[Actual Total]  Committed Total float64 fact [MarketingOperationsMV].[Project Budget].[Committed Total]  Committed Remaining Amount float64 fact [MarketingOperationsMV].[Project Budget].[Committed Remaining Amount]  Forecast Remaining Amount float64 fact [MarketingOperationsMV].[Project Budget].[Forecast Remaining Amount]  Actual Remaining Amount float64 fact [MarketingOperationsMV].[Project Budget].[Actual Remaining Amount]  Project Budget Amount Quarter ID float64 identifier [MarketingOperationsMV].[Project Budget Amount][MarketingOperationsMV].[Budget Amount].[Quarter ID]  Year float64 identifier [MarketingOperationsMV].[Project Budget Amount][MarketingOperationsMV].[Budget Amount].[Year]  Month float64 identifier [MarketingOperationsMV].[Project Budget Amount][MarketingOperationsMV].[Budget Amount].[Month]  Budget ID float64 identifier [MarketingOperationsMV].[Project Budget Amount][MarketingOperationsMV].[Budget Amount].[Budget ID]  Forecast Amount float64 fact [MarketingOperationsMV].[Project Budget Amount][MarketingOperationsMV].[Budget Amount].[Forecast Amount]  Committed Amount float64 fact [MarketingOperationsMV].[Project Budget Amount][MarketingOperationsMV].[Budget Amount].[Committed Amount]  Actual Amount float64 fact [MarketingOperationsMV].[Project Budget Amount][MarketingOperationsMV].[Budget Amount].[Actual Amount]  Budget Amount float64 fact [MarketingOperationsMV].[Project Budget Amount][MarketingOperationsMV].[Budget Amount].[Budget Amount]  Committed Remaining Amount float64 fact [MarketingOperationsMV].[Project Budget Amount][MarketingOperationsMV].[Budget Amount].[Committed Remaining Amount]  Forecast Remaining Amount float64 fact [MarketingOperationsMV].[Project Budget Amount][MarketingOperationsMV].[Budget Amount].[Forecast Remaining Amount]  Actual Remaining Amount float64 fact [MarketingOperationsMV].[Project Budget Amount][MarketingOperationsMV].[Budget Amount].[Actual Remaining Amount]  Quarter Year characterLength16 attribute [MarketingOperationsMV].[Quarter].[Quarter Year]  Fiscal Year characterLength16 attribute [MarketingOperationsMV].[Quarter].[Fiscal Year]  Project Line Item Project ID float64 identifier [MarketingOperationsMV].[Project Line Item].[Project ID]  Expenditure Date dateTime attribute [MarketingOperationsMV].[Project Line Item].[Expenditure Date]  Quarter Year characterLength16 attribute [MarketingOperationsMV].[Quarter for Project Line Item].[Quarter Year]  Account ID float64 attribute [MarketingOperationsMV].[Project Line Item].[Account ID]  Account Name (Code) characterLength16 attribute [MarketingOperationsMV].[Account].[Account Name (Code)]  Cost Category ID float64 attribute [MarketingOperationsMV].[Project Line Item].[Cost Category ID]  Cost Category Display characterLength16 attribute [MarketingOperationsMV].[Cost Category].[Cost Category Display]  Committed Amount float64 fact [MarketingOperationsMV].[Project Line Item].[Committed Amount]  Forecast Amount float64 fact [MarketingOperationsMV].[Project Line Item].[Forecast Amount]  Item Description characterLength16 attribute [MarketingOperationsMV].[Project Line Item].[Item Description]  Project Invoice Cost Project ID float64 attribute [MarketingOperationsMV].[Project Invoice Cost].[Project ID]  Account ID float64 attribute [MarketingOperationsMV].[Project Invoice Cost].[Account ID]  Invoice ID float64 identifier [MarketingOperationsMV].[Project Invoice Cost].[Invoice ID]  Invoice Number characterLength16 attribute [MarketingOperationsMV].[Project Invoice Cost].[Invoice Number]  Invoice URL characterLength16 attribute [MarketingOperationsMV].[Project Invoice Cost].[Invoice URL]  Vendor Display characterLength16 attribute [MarketingOperationsMV].[Project Invoice Cost].[Vendor Display]  Expenditure Date dateTime identifier [MarketingOperationsMV].[Project Invoice Cost].[Expenditure Date]  Quarter Year characterLength16 attribute [MarketingOperationsMV].[Quarter for Project Invoice Cost].[Quarter Year]  Cost Item ID float64 identifier [MarketingOperationsMV].[Project Invoice Cost].[Cost Item ID]  Cost Item Number float64 attribute [MarketingOperationsMV].[Project Invoice Cost].[Cost Item Number]  Item Description characterLength16 attribute [MarketingOperationsMV].[Project Invoice Cost].[Cost Item Description]  Cost Category ID float64 attribute [MarketingOperationsMV].[Project Invoice Cost].[Cost Category ID]  Cost Category Display characterLength16 attribute [MarketingOperationsMV].[Project Invoice Cost].[Cost Category Display]  Item Cost float64 fact [MarketingOperationsMV].[Project Invoice Cost].[Item Cost]  Project Metrics Project Metric Value Project ID float64 identifier [MarketingOperationsMV].[Project Metric Column Value].[Project ID]  Metric ID characterLength16 identifier [MarketingOperationsMV].[Project Metric Column Value].[Metric ID]  Metric Name characterLength16 attribute [MarketingOperationsMV].[Project Metric Column Value].[Metric Name]  Display Format characterLength16 attribute [MarketingOperationsMV].[Project Metric Column Value].[Display Format]  Display Order float64 fact [MarketingOperationsMV].[Project Metric Column Value].[Display Order]  Column Display characterLength16 attribute [MarketingOperationsMV].[Project Metric Column Value].[Column Display]  Metric Value float64 fact [MarketingOperationsMV].[Project Metric Column Value].[Metric Value]  Is Target? characterLength16 attribute [MarketingOperationsMV].[Project Metric Column Value].[Is Target?]  Dimension Type characterLength16 attribute [MarketingOperationsMV].[Project Metric Column Value].[Dimension Type]  Column Taborder float64 identifier [MarketingOperationsMV].[Project Metric Column Value].[Column Taborder]  Project Performance Summary Metrics PROJECT ID float64 fact [MarketingOperationsMV].[Project Performance Summary Metrics].[PROJECT ID]  DISPLAY FORMAT METRIC1 characterLength16 attribute [MarketingOperationsMV].[Project Performance Summary Metrics].[DISPLAY FORMAT METRIC1]  ACTUAL VALUE METRIC1 float64 fact [MarketingOperationsMV].[Project Performance Summary Metrics].[ACTUAL VALUE METRIC1]  TARGET VALUE METRIC1 float64 fact [MarketingOperationsMV].[Project Performance Summary Metrics].[TARGET VALUE METRIC1]  OPTIMISTIC VALUE METRIC1 float64 fact [MarketingOperationsMV].[Project Performance Summary Metrics].[OPTIMISTIC VALUE METRIC1]  PESSIMISTIC VALUE METRIC1 float64 fact [MarketingOperationsMV].[Project Performance Summary Metrics].[PESSIMISTIC VALUE METRIC1]  DISPLAY FORMAT METRIC2 characterLength16 attribute [MarketingOperationsMV].[Project Performance Summary Metrics].[DISPLAY FORMAT METRIC2]  ACTUAL VALUE METRIC2 float64 fact [MarketingOperationsMV].[Project Performance Summary Metrics].[ACTUAL VALUE METRIC2]  TARGET VALUE METRIC2 float64 fact [MarketingOperationsMV].[Project Performance Summary Metrics].[TARGET VALUE METRIC2]  OPTIMISTIC VALUE METRIC2 float64 fact [MarketingOperationsMV].[Project Performance Summary Metrics].[OPTIMISTIC VALUE METRIC2]  PESSIMISTIC VALUE METRIC2 float64 fact [MarketingOperationsMV].[Project Performance Summary Metrics].[PESSIMISTIC VALUE METRIC2]  DISPLAY FORMAT METRIC3 characterLength16 attribute [MarketingOperationsMV].[Project Performance Summary Metrics].[DISPLAY FORMAT METRIC3]  ACTUAL VALUE METRIC3 float64 fact [MarketingOperationsMV].[Project Performance Summary Metrics].[ACTUAL VALUE METRIC3]  TARGET VALUE METRIC3 float64 fact [MarketingOperationsMV].[Project Performance Summary Metrics].[TARGET VALUE METRIC3]  OPTIMISTIC VALUE METRIC3 float64 fact [MarketingOperationsMV].[Project Performance Summary Metrics].[OPTIMISTIC VALUE METRIC3]  PESSIMISTIC VALUE METRIC3 float64 fact [MarketingOperationsMV].[Project Performance Summary Metrics].[PESSIMISTIC VALUE METRIC3]  DISPLAY FORMAT METRIC4 characterLength16 attribute [MarketingOperationsMV].[Project Performance Summary Metrics].[DISPLAY FORMAT METRIC4]  ACTUAL VALUE METRIC4 float64 fact [MarketingOperationsMV].[Project Performance Summary Metrics].[ACTUAL VALUE METRIC4]  TARGET VALUE METRIC4 float64 fact [MarketingOperationsMV].[Project Performance Summary Metrics].[TARGET VALUE METRIC4]  OPTIMISTIC VALUE METRIC4 float64 fact [MarketingOperationsMV].[Project Performance Summary Metrics].[OPTIMISTIC VALUE METRIC4]  PESSIMISTIC VALUE METRIC4 float64 fact [MarketingOperationsMV].[Project Performance Summary Metrics].[PESSIMISTIC VALUE METRIC4]  DISPLAY FORMAT METRIC5 characterLength16 attribute [MarketingOperationsMV].[Project Performance Summary Metrics].[DISPLAY FORMAT METRIC5]  ACTUAL VALUE METRIC5 float64 fact [MarketingOperationsMV].[Project Performance Summary Metrics].[ACTUAL VALUE METRIC5]  TARGET VALUE METRIC5 float64 fact [MarketingOperationsMV].[Project Performance Summary Metrics].[TARGET VALUE METRIC5]  OPTIMISTIC VALUE METRIC5 float64 fact [MarketingOperationsMV].[Project Performance Summary Metrics].[OPTIMISTIC VALUE METRIC5]  PESSIMISTIC VALUE METRIC5 float64 fact [MarketingOperationsMV].[Project Performance Summary Metrics].[PESSIMISTIC VALUE METRIC5]  Project Performance Metrics Project ID float64 identifier [MarketingOperationsMV].[Project Metric].[Project ID]  Metric ID characterLength16 identifier [MarketingOperationsMV].[Project Metric].[Metric ID]  Metric Name characterLength16 attribute [MarketingOperationsMV].[Project Metric].[Metric Name]  Display Order float64 fact [MarketingOperationsMV].[Project Metric].[Display Order]  Metric Value 1 float64 fact [MarketingOperationsMV].[Project Metric].[Metric Value 1]  Metric Value 2 float64 fact [MarketingOperationsMV].[Project Metric].[Metric Value 2]  Metric Value 3 float64 fact [MarketingOperationsMV].[Project Metric].[Metric Value 3]  Metric Value 4 float64 fact [MarketingOperationsMV].[Project Metric].[Metric Value 4]  Metric Value 5 float64 fact [MarketingOperationsMV].[Project Metric].[Metric Value 5]  Programs Program Program ID float64 identifier [MarketingOperationsMV].[Program].[Program ID]  Program Name characterLength16 attribute [MarketingOperationsMV].[Program].[Program Name]  Program Code characterLength16 attribute [MarketingOperationsMV].[Program].[Program Code]  Program Description characterLength16 attribute [MarketingOperationsMV].[Program].[Program Description]  Program URL characterLength16 attribute #sq($[Environment]{'URL'})# + 'type=program&id=' + cast(cast([MarketingOperationsBV].[Program].[Program ID],integer),varchar(10))  Program Status characterLength16 attribute [MarketingOperationsMV].[Program].[Program Status]  Program Start Date dateTime attribute [MarketingOperationsMV].[Program].[Program Start Date]  Program End Date dateTime attribute [MarketingOperationsMV].[Program].[Program End Date]  Program Name (Code) characterLength16 attribute [MarketingOperationsMV].[Program].[Program Name (Code)]  Template Name characterLength16 attribute [MarketingOperationsMV].[Program].[Template Name]  Template Display characterLength16 attribute [MarketingOperationsMV].[Program Template].[Template Display]  Program Project Program ID float64 identifier [MarketingOperationsMV].[Program Project Ref].[Program ID]  Project ID float64 identifier [MarketingOperationsMV].[Program Project Ref].[Project ID]  Project Name characterLength16 attribute [MarketingOperationsMV].[Program Project][MarketingOperationsMV].[Project].[Project Name]  Project Code characterLength16 attribute [MarketingOperationsMV].[Program Project][MarketingOperationsMV].[Project].[Project Code]  Project Description characterLength16 attribute [MarketingOperationsMV].[Program Project][MarketingOperationsMV].[Project].[Project Description]  Project Start Date dateTime identifier [MarketingOperationsMV].[Program Project][MarketingOperationsMV].[Project].[Project Start Date]  Project End Date dateTime identifier [MarketingOperationsMV].[Program Project][MarketingOperationsMV].[Project].[Project End Date]  Project Status characterLength16 attribute [MarketingOperationsMV].[Program Project][MarketingOperationsMV].[Project].[Project Status]  Project Name (Code) characterLength16 attribute [MarketingOperationsMV].[Program Project][MarketingOperationsMV].[Project].[Project Name (Code)]  Program Owner Program ID float64 identifier [MarketingOperationsMV].[Program Owner].[Program ID]  User ID float64 identifier [MarketingOperationsMV].[Program Owner].[User ID]  Member Type ID float64 identifier [MarketingOperationsMV].[Program Owner].[Member Type ID]  Program Member Program ID float64 identifier [MarketingOperationsMV].[Program Member].[Program ID]  User ID float64 identifier [MarketingOperationsMV].[Program Member].[User ID]  Member Type ID float64 identifier [MarketingOperationsMV].[Program Member].[Member Type ID]  Namespace/Folder Query Subject Query Item Type Usage Ref Obj/Expr. Program Budgets Program Budget Budget ID float64 identifier [MarketingOperationsMV].[Program Budget].[Budget ID]  Program ID float64 identifier [MarketingOperationsMV].[Program Budget].[Program ID]  Budget Total float64 fact [MarketingOperationsMV].[Program Budget].[Budget Total]  Forecast Total float64 fact [MarketingOperationsMV].[Program Budget].[Forecast Total]  Actual Total float64 fact [MarketingOperationsMV].[Program Budget].[Actual Total]  Committed Total float64 fact [MarketingOperationsMV].[Program Budget].[Committed Total]  Allocation Total float64 fact [MarketingOperationsMV].[Program Budget].[Allocation Total]  Finalized Date dateTime attribute [MarketingOperationsMV].[Program Budget].[Finalized Date]  Program Budget Amount Quarter ID float64 identifier [MarketingOperationsMV].[Program Budget Amount][MarketingOperationsMV].[Budget Amount].[Quarter ID]  Year float64 identifier [MarketingOperationsMV].[Program Budget Amount][MarketingOperationsMV].[Budget Amount].[Year]  Month float64 identifier [MarketingOperationsMV].[Program Budget Amount][MarketingOperationsMV].[Budget Amount].[Month]  Budget ID float64 identifier [MarketingOperationsMV].[Program Budget Amount][MarketingOperationsMV].[Budget Amount].[Budget ID]  Forecast Amount float64 fact [MarketingOperationsMV].[Program Budget Amount][MarketingOperationsMV].[Budget Amount].[Forecast Amount]  Committed Amount float64 fact [MarketingOperationsMV].[Program Budget Amount][MarketingOperationsMV].[Budget Amount].[Committed Amount]  Actual Amount float64 fact [MarketingOperationsMV].[Program Budget Amount][MarketingOperationsMV].[Budget Amount].[Actual Amount]  Budget Amount float64 fact [MarketingOperationsMV].[Program Budget Amount][MarketingOperationsMV].[Budget Amount].[Budget Amount]  Allocated Amount float64 fact [MarketingOperationsMV].[Program Budget Amount][MarketingOperationsMV].[Budget Amount].[Allocated Amount]  Committed Remaining Amount float64 fact [MarketingOperationsMV].[Program Budget Amount][MarketingOperationsMV].[Budget Amount].[Committed Remaining Amount]  Forecast Remaining Amount float64 fact [MarketingOperationsMV].[Program Budget Amount][MarketingOperationsMV].[Budget Amount].[Forecast Remaining Amount]  Actual Remaining Amount float64 fact [MarketingOperationsMV].[Program Budget Amount][MarketingOperationsMV].[Budget Amount].[Actual Remaining Amount]  Allocated Remaining Amount float64 fact [MarketingOperationsMV].[Program Budget Amount][MarketingOperationsMV].[Budget Amount].[Allocated Remaining Amount]  Quarter Year characterLength16 attribute [MarketingOperationsMV].[Quarter].[Quarter Year]  Fiscal Year characterLength16 attribute [MarketingOperationsMV].[Quarter].[Fiscal Year]  Program Line Item Program ID float64 identifier [MarketingOperationsMV].[Program Line Item].[Program ID]  Expenditure Date dateTime attribute [MarketingOperationsMV].[Program Line Item].[Expenditure Date]  Quarter Year characterLength16 attribute [MarketingOperationsMV].[Quarter for Program Line Item][MarketingOperationsMV].[Quarter].[Quarter Year]  Account ID float64 attribute [MarketingOperationsMV].[Program Line Item].[Account ID]  Account Name (Code) characterLength16 attribute [MarketingOperationsMV].[Account].[Account Name (Code)]  Cost Category ID float64 attribute [MarketingOperationsMV].[Program Line Item].[Cost Category ID]  Cost Category Display characterLength16 attribute [MarketingOperationsMV].[Cost Category].[Cost Category Display]  Committed Amount float64 fact [MarketingOperationsMV].[Program Line Item].[Committed Amount]  Forecast Amount float64 fact [MarketingOperationsMV].[Program Line Item].[Forecast Amount]  Program Invoice Cost Program ID float64 identifier [MarketingOperationsMV].[Program Invoice Cost].[Program ID]  Invoice ID float64 identifier [MarketingOperationsMV].[Program Invoice Cost].[Invoice ID]  Invoice Number characterLength16 attribute [MarketingOperationsMV].[Program Invoice Cost].[Invoice Number]  Quarter Year characterLength16 attribute [MarketingOperationsMV].[Quarter for Program Invoice Cost][MarketingOperationsMV].[Quarter].[Quarter Year]  Vendor Display characterLength16 attribute [MarketingOperationsMV].[Program Invoice Cost].[Vendor Display]  Expenditure Date dateTime attribute [MarketingOperationsMV].[Program Invoice Cost].[Expenditure Date]  Cost Item ID float64 identifier [MarketingOperationsMV].[Program Invoice Cost].[Cost Item ID]  Cost Item Number float64 attribute [MarketingOperationsMV].[Program Invoice Cost].[Cost Item Number]  Item Description characterLength16 attribute [MarketingOperationsMV].[Program Invoice Cost].[Item Description]  Account ID float64 attribute [MarketingOperationsMV].[Program Invoice Cost].[Account ID]  Account Name (Code) characterLength16 attribute [MarketingOperationsMV].[Program Invoice Cost].[Account Name (Code)]  Cost Category ID float64 attribute [MarketingOperationsMV].[Program Invoice Cost].[Cost Category ID]  Cost Category Display characterLength16 attribute [MarketingOperationsMV].[Program Invoice Cost].[Cost Category Display]  Item Cost float64 fact [MarketingOperationsMV].[Program Invoice Cost].[Item Cost]  Plans Plan Plan ID float64 fact [MarketingOperationsMV].[Plan].[Plan ID]  Plan Code characterLength16 attribute [MarketingOperationsMV].[Plan].[Plan Code]  Plan Name characterLength16 attribute [MarketingOperationsMV].[Plan].[Plan Name]  Plan Description characterLength16 attribute [MarketingOperationsMV].[Plan].[Plan Description]  Plan URL characterLength16 attribute #sq($[Environment]{'URL'})# + 'type=plan&id=' + cast(cast([MarketingOperationsBV].[Plan].[Plan ID] ,integer),varchar(10))  Plan Status Code characterLength16 attribute [MarketingOperationsMV].[Plan].[Plan Status Code]  Plan Fiscal Year float64 attribute [MarketingOperationsMV].[Plan].[Plan Fiscal Year]  Plan Business Area ID float64 attribute [MarketingOperationsMV].[Plan].[Plan Business Area ID]  Start Date dateTime attribute [MarketingOperationsMV].[Plan].[Start Date]  End Date dateTime attribute [MarketingOperationsMV].[Plan].[End Date]  Plan Name (Code) characterLength16 attribute [MarketingOperationsMV].[Plan].[Plan Name (Code)]  Plan Program Area Plan ID float64 attribute [MarketingOperationsMV].[Plan Program Area Ref].[Plan ID]  Plan Program Area ID float64 identifier [MarketingOperationsMV].[Plan Program Area Ref].[Plan Program Area ID]  Program Area ID float64 attribute [MarketingOperationsMV].[Plan Program Area Ref].[Program Area ID]  Display Order float64 attribute [MarketingOperationsMV].[Plan Program Area Ref].[Display Order]  Program Area Name characterLength16 attribute [MarketingOperationsMV].[Plan Program Area][MarketingOperationsMV].[Program Area].[Program Area Name]  Plan Program Plan ID float64 identifier [MarketingOperationsMV].[Plan Program Ref].[Plan ID]  Plan Program Area ID float64 identifier [MarketingOperationsMV].[Plan Program Ref].[Plan Program Area ID]  Program ID float64 identifier [MarketingOperationsMV].[Plan Program Ref].[Program ID]  Program Name characterLength16 attribute [MarketingOperationsMV].[Plan Program][MarketingOperationsMV].[Program].[Program Name]  Program Code characterLength16 attribute [MarketingOperationsMV].[Plan Program][MarketingOperationsMV].[Program].[Program Code]  Program Description characterLength16 attribute [MarketingOperationsMV].[Plan Program][MarketingOperationsMV].[Program].[Program Description]  Program Start Date dateTime attribute [MarketingOperationsMV].[Plan Program][MarketingOperationsMV].[Program].[Program Start Date]  Program End Date dateTime attribute [MarketingOperationsMV].[Plan Program][MarketingOperationsMV].[Program].[Program End Date]  Program Status characterLength16 attribute [MarketingOperationsMV].[Plan Program][MarketingOperationsMV].[Program].[Program Status]  Program Name (Code) characterLength16 attribute [MarketingOperationsMV].[Plan Program][MarketingOperationsMV].[Program].[Program Name (Code)]  Namespace/Folder Query Subject Query Item Type Usage Ref Obj/Expr. Plan Budgets Plan Budget Budget ID float64 identifier [MarketingOperationsMV].[Plan Budget].[Budget ID]  Plan ID float64 identifier [MarketingOperationsMV].[Plan Budget].[Plan ID]  Budget Total float64 fact [MarketingOperationsMV].[Plan Budget].[Budget Total]  Forecast Total float64 fact [MarketingOperationsMV].[Plan Budget].[Forecast Total]  Actual Total float64 fact [MarketingOperationsMV].[Plan Budget].[Actual Total]  Committed Total float64 fact [MarketingOperationsMV].[Plan Budget].[Committed Total]  Allocated Total float64 fact [MarketingOperationsMV].[Plan Budget].[Allocated Total]  Finalized Date dateTime attribute [MarketingOperationsMV].[Plan Budget].[Finalized Date]  Plan Budget Amount Quarter ID float64 identifier [MarketingOperationsMV].[Plan Budget Amount][MarketingOperationsMV].[Budget Amount].[Quarter ID]  Year float64 identifier [MarketingOperationsMV].[Plan Budget Amount][MarketingOperationsMV].[Budget Amount].[Year]  Month float64 identifier [MarketingOperationsMV].[Plan Budget Amount][MarketingOperationsMV].[Budget Amount].[Month]  Budget ID float64 identifier [MarketingOperationsMV].[Plan Budget Amount][MarketingOperationsMV].[Budget Amount].[Budget ID]  Forecast Amount float64 fact [MarketingOperationsMV].[Plan Budget Amount][MarketingOperationsMV].[Budget Amount].[Forecast Amount]  Committed Amount float64 fact [MarketingOperationsMV].[Plan Budget Amount][MarketingOperationsMV].[Budget Amount].[Committed Amount]  Actual Amount float64 fact [MarketingOperationsMV].[Plan Budget Amount][MarketingOperationsMV].[Budget Amount].[Actual Amount]  Budget Amount float64 fact [MarketingOperationsMV].[Plan Budget Amount][MarketingOperationsMV].[Budget Amount].[Budget Amount]  Allocated Amount float64 fact [MarketingOperationsMV].[Plan Budget Amount][MarketingOperationsMV].[Budget Amount].[Allocated Amount]  Committed Remaining Amount float64 fact [MarketingOperationsMV].[Plan Budget Amount][MarketingOperationsMV].[Budget Amount].[Committed Remaining Amount]  Forecast Remaining Amount float64 fact [MarketingOperationsMV].[Plan Budget Amount][MarketingOperationsMV].[Budget Amount].[Forecast Remaining Amount]  Actual Remaining Amount float64 fact [MarketingOperationsMV].[Plan Budget Amount][MarketingOperationsMV].[Budget Amount].[Actual Remaining Amount]  Allocated Remaining Amount float64 fact [MarketingOperationsMV].[Plan Budget Amount][MarketingOperationsMV].[Budget Amount].[Allocated Remaining Amount]  Quarter Year characterLength16 attribute [MarketingOperationsMV].[Quarter].[Quarter Year]  Fiscal Year characterLength16 attribute [MarketingOperationsMV].[Quarter].[Fiscal Year]  Program Area Budget Budget ID float64 identifier [MarketingOperationsMV].[Program Area Budget].[Budget ID]  Plan Program Area ID float64 identifier [MarketingOperationsMV].[Program Area Budget].[Plan Program Area ID]  Budget Total float64 fact [MarketingOperationsMV].[Program Area Budget].[Budget Total]  Forecast Total float64 fact [MarketingOperationsMV].[Program Area Budget].[Forecast Total]  Actual Total float64 fact [MarketingOperationsMV].[Program Area Budget].[Actual Total]  Committed Total float64 fact [MarketingOperationsMV].[Program Area Budget].[Committed Total]  Finalized Date dateTime attribute [MarketingOperationsMV].[Program Area Budget].[Finalized Date]  Program Area Budget Amount Quarter ID float64 identifier [MarketingOperationsMV].[Program Area Budget Amount][MarketingOperationsMV].[Budget Amount].[Quarter ID]  Year float64 identifier [MarketingOperationsMV].[Program Area Budget Amount][MarketingOperationsMV].[Budget Amount].[Year]  Month float64 identifier [MarketingOperationsMV].[Program Area Budget Amount][MarketingOperationsMV].[Budget Amount].[Month]  Budget ID float64 identifier [MarketingOperationsMV].[Program Area Budget Amount][MarketingOperationsMV].[Budget Amount].[Budget ID]  Forecast Amount float64 fact [MarketingOperationsMV].[Program Area Budget Amount][MarketingOperationsMV].[Budget Amount].[Forecast Amount]  Committed Amount float64 fact [MarketingOperationsMV].[Program Area Budget Amount][MarketingOperationsMV].[Budget Amount].[Committed Amount]  Actual Amount float64 fact [MarketingOperationsMV].[Program Area Budget Amount][MarketingOperationsMV].[Budget Amount].[Actual Amount]  Budget Amount float64 fact [MarketingOperationsMV].[Program Area Budget Amount][MarketingOperationsMV].[Budget Amount].[Budget Amount]  Allocated Amount float64 fact [MarketingOperationsMV].[Program Area Budget Amount][MarketingOperationsMV].[Budget Amount].[Allocated Amount]  Committed Remaining Amount float64 fact [MarketingOperationsMV].[Program Area Budget Amount][MarketingOperationsMV].[Budget Amount].[Committed Remaining Amount]  Forecast Remaining Amount float64 fact [MarketingOperationsMV].[Program Area Budget Amount][MarketingOperationsMV].[Budget Amount].[Forecast Remaining Amount]  Actual Remaining Amount float64 fact [MarketingOperationsMV].[Program Area Budget Amount][MarketingOperationsMV].[Budget Amount].[Actual Remaining Amount]  Allocated Remaining Amount float64 fact [MarketingOperationsMV].[Program Area Budget Amount][MarketingOperationsMV].[Budget Amount].[Allocated Remaining Amount]  Quarter Year characterLength16 attribute [MarketingOperationsMV].[Quarter].[Quarter Year]  Accounts Account Account ID float64 identifier [MarketingOperationsMV].[Account].[Account ID]  Account Name characterLength16 attribute [MarketingOperationsMV].[Account].[Account Name]  Account Code characterLength16 attribute [MarketingOperationsMV].[Account].[Account Code]  Account Name (Code) characterLength16 attribute [MarketingOperationsMV].[Account].[Account Name (Code)]  Account Description characterLength16 attribute [MarketingOperationsMV].[Account].[Account Description]  Account URL characterLength16 attribute #sq($[Environment]{'URL'})# + 'type=account&id=' + cast(cast([MarketingOperationsBV].[Account].[Account ID],integer),varchar(10))  Parent Account Name (Code) characterLength16 attribute [MarketingOperationsMV].[Parent Account][MarketingOperationsMV].[Account].[Account Name (Code)]  Parent Account ID float64 attribute [MarketingOperationsMV].[Account].[Parent Account ID]  Account Budget Amount Parent Account ID float64 attribute [MarketingOperationsMV].[Account].[Parent Account ID]  Account ID float64 identifier [MarketingOperationsMV].[Account Budget].[Account ID]  Quarter ID float64 identifier [MarketingOperationsMV].[Account Budget Amount][MarketingOperationsMV].[Budget Amount].[Quarter ID]  Year float64 identifier [MarketingOperationsMV].[Account Budget Amount][MarketingOperationsMV].[Budget Amount].[Year]  Month float64 identifier [MarketingOperationsMV].[Account Budget Amount][MarketingOperationsMV].[Budget Amount].[Month]  Budget ID float64 identifier [MarketingOperationsMV].[Account Budget Amount][MarketingOperationsMV].[Budget Amount].[Budget ID]  Forecast Amount float64 fact [MarketingOperationsMV].[Account Budget Amount][MarketingOperationsMV].[Budget Amount].[Forecast Amount]  Committed Amount float64 fact [MarketingOperationsMV].[Account Budget Amount][MarketingOperationsMV].[Budget Amount].[Committed Amount]  Actual Amount float64 fact [MarketingOperationsMV].[Account Budget Amount][MarketingOperationsMV].[Budget Amount].[Actual Amount]  Budget Amount float64 fact [MarketingOperationsMV].[Account Budget Amount][MarketingOperationsMV].[Budget Amount].[Budget Amount]  Allocated Amount float64 fact [MarketingOperationsMV].[Account Budget Amount][MarketingOperationsMV].[Budget Amount].[Allocated Amount]  Committed Remaining Amount float64 fact [MarketingOperationsMV].[Account Budget Amount][MarketingOperationsMV].[Budget Amount].[Committed Remaining Amount]  Forecast Remaining Amount float64 fact [MarketingOperationsMV].[Account Budget Amount][MarketingOperationsMV].[Budget Amount].[Forecast Remaining Amount]  Actual Remaining Amount float64 fact [MarketingOperationsMV].[Account Budget Amount][MarketingOperationsMV].[Budget Amount].[Actual Remaining Amount]  Allocated Remaining Amount float64 fact [MarketingOperationsMV].[Account Budget Amount][MarketingOperationsMV].[Budget Amount].[Allocated Remaining Amount]  Sub-Account Budget Amount Account ID float64 identifier [MarketingOperationsMV].[Sub-Account Budget Amount].[Account ID]  Quarter_ID float64 identifier [MarketingOperationsMV].[Sub-Account Budget Amount].[Quarter_ID]  Year1 float64 identifier [MarketingOperationsMV].[Sub-Account Budget Amount].[Year1]  Month1 float64 identifier [MarketingOperationsMV].[Sub-Account Budget Amount].[Month1]  Budget_Amount float64 fact [MarketingOperationsMV].[Sub-Account Budget Amount].[Budget_Amount]  Forecast_Amount float64 fact [MarketingOperationsMV].[Sub-Account Budget Amount].[Forecast_Amount]  Committed_Amount float64 fact [MarketingOperationsMV].[Sub-Account Budget Amount].[Committed_Amount]  Actual_Amount float64 fact [MarketingOperationsMV].[Sub-Account Budget Amount].[Actual_Amount]  Quarter Year characterLength16 attribute [MarketingOperationsMV].[Quarter].[Quarter Year]  Parent Account Account ID float64 identifier [MarketingOperationsMV].[Parent Account][MarketingOperationsMV].[Account].[Account ID]  Account Code characterLength16 attribute [MarketingOperationsMV].[Parent Account][MarketingOperationsMV].[Account].[Account Code]  Account Description characterLength16 attribute [MarketingOperationsMV].[Parent Account][MarketingOperationsMV].[Account].[Account Description]  Parent Account ID float64 attribute [MarketingOperationsMV].[Parent Account][MarketingOperationsMV].[Account].[Parent Account ID]  Account Name characterLength16 attribute [MarketingOperationsMV].[Parent Account][MarketingOperationsMV].[Account].[Account Name]  Account Name (Code) characterLength16 attribute [MarketingOperationsMV].[Parent Account][MarketingOperationsMV].[Account].[Account Name (Code)]  Approvals Approval Approval ID float64 identifier [MarketingOperationsMV].[Approval].[Approval ID]  Approval Name characterLength16 attribute [MarketingOperationsMV].[Approval].[Approval Name]  Approval Description characterLength16 attribute [MarketingOperationsMV].[Approval].[Approval Description]  Approval URL characterLength16 attribute #sq($[Environment]{'URL'})# + 'type=approval&id=' + cast(cast([MarketingOperationsBV].[Approval].[Approval ID],integer),varchar(10))  Approval Status characterLength16 attribute [MarketingOperationsMV].[Approval Status].[Approval Status]  Approval Date dateTime attribute [MarketingOperationsMV].[Approval].[Approval Date]  Source Object ID float64 identifier [MarketingOperationsMV].[Approval].[Source Object ID]  Source Object Type characterLength16 attribute [MarketingOperationsMV].[Approval].[Source Object Type]  Source Workflow Task ID float64 identifier [MarketingOperationsMV].[Approval].[Source Workflow Task ID]  Approval Item Approval ID float64 identifier [MarketingOperationsMV].[Approval Item].[Approval ID]  Approval Item Order float64 attribute [MarketingOperationsMV].[Approval Item].[Approval Item Order]  Approval Item Name characterLength16 attribute [MarketingOperationsMV].[Approval Item].[Approval Item Name]  Approver Approval ID float64 identifier [MarketingOperationsMV].[Approver].[Approval ID]  Approver Order float64 attribute [MarketingOperationsMV].[Approver].[Approver Order]  User ID float64 identifier [MarketingOperationsMV].[Approver].[User ID]  Is Required? characterLength16 attribute [MarketingOperationsMV].[Approver].[Is Required?]  Response Date dateTime attribute [MarketingOperationsMV].[Approver].[Response Date]  User Full Name - First Last characterLength16 attribute [MarketingOperationsMV].[Approver User][MarketingOperationsMV].[User].[User Full Name - First Last]  User Full Name - Last, First characterLength16 attribute [MarketingOperationsMV].[Approver User][MarketingOperationsMV].[User].[User Full Name - Last, First]  Approver Status characterLength16 attribute [MarketingOperationsMV].[Approver].[Approver Status]  Budgets Budget Amount Quarter ID float64 identifier [MarketingOperationsMV].[Budget Amount].[Quarter ID]  Year float64 identifier [MarketingOperationsMV].[Budget Amount].[Year]  Month float64 identifier [MarketingOperationsMV].[Budget Amount].[Month]  Budget ID float64 identifier [MarketingOperationsMV].[Budget Amount].[Budget ID]  Forecast Amount float64 fact [MarketingOperationsMV].[Budget Amount].[Forecast Amount]  Committed Amount float64 fact [MarketingOperationsMV].[Budget Amount].[Committed Amount]  Actual Amount float64 fact [MarketingOperationsMV].[Budget Amount].[Actual Amount]  Budget Amount float64 fact [MarketingOperationsMV].[Budget Amount].[Budget Amount]  Allocated Amount float64 fact [MarketingOperationsMV].[Budget Amount].[Allocated Amount]  Committed Remaining Amount float64 fact [MarketingOperationsMV].[Budget Amount].[Committed Remaining Amount]  Forecast Remaining Amount float64 fact [MarketingOperationsMV].[Budget Amount].[Forecast Remaining Amount]  Actual Remaining Amount float64 fact [MarketingOperationsMV].[Budget Amount].[Actual Remaining Amount]  Allocated Remaining Amount float64 fact [MarketingOperationsMV].[Budget Amount].[Allocated Remaining Amount]  Quarter Description characterLength16 attribute [MarketingOperationsMV].[Quarter].[Quarter Description]  Quarter Year characterLength16 attribute [MarketingOperationsMV].[Quarter].[Quarter Year]  Month Year characterLength16 attribute [MarketingOperationsMV].[Quarter].[Month Year]  Invoices Invoice Invoice ID float64 identifier [MarketingOperationsMV].[Invoice].[Invoice ID]  Invoice Number characterLength16 attribute [MarketingOperationsMV].[Invoice].[Invoice Number]  Vendor Display characterLength16 attribute [MarketingOperationsMV].[Vendor].[Vendor Display]  PO Number characterLength16 attribute [MarketingOperationsMV].[Invoice].[PO Number]  Due Date dateTime identifier [MarketingOperationsMV].[Invoice].[Due Date]  State Code characterLength16 attribute [MarketingOperationsMV].[Invoice].[State Code]  Invoice Date dateTime identifier [MarketingOperationsMV].[Invoice].[Invoice Date]  Invoice URL characterLength16 attribute [MarketingOperationsMV].[Invoice].[Invoice URL]  Notes characterLength16 attribute [MarketingOperationsMV].[Invoice].[Notes]  Payment Terms characterLength16 attribute [MarketingOperationsMV].[Invoice].[Payment Terms]  Invoice Amount float64 fact [MarketingOperationsMV].[Invoice].[Invoice Amount]  Invoice Code characterLength16 attribute [MarketingOperationsMV].[Invoice].[Invoice Code]  Payable Date dateTime attribute [MarketingOperationsMV].[Invoice].[Payable Date]  Paid Date dateTime attribute [MarketingOperationsMV].[Invoice].[Paid Date]  Invoice Line Item Invoice ID float64 identifier [MarketingOperationsMV].[Invoice Line Item].[Invoice ID]  Cost Item ID float64 identifier [MarketingOperationsMV].[Invoice Line Item].[Cost Item ID]  Cost Item Number float64 attribute [MarketingOperationsMV].[Invoice Line Item].[Cost Item Number]  Item Description characterLength16 attribute [MarketingOperationsMV].[Invoice Line Item].[Item Description]  Source Object Type characterLength16 attribute [MarketingOperationsMV].[Invoice Line Item].[Source Object Type]  Source Object ID float64 attribute [MarketingOperationsMV].[Invoice Line Item].[Source Object ID]  Source Object Code characterLength16 attribute [MarketingOperationsMV].[Invoice Line Item].[Source Object Code]  Account ID float64 attribute [MarketingOperationsMV].[Invoice Line Item].[Account ID]  Account Code characterLength16 attribute [MarketingOperationsMV].[Invoice Line Item].[Account Code]  Cost Category ID float64 attribute [MarketingOperationsMV].[Invoice Line Item].[Cost Category ID]  Cost Category Code characterLength16 attribute [MarketingOperationsMV].[Invoice Line Item].[Cost Category Code]  Quantity float64 fact [MarketingOperationsMV].[Invoice Line Item].[Quantity]  Unit Cost float64 fact [MarketingOperationsMV].[Invoice Line Item].[Unit Cost]  Item Cost float64 fact [MarketingOperationsMV].[Invoice Line Item].[Item Cost]  Custom Attributes Project Custom Attributes Project ID float64 identifier [MarketingOperationsMV].[Project Custom Attributes].[Project ID]  Initiative characterLength16 attribute [MarketingOperationsMV].[Initiative].[Initiative]  Channel Name characterLength16 attribute [MarketingOperationsMV].[Channel].[CHANNEL_NAME]  Business Unit characterLength16 attribute [MarketingOperationsMV].[Business Unit].[Business Unit]  Product Family characterLength16 attribute [MarketingOperationsMV].[Product Family].[Product Family]  Segment characterLength16 attribute [MarketingOperationsMV].[Segment].[Segment]  Budget Period characterLength16 attribute [MarketingOperationsMV].[Budget Period].[budget_period_name]  Project Performance Summary Custom Metrics Project ID float64 fact [MarketingOperationsMV].[Project Performance Summary Custom Metrics].[Project ID]  Total Revenue float64 fact [MarketingOperationsMV].[Project Performance Summary Custom Metrics].[Total Revenue]  ResponseRateActual float64 fact [MarketingOperationsMV].[Project Performance Summary Custom Metrics].[ResponseRateActual]  ResponseRateTarget float64 fact [MarketingOperationsMV].[Project Performance Summary Custom Metrics].[ResponseRateTarget]  Total Leads Generated (Actual) float64 fact [MarketingOperationsMV].[Project Performance Summary Custom Metrics].[Total Leads Generated (Actual)]  Total Leads Generated (Target) float64 fact [MarketingOperationsMV].[Project Performance Summary Custom Metrics].[Total Leads Generated (Target)]  Total Cost Passed float64 fact [MarketingOperationsMV].[Project Performance Summary Custom Metrics].[Total Cost Passed]  Program Performance Metrics_notused program_id float64 identifier [MarketingOperationsMV].[Program Metric].[program_id]  metric_id characterLength16 identifier [MarketingOperationsMV].[Program Metric].[metric_id]  display_name characterLength16 attribute [MarketingOperationsMV].[Program Metric].[display_name]  display_order float64 fact [MarketingOperationsMV].[Program Metric].[display_order]  metric_value1 float64 fact [MarketingOperationsMV].[Program Metric].[metric_value1]  metric_value2 float64 fact [MarketingOperationsMV].[Program Metric].[metric_value2]  metric_value3 float64 fact [MarketingOperationsMV].[Program Metric].[metric_value3]  metric_value4 float64 fact [MarketingOperationsMV].[Program Metric].[metric_value4]  metric_value5 float64 fact [MarketingOperationsMV].[Program Metric].[metric_value5]  Namespace/Folder Query Subject Query Item Type Usage Ref Obj/Expr. Projects and Requests Over Time Requests Over Time   (shortcut)   [MarketingOperationsMV].[Requests Over Time] Projects Over Time   (shortcut)   [MarketingOperationsMV].[Projects Over Time] Projects Quarter   (shortcut)   [MarketingOperationsMV].[Projects Quarter]
Namespace/Folder Query Subject Query Item Type Usage Ref Obj/Expr. Campaign Listing Campaign   (shortcut)   [Model View].[Campaign] Offer   (shortcut)   [Model View].[Offer] Cell   (shortcut)   [Model View].[Cell] CampToOffer   (shortcut)   [Model View].[CampToOffer] Campaign Custom Attributes Campaign Cust Attributes   (shortcut)   [Model View].[Campaign Cust Attributes] Offer Custom Attributes   (shortcut)   [Model View].[Offer Custom Attributes] Cell Custom Attributes   (shortcut)   [Model View].[Cell Custom Attributes] Campaign   (shortcut)   [Model View].[Campaign] Offer   (shortcut)   [Model View].[Offer] Cell   (shortcut)   [Model View].[Cell] CampToOffer   (shortcut)   [Model View].[CampToOffer] Campaign Performance by Day Campaign Contact History by Day   (shortcut)   [Model View].[Campaign Contact History by Day] Campaign Offer Contact History by Day   (shortcut)   [Model View].[Campaign Offer Contact History by Day] Campaign Cell Contact History by Day   (shortcut)   [Model View].[Campaign Cell Contact History by Day] Campaign Response History by Day   (shortcut)   [Model View].[Campaign Response History by Day] Campaign Offer Response History by Day   (shortcut)   [Model View].[Campaign Offer Response History by Day] Campaign Cell Response History by Day   (shortcut)   [Model View].[Campaign Cell Response History by Day] Campaign   (shortcut)   [Model View].[Campaign] Offer   (shortcut)   [Model View].[Offer] Cell   (shortcut)   [Model View].[Cell] ControlCells   (shortcut)   [Model View].[Cell] Responder Rate Control Group by Cell by Day   (shortcut)   [Model View].[Responder Rate Control Group by Cell by Day] Calendar   (shortcut)   [Model View].[Calendar] Campaign Performance by Month Campaign Contact History by Month   (shortcut)   [Model View].[Campaign Contact History by Month] Campaign Offer Contact History by Month   (shortcut)   [Model View].[Campaign Offer Contact History by Month] Campaign Cell Contact History by Month   (shortcut)   [Model View].[Campaign Cell Contact History by Month] Campaign Response History by Month   (shortcut)   [Model View].[Campaign Response History by Month] Campaign Offer Response History by Month   (shortcut)   [Model View].[Campaign Offer Response History by Month] Campaign Cell Response History by Month   (shortcut)   [Model View].[Campaign Cell Response History by Month] Campaign   (shortcut)   [Model View].[Campaign] Offer   (shortcut)   [Model View].[Offer] Cell   (shortcut)   [Model View].[Cell] ControlCells   (shortcut)   [Model View].[Cell] Responder Rate Control Group by Cell by Month   (shortcut)   [Model View].[Responder Rate Control Group by Cell by Month] Calendar Month   (shortcut)   [Model View].[Calendar Month] Campaign Performance Summary Campaign Contact History Summary   (shortcut)   [Model View].[Campaign Contact History Summary] Campaign Response History Summary   (shortcut)   [Model View].[Campaign Response History Summary] Campaign Offer Contact History Summary   (shortcut)   [Model View].[Campaign Offer Contact History Summary] Campaign Offer Response History Summary   (shortcut)   [Model View].[Campaign Offer Response History Summary] Campaign Cell Contact History Summary   (shortcut)   [Model View].[Campaign Cell Contact History Summary] Campaign Cell Response History Summary   (shortcut)   [Model View].[Campaign Cell Response History Summary] Campaign   (shortcut)   [Model View].[Campaign] Offer   (shortcut)   [Model View].[Offer] Cell   (shortcut)   [Model View].[Cell] ControlCells   (shortcut)   [Model View].[Cell] Responder Rate Control Group at Cell Level   (shortcut)   [Model View].[Responder Rate Control Group at Cell Level] Campaign Offer Detailed Response Breakout Campaign Response Breakout   (shortcut)   [Model View].[Campaign Response Breakout] Campaign Offer Response Breakout   (shortcut)   [Model View].[Campaign Offer Response Breakout] Campaign Response History Summary   (shortcut)   [Model View].[Campaign Response History Summary] Campaign Offer Response History Summary   (shortcut)   [Model View].[Campaign Offer Response History Summary] Campaign   (shortcut)   [Model View].[Campaign] Offer   (shortcut)   [Model View].[Offer] CampToOffer   (shortcut)   [Model View].[CampToOffer] Campaign Offer Detailed Response Breakout Campaign Contact History Summary Campaign ID decimal identifier [Campaign Performance Summary Star Schema].[Campaign Contact History Summary][Model View].[Campaign Contact History Summary].[Campaign ID]  Number of Offers Given float64 fact total ([Campaign Performance Summary Star Schema].[Campaign Contact History Summary][Model View].[Campaign Contact History Summary].[Number of Offers Given] for [Campaign Performance Summary Star Schema].[Campaign Contact History Summary][Model View].[Campaign Contact History Summary].[Campaign ID] )  Number of Offers Given Control Group float64 fact total ([Campaign Performance Summary Star Schema].[Campaign Contact History Summary][Model View].[Campaign Contact History Summary].[Number of Offers Given Control Group] for [Campaign Performance Summary Star Schema].[Campaign Contact History Summary][Model View].[Campaign Contact History Summary].[Campaign ID] )  Unique Recipients float64 fact total ([Campaign Performance Summary Star Schema].[Campaign Contact History Summary][Model View].[Campaign Contact History Summary].[Unique Recipients] for [Campaign Performance Summary Star Schema].[Campaign Contact History Summary][Model View].[Campaign Contact History Summary].[Campaign ID] )  Unique Recipients Control Group float64 fact total ([Campaign Performance Summary Star Schema].[Campaign Contact History Summary][Model View].[Campaign Contact History Summary].[Unique Recipients Control Group] for [Campaign Performance Summary Star Schema].[Campaign Contact History Summary][Model View].[Campaign Contact History Summary].[Campaign ID] )  Number of Offer Versions float64 fact total ([Campaign Performance Summary Star Schema].[Campaign Contact History Summary][Model View].[Campaign Contact History Summary].[Number of Offer Versions] for [Campaign Performance Summary Star Schema].[Campaign Contact History Summary][Model View].[Campaign Contact History Summary].[Campaign ID] )  Number of Offer Versions Control Group float64 fact total ([Campaign Performance Summary Star Schema].[Campaign Contact History Summary][Model View].[Campaign Contact History Summary].[Number of Offer Versions Control Group] for [Campaign Performance Summary Star Schema].[Campaign Contact History Summary][Model View].[Campaign Contact History Summary].[Campaign ID] )  Campaign Offer Contact History Summary Campaign ID decimal identifier [Campaign Performance Summary Star Schema].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Campaign ID]  Offer ID decimal identifier [Campaign Performance Summary Star Schema].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Offer ID]  Number of Offers Given float64 fact total ([Campaign Performance Summary Star Schema].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Number of Offers Given] for [Campaign Performance Summary Star Schema].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Campaign ID] ,[Campaign Performance Summary Star Schema].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Offer ID] )  Number of Offers Given Control Group float64 fact total ([Campaign Performance Summary Star Schema].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Number of Offers Given Control Group] for [Campaign Performance Summary Star Schema].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Campaign ID] ,[Campaign Performance Summary Star Schema].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Offer ID] )  Unique Recipients float64 fact total ([Campaign Performance Summary Star Schema].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Unique Recipients] for [Campaign Performance Summary Star Schema].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Campaign ID] ,[Campaign Performance Summary Star Schema].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Offer ID] )  Unique Recipients Control Group float64 fact total ([Campaign Performance Summary Star Schema].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Unique Recipients Control Group] for [Campaign Performance Summary Star Schema].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Campaign ID] ,[Campaign Performance Summary Star Schema].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Offer ID] )  Number of Offer Versions float64 fact total ( [Campaign Performance Summary Star Schema].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Number of Offer Versions] for [Campaign Performance Summary Star Schema].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Campaign ID] ,[Campaign Performance Summary Star Schema].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Offer ID] )  Number of Offer Versions Control Group float64 fact total ([Campaign Performance Summary Star Schema].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Number of Offer Versions Control Group] for [Campaign Performance Summary Star Schema].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Campaign ID] ,[Campaign Performance Summary Star Schema].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Offer ID] )  Campaign Offer Contact Statuses Breakout Campaign Response History Summary   (shortcut)   [Model View].[Campaign Response History Summary] Campaign Offer Response History Summary   (shortcut)   [Model View].[Campaign Offer Response History Summary] Campaign   (shortcut)   [Model View].[Campaign] Offer   (shortcut)   [Model View].[Offer] CampToOffer   (shortcut)   [Model View].[CampToOffer] Campaign Contact Status Breakout   (shortcut)   [Model View].[Campaign Contact Status Breakout] Campaign Offer Contact Status Breakout   (shortcut)   [Model View].[Campaign Offer Contact Status Breakout] Campaign Offer Contact Statuses Breakout Campaign Contact History Summary Campaign ID decimal identifier [Campaign Performance Summary Star Schema].[Campaign Contact History Summary][Model View].[Campaign Contact History Summary].[Campaign ID]  Number of Offers Given float64 fact total ([Campaign Performance Summary Star Schema].[Campaign Contact History Summary][Model View].[Campaign Contact History Summary].[Number of Offers Given] for [Campaign Performance Summary Star Schema].[Campaign Contact History Summary][Model View].[Campaign Contact History Summary].[Campaign ID] )  Number of Offers Given Control Group float64 fact total ([Campaign Performance Summary Star Schema].[Campaign Contact History Summary][Model View].[Campaign Contact History Summary].[Number of Offers Given Control Group] for [Campaign Performance Summary Star Schema].[Campaign Contact History Summary][Model View].[Campaign Contact History Summary].[Campaign ID] )  Unique Recipients float64 fact total ([Campaign Performance Summary Star Schema].[Campaign Contact History Summary][Model View].[Campaign Contact History Summary].[Unique Recipients] for [Campaign Performance Summary Star Schema].[Campaign Contact History Summary][Model View].[Campaign Contact History Summary].[Campaign ID] )  Unique Recipients Control Group float64 fact total ([Campaign Performance Summary Star Schema].[Campaign Contact History Summary][Model View].[Campaign Contact History Summary].[Unique Recipients Control Group] for [Campaign Performance Summary Star Schema].[Campaign Contact History Summary][Model View].[Campaign Contact History Summary].[Campaign ID] )  Number of Offer Versions float64 fact total ([Campaign Performance Summary Star Schema].[Campaign Contact History Summary][Model View].[Campaign Contact History Summary].[Number of Offer Versions] for [Campaign Performance Summary Star Schema].[Campaign Contact History Summary][Model View].[Campaign Contact History Summary].[Campaign ID] )  Number of Offer Versions Control Group float64 fact total ([Campaign Performance Summary Star Schema].[Campaign Contact History Summary][Model View].[Campaign Contact History Summary].[Number of Offer Versions Control Group] for [Campaign Performance Summary Star Schema].[Campaign Contact History Summary][Model View].[Campaign Contact History Summary].[Campaign ID] )  Campaign Offer Contact History Summary Campaign ID decimal identifier [Campaign Performance Summary Star Schema].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Campaign ID]  Offer ID decimal identifier [Campaign Performance Summary Star Schema].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Offer ID]  Number of Offers Given float64 fact total ([Campaign Performance Summary Star Schema].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Number of Offers Given] for [Campaign Performance Summary Star Schema].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Campaign ID] ,[Campaign Performance Summary Star Schema].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Offer ID] )  Number of Offers Given Control Group float64 fact total ([Campaign Performance Summary Star Schema].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Number of Offers Given Control Group] for [Campaign Performance Summary Star Schema].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Campaign ID] ,[Campaign Performance Summary Star Schema].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Offer ID] )  Unique Recipients float64 fact total ([Campaign Performance Summary Star Schema].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Unique Recipients] for [Campaign Performance Summary Star Schema].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Campaign ID] ,[Campaign Performance Summary Star Schema].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Offer ID] )  Unique Recipients Control Group float64 fact total ([Campaign Performance Summary Star Schema].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Unique Recipients Control Group] for [Campaign Performance Summary Star Schema].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Campaign ID] ,[Campaign Performance Summary Star Schema].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Offer ID] )  Number of Offer Versions float64 fact total ( [Campaign Performance Summary Star Schema].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Number of Offer Versions] for [Campaign Performance Summary Star Schema].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Campaign ID] ,[Campaign Performance Summary Star Schema].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Offer ID] )  Number of Offer Versions Control Group float64 fact total ([Campaign Performance Summary Star Schema].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Number of Offer Versions Control Group] for [Campaign Performance Summary Star Schema].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Campaign ID] ,[Campaign Performance Summary Star Schema].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Offer ID] )  Offer Performance by Day Offer Contact History by Day   (shortcut)   [Model View].[Offer Contact History by Day] Offer Campaign Contact History by Day   (shortcut)   [Model View].[Offer Campaign Contact History by Day] Offer Campaign Response History by Day   (shortcut)   [Model View].[Offer Campaign Response History by Day] Offer Response History by Day   (shortcut)   [Model View].[Offer Response History by Day] Campaign   (shortcut)   [Model View].[Campaign] Offer   (shortcut)   [Model View].[Offer] Calendar   (shortcut)   [Model View].[Calendar] Offer Performance by Month Offer Contact History by Month   (shortcut)   [Model View].[Offer Contact History by Month] Offer Campaign Contact History by Month   (shortcut)   [Model View].[Offer Campaign Contact History by Month] Offer Campaign Response History by Month   (shortcut)   [Model View].[Offer Campaign Response History by Month] Offer Response History by Month   (shortcut)   [Model View].[Offer Response History by Month] Campaign   (shortcut)   [Model View].[Campaign] Offer   (shortcut)   [Model View].[Offer] Calendar Month   (shortcut)   [Model View].[Calendar Month] Offer Performance Summary Offer Contact History Summary   (shortcut)   [Model View].[Offer Contact History Summary] Offer Campaign Contact History Summary   (shortcut)   [Model View].[Offer Campaign Contact History Summary] Offer Campaign Response History Summary   (shortcut)   [Model View].[Offer Campaign Response History Summary] Offer Response History Summary   (shortcut)   [Model View].[Offer Response History Summary] Offer Performance Metrics Summary   (shortcut)   [Model View].[Offer Performance Metrics Summary] Campaign   (shortcut)   [Model View].[Campaign] Offer   (shortcut)   [Model View].[Offer] Time Dimensions Calendar   (shortcut)   [Model View].[Calendar] Time   (shortcut)   [Model View].[Time]
Namespace/Folder Query Subject Query Item Type Usage Ref Obj/Expr. Campaign Project by Cell Campaign Financial Campaign ID decimal identifier [Campaign Project by Cell Performance Summary Star Schema].[Campaign][Model View].[Campaign].[Campaign ID]  Campaign Name characterLength16 attribute [Campaign Project by Cell Performance Summary Star Schema].[Campaign][Model View].[Campaign].[Campaign Name]  Campaign Code characterLength16 attribute [Campaign Project by Cell Performance Summary Star Schema].[Campaign][Model View].[Campaign].[Campaign Code]  CampaignURL characterLength16 attribute [Campaign Project by Cell Performance Summary Star Schema].[Campaign][Model View].[Campaign].[CampaignURL]  Project ID float64 identifier [Campaign Project by Cell Performance Summary Star Schema].[Project Performance Summary Metrics][Model View].[Project Performance Summary Metrics].[Project ID]  Project URL characterLength16 attribute [MarketingOperationsMV].[Project].[Project URL]  Project Total Cost float64 fact IF([Campaign Project by Cell Performance Summary Star Schema].[Project Performance Summary Metrics][Model View].[Project Performance Summary Metrics].[Project Total Cost] is missing) THEN(0) ELSE([Campaign Project by Cell Performance Summary Star Schema].[Project Performance Summary Metrics][Model View].[Project Performance Summary Metrics].[Project Total Cost])  Project Total Revenue float64 fact IF([Campaign Project by Cell Performance Summary Star Schema].[Project Performance Summary Metrics][Model View].[Project Performance Summary Metrics].[Project Total Revenue] is missing) THEN(0) ELSE([Campaign Project by Cell Performance Summary Star Schema].[Project Performance Summary Metrics][Model View].[Project Performance Summary Metrics].[Project Total Revenue])  Budget Total float64 fact IF([Campaign Project by Cell Performance Summary Star Schema].[Project Budget][MarketingOperationsMV].[Project Budget].[Budget Total] is missing) THEN(0) ELSE([Campaign Project by Cell Performance Summary Star Schema].[Project Budget][MarketingOperationsMV].[Project Budget].[Budget Total])  Committed Total float64 fact IF([Campaign Project by Cell Performance Summary Star Schema].[Project Budget][MarketingOperationsMV].[Project Budget].[Committed Total] is missing) THEN(0) ELSE([Campaign Project by Cell Performance Summary Star Schema].[Project Budget][MarketingOperationsMV].[Project Budget].[Committed Total])  Actual Cost float64 fact IF ( total([Campaign Project by Cell Performance Summary Star Schema].[CCOCH and Offer Attributes][Model View].[CCOCH and Offer Attributes].[Actual Cost] for [Campaign Project by Cell Performance Summary Star Schema].[CCOCH and Offer Attributes][Model View].[CCOCH and Offer Attributes].[Campaign ID] ) is missing) THEN (0) ELSE (total([Campaign Project by Cell Performance Summary Star Schema].[CCOCH and Offer Attributes][Model View].[CCOCH and Offer Attributes].[Actual Cost] for [Campaign Project by Cell Performance Summary Star Schema].[CCOCH and Offer Attributes][Model View].[CCOCH and Offer Attributes].[Campaign ID] ))  Cell Financial Campaign ID int64 identifier [Campaign Project by Cell Performance Summary Star Schema].[Cell without Ctrl Cells][Model View].[Cell without Ctrl Cells].[Campaign ID]   Cell ID int64 identifier [Campaign Project by Cell Performance Summary Star Schema].[Cell without Ctrl Cells][Model View].[Cell without Ctrl Cells].[Cell ID]   Cell Name characterLength16 attribute [Campaign Project by Cell Performance Summary Star Schema].[Cell without Ctrl Cells][Model View].[Cell without Ctrl Cells].[Cell Name]   Cell Code characterLength16 attribute [Campaign Project by Cell Performance Summary Star Schema].[Cell without Ctrl Cells][Model View].[Cell without Ctrl Cells].[Cell Code]   Actual Cost float64 fact IF ( total([Campaign Project by Cell Performance Summary Star Schema].[CCOCH and Offer Attributes][Model View].[CCOCH and Offer Attributes].[Actual Cost] for [Campaign Project by Cell Performance Summary Star Schema].[CCOCH and Offer Attributes][Model View].[CCOCH and Offer Attributes].[Campaign ID] ,[Campaign Project by Cell Performance Summary Star Schema].[CCOCH and Offer Attributes][Model View].[CCOCH and Offer Attributes].[Cell ID] ) is missing) THEN (0) ELSE (total([Campaign Project by Cell Performance Summary Star Schema].[CCOCH and Offer Attributes][Model View].[CCOCH and Offer Attributes].[Actual Cost] for [Campaign Project by Cell Performance Summary Star Schema].[CCOCH and Offer Attributes][Model View].[CCOCH and Offer Attributes].[Campaign ID] ,[Campaign Project by Cell Performance Summary Star Schema].[CCOCH and Offer Attributes][Model View].[CCOCH and Offer Attributes].[Cell ID] ))  Gross Revenue int64 fact IF ([Campaign Project by Cell Performance Summary Star Schema].[Campaign Cell Offer Response History Summary][Model View].[Campaign Cell Offer Response History Summary].[Gross Revenue] is missing) THEN (0) ELSE ([Campaign Project by Cell Performance Summary Star Schema].[Campaign Cell Offer Response History Summary][Model View].[Campaign Cell Offer Response History Summary].[Gross Revenue])  Campaign Project Campaign ID decimal identifier [Campaign Project by Cell Performance Summary Star Schema].[Distinct Campaigns for Cells].[Campaign ID]   Project ID int64 identifier [Campaign Project by Cell Performance Summary Star Schema].[Campaign][Model View].[Campaign].[Project ID]  Project Total Cost float64 fact IF([Campaign Project by Cell Performance Summary Star Schema].[Project Performance Summary Metrics][Model View].[Project Performance Summary Metrics].[Project Total Cost] is missing) THEN(0) ELSE([Campaign Project by Cell Performance Summary Star Schema].[Project Performance Summary Metrics][Model View].[Project Performance Summary Metrics].[Project Total Cost])  Project Total Revenue float64 fact IF([Campaign Project by Cell Performance Summary Star Schema].[Project Performance Summary Metrics][Model View].[Project Performance Summary Metrics].[Project Total Revenue] is missing) THEN(0) ELSE([Campaign Project by Cell Performance Summary Star Schema].[Project Performance Summary Metrics][Model View].[Project Performance Summary Metrics].[Project Total Revenue])  Budget Total float64 fact IF([Campaign Project by Cell Performance Summary Star Schema].[Project Budget][MarketingOperationsMV].[Project Budget].[Budget Total] is missing) THEN(0) ELSE([Campaign Project by Cell Performance Summary Star Schema].[Project Budget][MarketingOperationsMV].[Project Budget].[Budget Total])  Committed Total float64 fact IF([Campaign Project by Cell Performance Summary Star Schema].[Project Budget][MarketingOperationsMV].[Project Budget].[Committed Total] is missing) THEN(0) ELSE([Campaign Project by Cell Performance Summary Star Schema].[Project Budget][MarketingOperationsMV].[Project Budget].[Committed Total])  Campaign Project by Offer Campaign Project by Offer Campaign ID decimal identifier [Campaign Project by Offer Performance Summary Star Schema].[CampToOffer][Model View].[CampToOffer].[Campaign ID]  Campaign Name characterLength16 attribute [Campaign Project by Offer Performance Summary Star Schema].[Campaign][Model View].[Campaign].[Campaign Name]  Campaign Code characterLength16 attribute [Campaign Project by Offer Performance Summary Star Schema].[Campaign][Model View].[Campaign].[Campaign Code]  Creator Flag int64 attribute [Campaign Project by Offer Performance Summary Star Schema].[Campaign][Model View].[Campaign].[Creator Flag]  CampaignURL characterLength16 attribute [Campaign Project by Offer Performance Summary Star Schema].[Campaign][Model View].[Campaign].[CampaignURL]  Project URL characterLength16 attribute [MarketingOperationsMV].[Project].[Project URL]  Initiative characterLength16 attribute [Campaign Project by Offer Performance Summary Star Schema].[Campaign][Model View].[Campaign].[Initiative]  Offer ID decimal identifier [Campaign Project by Offer Performance Summary Star Schema].[CampToOffer][Model View].[CampToOffer].[Offer ID]  Offer Name characterLength16 attribute [Campaign Project by Offer Performance Summary Star Schema].[Offer][Model View].[Offer].[Offer Name]  Offer Code1 characterLength16 attribute [Campaign Project by Offer Performance Summary Star Schema].[Offer][Model View].[Offer].[Offer Code1]  OfferURL characterLength16 attribute [Campaign Project by Offer Performance Summary Star Schema].[Offer][Model View].[Offer].[OfferURL]  Channel characterLength16 attribute [Campaign Project by Offer Performance Summary Star Schema].[Offer Custom Attributes][Model View].[Offer Custom Attributes].[Channel]  Gross Revenue float64 fact [Campaign Project by Offer Performance Summary Star Schema].[Campaign Offer Response History Summary][Model View].[Campaign Offer Response History Summary].[Gross Revenue]  Offer Fulfillment Cost float64 fact IF([Campaign Project by Offer Performance Summary Star Schema].[Offer Custom Attributes][Model View].[Offer Custom Attributes].[Offer Fulfillment Cost] is missing) THEN(0) ELSE([Campaign Project by Offer Performance Summary Star Schema].[Offer Custom Attributes][Model View].[Offer Custom Attributes].[Offer Fulfillment Cost])  Offer Fixed Cost float64 fact IF([Campaign Project by Offer Performance Summary Star Schema].[Offer Custom Attributes][Model View].[Offer Custom Attributes].[Offer Fixed Cost] is missing) THEN(0) ELSE([Campaign Project by Offer Performance Summary Star Schema].[Offer Custom Attributes][Model View].[Offer Custom Attributes].[Offer Fixed Cost])  Project Total Cost float64 fact IF([Campaign Project by Offer Performance Summary Star Schema].[Project Performance Summary Metrics][Model View].[Project Performance Summary Metrics].[Project Total Cost] is missing) THEN(0) ELSE([Campaign Project by Offer Performance Summary Star Schema].[Project Performance Summary Metrics][Model View].[Project Performance Summary Metrics].[Project Total Cost])  Project Total Revenue float64 fact IF([Campaign Project by Offer Performance Summary Star Schema].[Project Performance Summary Metrics][Model View].[Project Performance Summary Metrics].[Project Total Revenue] is missing) THEN(0) ELSE([Campaign Project by Offer Performance Summary Star Schema].[Project Performance Summary Metrics][Model View].[Project Performance Summary Metrics].[Project Total Revenue])  Budget Total float64 fact IF([Campaign Project by Offer Performance Summary Star Schema].[Project Budget][MarketingOperationsMV].[Project Budget].[Budget Total] is missing) THEN(0) ELSE([Campaign Project by Offer Performance Summary Star Schema].[Project Budget][MarketingOperationsMV].[Project Budget].[Budget Total])  Committed Total float64 fact IF([Campaign Project by Offer Performance Summary Star Schema].[Project Budget][MarketingOperationsMV].[Project Budget].[Committed Total] is missing) THEN(0) ELSE([Campaign Project by Offer Performance Summary Star Schema].[Project Budget][MarketingOperationsMV].[Project Budget].[Committed Total])  Campaign Project Campaign ID decimal identifier [Campaign Project by Offer Performance Summary Star Schema].[Distinct Campaigns for Offers].[Campaign ID]   Project ID int64 identifier [Campaign Project by Offer Performance Summary Star Schema].[Campaign][Model View].[Campaign].[Project ID]  Project Total Cost float64 fact IF([Campaign Project by Offer Performance Summary Star Schema].[Project Performance Summary Metrics][Model View].[Project Performance Summary Metrics].[Project Total Cost] is missing) THEN(0) ELSE([Campaign Project by Offer Performance Summary Star Schema].[Project Performance Summary Metrics][Model View].[Project Performance Summary Metrics].[Project Total Cost])  Project Total Revenue float64 fact IF([Campaign Project by Offer Performance Summary Star Schema].[Project Performance Summary Metrics][Model View].[Project Performance Summary Metrics].[Project Total Revenue] is missing) THEN(0) ELSE([Campaign Project by Offer Performance Summary Star Schema].[Project Performance Summary Metrics][Model View].[Project Performance Summary Metrics].[Project Total Revenue])  Budget Total float64 fact IF([Campaign Project by Offer Performance Summary Star Schema].[Project Budget][MarketingOperationsMV].[Project Budget].[Budget Total] is missing) THEN(0) ELSE([Campaign Project by Offer Performance Summary Star Schema].[Project Budget][MarketingOperationsMV].[Project Budget].[Budget Total])  Committed Total float64 fact IF([Campaign Project by Offer Performance Summary Star Schema].[Project Budget][MarketingOperationsMV].[Project Budget].[Committed Total] is missing) THEN(0) ELSE([Campaign Project by Offer Performance Summary Star Schema].[Project Budget][MarketingOperationsMV].[Project Budget].[Committed Total])

Model View

Namespace/Folder	Query Subject	Query Item	Type	Usage	Ref Obj/Expr.
Namespace/Folder Query Subject Query Item Type Usage Ref Obj/Expr. Common User User ID float64 fact [MarketingOperationsDS].[uap_user].[USER_ID]  Last Name characterLength16 attribute IF ([MarketingOperationsDS].[uap_user].[LAST_NAME] is missing) THEN ('') ELSE ([MarketingOperationsDS].[uap_user].[LAST_NAME])  First Name characterLength16 attribute IF ([MarketingOperationsDS].[uap_user].[FIRST_NAME] is missing) THEN ('') ELSE ([MarketingOperationsDS].[uap_user].[FIRST_NAME])  Email Address characterLength16 attribute [MarketingOperationsDS].[uap_user].[EMAIL_ID]  User Full Name - First Last characterLength16 attribute IF ([MarketingOperationsMV].[User].[First Name] ='') THEN ([MarketingOperationsMV].[User].[Last Name]) ELSE ([MarketingOperationsMV].[User].[First Name] + ' ' + [MarketingOperationsMV].[User].[Last Name])  User Full Name - Last, First characterLength16 attribute IF ([MarketingOperationsMV].[User].[Last Name] ='') THEN ([MarketingOperationsMV].[User].[First Name]) ELSE ([MarketingOperationsMV].[User].[Last Name] + ', ' + [MarketingOperationsMV].[User].[First Name])  Last Modified Date dateTime identifier [MarketingOperationsDS].[uap_user].[LAST_MOD_DATE]  Login ID characterLength16 attribute [MarketingOperationsDS].[uap_user].[LOGIN_ID]  Status Code characterLength16 attribute [MarketingOperationsDS].[uap_user].[STATUS_CODE]  Member Type Member Type ID float64 identifier [MarketingOperationsDS].[uap_member_type].[mem_type_id]  Member Type Name characterLength16 attribute [MarketingOperationsDS].[uap_member_type].[mem_name]  Status Status Code characterLength16 identifier [MarketingOperationsDS].[uap_status].[STATUS_CODE]  Status characterLength16 attribute [MarketingOperationsDS].[uap_status].[STATUS_DESC]  Template Template ID float64 identifier [MarketingOperationsDS].[UAP_TT_TEMPLATES].[TEMPLATE_ID]  Object Type float64 attribute [MarketingOperationsDS].[UAP_TT_TEMPLATES].[OBJECT_TYPE]  Template Name characterLength16 attribute [MarketingOperationsDS].[UAP_TT_TEMPLATES].[TEMPLATE_NAME]  Template Display characterLength16 attribute [MarketingOperationsDS].[UAP_TT_TEMPLATES].[ACTUAL_DISPLAY]  Template Instance Display characterLength16 attribute [MarketingOperationsDS].[UAP_TT_TEMPLATES].[DISPLAY]  User Roles role_id float64 identifier [MarketingOperationsDS].[uap_user_roles].[ROLE_ID]  sec_policy_id float64 identifier [MarketingOperationsDS].[uap_user_roles].[SEC_POLICY_ID]  user_id float64 identifier [MarketingOperationsDS].[uap_user_roles].[USER_ID]  Roles role_id float64 identifier [MarketingOperationsDS].[uap_roles].[ROLE_ID]  role_name characterLength16 attribute [MarketingOperationsDS].[uap_roles].[ROLE_NAME]  role_desc characterLength16 attribute [MarketingOperationsDS].[uap_roles].[ROLE_DESC]  sec_policy_id float64 fact [MarketingOperationsDS].[uap_roles].[SEC_POLICY_ID]  Users Roles user_id float64 identifier [MarketingOperationsMV].[User Roles].[user_id]  role_id float64 identifier [MarketingOperationsMV].[User Roles].[role_id]  role_name characterLength16 attribute [MarketingOperationsMV].[Roles].[role_name]  Team Team ID float64 identifier [MarketingOperationsDS].[UAP_TEAMS].[TEAM_ID]  Team Name characterLength16 attribute [MarketingOperationsDS].[UAP_TEAMS].[NAME]  Team Description characterLength16 attribute [MarketingOperationsDS].[UAP_TEAMS].[DESCRIPTION]  Team Skillsets characterLength16 attribute [MarketingOperationsDS].[UAP_TEAMS].[SKILLSETS]  Team Status ID float64 identifier [MarketingOperationsDS].[UAP_TEAMS].[STATUS]  Team Member Team ID float64 identifier [MarketingOperationsDS].[UAP_TEAM_MEMBERS].[TEAM_ID]  Team Member ID float64 identifier [MarketingOperationsDS].[UAP_TEAM_MEMBERS].[USER_ID]  Team Member Type ID float64 identifier [MarketingOperationsDS].[UAP_TEAM_MEMBERS].[MEM_TYPE_ID]  List Definitions Vendor Vendor ID float64 identifier [MarketingOperationsDS].[uap_ml_vendor].[VENDOR_ID]  Vendor Code characterLength16 attribute [MarketingOperationsDS].[uap_ml_vendor].[CODE]  Vendor Name characterLength16 attribute [MarketingOperationsDS].[uap_ml_vendor].[NAME]  Vendor Display characterLength16 attribute [MarketingOperationsDS].[uap_ml_vendor].[DISPLAY]  Program Area Program Area ID float64 identifier [MarketingOperationsDS].[uap_prgm_area].[PRGM_AREA_ID]  Program Area Name characterLength16 attribute [MarketingOperationsDS].[uap_prgm_area].[NAME]  Cost Category Cost Category ID float64 identifier [MarketingOperationsDS].[uap_ml_cost_cat].[COST_CAT_ID]  Cost Category Code characterLength16 attribute [MarketingOperationsDS].[uap_ml_cost_cat].[CODE]  Cost Category Name characterLength16 attribute [MarketingOperationsDS].[uap_ml_cost_cat].[NAME]  Cost Category Display characterLength16 attribute [MarketingOperationsDS].[uap_ml_cost_cat].[DISPLAY]  Projects Project User   (shortcut)   [MarketingOperationsMV].[User] Shortcut to Task   (shortcut)   [MarketingOperationsMV].[Task] Projects Project Project ID float64 identifier [MarketingOperationsDS].[uap_projects].[PROJECT_ID]  Project Name characterLength16 attribute [MarketingOperationsDS].[uap_projects].[NAME]  Project Code characterLength16 attribute [MarketingOperationsDS].[uap_projects].[PROJ_CODE]  Project Description characterLength16 attribute [MarketingOperationsDS].[uap_projects].[DESCRIPTION]  Project Start Date dateTime identifier [MarketingOperationsDS].[uap_projects].[START_DATE]  Project End Date dateTime identifier [MarketingOperationsDS].[uap_projects].[END_DATE]  Project Actual Start Date dateTime identifier [MarketingOperationsDS].[uap_projects].[ACTUAL_ST_DATE]  Project Actual End Date dateTime identifier [MarketingOperationsDS].[uap_projects].[ACTUAL_END_DATE]  Project Status characterLength16 attribute [MarketingOperationsDS].[uap_projects].[STATE_CODE]  Project URL characterLength16 attribute #sq($[Environment]{'URL'})# + 'type=project&id=' + cast(cast([MarketingOperationsMV].[Project].[Project ID], integer), varchar(10))  Project Name (Code) characterLength16 attribute [MarketingOperationsMV].[Project].[Project Name] + ' (' + [MarketingOperationsMV].[Project].[Project Code] + ')'  Project Request Flag characterLength16 attribute [MarketingOperationsDS].[uap_projects].[FLAG_PROJ_REQUEST]  Template Name characterLength16 attribute [MarketingOperationsDS].[uap_projects].[TEMPLATE_NAME]  Project Requests Project ID float64 identifier [MarketingOperationsDS].[uap_projects].[PROJECT_ID]  Project Name characterLength16 attribute [MarketingOperationsDS].[uap_projects].[NAME]  Project Code characterLength16 attribute [MarketingOperationsDS].[uap_projects].[PROJ_CODE]  Project Description characterLength16 attribute [MarketingOperationsDS].[uap_projects].[DESCRIPTION]  Project Start Date dateTime identifier [MarketingOperationsDS].[uap_projects].[START_DATE]  Project End Date dateTime identifier [MarketingOperationsDS].[uap_projects].[END_DATE]  Project Actual Start Date dateTime identifier [MarketingOperationsDS].[uap_projects].[ACTUAL_ST_DATE]  Project Actual End Date dateTime identifier [MarketingOperationsDS].[uap_projects].[ACTUAL_END_DATE]  Project Request Status characterLength16 attribute [MarketingOperationsDS].[uap_projects].[STATE_CODE]  Project Request URL characterLength16 attribute #sq($[Environment]{'URL'})# + 'type=projectrequest&id=' + cast(cast([MarketingOperationsMV].[Project Requests].[Project ID], integer), varchar(10))  Project Name (Code) characterLength16 attribute [MarketingOperationsMV].[Project Requests].[Project Name] + ' (' + [MarketingOperationsMV].[Project Requests].[Project Code] + ')'  Project Request Flag characterLength16 attribute [MarketingOperationsDS].[uap_projects].[FLAG_PROJ_REQUEST]  Project Request ID float64 identifier [MarketingOperationsDS].[uap_projects].[PROJ_REQUEST_ID]  Request Submit Date dateTime identifier [MarketingOperationsDS].[uap_projects].[REQ_SUBMIT_DATE]  Request Complete Date dateTime identifier [MarketingOperationsDS].[uap_projects].[REQ_COMP_DATE]  Template Name characterLength16 attribute [MarketingOperationsDS].[uap_projects].[TEMPLATE_NAME]  Project Owner Project ID float64 identifier [MarketingOperationsDS].[uap_proj_users].[PROJECT_ID]  User ID float64 identifier [MarketingOperationsDS].[uap_proj_users].[USER_ID]  Member Type ID float64 identifier [MarketingOperationsDS].[uap_proj_users].[MEM_TYPE_ID]  Project Member Project ID float64 identifier [MarketingOperationsDS].[uap_proj_users].[PROJECT_ID]  User ID float64 identifier [MarketingOperationsDS].[uap_proj_users].[USER_ID]  Member Type ID float64 identifier [MarketingOperationsDS].[uap_proj_users].[MEM_TYPE_ID]  Project Status Status Code characterLength16 identifier [MarketingOperationsDS].[uap_status].[STATUS_CODE]  Status characterLength16 attribute [MarketingOperationsDS].[uap_status].[STATUS_DESC]  Project Approval Approval ID float64 identifier [MarketingOperationsDS].[UAP_APPROVALS].[APPROVAL_ID]  Approval Name characterLength16 attribute [MarketingOperationsDS].[UAP_APPROVALS].[NAME]  Approval Description characterLength16 attribute [MarketingOperationsDS].[UAP_APPROVALS].[DESCRIPTION]  Approval Status Code characterLength16 attribute [MarketingOperationsDS].[UAP_APPROVALS].[STATE_CODE]  Approval Date dateTime attribute [MarketingOperationsDS].[UAP_APPROVALS].[APPROVAL_DATE]  Project ID float64 attribute [MarketingOperationsDS].[UAP_APPROVALS].[SRC_OBJECT_ID]  Workflow Task ID float64 attribute [MarketingOperationsDS].[UAP_APPROVALS].[SRC_WF_STEP]  Project Template Template ID float64 identifier [MarketingOperationsMV].[Template].[Template ID]  Object Type float64 attribute [MarketingOperationsMV].[Template].[Object Type]  Template Name characterLength16 attribute [MarketingOperationsMV].[Template].[Template Name]  Template Display characterLength16 attribute [MarketingOperationsMV].[Template].[Template Display]  Template Instance Display characterLength16 attribute [MarketingOperationsMV].[Template].[Template Instance Display]  Namespace/Folder Query Subject Query Item Type Usage Ref Obj/Expr. Workflow Task Parent Project   (shortcut)   [MarketingOperationsMV].[Project] Stage Parent Project   (shortcut)   [MarketingOperationsMV].[Project] Task User   (shortcut)   [MarketingOperationsMV].[User] Workflow Task Status Status Code characterLength16 identifier [MarketingOperationsDS].[uap_status].[STATUS_CODE]  Status characterLength16 attribute [MarketingOperationsDS].[uap_status].[STATUS_DESC]  Milestone Milestone Type ID float64 identifier [MarketingOperationsDS].[uap_wf_milestone].[MILESTONE_TYPE]  Milestone characterLength16 attribute [MarketingOperationsDS].[uap_wf_milestone].[MILESTONE_DESC]  Task Task ID float64 identifier [MarketingOperationsDS].[uap_workflow].[WF_NO]  Task Number characterLength16 attribute [MarketingOperationsDS].[uap_workflow].[DISPLAY_ID]  Task Name characterLength16 attribute [MarketingOperationsDS].[uap_workflow].[NAME]  Status characterLength16 attribute IF([MarketingOperationsDS].[uap_workflow].[STATUS_CODE]='' or [MarketingOperationsDS].[uap_workflow].[STATUS_CODE] is null) THEN ('PENDING') ELSE([MarketingOperationsDS].[uap_workflow].[STATUS_CODE])  % Complete float64 attribute [MarketingOperationsDS].[uap_workflow].[PCNT_COMP]  Forecast/Actual Start dateTime attribute [MarketingOperationsDS].[uap_workflow].[FORECAST_ST]  Forecast/Actual End dateTime attribute [MarketingOperationsDS].[uap_workflow].[FORECAST_END]  Duration float64 attribute [MarketingOperationsDS].[uap_workflow].[DURATION]  Duration String characterLength16 attribute [MarketingOperationsDS].[uap_workflow].[DURATION_STR]  Actual Duration float64 attribute [MarketingOperationsDS].[uap_workflow].[ACTUAL_DURATION]  Actual Duration String characterLength16 attribute [MarketingOperationsDS].[uap_workflow].[ACTUAL_DURATION_STR]  Anchor? characterLength16 attribute [MarketingOperationsDS].[uap_workflow].[FLAG_ANCHOR]  Start Date dateTime attribute [MarketingOperationsDS].[uap_workflow].[START_DATE]  End Date dateTime attribute [MarketingOperationsDS].[uap_workflow].[END_DATE]  Milestone Type ID float64 attribute [MarketingOperationsDS].[uap_workflow].[MILESTONE_TYPE]  Notes characterLength16 attribute [MarketingOperationsDS].[uap_workflow].[NOTES]  Project ID float64 attribute [MarketingOperationsDS].[uap_workflow].[PROJECT_ID]  Parent Stage ID float64 attribute [MarketingOperationsDS].[uap_workflow].[PARENT_STAGE]  Link? characterLength16 attribute [MarketingOperationsDS].[uap_workflow].[FLAG_LINK]  Link ID float64 attribute [MarketingOperationsDS].[uap_workflow].[LINK_ID]  Link Object characterLength16 attribute [MarketingOperationsDS].[uap_workflow].[LINK_OBJECT]  Task Number Name characterLength16 attribute [MarketingOperationsMV].[Task].[Task Number] + ' ' + [MarketingOperationsMV].[Task].[Task Name]   Effort float64 fact [MarketingOperationsDS].[uap_workflow].[EFFORT]  Effort String characterLength16 attribute [MarketingOperationsDS].[uap_workflow].[EFFORT_STR]  Forecast/Actual Effort float64 fact [MarketingOperationsDS].[uap_workflow].[ACTUAL_EFFORT]  Forecast/Actual Effort String characterLength16 attribute [MarketingOperationsDS].[uap_workflow].[ACTUAL_EFFORT_STR]  Task URL characterLength16 attribute #sq($[Environment]{'URL'})# + 'type=task&id=' + cast(cast([MarketingOperationsMV].[Task].[Task ID] ,integer),varchar(10))  Stage Stage ID float64 identifier [MarketingOperationsDS].[uap_workflow].[WF_NO]  Stage Number float64 attribute [MarketingOperationsDS].[uap_workflow].[DISPLAY_ORDER]  Stage Name characterLength16 attribute [MarketingOperationsDS].[uap_workflow].[NAME]  Project ID float64 attribute [MarketingOperationsDS].[uap_workflow].[PROJECT_ID]  Task Member Task ID float64 identifier [MarketingOperationsDS].[uap_wf_users].[WF_NO]  User ID float64 identifier [MarketingOperationsDS].[uap_wf_users].[USER_ID]  Project Budgets Project Budget Reference   (shortcut)   [MarketingOperationsMV].[Budget] Project Budget Amount   (shortcut)   [MarketingOperationsMV].[Budget Amount] Project Budgets Project Line Item Project ID float64 identifier [MarketingOperationsDS].[uap_proj_cost].[PROJECT_ID]  Cost Item ID float64 identifier [MarketingOperationsDS].[uap_proj_cost].[COST_ITEM_ID]  Version ID float64 attribute [MarketingOperationsDS].[uap_proj_cost].[VERSION_ID]  Cost Item Number float64 attribute [MarketingOperationsDS].[uap_proj_cost].[COST_ITEM_NO]  Account ID float64 attribute [MarketingOperationsDS].[uap_proj_cost].[ACCOUNT_ID]  Account Code characterLength16 attribute [MarketingOperationsDS].[uap_proj_cost].[ACCOUNT_CODE]  Forecast Amount float64 fact [MarketingOperationsDS].[uap_proj_cost].[FORECAST_AMT]  Committed Amount float64 fact [MarketingOperationsDS].[uap_proj_cost].[COMMITTED_AMT]  Expenditure Date dateTime attribute [MarketingOperationsDS].[uap_proj_cost].[EXPENDITURE_DATE]  Cost Category ID float64 attribute [MarketingOperationsDS].[uap_proj_cost].[COST_CAT_ID]  Cost Category Code characterLength16 attribute [MarketingOperationsDS].[uap_proj_cost].[COST_CAT_CODE]  Item Description characterLength16 attribute [MarketingOperationsDS].[uap_proj_cost].[COST_ITEM_DESC]  Project Invoice Line Item Invoice ID float64 identifier [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[INVOICE_ID]  Cost Item ID float64 identifier [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[COST_ITEM_ID]  Cost Item Number float64 attribute [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[COST_ITEM_NO]  Cost Item Description characterLength16 attribute [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[COST_ITEM_DESC]  Source Object Type characterLength16 attribute [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[SRC_OBJ_TYPE]  Source Object ID float64 attribute [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[SRC_OBJ_ID]  Source Object Code characterLength16 attribute [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[SRC_OBJ_CODE]  Account ID float64 attribute [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[ACCOUNT_ID]  Account Code characterLength16 attribute [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[ACCOUNT_CODE]  Cost Category ID float64 attribute [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[COST_CAT_ID]  Cost Category Code characterLength16 attribute [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[COST_CAT_CODE]  Quantity float64 fact [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[QUANTITY]  Unit Cost float64 fact [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[UNIT_COST]  Item Cost float64 fact [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[ITEM_COST]  Project Invoice Cost Project ID float64 attribute [MarketingOperationsMV].[Project Invoice Line Item].[Source Object ID]  Invoice ID float64 identifier [MarketingOperationsMV].[Project Invoice Line Item].[Invoice ID]  Invoice Number characterLength16 attribute [MarketingOperationsMV].[Invoice].[Invoice Number]  Invoice URL characterLength16 attribute [MarketingOperationsMV].[Invoice].[Invoice URL]  Vendor Display characterLength16 attribute [MarketingOperationsMV].[Vendor].[Vendor Display]  Expenditure Date dateTime identifier if ([MarketingOperationsMV].[Invoice].[Paid Date] = null) THEN ([MarketingOperationsMV].[Invoice].[Due Date]) ELSE ([MarketingOperationsMV].[Invoice].[Paid Date] )  Cost Item ID float64 identifier [MarketingOperationsMV].[Project Invoice Line Item].[Cost Item ID]  Cost Item Number float64 attribute [MarketingOperationsMV].[Project Invoice Line Item].[Cost Item Number]  Cost Item Description characterLength16 attribute [MarketingOperationsMV].[Project Invoice Line Item].[Cost Item Description]  Account ID float64 attribute [MarketingOperationsMV].[Project Invoice Line Item].[Account ID]  Cost Category ID float64 attribute [MarketingOperationsMV].[Project Invoice Line Item].[Cost Category ID]  Cost Category Display characterLength16 attribute [MarketingOperationsMV].[Cost Category].[Cost Category Display]  Item Cost float64 fact [MarketingOperationsMV].[Project Invoice Line Item].[Item Cost]  Quarter for Project Line Item Quarter ID float64 identifier [MarketingOperationsDS].[uap_quarters].[QUARTER_ID]  Year float64 identifier [MarketingOperationsDS].[uap_quarters].[YEAR]  Month float64 identifier [MarketingOperationsDS].[uap_quarters].[MONTH]  Quarter Description characterLength16 attribute [MarketingOperationsDS].[uap_quarters].[DESCRIPTION]  Quarter Year characterLength16 attribute substring ([MarketingOperationsMV].[Quarter for Project Line Item].[Quarter Description] , position ( '(' , [MarketingOperationsMV].[Quarter for Project Line Item].[Quarter Description] ) + 1, 7)  Month Year characterLength16 attribute substring ( [MarketingOperationsMV].[Quarter for Project Line Item].[Quarter Description], 0, position('(', [MarketingOperationsMV].[Quarter for Project Line Item].[Quarter Description]) - 1)  Quarter for Project Invoice Cost Quarter ID float64 identifier [MarketingOperationsDS].[uap_quarters].[QUARTER_ID]  Year float64 identifier [MarketingOperationsDS].[uap_quarters].[YEAR]  Month float64 identifier [MarketingOperationsDS].[uap_quarters].[MONTH]  Quarter Description characterLength16 attribute [MarketingOperationsDS].[uap_quarters].[DESCRIPTION]  Quarter Year characterLength16 attribute substring ([MarketingOperationsMV].[Quarter for Project Invoice Cost].[Quarter Description] , position ( '(' , [MarketingOperationsMV].[Quarter for Project Invoice Cost].[Quarter Description] ) + 1, 7)  Month Year characterLength16 attribute substring ( [MarketingOperationsMV].[Quarter for Project Invoice Cost].[Quarter Description], 0, position('(', [MarketingOperationsMV].[Quarter for Project Invoice Cost].[Quarter Description]) - 1)  Project Budget Budget ID float64 identifier [MarketingOperationsDS].[uap_proj_budget].[BUDGET_ID]  Project ID float64 identifier [MarketingOperationsDS].[uap_proj_budget].[PROJECT_ID]  Budget Total float64 fact [MarketingOperationsDS].[uap_proj_budget].[BUDGET_TOTAL]  Forecast Total float64 fact [MarketingOperationsDS].[uap_proj_budget].[FORECAST_TOTAL]  Actual Total float64 fact [MarketingOperationsDS].[uap_proj_budget].[ACTUAL_TOTAL]  Committed Total float64 fact [MarketingOperationsDS].[uap_proj_budget].[COMMITTED_TOTAL]  Committed Remaining Amount float64 fact [MarketingOperationsMV].[Project Budget].[Budget Total] - [MarketingOperationsMV].[Project Budget].[Committed Total]   Forecast Remaining Amount float64 fact [MarketingOperationsMV].[Project Budget].[Budget Total] - [MarketingOperationsMV].[Project Budget].[Forecast Total]   Actual Remaining Amount float64 fact [MarketingOperationsMV].[Project Budget].[Budget Total] - [MarketingOperationsMV].[Project Budget].[Actual Total]   Project Metrics Project Metric Metric ID characterLength16 identifier [MarketingOperationsDS].[uap_proj_metrics].[METRIC_ID]  Metric Name characterLength16 attribute [MarketingOperationsDS].[uap_proj_metrics].[DISPLAY_NAME]  Display Order float64 fact [MarketingOperationsDS].[uap_proj_metrics].[DISPLAY_ORDER]  Units characterLength16 attribute [MarketingOperationsDS].[uap_proj_metrics].[UNITS]  Input Method characterLength16 attribute [MarketingOperationsDS].[uap_proj_metrics].[INPUT_METHOD]  Display Format characterLength16 attribute [MarketingOperationsDS].[uap_proj_metrics].[DISPLAY_FORMAT]  Metric Value 1 float64 fact [MarketingOperationsDS].[uap_proj_metrics].[METRIC_VALUE1]  Metric Value 3 float64 fact [MarketingOperationsDS].[uap_proj_metrics].[METRIC_VALUE3]  Metric Value 2 float64 fact [MarketingOperationsDS].[uap_proj_metrics].[METRIC_VALUE2]  Metric Description characterLength16 attribute [MarketingOperationsDS].[uap_proj_metrics].[DESCRIPTION]  Formula characterLength16 attribute [MarketingOperationsDS].[uap_proj_metrics].[FORMULA]  Metric Value 4 float64 fact [MarketingOperationsDS].[uap_proj_metrics].[METRIC_VALUE4]  Metric Precision float64 fact [MarketingOperationsDS].[uap_proj_metrics].[METRIC_PRECISION]  Metric Value 5 float64 fact [MarketingOperationsDS].[uap_proj_metrics].[METRIC_VALUE5]  Metric Columns float64 fact [MarketingOperationsDS].[uap_proj_metrics].[METRIC_COLUMNS]  Project ID float64 identifier [MarketingOperationsDS].[uap_proj_metrics].[PROJECT_ID]  Metric Group ID characterLength16 attribute [MarketingOperationsDS].[uap_proj_metrics].[GRP_ID]  Metric NaN 1 characterLength16 attribute [MarketingOperationsDS].[uap_proj_metrics].[METRIC1_NAN]  Metric NaN 2 characterLength16 attribute [MarketingOperationsDS].[uap_proj_metrics].[METRIC2_NAN]  Metric NaN 3 characterLength16 attribute [MarketingOperationsDS].[uap_proj_metrics].[METRIC3_NAN]  Metric NaN 4 characterLength16 attribute [MarketingOperationsDS].[uap_proj_metrics].[METRIC4_NAN]  Metric NaN 5 characterLength16 attribute [MarketingOperationsDS].[uap_proj_metrics].[METRIC5_NAN]  Planned Value float64 fact [MarketingOperationsDS].[uap_proj_metrics].[PLANNED_VALUE]  Planed NaN characterLength16 attribute [MarketingOperationsDS].[uap_proj_metrics].[PLANNED_NAN]  Is Planned Value? characterLength16 attribute [MarketingOperationsDS].[uap_proj_metrics].[IS_PLANNED_VALUE]  Show as Rollup? characterLength16 attribute [MarketingOperationsDS].[uap_proj_metrics].[SHOW_AS_ROLLUP]  Is Visible? characterLength16 attribute [MarketingOperationsDS].[uap_proj_metrics].[IS_VISIBLE]  Project Metrics New Project ID float64 identifier [MarketingOperationsMV].[Project Metric].[Project ID]  Metric ID characterLength16 identifier [MarketingOperationsMV].[Project Metric].[Metric ID]  Metric Name characterLength16 attribute [MarketingOperationsMV].[Project Metric].[Metric Name]  Display Order float64 fact [MarketingOperationsMV].[Project Metric].[Display Order]  Display Format characterLength16 attribute [MarketingOperationsMV].[Project Metric].[Display Format]  Project Metric Column Project ID float64 identifier [MarketingOperationsDS].[uap_metric_cols].[PROJECT_ID]  Column Taborder float64 identifier [MarketingOperationsDS].[uap_metric_cols].[COL_TABORDER]  Column Display characterLength16 attribute [MarketingOperationsDS].[uap_metric_cols].[COL_DISPLAY]  Is Target? characterLength16 attribute [MarketingOperationsDS].[uap_metric_cols].[FLAG_TARGET]  Dimension Type characterLength16 attribute [MarketingOperationsDS].[uap_metric_cols].[DIMENSION_TYPE]  Project Metric Column Value Project ID float64 identifier [MarketingOperationsMV].[Project Metric].[Project ID]  Metric ID characterLength16 identifier [MarketingOperationsMV].[Project Metric].[Metric ID]  Metric Name characterLength16 attribute [MarketingOperationsMV].[Project Metric].[Metric Name]  Display Format characterLength16 attribute [MarketingOperationsMV].[Project Metrics New].[Display Format]  Display Order float64 fact [MarketingOperationsMV].[Project Metrics New].[Display Order]  Column Display characterLength16 attribute [MarketingOperationsMV].[Project Metric Column].[Column Display]  Metric Value float64 fact if ([MarketingOperationsMV].[Project Metric Column].[Column Taborder] = 0) then ([MarketingOperationsMV].[Project Metric].[Metric Value 1] ) else if ([MarketingOperationsMV].[Project Metric Column].[Column Taborder] = 1) then ([MarketingOperationsMV].[Project Metric].[Metric Value 3] ) else if ([MarketingOperationsMV].[Project Metric Column].[Column Taborder] = 2) then ([MarketingOperationsMV].[Project Metric].[Metric Value 2] ) else if ([MarketingOperationsMV].[Project Metric Column].[Column Taborder] = 3) then ([MarketingOperationsMV].[Project Metric].[Metric Value 4] ) else ([MarketingOperationsMV].[Project Metric].[Metric Value 5] )   Is Target? characterLength16 attribute [MarketingOperationsMV].[Project Metric Column].[Is Target?]  Dimension Type characterLength16 attribute [MarketingOperationsMV].[Project Metric Column].[Dimension Type]  Column Taborder float64 identifier [MarketingOperationsMV].[Project Metric Column].[Column Taborder]  Project Performance Summary Metrics PROJECT ID float64 fact   DISPLAY FORMAT METRIC1 characterLength16 attribute   ACTUAL VALUE METRIC1 float64 fact   TARGET VALUE METRIC1 float64 fact   OPTIMISTIC VALUE METRIC1 float64 fact   PESSIMISTIC VALUE METRIC1 float64 fact   DISPLAY FORMAT METRIC2 characterLength16 attribute   ACTUAL VALUE METRIC2 float64 fact   TARGET VALUE METRIC2 float64 fact   OPTIMISTIC VALUE METRIC2 float64 fact   PESSIMISTIC VALUE METRIC2 float64 fact   DISPLAY FORMAT METRIC3 characterLength16 attribute   ACTUAL VALUE METRIC3 float64 fact   TARGET VALUE METRIC3 float64 fact   OPTIMISTIC VALUE METRIC3 float64 fact   PESSIMISTIC VALUE METRIC3 float64 fact   DISPLAY FORMAT METRIC4 characterLength16 attribute   ACTUAL VALUE METRIC4 float64 fact   TARGET VALUE METRIC4 float64 fact   OPTIMISTIC VALUE METRIC4 float64 fact   PESSIMISTIC VALUE METRIC4 float64 fact   DISPLAY FORMAT METRIC5 characterLength16 attribute   ACTUAL VALUE METRIC5 float64 fact   TARGET VALUE METRIC5 float64 fact   OPTIMISTIC VALUE METRIC5 float64 fact   PESSIMISTIC VALUE METRIC5 float64 fact   Programs Program Project   (shortcut)   [MarketingOperationsMV].[Project] Program User   (shortcut)   [MarketingOperationsMV].[User] Programs Program Program ID float64 identifier [MarketingOperationsDS].[uap_programs].[PROGRAM_ID]  Program Name characterLength16 attribute [MarketingOperationsDS].[uap_programs].[NAME]  Program Code characterLength16 attribute [MarketingOperationsDS].[uap_programs].[PROGRAM_CODE]  Program Description characterLength16 attribute [MarketingOperationsDS].[uap_programs].[DESCRIPTION]  Program Start Date dateTime attribute [MarketingOperationsDS].[uap_programs].[START_DATE]  Program End Date dateTime attribute [MarketingOperationsDS].[uap_programs].[END_DATE]  Program Status characterLength16 attribute [MarketingOperationsDS].[uap_programs].[STATE_CODE]  Program Name (Code) characterLength16 attribute [MarketingOperationsMV].[Program].[Program Name] + ' (' + [MarketingOperationsMV].[Program].[Program Code] + ')'  Template Name characterLength16 attribute [MarketingOperationsDS].[uap_programs].[TEMPLATE_NAME]  Program Project Ref Project ID float64 identifier [MarketingOperationsDS].[uap_prgrm_project].[PROJECT_ID]  Program ID float64 identifier [MarketingOperationsDS].[uap_prgrm_project].[PROGRAM_ID]  Program Owner Program ID float64 identifier [MarketingOperationsDS].[uap_prgrm_users].[PROGRAM_ID]  User ID float64 identifier [MarketingOperationsDS].[uap_prgrm_users].[USER_ID]  Member Type ID float64 identifier [MarketingOperationsDS].[uap_prgrm_users].[MEM_TYPE_ID]  Program Member Program ID float64 identifier [MarketingOperationsDS].[uap_prgrm_users].[PROGRAM_ID]  User ID float64 identifier [MarketingOperationsDS].[uap_prgrm_users].[USER_ID]  Member Type ID float64 identifier [MarketingOperationsDS].[uap_prgrm_users].[MEM_TYPE_ID]  Program Template Template ID float64 identifier [MarketingOperationsMV].[Template].[Template ID]  Object Type float64 attribute [MarketingOperationsMV].[Template].[Object Type]  Template Name characterLength16 attribute [MarketingOperationsMV].[Template].[Template Name]  Template Display characterLength16 attribute [MarketingOperationsMV].[Template].[Template Display]  Namespace/Folder Query Subject Query Item Type Usage Ref Obj/Expr. Program Budgets Program Budget Reference   (shortcut)   [MarketingOperationsMV].[Budget] Program Budget Amount   (shortcut)   [MarketingOperationsMV].[Budget Amount] Quarter for Program Invoice Cost   (shortcut)   [MarketingOperationsMV].[Quarter] Quarter for Program Line Item   (shortcut)   [MarketingOperationsMV].[Quarter] Program Budgets Program Budget Budget ID float64 identifier [MarketingOperationsDS].[uap_prgrm_budget].[BUDGET_ID]  Program ID float64 identifier [MarketingOperationsDS].[uap_prgrm_budget].[PROGRAM_ID]  Budget Total float64 fact [MarketingOperationsDS].[uap_prgrm_budget].[BUDGET_TOTAL]  Forecast Total float64 fact [MarketingOperationsDS].[uap_prgrm_budget].[FORECAST_TOTAL]  Actual Total float64 fact [MarketingOperationsDS].[uap_prgrm_budget].[ACTUAL_TOTAL]  Committed Total float64 fact [MarketingOperationsDS].[uap_prgrm_budget].[COMMITTED_TOTAL]  Allocation Total float64 fact [MarketingOperationsDS].[uap_prgrm_budget].[ALLOC_TOTAL]  Finalized Date dateTime attribute [MarketingOperationsDS].[uap_prgrm_budget].[FINALIZED_DATE]  Program Invoice Line Item Invoice ID float64 identifier [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[INVOICE_ID]  Cost Item ID float64 identifier [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[COST_ITEM_ID]  Cost Item Number float64 attribute [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[COST_ITEM_NO]  Item Description characterLength16 attribute [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[COST_ITEM_DESC]  Source Object Type characterLength16 attribute [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[SRC_OBJ_TYPE]  Source Object ID float64 attribute [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[SRC_OBJ_ID]  Source Object Code characterLength16 attribute [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[SRC_OBJ_CODE]  Account ID float64 attribute [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[ACCOUNT_ID]  Account Code characterLength16 attribute [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[ACCOUNT_CODE]  Cost Category ID float64 attribute [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[COST_CAT_ID]  Cost Category Code characterLength16 attribute [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[COST_CAT_CODE]  Quantity float64 fact [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[QUANTITY]  Unit Cost float64 fact [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[UNIT_COST]  Item Cost float64 fact [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[ITEM_COST]  Program Invoice Cost Program ID float64 identifier [MarketingOperationsMV].[Program].[Program ID]  Invoice ID float64 identifier [MarketingOperationsMV].[Program Invoice Line Item].[Invoice ID]  Invoice Number characterLength16 attribute [MarketingOperationsMV].[Invoice].[Invoice Number]  Vendor Display characterLength16 attribute [MarketingOperationsMV].[Vendor].[Vendor Display]  Expenditure Date dateTime attribute [MarketingOperationsMV].[Invoice].[Paid Date]  Cost Item ID float64 identifier [MarketingOperationsMV].[Program Invoice Line Item].[Cost Item ID]  Cost Item Number float64 attribute [MarketingOperationsMV].[Program Invoice Line Item].[Cost Item Number]  Item Description characterLength16 attribute [MarketingOperationsMV].[Program Invoice Line Item].[Item Description]  Account ID float64 attribute [MarketingOperationsMV].[Program Invoice Line Item].[Account ID]  Account Name (Code) characterLength16 attribute [MarketingOperationsMV].[Account].[Account Name (Code)]  Cost Category ID float64 attribute [MarketingOperationsMV].[Program Invoice Line Item].[Cost Category ID]  Cost Category Display characterLength16 attribute [MarketingOperationsMV].[Cost Category].[Cost Category Display]  Item Cost float64 fact [MarketingOperationsMV].[Program Invoice Line Item].[Item Cost]  Program Line Item Program ID float64 identifier [MarketingOperationsDS].[uap_prgrm_cost].[PROGRAM_ID]  Cost Item ID float64 identifier [MarketingOperationsDS].[uap_prgrm_cost].[COST_ITEM_ID]  Version ID float64 attribute [MarketingOperationsDS].[uap_prgrm_cost].[VERSION_ID]  Cost Item Number float64 attribute [MarketingOperationsDS].[uap_prgrm_cost].[COST_ITEM_NO]  Cost Item Description characterLength16 attribute [MarketingOperationsDS].[uap_prgrm_cost].[COST_ITEM_DESC]  Account ID float64 attribute [MarketingOperationsDS].[uap_prgrm_cost].[ACCOUNT_ID]  Account Code characterLength16 attribute [MarketingOperationsDS].[uap_prgrm_cost].[ACCOUNT_CODE]  Forecast Amount float64 fact [MarketingOperationsDS].[uap_prgrm_cost].[FORECAST_AMT]  Committed Amount float64 fact [MarketingOperationsDS].[uap_prgrm_cost].[COMMITTED_AMT]  Expenditure Date dateTime attribute [MarketingOperationsDS].[uap_prgrm_cost].[EXPENDITURE_DATE]  Cost Category ID float64 attribute [MarketingOperationsDS].[uap_prgrm_cost].[COST_CAT_ID]  Cost Category Code characterLength16 attribute [MarketingOperationsDS].[uap_prgrm_cost].[COST_CAT_CODE]  Program Metrics Program Metric program_id float64 identifier [MarketingOperationsDS].[uap_prgrm_metrics].[PROGRAM_ID]  metric_id characterLength16 identifier [MarketingOperationsDS].[uap_prgrm_metrics].[METRIC_ID]  show_as_rollup characterLength16 identifier [MarketingOperationsDS].[uap_prgrm_metrics].[SHOW_AS_ROLLUP]  display_name characterLength16 attribute [MarketingOperationsDS].[uap_prgrm_metrics].[DISPLAY_NAME]  display_order float64 fact [MarketingOperationsDS].[uap_prgrm_metrics].[DISPLAY_ORDER]  input_method characterLength16 attribute [MarketingOperationsDS].[uap_prgrm_metrics].[INPUT_METHOD]  formula characterLength16 attribute [MarketingOperationsDS].[uap_prgrm_metrics].[FORMULA]  units characterLength16 attribute [MarketingOperationsDS].[uap_prgrm_metrics].[UNITS]  display_format characterLength16 attribute [MarketingOperationsDS].[uap_prgrm_metrics].[DISPLAY_FORMAT]  metric_precision float64 fact [MarketingOperationsDS].[uap_prgrm_metrics].[METRIC_PRECISION]  description characterLength16 attribute [MarketingOperationsDS].[uap_prgrm_metrics].[DESCRIPTION]  metric_columns float64 fact [MarketingOperationsDS].[uap_prgrm_metrics].[METRIC_COLUMNS]  metric_value1 float64 fact [MarketingOperationsDS].[uap_prgrm_metrics].[METRIC_VALUE1]  metric_value2 float64 fact [MarketingOperationsDS].[uap_prgrm_metrics].[METRIC_VALUE2]  metric_value3 float64 fact [MarketingOperationsDS].[uap_prgrm_metrics].[METRIC_VALUE3]  metric_value4 float64 fact [MarketingOperationsDS].[uap_prgrm_metrics].[METRIC_VALUE4]  metric_value5 float64 fact [MarketingOperationsDS].[uap_prgrm_metrics].[METRIC_VALUE5]  metric_rollup1 float64 fact [MarketingOperationsDS].[uap_prgrm_metrics].[METRIC_ROLLUP1]  metric_rollup2 float64 fact [MarketingOperationsDS].[uap_prgrm_metrics].[METRIC_ROLLUP2]  metric_rollup3 float64 fact [MarketingOperationsDS].[uap_prgrm_metrics].[METRIC_ROLLUP3]  metric_rollup4 float64 fact [MarketingOperationsDS].[uap_prgrm_metrics].[METRIC_ROLLUP4]  metric_rollup5 float64 fact [MarketingOperationsDS].[uap_prgrm_metrics].[METRIC_ROLLUP5]  metric1_nan characterLength16 attribute [MarketingOperationsDS].[uap_prgrm_metrics].[METRIC1_NAN]  metric2_nan characterLength16 attribute [MarketingOperationsDS].[uap_prgrm_metrics].[METRIC2_NAN]  metric3_nan characterLength16 attribute [MarketingOperationsDS].[uap_prgrm_metrics].[METRIC3_NAN]  metric4_nan characterLength16 attribute [MarketingOperationsDS].[uap_prgrm_metrics].[METRIC4_NAN]  metric5_nan characterLength16 attribute [MarketingOperationsDS].[uap_prgrm_metrics].[METRIC5_NAN]  planned_value float64 fact [MarketingOperationsDS].[uap_prgrm_metrics].[PLANNED_VALUE]  planned_nan characterLength16 attribute [MarketingOperationsDS].[uap_prgrm_metrics].[PLANNED_NAN]  grp_id characterLength16 attribute [MarketingOperationsDS].[uap_prgrm_metrics].[GRP_ID]  is_planned_value characterLength16 attribute [MarketingOperationsDS].[uap_prgrm_metrics].[IS_PLANNED_VALUE]  alloc_total float64 fact [MarketingOperationsDS].[uap_prgrm_metrics].[ALLOC_TOTAL]  is_visible characterLength16 attribute [MarketingOperationsDS].[uap_prgrm_metrics].[IS_VISIBLE]  Plans Plan Program   (shortcut)   [MarketingOperationsMV].[Program] Plan Program Area   (shortcut)   [MarketingOperationsMV].[Program Area] Plan User   (shortcut)   [MarketingOperationsMV].[User] Plans Plan Plan ID float64 fact [MarketingOperationsDS].[uap_plans].[PLAN_ID]  Plan Code characterLength16 attribute [MarketingOperationsDS].[uap_plans].[PLAN_CODE]  Plan Name characterLength16 attribute [MarketingOperationsDS].[uap_plans].[NAME]  Plan Description characterLength16 attribute [MarketingOperationsDS].[uap_plans].[DESCRIPTION]  Plan Status Code characterLength16 attribute [MarketingOperationsDS].[uap_plans].[STATE_CODE]  Plan Fiscal Year float64 attribute [MarketingOperationsDS].[uap_plans].[FISCAL_YEAR]  Plan Business Area ID float64 attribute [MarketingOperationsDS].[uap_plans].[BUS_AREA_ID]  Start Date dateTime attribute [MarketingOperationsDS].[uap_plans].[ACTUAL_ST_DATE]  End Date dateTime attribute [MarketingOperationsDS].[uap_plans].[ACTUAL_END_DATE]  Plan Name (Code) characterLength16 attribute [MarketingOperationsMV].[Plan].[Plan Name] + ' (' + [MarketingOperationsMV].[Plan].[Plan Code] + ')'  Plan Program Area Ref Plan Program Area ID float64 identifier [MarketingOperationsDS].[uap_plan_parea].[PLAN_PAREA_ID]  Plan ID float64 attribute [MarketingOperationsDS].[uap_plan_parea].[PLAN_ID]  Program Area ID float64 attribute [MarketingOperationsDS].[uap_plan_parea].[PRGM_AREA_ID]  Display Order float64 attribute [MarketingOperationsDS].[uap_plan_parea].[DISPLAY_ORDER]  Plan Program Ref Plan ID float64 identifier [MarketingOperationsDS].[uap_plan_prgrm].[PLAN_ID]  Program ID float64 identifier [MarketingOperationsDS].[uap_plan_prgrm].[PROGRAM_ID]  Plan Program Area ID float64 identifier [MarketingOperationsDS].[uap_plan_prgrm].[PLAN_PAREA_ID]  Plan Member Plan ID float64 identifier [MarketingOperationsDS].[uap_plan_users].[PLAN_ID]  Member Type ID float64 attribute [MarketingOperationsDS].[uap_plan_users].[MEM_TYPE_ID]  User ID float64 identifier [MarketingOperationsDS].[uap_plan_users].[USER_ID]  Namespace/Folder Query Subject Query Item Type Usage Ref Obj/Expr. Plan Budgets Plan Budget Reference   (shortcut)   [MarketingOperationsMV].[Budget] Plan Budget Amount   (shortcut)   [MarketingOperationsMV].[Budget Amount] Program Area Budget Reference   (shortcut)   [MarketingOperationsMV].[Budget] Program Area Budget Amount   (shortcut)   [MarketingOperationsMV].[Budget Amount] Plan Budgets Plan Budget Budget ID float64 identifier [MarketingOperationsDS].[uap_plan_budget].[BUDGET_ID]  Plan ID float64 identifier [MarketingOperationsDS].[uap_plan_budget].[PLAN_ID]  Budget Total float64 fact [MarketingOperationsDS].[uap_plan_budget].[BUDGET_TOTAL]  Forecast Total float64 fact [MarketingOperationsDS].[uap_plan_budget].[FORECAST_TOTAL]  Actual Total float64 fact [MarketingOperationsDS].[uap_plan_budget].[ACTUAL_TOTAL]  Committed Total float64 fact [MarketingOperationsDS].[uap_plan_budget].[COMMITTED_TOTAL]  Allocated Total float64 fact [MarketingOperationsDS].[uap_plan_budget].[ALLOC_TOTAL]  Finalized Date dateTime attribute [MarketingOperationsDS].[uap_plan_budget].[FINALIZED_DATE]  Program Area Budget Budget ID float64 identifier [MarketingOperationsDS].[uap_parea_budget].[BUDGET_ID]  Plan Program Area ID float64 identifier [MarketingOperationsDS].[uap_parea_budget].[PLAN_PAREA_ID]  Budget Total float64 fact [MarketingOperationsDS].[uap_parea_budget].[BUDGET_TOTAL]  Forecast Total float64 fact [MarketingOperationsDS].[uap_parea_budget].[FORECAST_TOTAL]  Actual Total float64 fact [MarketingOperationsDS].[uap_parea_budget].[ACTUAL_TOTAL]  Committed Total float64 fact [MarketingOperationsDS].[uap_parea_budget].[COMMITTED_TOTAL]  Finalized Date dateTime attribute [MarketingOperationsDS].[uap_parea_budget].[FINALIZED_DATE]  Accounts Parent Account   (shortcut)   [MarketingOperationsMV].[Account] Account Budget Amount   (shortcut)   [MarketingOperationsMV].[Budget Amount] Account Budget Reference   (shortcut)   [MarketingOperationsMV].[Budget] Accounts Account Account ID float64 identifier [MarketingOperationsDS].[UAP_ACCOUNTS].[ACCOUNT_ID]  Account Code characterLength16 attribute [MarketingOperationsDS].[UAP_ACCOUNTS].[ACCOUNT_CODE]  Account Description characterLength16 attribute [MarketingOperationsDS].[UAP_ACCOUNTS].[ACCOUNT_DESC]  Parent Account ID float64 attribute [MarketingOperationsDS].[UAP_ACCOUNTS].[SRC_ACCOUNT_ID]  Account Name characterLength16 attribute [MarketingOperationsDS].[UAP_ACCOUNTS].[ACCOUNT_NAME]  Account Name (Code) characterLength16 attribute [MarketingOperationsMV].[Account].[Account Name] + ' (' + [MarketingOperationsMV].[Account].[Account Code] + ')'  Account Budget Account ID float64 identifier [MarketingOperationsDS].[UAP_ACT_BUDGET].[ACCOUNT_ID]  Budget ID float64 identifier [MarketingOperationsDS].[UAP_ACT_BUDGET].[BUDGET_ID]  Sub-Account Budget Amount Account ID float64 identifier   Quarter_ID float64 identifier   Year1 float64 identifier   Month1 float64 identifier   Budget_Amount float64 fact   Forecast_Amount float64 fact   Committed_Amount float64 fact   Actual_Amount float64 fact   Approvals Approver User   (shortcut)   [MarketingOperationsMV].[User] Approvals Approval Approval ID float64 identifier [MarketingOperationsDS].[UAP_APPROVALS].[APPROVAL_ID]  Approval Name characterLength16 attribute [MarketingOperationsDS].[UAP_APPROVALS].[NAME]  Approval Description characterLength16 attribute [MarketingOperationsDS].[UAP_APPROVALS].[DESCRIPTION]  Approval Status Code characterLength16 attribute [MarketingOperationsDS].[UAP_APPROVALS].[STATE_CODE]  Approval Date dateTime attribute [MarketingOperationsDS].[UAP_APPROVALS].[APPROVAL_DATE]  Source Object ID float64 identifier [MarketingOperationsDS].[UAP_APPROVALS].[SRC_OBJECT_ID]  Source Object Type characterLength16 attribute [MarketingOperationsDS].[UAP_APPROVALS].[SRC_OBJECT]  Source Workflow Task ID float64 identifier [MarketingOperationsDS].[UAP_APPROVALS].[SRC_WF_STEP]  Approval Item Approval ID float64 identifier [MarketingOperationsDS].[UAP_APPR_ITEMS].[APPROVAL_ID]  Approval Item Order float64 attribute [MarketingOperationsDS].[UAP_APPR_ITEMS].[APPR_ITEM_SEQ]  Approval Item Name characterLength16 attribute [MarketingOperationsDS].[UAP_APPR_ITEMS].[ORIG_FILE_NAME]  Approver Approval ID float64 identifier [MarketingOperationsDS].[UAP_APPROVER_LIST].[APPROVAL_ID]  Approver Status characterLength16 attribute [MarketingOperationsDS].[UAP_APPROVER_LIST].[STATUS_CODE]  Approver Order float64 attribute [MarketingOperationsDS].[UAP_APPROVER_LIST].[APPR_ORDER]  User ID float64 identifier [MarketingOperationsDS].[UAP_APPROVER_LIST].[USER_ID]  Is Required? characterLength16 attribute [MarketingOperationsDS].[UAP_APPROVER_LIST].[REQUIRED]  Response Date dateTime attribute [MarketingOperationsDS].[UAP_APPROVER_LIST].[RESP_DATE]  Approval Status Approval Status Code characterLength16 identifier [MarketingOperationsDS].[uap_status].[STATUS_CODE]  Approval Status characterLength16 attribute [MarketingOperationsDS].[uap_status].[STATUS_DESC]  Budgets Budget Amount Quarter ID float64 identifier [MarketingOperationsDS].[uap_budget_amt].[QUARTER_ID]  Year float64 identifier [MarketingOperationsDS].[uap_budget_amt].[YEAR]  Month float64 identifier [MarketingOperationsDS].[uap_budget_amt].[MONTH]  Budget ID float64 identifier [MarketingOperationsDS].[uap_budget_amt].[BUDGET_ID]  Forecast Amount float64 fact [MarketingOperationsDS].[uap_budget_amt].[FORECAST_AMT]  Committed Amount float64 fact [MarketingOperationsDS].[uap_budget_amt].[COMMITTED_AMT]  Actual Amount float64 fact [MarketingOperationsDS].[uap_budget_amt].[ACTUAL_AMT]  Budget Amount float64 fact [MarketingOperationsDS].[uap_budget_amt].[BUDGET_AMT]  Allocated Amount float64 fact [MarketingOperationsDS].[uap_budget_amt].[ALLOC_AMT]  Committed Remaining Amount float64 fact IF ( [MarketingOperationsMV].[Budget Amount].[Committed Amount] is null ) THEN ([MarketingOperationsMV].[Budget Amount].[Budget Amount] ) ELSE ( [MarketingOperationsMV].[Budget Amount].[Budget Amount] - [MarketingOperationsMV].[Budget Amount].[Committed Amount] )  Forecast Remaining Amount float64 fact IF ( [MarketingOperationsMV].[Budget Amount].[Forecast Amount] is null ) THEN ( [MarketingOperationsMV].[Budget Amount].[Budget Amount] ) ELSE ( [MarketingOperationsMV].[Budget Amount].[Budget Amount] - [MarketingOperationsMV].[Budget Amount].[Forecast Amount] )  Actual Remaining Amount float64 fact IF ( [MarketingOperationsMV].[Budget Amount].[Actual Amount] is null) THEN ( [MarketingOperationsMV].[Budget Amount].[Budget Amount] ) ELSE ( [MarketingOperationsMV].[Budget Amount].[Budget Amount] - [MarketingOperationsMV].[Budget Amount].[Actual Amount] )  Allocated Remaining Amount float64 fact IF ( [MarketingOperationsMV].[Budget Amount].[Allocated Amount] is null ) THEN ( [MarketingOperationsMV].[Budget Amount].[Budget Amount] ) ELSE ( [MarketingOperationsMV].[Budget Amount].[Budget Amount] - [MarketingOperationsMV].[Budget Amount].[Allocated Amount] )  Quarter Quarter ID float64 identifier [MarketingOperationsDS].[uap_quarters].[QUARTER_ID]  Year float64 identifier [MarketingOperationsDS].[uap_quarters].[YEAR]  Month float64 identifier [MarketingOperationsDS].[uap_quarters].[MONTH]  Quarter Description characterLength16 attribute [MarketingOperationsDS].[uap_quarters].[DESCRIPTION]  Quarter Year characterLength16 attribute substring ([MarketingOperationsMV].[Quarter].[Quarter Description] , position ( '(' , [MarketingOperationsMV].[Quarter].[Quarter Description] ) + 1, 7)  Month Year characterLength16 attribute substring ( [MarketingOperationsMV].[Quarter].[Quarter Description], 0, position('(', [MarketingOperationsMV].[Quarter].[Quarter Description]) - 1)  Fiscal Year characterLength16 attribute substring ([MarketingOperationsMV].[Quarter].[Quarter Description] , 5,4)  Budget Budget ID float64 identifier [MarketingOperationsDS].[uap_budgets].[BUDGET_ID]  Invoices Invoice Invoice ID float64 identifier [MarketingOperationsDS].[UAP_INVOICES].[INVOICE_ID]  Invoice Number characterLength16 attribute [MarketingOperationsDS].[UAP_INVOICES].[INVOICE_NO]  Vendor ID float64 attribute [MarketingOperationsDS].[UAP_INVOICES].[VENDOR_ID]  PO Number characterLength16 attribute [MarketingOperationsDS].[UAP_INVOICES].[PO_NO]  Due Date dateTime identifier [MarketingOperationsDS].[UAP_INVOICES].[DUE_DATE]  Status Code characterLength16 attribute [MarketingOperationsDS].[UAP_INVOICES].[STATUS_CODE]  State Code characterLength16 attribute [MarketingOperationsDS].[UAP_INVOICES].[STATE_CODE]  Invoice Date dateTime identifier [MarketingOperationsDS].[UAP_INVOICES].[SUBMIT_DATE]  Notes characterLength16 attribute [MarketingOperationsDS].[UAP_INVOICES].[NOTES]  Payment Terms characterLength16 attribute [MarketingOperationsDS].[UAP_INVOICES].[PAYMENT_TERMS]  Invoice Amount float64 fact [MarketingOperationsDS].[UAP_INVOICES].[INVOICE_AMOUNT]  Invoice Code characterLength16 attribute [MarketingOperationsDS].[UAP_INVOICES].[INVOICE_CODE]  Payable Date dateTime attribute [MarketingOperationsDS].[UAP_INVOICES].[PAYABLE_DATE]  Paid Date dateTime attribute [MarketingOperationsDS].[UAP_INVOICES].[PAID_DATE]  Invoice URL characterLength16 attribute #sq($[Environment]{'URL'})# + 'type=invoice&id=' + cast(cast([MarketingOperationsMV].[Invoice].[Invoice ID],integer),varchar(10))  Invoice Line Item Invoice ID float64 identifier [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[INVOICE_ID]  Cost Item ID float64 identifier [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[COST_ITEM_ID]  Cost Item Number float64 attribute [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[COST_ITEM_NO]  Item Description characterLength16 attribute [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[COST_ITEM_DESC]  Source Object Type characterLength16 attribute [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[SRC_OBJ_TYPE]  Source Object ID float64 attribute [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[SRC_OBJ_ID]  Source Object Code characterLength16 attribute [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[SRC_OBJ_CODE]  Account ID float64 attribute [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[ACCOUNT_ID]  Account Code characterLength16 attribute [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[ACCOUNT_CODE]  Cost Category ID float64 attribute [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[COST_CAT_ID]  Cost Category Code characterLength16 attribute [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[COST_CAT_CODE]  Quantity float64 fact [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[QUANTITY]  Unit Cost float64 fact [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[UNIT_COST]  Item Cost float64 fact [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[ITEM_COST]  Custom Attributes Project Custom Attributes Project ID float64 identifier [MarketingOperationsDS].[DYN_PROJECTATTS].[PROJECT_ID]  Initiative ID float64 fact [MarketingOperationsDS].[DYN_PROJECTATTS].[INIT_TYPE_ID]  Segment ID float64 fact [MarketingOperationsDS].[DYN_PROJECTATTS].[SEGMENT_ID]  Channel_Id float64 fact [MarketingOperationsDS].[DYN_PROJECTATTS].[CHANNEL_ID]  Business Unit ID float64 fact [MarketingOperationsDS].[DYN_PROJECTATTS].[BUSINESS_UNIT_ID]  Product Family ID float64 fact [MarketingOperationsDS].[DYN_PROJECTATTS].[PROD_FAMILY_ID]  Budget Period Id float64 fact [MarketingOperationsDS].[DYN_PROJECTATTS].[BUDGET_PERIOD_ID]  Business Unit Business Unit ID float64 identifier [MarketingOperationsDS].[LKUP_BUSINESS_UNIT].[BUSINESS_UNIT_ID]  Business Unit characterLength16 attribute [MarketingOperationsDS].[LKUP_BUSINESS_UNIT].[BUSINESS_UNIT_NAME]  Initiative Initiative ID float64 identifier [MarketingOperationsDS].[LKUP_INITIATIVE].[INIT_TYPE_ID]  Initiative characterLength16 attribute [MarketingOperationsDS].[LKUP_INITIATIVE].[INIT_TYPE_NAME]  Product Family Product Family ID float64 identifier [MarketingOperationsDS].[LKUP_PROD_FAMILY].[PROD_FAMILY_ID]  Product Family characterLength16 attribute [MarketingOperationsDS].[LKUP_PROD_FAMILY].[PROD_FAMILY_NAME]  Segment Segment ID float64 identifier [MarketingOperationsDS].[LKUP_SEGMENTS].[SEGMENT_ID]  Segment characterLength16 attribute [MarketingOperationsDS].[LKUP_SEGMENTS].[SEGMENT_NAME]  Project Performance Summary Custom Metrics Project ID float64 fact   Total Revenue float64 fact   ResponseRateActual float64 fact   ResponseRateTarget float64 fact   Total Leads Generated (Actual) float64 fact   Total Leads Generated (Target) float64 fact   Total Cost Passed float64 fact   Channel CHANNEL_ID float64 identifier [MarketingOperationsDS].[LKUP_CHANNEL].[CHANNEL_ID]  CHANNEL_NAME characterLength16 attribute [MarketingOperationsDS].[LKUP_CHANNEL].[CHANNEL_NAME]  Budget Period budget_period_id float64 identifier [MarketingOperationsDS].[LKUP_BUDGET_PERIOD].[BUDGET_PERIOD_ID]  budget_period_name characterLength16 attribute [MarketingOperationsDS].[LKUP_BUDGET_PERIOD].[BUDGET_PERIOD_NAME]  Dashboards Requests Over Time Project ID float64 identifier [MarketingOperationsMV].[Project Requests].[Project ID]  Project Name characterLength16 attribute [MarketingOperationsMV].[Project Requests].[Project Name]  Project Code characterLength16 attribute [MarketingOperationsMV].[Project Requests].[Project Code]  Project Description characterLength16 attribute [MarketingOperationsMV].[Project Requests].[Project Description]  Project Start Date dateTime identifier [MarketingOperationsMV].[Project Requests].[Project Start Date]  Project End Date dateTime identifier [MarketingOperationsMV].[Project Requests].[Project End Date]  Project Actual Start Date dateTime identifier [MarketingOperationsMV].[Project Requests].[Project Actual Start Date]  Project Actual End Date dateTime identifier [MarketingOperationsMV].[Project Requests].[Project Actual End Date]  Project Request Status characterLength16 attribute [MarketingOperationsMV].[Project Requests].[Project Request Status]  Project URL characterLength16 attribute [MarketingOperationsMV].[Project Requests].[Project Request URL]  Project Name (Code) characterLength16 attribute [MarketingOperationsMV].[Project Requests].[Project Name (Code)]  Project Request Flag characterLength16 attribute [MarketingOperationsMV].[Project Requests].[Project Request Flag]  Project Request ID float64 identifier [MarketingOperationsMV].[Project Requests].[Project Request ID]  Request Submit Date dateTime identifier [MarketingOperationsMV].[Project Requests].[Request Submit Date]  Request Complete Date dateTime identifier [MarketingOperationsMV].[Project Requests].[Request Complete Date]  Request Submit Month int32 identifier extract(month, [MarketingOperationsMV].[Requests Over Time].[Request Submit Date] ) -1  Request Submit Year int32 identifier extract (year, [MarketingOperationsMV].[Requests Over Time].[Request Submit Date] )  Template Name characterLength16 attribute [MarketingOperationsMV].[Project Requests].[Template Name]  Projects Over Time Project ID float64 identifier [MarketingOperationsMV].[Project].[Project ID]  Project Name characterLength16 attribute [MarketingOperationsMV].[Project].[Project Name]  Project Code characterLength16 attribute [MarketingOperationsMV].[Project].[Project Code]  Project Description characterLength16 attribute [MarketingOperationsMV].[Project].[Project Description]  Project Start Date dateTime identifier [MarketingOperationsMV].[Project].[Project Start Date]  Project End Date dateTime identifier [MarketingOperationsMV].[Project].[Project End Date]  Project Actual Start Date dateTime identifier [MarketingOperationsMV].[Project].[Project Actual Start Date]  Project Actual End Date dateTime identifier [MarketingOperationsMV].[Project].[Project Actual End Date]  Project Actual End Month float64 identifier extract(month, [MarketingOperationsMV].[Projects Over Time].[Project Actual End Date] ) -1  Project Actual End Year float64 identifier extract(year, [MarketingOperationsMV].[Projects Over Time].[Project Actual End Date] )  Project Status Code characterLength16 identifier [MarketingOperationsMV].[Project Status].[Status Code]  Project Status characterLength16 attribute [MarketingOperationsMV].[Project Status].[Status]  Project URL characterLength16 attribute [MarketingOperationsMV].[Project].[Project URL]  Project Name (Code) characterLength16 attribute [MarketingOperationsMV].[Project].[Project Name (Code)]  Project Request Flag characterLength16 attribute [MarketingOperationsMV].[Project].[Project Request Flag]  Template Name characterLength16 attribute [MarketingOperationsMV].[Project].[Template Name]  Projects Quarter Quarter ID float64 identifier [MarketingOperationsDS].[uap_quarters].[QUARTER_ID]  Year float64 identifier [MarketingOperationsDS].[uap_quarters].[YEAR]  Month float64 identifier [MarketingOperationsDS].[uap_quarters].[MONTH]  Quarter Description characterLength16 attribute [MarketingOperationsDS].[uap_quarters].[DESCRIPTION]  Quarter Year characterLength16 attribute substring ([MarketingOperationsMV].[Projects Quarter].[Quarter Description] , position ( '(' , [MarketingOperationsMV].[Projects Quarter].[Quarter Description] ) + 1, 7)  Month Year characterLength16 attribute substring ( [MarketingOperationsMV].[Projects Quarter].[Quarter Description], 0, position('(', [MarketingOperationsMV].[Projects Quarter].[Quarter Description]) - 1)  Fiscal Year characterLength16 attribute substring ([MarketingOperationsMV].[Projects Quarter].[Quarter Description] , 5,4)  Namespace/Folder Query Subject Query Item Type Usage Ref Obj/Expr. Projects and Requests Over Time Star Schema Requests Over Time   (shortcut)   [MarketingOperationsMV].[Requests Over Time] Projects Over Time   (shortcut)   [MarketingOperationsMV].[Projects Over Time] Projects Quarter   (shortcut)   [MarketingOperationsMV].[Projects Quarter]
Namespace/Folder Query Subject Query Item Type Usage Ref Obj/Expr. Campaign Common ControlCells   (shortcut)   [Model View].[Cell] Campaign Common Campaign Campaign ID decimal identifier [CampaignDS].[UARC_CAMPAIGN].[CAMPAIGNID]  Campaign Name characterLength16 attribute [CampaignDS].[UARC_CAMPAIGN].[NAME]  Description characterLength16 attribute [CampaignDS].[UARC_CAMPAIGN].[DESCRIPTION]  Campaign Code characterLength16 attribute [CampaignDS].[UARC_CAMPAIGN].[CAMPAIGNCODE]  Objectives characterLength16 attribute [CampaignDS].[UARC_CAMPAIGN].[OBJECTIVES]  Last Run Date dateTime attribute [CampaignDS].[UARC_CAMPAIGN].[LASTRUNDATE]  Initiative characterLength16 attribute IF ([CampaignDS].[UARC_CAMPAIGN].[INITIATIVE]=' ' OR [CampaignDS].[UARC_CAMPAIGN].[INITIATIVE] is missing) THEN(' ') ELSE([CampaignDS].[UARC_CAMPAIGN].[INITIATIVE])  Create Date dateTime attribute [CampaignDS].[UARC_CAMPAIGN].[CREATEDATE]  Update Date dateTime attribute [CampaignDS].[UARC_CAMPAIGN].[UPDATEDATE]  Start Date dateTime attribute [CampaignDS].[UARC_CAMPAIGN].[STARTDATE]  End Date dateTime attribute [CampaignDS].[UARC_CAMPAIGN].[ENDDATE]  CampaignURL characterLength16 attribute #sq($[Environment]{'Redirect URL'})# + 'type=campaign&id=' + cast(cast([Model View].[Campaign].[Campaign ID] , integer), varchar(10))  Not Applilcable Calc character attribute '-'  Create By int64 attribute [CampaignDS].[UARC_CAMPAIGN].[CREATEBY]  Update By int64 attribute [CampaignDS].[UARC_CAMPAIGN].[UPDATEBY]  Run By int64 attribute [CampaignDS].[UARC_CAMPAIGN].[RUNBY]  Project ID int64 identifier [CampaignDS].[UARC_CAMPAIGN].[PROJECTID]  Creator Flag int64 attribute [CampaignDS].[UARC_CAMPAIGN].[CREATORFLAG]  Offer Offer ID decimal identifier [CampaignDS].[UARC_OFFER].[OFFERID]  Offer Name characterLength16 attribute [CampaignDS].[UARC_OFFER].[NAME]  OfferURL characterLength16 attribute #sq($[Environment]{'Redirect URL'})# + 'type=offer&id=' + cast(cast([Model View].[Offer].[Offer ID] , integer), varchar(10))  Offer Code1 characterLength16 attribute [CampaignDS].[UARC_OFFER].[OFFERCODE1]  Offer Code2 characterLength16 attribute [CampaignDS].[UARC_OFFER].[OFFERCODE2]  Offer Code3 characterLength16 attribute [CampaignDS].[UARC_OFFER].[OFFERCODE3]  Offer Code4 characterLength16 attribute [CampaignDS].[UARC_OFFER].[OFFERCODE4]  Offer Code5 characterLength16 attribute [CampaignDS].[UARC_OFFER].[OFFERCODE5]  Create Date dateTime attribute [CampaignDS].[UARC_OFFER].[CREATEDATE]  Create By int64 attribute [CampaignDS].[UARC_OFFER].[CREATEBY]  Update Date dateTime attribute [CampaignDS].[UARC_OFFER].[UPDATEDATE]  Update By int64 attribute [CampaignDS].[UARC_OFFER].[UPDATEBY]  Retired int64 attribute [CampaignDS].[UARC_OFFER].[RETIRED]  Cell Cell ID decimal identifier [CampaignDS].[UARC_CELL].[CELLID]  Cell Name characterLength16 attribute [CampaignDS].[UARC_CELL].[CELLNAME]  Cell Code characterLength16 attribute [CampaignDS].[UARC_CELL].[CELLCODE]  Control Cell ID decimal attribute [CampaignDS].[UARC_CELL].[CONTROLCELLID]  Is Control int64 attribute [CampaignDS].[UARC_CELL].[ISCONTROL]  Campaign ID decimal identifier [CampaignDS].[UARC_CELL].[CAMPAIGNID]  CampToOffer Offer ID decimal identifier [CampaignDS].[UARC_CAMPTOOFFER].[OFFERID]  Campaign ID decimal identifier [CampaignDS].[UARC_CAMPTOOFFER].[CAMPAIGNID]  Calendar Date ID decimal identifier [CampaignDS].[UARC_CALENDAR].[DATEID]  Year int64 attribute [CampaignDS].[UARC_CALENDAR].[YEAR]  Fiscal Year int64 attribute [CampaignDS].[UARC_CALENDAR].[FISCALYEAR]  Quarter int64 attribute [CampaignDS].[UARC_CALENDAR].[QUARTER]  Fiscal Quarter int64 attribute [CampaignDS].[UARC_CALENDAR].[FISCALQUARTER]  Month int64 attribute [CampaignDS].[UARC_CALENDAR].[MONTH]  Week of Year int64 attribute [CampaignDS].[UARC_CALENDAR].[WEEKOFYEAR]  Week of Month int64 attribute [CampaignDS].[UARC_CALENDAR].[WEEKOFMONTH]  Day of Year int64 attribute [CampaignDS].[UARC_CALENDAR].[DAYOFYEAR]  Day of Month int64 attribute [CampaignDS].[UARC_CALENDAR].[DAYOFMONTH]  Day of Week int64 attribute [CampaignDS].[UARC_CALENDAR].[DAYOFWEEK]  Actual Date dateTime identifier [CampaignDS].[UARC_CALENDAR].[ACTUALDATE]  First Day of Week dateTime attribute [CampaignDS].[UARC_CALENDAR].[FIRSTDAYOFWEEK]  Last Day of Week dateTime attribute [CampaignDS].[UARC_CALENDAR].[LASTDAYOFWEEK]  Calendar Month Date ID int64 identifier [Model View].[Calendar].[Date ID]  Year int32 attribute [Model View].[Calendar].[Year]  Fiscal Year int32 attribute [Model View].[Calendar].[Fiscal Year]  Month int32 attribute [Model View].[Calendar].[Month]  Time Time ID decimal identifier [CampaignDS].[UARC_TIME].[TIMEID]  Hour int64 identifier [CampaignDS].[UARC_TIME].[HOUR]  Minute int64 identifier [CampaignDS].[UARC_TIME].[MINUTE]  Namespace/Folder Query Subject Query Item Type Usage Ref Obj/Expr. Campaign Listing Star Schema Campaign   (shortcut)   [Model View].[Campaign] Offer   (shortcut)   [Model View].[Offer] Cell   (shortcut)   [Model View].[Cell] CampToOffer   (shortcut)   [Model View].[CampToOffer] Campaign Custom Attributes Campaign Cust Attributes Campaign ID decimal identifier [CampaignDS].[UARC_CAMPEXTATTR].[CAMPAIGNID]   Offer Custom Attributes Offer ID decimal identifier [CampaignDS].[UARC_OFFEREXTATTR].[OFFERID]   Effective Date dateTime attribute [CampaignDS].[UARC_OFFEREXTATTR].[EFFECTIVE_DATE]  Expiration Date dateTime attribute [CampaignDS].[UARC_OFFEREXTATTR].[EXPIRATION_DATE]  Expiration Duration float64 fact [CampaignDS].[UARC_OFFEREXTATTR].[EXPIRATION_DUR]   Channel characterLength16 attribute [CampaignDS].[UARC_OFFEREXTATTR].[CHANNEL]  Cost Per Contact float64 fact IF([CampaignDS].[UARC_OFFEREXTATTR].[COST_PER_CONTACT] is missing) THEN (0) ELSE ([CampaignDS].[UARC_OFFEREXTATTR].[COST_PER_CONTACT])   Revenue Per Response float64 fact IF([CampaignDS].[UARC_OFFEREXTATTR].[REVENUE_PER_RESP] is missing) THEN (0) ELSE ([CampaignDS].[UARC_OFFEREXTATTR].[REVENUE_PER_RESP])  Offer Fulfillment Cost float64 fact IF([CampaignDS].[UARC_OFFEREXTATTR].[OFFER_FULFILL_COST] is missing) THEN (0) ELSE([CampaignDS].[UARC_OFFEREXTATTR].[OFFER_FULFILL_COST])  Offer Fixed Cost float64 fact IF ([CampaignDS].[UARC_OFFEREXTATTR].[OFFER_FIXED_COST] is missing) THEN (0) ELSE ([CampaignDS].[UARC_OFFEREXTATTR].[OFFER_FIXED_COST])  Cell Custom Attributes Cell ID decimal identifier [CampaignDS].[UARC_CELLEXTATTR].[CELLID]   Namespace/Folder Query Subject Query Item Type Usage Ref Obj/Expr. Campaign Custom Attributes Star Schema Campaign Cust Attributes   (shortcut)   [Model View].[Campaign Cust Attributes] Offer Custom Attributes   (shortcut)   [Model View].[Offer Custom Attributes] Cell Custom Attributes   (shortcut)   [Model View].[Cell Custom Attributes] Campaign   (shortcut)   [Model View].[Campaign] Offer   (shortcut)   [Model View].[Offer] Cell   (shortcut)   [Model View].[Cell] CampToOffer   (shortcut)   [Model View].[CampToOffer] Namespace/Folder Query Subject Query Item Type Usage Ref Obj/Expr. Campaign Performance Day Campaign Contact History by Day Campaign ID decimal identifier [CampaignDS].[UARC_CCH_DY].[CAMPAIGNID]  Actual Date dateTime attribute [CampaignDS].[UARC_CCH_DY].[ACTUALDATE]  Number of Offers Given float64 fact [CampaignDS].[UARC_CCH_DY].[NUM_OF_OFFERS]   Number of Offers Given Control Group float64 fact [CampaignDS].[UARC_CCH_DY].[NUM_OF_OFFERS_CG]   Unique Recipients float64 fact [CampaignDS].[UARC_CCH_DY].[UNIQUE_RECIPIENTS]  Unique Recipients Control Group float64 fact [CampaignDS].[UARC_CCH_DY].[UNIQUE_RECIP_CG]   Number of Offer Versions float64 fact [CampaignDS].[UARC_CCH_DY].[NUM_OFF_VERS]  Number of Offer Versions Control Group float64 fact [CampaignDS].[UARC_CCH_DY].[NUM_OFF_VERS_CG]  Campaign Offer Contact History by Day Campaign ID decimal identifier [CampaignDS].[UARC_COCH_DY].[CAMPAIGNID]  Offer ID decimal identifier [CampaignDS].[UARC_COCH_DY].[OFFERID]  Actual Date dateTime attribute [CampaignDS].[UARC_COCH_DY].[ACTUALDATE]  Number of Offers Given float64 fact [CampaignDS].[UARC_COCH_DY].[NUM_OF_OFFERS]   Number of Offers Given Control Group float64 fact [CampaignDS].[UARC_COCH_DY].[NUM_OF_OFFERS_CG]   Unique Recipients float64 fact [CampaignDS].[UARC_COCH_DY].[UNIQUE_RECIPIENTS]  Unique Recipients Control Group float64 fact [CampaignDS].[UARC_COCH_DY].[UNIQUE_RECIP_CG]  Number of Offer Versions float64 fact [CampaignDS].[UARC_COCH_DY].[NUM_OFF_VERS]   Number of Offer Versions Control Group float64 fact [CampaignDS].[UARC_COCH_DY].[NUM_OFF_VERS_CG]   Campaign Cell Contact History by Day Campaign ID decimal identifier [CampaignDS].[UARC_CCCH_DY].[CAMPAIGNID]  Cell ID decimal identifier [CampaignDS].[UARC_CCCH_DY].[CELLID]  Actual Date dateTime attribute [CampaignDS].[UARC_CCCH_DY].[ACTUALDATE]  Number of Offers Given float64 fact [CampaignDS].[UARC_CCCH_DY].[NUM_OF_OFFERS]   Number of Offers Given Control Group float64 fact [CampaignDS].[UARC_CCCH_DY].[NUM_OF_OFFERS_CG]   Unique Recipients float64 fact [CampaignDS].[UARC_CCCH_DY].[UNIQUE_RECIPIENTS]  Unique Recipients Control Group float64 fact [CampaignDS].[UARC_CCCH_DY].[UNIQUE_RECIP_CG]  Number of Offer Versions float64 fact [CampaignDS].[UARC_CCCH_DY].[NUM_OFF_VERS]   Number of Offer Versions Control Group float64 fact [CampaignDS].[UARC_CCCH_DY].[NUM_OFF_VERS_CG]   Campaign Response History by Day Campaign ID decimal identifier [CampaignDS].[UARC_CRH_DY].[CAMPAIGNID]  Actual Date dateTime attribute [CampaignDS].[UARC_CRH_DY].[ACTUALDATE]  Response Transactions float64 fact [CampaignDS].[UARC_CRH_DY].[RESP_TRANS]   Response Transactions Control Group float64 fact [CampaignDS].[UARC_CRH_DY].[RESP_TRANS_CG]   Unique Responders float64 fact [CampaignDS].[UARC_CRH_DY].[UNIQUE_RESPONDERS]  Unique Responders Control Group float64 fact [CampaignDS].[UARC_CRH_DY].[UNIQUE_RESP_CG]  Not Contacted Responders float64 fact [CampaignDS].[UARC_CRH_DY].[NOT_CONT_RESP]   Responses After Expiration float64 fact [CampaignDS].[UARC_CRH_DY].[RESP_AFTER_EXP]   Responses After Expiration Control Group float64 fact [CampaignDS].[UARC_CRH_DY].[RESP_AFTER_EXP_CG]  Revenue Per Response float64 fact IF([CampaignDS].[UARC_CRH_DY].[REVENUE_PER_RESP] is missing) THEN(0) ELSE([CampaignDS].[UARC_CRH_DY].[REVENUE_PER_RESP])  Revenue Per Response Control Group float64 fact IF([CampaignDS].[UARC_CRH_DY].[REV_PER_RESP_CG] is missing) THEN (0) ELSE ([CampaignDS].[UARC_CRH_DY].[REV_PER_RESP_CG])  Gross Revenue float64 fact IF([CampaignDS].[UARC_CRH_DY].[GROSS_REVENUE] is missing) THEN(0) ELSE ([CampaignDS].[UARC_CRH_DY].[GROSS_REVENUE])  Gross Revenue Control Group float64 fact IF([CampaignDS].[UARC_CRH_DY].[GROSS_REVENUE_CG] is missing) THEN (0) ELSE([CampaignDS].[UARC_CRH_DY].[GROSS_REVENUE_CG])  Campaign Offer Response History by Day Campaign ID decimal identifier [CampaignDS].[UARC_CORH_DY].[CAMPAIGNID]  Offer ID decimal identifier [CampaignDS].[UARC_CORH_DY].[OFFERID]  Actual Date dateTime attribute [CampaignDS].[UARC_CORH_DY].[ACTUALDATE]  Response Transactions float64 fact [CampaignDS].[UARC_CORH_DY].[RESP_TRANS]   Response Transactions Control Group float64 fact [CampaignDS].[UARC_CORH_DY].[RESP_TRANS_CG]   Unique Responders float64 fact [CampaignDS].[UARC_CORH_DY].[UNIQUE_RESPONDERS]  Unique Responders Control Group float64 fact [CampaignDS].[UARC_CORH_DY].[UNIQUE_RESP_CG]  Not Contacted Responders float64 fact [CampaignDS].[UARC_CORH_DY].[NOT_CONT_RESP]   Responses After Expiration float64 fact [CampaignDS].[UARC_CORH_DY].[RESP_AFTER_EXP]   Responses After Expiration Control Group float64 fact [CampaignDS].[UARC_CORH_DY].[RESP_AFTER_EXP_CG]  Revenue Per Response float64 fact IF([CampaignDS].[UARC_CORH_DY].[REVENUE_PER_RESP] is missing) THEN(0) ELSE([CampaignDS].[UARC_CORH_DY].[REVENUE_PER_RESP])  Revenue Per Response Control Group float64 fact IF([CampaignDS].[UARC_CORH_DY].[REV_PER_RESP_CG] IS MISSING) THEN(0) ELSE([CampaignDS].[UARC_CORH_DY].[REV_PER_RESP_CG])  Gross Revenue float64 fact IF([CampaignDS].[UARC_CORH_DY].[GROSS_REVENUE] is missing) THEN(0) ELSE([CampaignDS].[UARC_CORH_DY].[GROSS_REVENUE])  Gross Revenue Control Group float64 fact IF([CampaignDS].[UARC_CORH_DY].[GROSS_REVENUE_CG] is missing) THEN(0) ELSE([CampaignDS].[UARC_CORH_DY].[GROSS_REVENUE_CG])  Campaign Cell Response History by Day Campaign ID decimal identifier [CampaignDS].[UARC_CCRH_DY].[CAMPAIGNID]  Cell ID decimal identifier [CampaignDS].[UARC_CCRH_DY].[CELLID]  Actual Date dateTime attribute [CampaignDS].[UARC_CCRH_DY].[ACTUALDATE]  Response Transactions float64 fact [CampaignDS].[UARC_CCRH_DY].[RESP_TRANS]   Response Transactions Control Group float64 fact [CampaignDS].[UARC_CCRH_DY].[RESP_TRANS_CG]   Unique Responders float64 fact [CampaignDS].[UARC_CCRH_DY].[UNIQUE_RESPONDERS]  Unique Responders Control Group float64 fact [CampaignDS].[UARC_CCRH_DY].[UNIQUE_RESP_CG]  Not Contacted Responders float64 fact [CampaignDS].[UARC_CCRH_DY].[NOT_CONT_RESP]   Responses After Expiration float64 fact [CampaignDS].[UARC_CCRH_DY].[RESP_AFTER_EXP]   Responses After Expiration Control Group float64 fact [CampaignDS].[UARC_CCRH_DY].[RESP_AFTER_EXP_CG]  Revenue Per Response float64 fact IF([CampaignDS].[UARC_CCRH_DY].[REVENUE_PER_RESP] is missing) THEN(0) ELSE([CampaignDS].[UARC_CCRH_DY].[REVENUE_PER_RESP])  Revenue Per Response Control Group float64 fact IF([CampaignDS].[UARC_CCRH_DY].[REV_PER_RESP_CG] is missing) THEN(0) ELSE([CampaignDS].[UARC_CCRH_DY].[REV_PER_RESP_CG])  Gross Revenue float64 fact IF([CampaignDS].[UARC_CCRH_DY].[GROSS_REVENUE] is missing) THEN(0) ELSE([CampaignDS].[UARC_CCRH_DY].[GROSS_REVENUE])  Gross Revenue Control Group float64 fact IF([CampaignDS].[UARC_CCRH_DY].[GROSS_REVENUE_CG] is missing) THEN (0) ELSE([CampaignDS].[UARC_CCRH_DY].[GROSS_REVENUE_CG])  Namespace/Folder Query Subject Query Item Type Usage Ref Obj/Expr. Campaign Performance by Day Star Schema Campaign Contact History by Day   (shortcut)   [Model View].[Campaign Contact History by Day] Campaign Offer Contact History by Day   (shortcut)   [Model View].[Campaign Offer Contact History by Day] Campaign Cell Contact History by Day   (shortcut)   [Model View].[Campaign Cell Contact History by Day] Campaign Response History by Day   (shortcut)   [Model View].[Campaign Response History by Day] Campaign Offer Response History by Day   (shortcut)   [Model View].[Campaign Offer Response History by Day] Campaign Cell Response History by Day   (shortcut)   [Model View].[Campaign Cell Response History by Day] Campaign   (shortcut)   [Model View].[Campaign] Offer   (shortcut)   [Model View].[Offer] Cell   (shortcut)   [Model View].[Cell] ControlCells   (shortcut)   [Model View].[Cell] Responder Rate Control Group by Cell by Day   (shortcut)   [Model View].[Responder Rate Control Group by Cell by Day] Calendar   (shortcut)   [Model View].[Calendar] Namespace/Folder Query Subject Query Item Type Usage Ref Obj/Expr. Responder Rate Calculations by Day Responder Rate by Cell by Day Cell ID decimal identifier [Campaign Performance by Day Star Schema].[Cell][Model View].[Cell].[Cell ID]  Responder Rate float64 fact IF([Campaign Performance by Day Star Schema].[Campaign Cell Response History by Day][Model View].[Campaign Cell Response History by Day].[Unique Responders] /[Campaign Performance by Day Star Schema].[Campaign Cell Contact History by Day][Model View].[Campaign Cell Contact History by Day].[Unique Recipients] is missing) THEN(0) ELSE([Campaign Performance by Day Star Schema].[Campaign Cell Response History by Day][Model View].[Campaign Cell Response History by Day].[Unique Responders] /[Campaign Performance by Day Star Schema].[Campaign Cell Contact History by Day][Model View].[Campaign Cell Contact History by Day].[Unique Recipients])  Responder Rate Control Group by Cell by Day Cell ID decimal identifier [Campaign Performance by Day Star Schema].[Cell][Model View].[Cell].[Cell ID]  Campaign ID decimal identifier [Campaign Performance by Day Star Schema].[Cell][Model View].[Cell].[Campaign ID]  Responder Rate Control Group float64 fact IF([Campaign Performance by Day Star Schema].[Campaign Cell Response History by Day][Model View].[Campaign Cell Response History by Day].[Unique Responders Control Group] /[Campaign Performance by Day Star Schema].[Campaign Cell Contact History by Day][Model View].[Campaign Cell Contact History by Day].[Unique Recipients Control Group] is missing) THEN(0) ELSE([Campaign Performance by Day Star Schema].[Campaign Cell Response History by Day][Model View].[Campaign Cell Response History by Day].[Unique Responders Control Group] /[Campaign Performance by Day Star Schema].[Campaign Cell Contact History by Day][Model View].[Campaign Cell Contact History by Day].[Unique Recipients Control Group])  Campaign Performance by Month Campaign Contact History by Month Campaign ID decimal identifier [CampaignDS].[UARC_CCH_MO].[CAMPAIGNID]  Month float64 attribute [CampaignDS].[UARC_CCH_MO].[MONTH]  Year float64 attribute [CampaignDS].[UARC_CCH_MO].[YEAR]   Number of Offers Given float64 fact [CampaignDS].[UARC_CCH_MO].[NUM_OF_OFFERS]   Number of Offers Given Control Group float64 fact [CampaignDS].[UARC_CCH_MO].[NUM_OF_OFFERS_CG]   Unique Recipients float64 fact [CampaignDS].[UARC_CCH_MO].[UNIQUE_RECIPIENTS]  Unique Recipients Control Group float64 fact [CampaignDS].[UARC_CCH_MO].[UNIQUE_RECIP_CG]  Number of Offer Versions float64 fact [CampaignDS].[UARC_CCH_MO].[NUM_OFF_VERS]   Number of Offer Versions Control Group float64 fact [CampaignDS].[UARC_CCH_MO].[NUM_OFF_VERS_CG]   Campaign Offer Contact History by Month Campaign ID decimal identifier [CampaignDS].[UARC_COCH_MO].[CAMPAIGNID]  Offer ID decimal identifier [CampaignDS].[UARC_COCH_MO].[OFFERID]  Month float64 attribute [CampaignDS].[UARC_COCH_MO].[MONTH]  Year float64 attribute [CampaignDS].[UARC_COCH_MO].[YEAR]   Number of Offers float64 fact [CampaignDS].[UARC_COCH_MO].[NUM_OF_OFFERS]   Number of Offers Control Group float64 fact [CampaignDS].[UARC_COCH_MO].[NUM_OF_OFFERS_CG]   Unique Recipients float64 fact [CampaignDS].[UARC_COCH_MO].[UNIQUE_RECIPIENTS]  Unique Recipients Control Group float64 fact [CampaignDS].[UARC_COCH_MO].[UNIQUE_RECIP_CG]  Number of Offer Versions float64 fact [CampaignDS].[UARC_COCH_MO].[NUM_OFF_VERS]   Number of Offer Versions Control Group float64 fact [CampaignDS].[UARC_COCH_MO].[NUM_OFF_VERS_CG]   Campaign Cell Contact History by Month Campaign ID decimal identifier [CampaignDS].[UARC_CCCH_MO].[CAMPAIGNID]  Cell ID decimal identifier [CampaignDS].[UARC_CCCH_MO].[CELLID]  Month float64 attribute [CampaignDS].[UARC_CCCH_MO].[MONTH]  Year float64 attribute [CampaignDS].[UARC_CCCH_MO].[YEAR]  Number of Offers Given float64 fact [CampaignDS].[UARC_CCCH_MO].[NUM_OF_OFFERS]   Number of Offers Given Control Group float64 fact [CampaignDS].[UARC_CCCH_MO].[NUM_OF_OFFERS_CG]   Unique Recipients float64 fact [CampaignDS].[UARC_CCCH_MO].[UNIQUE_RECIPIENTS]  Unique Recipients Control Group float64 fact [CampaignDS].[UARC_CCCH_MO].[UNIQUE_RECIP_CG]  Number of Offer Versions float64 fact [CampaignDS].[UARC_CCCH_MO].[NUM_OFF_VERS]  Number of Offer Versions Control Group float64 fact [CampaignDS].[UARC_CCCH_MO].[NUM_OFF_VERS_CG]  Campaign Response History by Month Campaign ID decimal identifier [CampaignDS].[UARC_CRH_MO].[CAMPAIGNID]  Month decimal attribute [CampaignDS].[UARC_CRH_MO].[MONTH]  Year decimal attribute [CampaignDS].[UARC_CRH_MO].[YEAR]  Response Transactions float64 fact [CampaignDS].[UARC_CRH_MO].[RESP_TRANS]   Response Transactions Control Group float64 fact [CampaignDS].[UARC_CRH_MO].[RESP_TRANS_CG]   Unique Responders float64 fact [CampaignDS].[UARC_CRH_MO].[UNIQUE_RESPONDERS]  Unique Responders Control Group float64 fact [CampaignDS].[UARC_CRH_MO].[UNIQUE_RESP_CG]  Not Contacted Responders float64 fact [CampaignDS].[UARC_CRH_MO].[NOT_CONT_RESP]   Responses After Expiration float64 fact [CampaignDS].[UARC_CRH_MO].[RESP_AFTER_EXP]   Responses After Expiration Control Group float64 fact [CampaignDS].[UARC_CRH_MO].[RESP_AFTER_EXP_CG]  Revenue Per Response float64 fact IF([CampaignDS].[UARC_CRH_MO].[REVENUE_PER_RESP] is missing) THEN(0) ELSE([CampaignDS].[UARC_CRH_MO].[REVENUE_PER_RESP])  Revenue Per Response Control Group float64 fact IF([CampaignDS].[UARC_CRH_MO].[REV_PER_RESP_CG] is missing) THEN(0) ELSE([CampaignDS].[UARC_CRH_MO].[REV_PER_RESP_CG])  Gross Revenue float64 fact IF([CampaignDS].[UARC_CRH_MO].[GROSS_REVENUE] is missing) THEN(0) ELSE([CampaignDS].[UARC_CRH_MO].[GROSS_REVENUE])  Gross Revenue Control Group float64 fact IF([CampaignDS].[UARC_CRH_MO].[GROSS_REVENUE_CG] is missing) THEN(0) ELSE([CampaignDS].[UARC_CRH_MO].[GROSS_REVENUE_CG])  Campaign Offer Response History by Month Campaign ID decimal identifier [CampaignDS].[UARC_CORH_MO].[CAMPAIGNID]  Offer ID decimal identifier [CampaignDS].[UARC_CORH_MO].[OFFERID]  Month decimal attribute [CampaignDS].[UARC_CORH_MO].[MONTH]  Year decimal attribute [CampaignDS].[UARC_CORH_MO].[YEAR]   Response Transactions float64 fact [CampaignDS].[UARC_CORH_MO].[RESP_TRANS]   Response Transactions Control Group float64 fact [CampaignDS].[UARC_CORH_MO].[RESP_TRANS_CG]   Unique Responders float64 fact [CampaignDS].[UARC_CORH_MO].[UNIQUE_RESPONDERS]  Unique Responders Control Group float64 fact [CampaignDS].[UARC_CORH_MO].[UNIQUE_RESP_CG]  Not Contacted Responders float64 fact [CampaignDS].[UARC_CORH_MO].[NOT_CONT_RESP]   Responses After Expiration float64 fact [CampaignDS].[UARC_CORH_MO].[RESP_AFTER_EXP]   Responses After Expiration Control Group float64 fact [CampaignDS].[UARC_CORH_MO].[RESP_AFTER_EXP_CG]  Revenue Per Response float64 fact IF([CampaignDS].[UARC_CORH_MO].[REVENUE_PER_RESP] is missing) THEN(0) ELSE([CampaignDS].[UARC_CORH_MO].[REVENUE_PER_RESP])  Revenue Per Response Control Group float64 fact IF([CampaignDS].[UARC_CORH_MO].[REV_PER_RESP_CG] is missing) THEN(0) ELSE([CampaignDS].[UARC_CORH_MO].[REV_PER_RESP_CG])  Gross Revenue float64 fact IF([CampaignDS].[UARC_CORH_MO].[GROSS_REVENUE] is missing) THEN(0) ELSE([CampaignDS].[UARC_CORH_MO].[GROSS_REVENUE])  Gross Revenue Control Group float64 fact IF([CampaignDS].[UARC_CORH_MO].[GROSS_REVENUE_CG] is missing) THEN(0) ELSE([CampaignDS].[UARC_CORH_MO].[GROSS_REVENUE_CG])  Campaign Cell Response History by Month Campaign ID decimal identifier [CampaignDS].[UARC_CCRH_MO].[CAMPAIGNID]  Cell ID decimal identifier [CampaignDS].[UARC_CCRH_MO].[CELLID]  Month decimal attribute [CampaignDS].[UARC_CCRH_MO].[MONTH]  Year decimal attribute [CampaignDS].[UARC_CCRH_MO].[YEAR]   Response Transactions float64 fact [CampaignDS].[UARC_CCRH_MO].[RESP_TRANS]   Response Transactions Control Group float64 fact [CampaignDS].[UARC_CCRH_MO].[RESP_TRANS_CG]   Unique Responders float64 fact [CampaignDS].[UARC_CCRH_MO].[UNIQUE_RESPONDERS]  Unique Responders Control Group float64 fact [CampaignDS].[UARC_CCRH_MO].[UNIQUE_RESP_CG]  Not Contacted Responders float64 fact [CampaignDS].[UARC_CCRH_MO].[NOT_CONT_RESP]   Responses After Expiration float64 fact [CampaignDS].[UARC_CCRH_MO].[RESP_AFTER_EXP]   Responses After Expiration Control Group float64 fact [CampaignDS].[UARC_CCRH_MO].[RESP_AFTER_EXP_CG]  Revenue Per Response float64 fact IF([CampaignDS].[UARC_CCRH_MO].[REVENUE_PER_RESP] is missing) THEN(0) ELSE([CampaignDS].[UARC_CCRH_MO].[REVENUE_PER_RESP])  Revenue Per Response Control Group float64 fact IF([CampaignDS].[UARC_CCRH_MO].[REV_PER_RESP_CG] is missing) THEN(0) ELSE([CampaignDS].[UARC_CCRH_MO].[REV_PER_RESP_CG])  Gross Revenue float64 fact IF([CampaignDS].[UARC_CCRH_MO].[GROSS_REVENUE] is missing) THEN (0) ELSE([CampaignDS].[UARC_CCRH_MO].[GROSS_REVENUE])  Gross Revenue Control Group float64 fact IF([CampaignDS].[UARC_CCRH_MO].[GROSS_REVENUE_CG] is missing) THEN(0) ELSE([CampaignDS].[UARC_CCRH_MO].[GROSS_REVENUE_CG])  Namespace/Folder Query Subject Query Item Type Usage Ref Obj/Expr. Campaign Performance by Month Star Schema Campaign Contact History by Month   (shortcut)   [Model View].[Campaign Contact History by Month] Campaign Offer Contact History by Month   (shortcut)   [Model View].[Campaign Offer Contact History by Month] Campaign Cell Contact History by Month   (shortcut)   [Model View].[Campaign Cell Contact History by Month] Campaign Response History by Month   (shortcut)   [Model View].[Campaign Response History by Month] Campaign Offer Response History by Month   (shortcut)   [Model View].[Campaign Offer Response History by Month] Campaign Cell Response History by Month   (shortcut)   [Model View].[Campaign Cell Response History by Month] Campaign   (shortcut)   [Model View].[Campaign] Offer   (shortcut)   [Model View].[Offer] Cell   (shortcut)   [Model View].[Cell] ControlCells   (shortcut)   [Model View].[Cell] Responder Rate Control Group by Cell by Month   (shortcut)   [Model View].[Responder Rate Control Group by Cell by Month] Calendar Month   (shortcut)   [Model View].[Calendar Month] Namespace/Folder Query Subject Query Item Type Usage Ref Obj/Expr. Responder Rate Calculations by Month Responder Rate by Cell by Month Cell ID decimal identifier [Campaign Performance by Month Star Schema].[Cell][Model View].[Cell].[Cell ID]  Responder Rate by Month float64 fact IF([Campaign Performance by Month Star Schema].[Campaign Cell Response History by Month][Model View].[Campaign Cell Response History by Month].[Unique Responders] /[Campaign Performance by Month Star Schema].[Campaign Cell Contact History by Month][Model View].[Campaign Cell Contact History by Month].[Unique Recipients] is missing) THEN(0) ELSE([Campaign Performance by Month Star Schema].[Campaign Cell Response History by Month][Model View].[Campaign Cell Response History by Month].[Unique Responders] /[Campaign Performance by Month Star Schema].[Campaign Cell Contact History by Month][Model View].[Campaign Cell Contact History by Month].[Unique Recipients])  Responder Rate Control Group by Cell by Month Cell ID decimal identifier [Campaign Performance by Month Star Schema].[Cell][Model View].[Cell].[Cell ID]  Campaign ID decimal identifier [Campaign Performance by Month Star Schema].[Cell][Model View].[Cell].[Campaign ID]  Responder Rate Control Group float64 fact IF([Campaign Performance by Month Star Schema].[Campaign Cell Response History by Month][Model View].[Campaign Cell Response History by Month].[Unique Responders Control Group] /[Campaign Performance by Month Star Schema].[Campaign Cell Contact History by Month][Model View].[Campaign Cell Contact History by Month].[Unique Recipients Control Group] is missing) THEN(0) ELSE([Campaign Performance by Month Star Schema].[Campaign Cell Response History by Month][Model View].[Campaign Cell Response History by Month].[Unique Responders Control Group] /[Campaign Performance by Month Star Schema].[Campaign Cell Contact History by Month][Model View].[Campaign Cell Contact History by Month].[Unique Recipients Control Group])  Campaign Performance Summary Campaign Contact History Summary Campaign ID int64 identifier [CampaignDS].[UARC_CCH_SUMMARY].[CAMPAIGNID]  Number of Offers Given int32 fact [CampaignDS].[UARC_CCH_SUMMARY].[NUM_OF_OFFERS]   Number of Offers Given Control Group int32 fact [CampaignDS].[UARC_CCH_SUMMARY].[NUM_OF_OFFERS_CG]   Unique Recipients int32 fact [CampaignDS].[UARC_CCH_SUMMARY].[UNIQUE_RECIPIENTS]  Unique Recipients Control Group int32 fact [CampaignDS].[UARC_CCH_SUMMARY].[UNIQUE_RECIP_CG]  Number of Offer Versions int32 fact [CampaignDS].[UARC_CCH_SUMMARY].[NUM_OFF_VERS]  Number of Offer Versions Control Group int32 fact [CampaignDS].[UARC_CCH_SUMMARY].[NUM_OFF_VERS_CG]  Campaign Response History Summary Campaign ID int64 identifier [CampaignDS].[UARC_CRH_SUMMARY].[CAMPAIGNID]  Response Transactions int32 fact [CampaignDS].[UARC_CRH_SUMMARY].[RESP_TRANS]   Response Transactions Control Group int32 fact [CampaignDS].[UARC_CRH_SUMMARY].[RESP_TRANS_CG]   Unique Responders int32 fact [CampaignDS].[UARC_CRH_SUMMARY].[UNIQUE_RESPONDERS]  Unique Responders Control Group int32 fact [CampaignDS].[UARC_CRH_SUMMARY].[UNIQUE_RESP_CG]  Not Contacted Responders int32 fact [CampaignDS].[UARC_CRH_SUMMARY].[NOT_CONT_RESP]   Responses After Expiration int32 fact [CampaignDS].[UARC_CRH_SUMMARY].[RESP_AFTER_EXP]   Responses After Expiration Control Group int32 fact [CampaignDS].[UARC_CRH_SUMMARY].[RESP_AFTER_EXP_CG]  Revenue Per Response decimal fact IF([CampaignDS].[UARC_CRH_SUMMARY].[REVENUE_PER_RESP] is missing) THEN(0) ELSE([CampaignDS].[UARC_CRH_SUMMARY].[REVENUE_PER_RESP])  Revenue Per Response Control Group decimal fact IF([CampaignDS].[UARC_CRH_SUMMARY].[REV_PER_RESP_CG] is missing) THEN(0) ELSE([CampaignDS].[UARC_CRH_SUMMARY].[REV_PER_RESP_CG])  Gross Revenue decimal fact IF([CampaignDS].[UARC_CRH_SUMMARY].[GROSS_REVENUE] is missing) THEN(0) ELSE([CampaignDS].[UARC_CRH_SUMMARY].[GROSS_REVENUE])  Gross Revenue Control Group decimal fact IF([CampaignDS].[UARC_CRH_SUMMARY].[GROSS_REVENUE_CG] is missing) THEN(0) ELSE([CampaignDS].[UARC_CRH_SUMMARY].[GROSS_REVENUE_CG])  Campaign Offer Contact History Summary Campaign ID decimal identifier [CampaignDS].[UARC_COCH_SUMMARY].[CAMPAIGNID]  Offer ID decimal identifier [CampaignDS].[UARC_COCH_SUMMARY].[OFFERID]  Number of Offers Given float64 fact [CampaignDS].[UARC_COCH_SUMMARY].[NUM_OF_OFFERS]   Number of Offers Given Control Group float64 fact [CampaignDS].[UARC_COCH_SUMMARY].[NUM_OF_OFFERS_CG]   Unique Recipients float64 fact [CampaignDS].[UARC_COCH_SUMMARY].[UNIQUE_RECIPIENTS]  Unique Recipients Control Group float64 fact [CampaignDS].[UARC_COCH_SUMMARY].[UNIQUE_RECIP_CG]  Number of Offer Versions float64 fact [CampaignDS].[UARC_COCH_SUMMARY].[NUM_OFF_VERS]  Number of Offer Versions Control Group float64 fact [CampaignDS].[UARC_COCH_SUMMARY].[NUM_OFF_VERS_CG]  Campaign Offer Response History Summary Campaign ID int64 identifier [CampaignDS].[UARC_CORH_SUMMARY].[CAMPAIGNID]  Offer ID int64 identifier [CampaignDS].[UARC_CORH_SUMMARY].[OFFERID]  Response Transactions int32 fact [CampaignDS].[UARC_CORH_SUMMARY].[RESP_TRANS]   Unique Responders int32 fact [CampaignDS].[UARC_CORH_SUMMARY].[UNIQUE_RESPONDERS]  Unique Responders Control Group int32 fact [CampaignDS].[UARC_CORH_SUMMARY].[UNIQUE_RESP_CG]  Not Contacted Responders int32 fact [CampaignDS].[UARC_CORH_SUMMARY].[NOT_CONT_RESP]   Responses After Expiration int32 fact [CampaignDS].[UARC_CORH_SUMMARY].[RESP_AFTER_EXP]   Responses After Expiration Control Group int32 fact [CampaignDS].[UARC_CORH_SUMMARY].[RESP_AFTER_EXP_CG]  Response Transactions Control Group int32 fact [CampaignDS].[UARC_CORH_SUMMARY].[RESP_TRANS_CG]   Revenue Per Response decimal fact IF([CampaignDS].[UARC_CORH_SUMMARY].[REVENUE_PER_RESP] is missing) THEN(0) ELSE([CampaignDS].[UARC_CORH_SUMMARY].[REVENUE_PER_RESP])  Revenue Per Response Control Group decimal fact IF([CampaignDS].[UARC_CORH_SUMMARY].[REV_PER_RESP_CG] is missing) THEN(0) ELSE([CampaignDS].[UARC_CORH_SUMMARY].[REV_PER_RESP_CG])  Gross Revenue decimal fact IF([CampaignDS].[UARC_CORH_SUMMARY].[GROSS_REVENUE] is missing) THEN(0) ELSE([CampaignDS].[UARC_CORH_SUMMARY].[GROSS_REVENUE])  Gross Revenue Control Group decimal fact IF([CampaignDS].[UARC_CORH_SUMMARY].[GROSS_REVENUE_CG] is missing) THEN(0) ELSE([CampaignDS].[UARC_CORH_SUMMARY].[GROSS_REVENUE_CG])  Campaign Cell Contact History Summary Campaign ID decimal identifier [CampaignDS].[UARC_CCCH_SUMMARY].[CAMPAIGNID]  Cell ID decimal identifier [CampaignDS].[UARC_CCCH_SUMMARY].[CELLID]  Number of Offers Given float64 fact [CampaignDS].[UARC_CCCH_SUMMARY].[NUM_OF_OFFERS]   Number of Offers Given Control Group float64 fact [CampaignDS].[UARC_CCCH_SUMMARY].[NUM_OF_OFFERS_CG]   Unique Recipients float64 fact [CampaignDS].[UARC_CCCH_SUMMARY].[UNIQUE_RECIPIENTS]  Unique Recipients Control Group float64 fact [CampaignDS].[UARC_CCCH_SUMMARY].[UNIQUE_RECIP_CG]  Number of Offer Versions float64 fact [CampaignDS].[UARC_CCCH_SUMMARY].[NUM_OFF_VERS]  Number of Offer Versions Control Group float64 fact [CampaignDS].[UARC_CCCH_SUMMARY].[NUM_OFF_VERS_CG]  Campaign Cell Response History Summary Campaign ID int64 identifier [CampaignDS].[UARC_CCRH_SUMMARY].[CAMPAIGNID]  Cell ID int64 identifier [CampaignDS].[UARC_CCRH_SUMMARY].[CELLID]  Response Transactions int32 fact [CampaignDS].[UARC_CCRH_SUMMARY].[RESP_TRANS]   Unique Responders int32 fact [CampaignDS].[UARC_CCRH_SUMMARY].[UNIQUE_RESPONDERS]  Unique Responders Control Group int32 fact [CampaignDS].[UARC_CCRH_SUMMARY].[UNIQUE_RESP_CG]  Not Contacted Responders int32 fact [CampaignDS].[UARC_CCRH_SUMMARY].[NOT_CONT_RESP]   Responses After Expiration int32 fact [CampaignDS].[UARC_CCRH_SUMMARY].[RESP_AFTER_EXP]   Responses After Expiration Control Group int32 fact [CampaignDS].[UARC_CCRH_SUMMARY].[RESP_AFTER_EXP_CG]  Response Transactions Control Group int32 fact [CampaignDS].[UARC_CCRH_SUMMARY].[RESP_TRANS_CG]   Revenue Per Response decimal fact IF([CampaignDS].[UARC_CCRH_SUMMARY].[REVENUE_PER_RESP] is missing) THEN(0) ELSE([CampaignDS].[UARC_CCRH_SUMMARY].[REVENUE_PER_RESP])  Revenue Per Response Control Group decimal fact IF([CampaignDS].[UARC_CCRH_SUMMARY].[REV_PER_RESP_CG] is missing) THEN(0) ELSE([CampaignDS].[UARC_CCRH_SUMMARY].[REV_PER_RESP_CG])  Gross Revenue decimal fact IF([CampaignDS].[UARC_CCRH_SUMMARY].[GROSS_REVENUE] is missing) THEN (0) ELSE([CampaignDS].[UARC_CCRH_SUMMARY].[GROSS_REVENUE])  Gross Revenue Control Group decimal fact IF([CampaignDS].[UARC_CCRH_SUMMARY].[GROSS_REVENUE_CG] is missing) THEN(0) ELSE([CampaignDS].[UARC_CCRH_SUMMARY].[GROSS_REVENUE_CG])  Namespace/Folder Query Subject Query Item Type Usage Ref Obj/Expr. Campaign Performance Summary Star Schema Campaign Contact History Summary   (shortcut)   [Model View].[Campaign Contact History Summary] Campaign Response History Summary   (shortcut)   [Model View].[Campaign Response History Summary] Campaign Offer Contact History Summary   (shortcut)   [Model View].[Campaign Offer Contact History Summary] Campaign Offer Response History Summary   (shortcut)   [Model View].[Campaign Offer Response History Summary] Campaign Cell Contact History Summary   (shortcut)   [Model View].[Campaign Cell Contact History Summary] Campaign Cell Response History Summary   (shortcut)   [Model View].[Campaign Cell Response History Summary] Campaign   (shortcut)   [Model View].[Campaign] Offer   (shortcut)   [Model View].[Offer] Cell   (shortcut)   [Model View].[Cell] ControlCells   (shortcut)   [Model View].[Cell] Responder Rate Control Group at Cell Level   (shortcut)   [Model View].[Responder Rate Control Group at Cell Level] Namespace/Folder Query Subject Query Item Type Usage Ref Obj/Expr. Responder Rate Calculations Performance Summary Responder Rate at Cell Level Cell ID decimal identifier [Campaign Performance Summary Star Schema].[Cell][Model View].[Cell].[Cell ID]  Responder Rate float64 fact IF([Campaign Performance Summary Star Schema].[Campaign Cell Response History Summary][Model View].[Campaign Cell Response History Summary].[Unique Responders] /[Campaign Performance Summary Star Schema].[Campaign Cell Contact History Summary][Model View].[Campaign Cell Contact History Summary].[Unique Recipients] is missing) THEN(0) ELSE([Campaign Performance Summary Star Schema].[Campaign Cell Response History Summary][Model View].[Campaign Cell Response History Summary].[Unique Responders] /[Campaign Performance Summary Star Schema].[Campaign Cell Contact History Summary][Model View].[Campaign Cell Contact History Summary].[Unique Recipients])  Responder Rate Control Group at Cell Level Cell ID decimal identifier [Campaign Performance Summary Star Schema].[Cell][Model View].[Cell].[Cell ID]  Campaign ID decimal identifier [Campaign Performance Summary Star Schema].[Cell][Model View].[Cell].[Campaign ID]  Responder Rate Control Group float64 fact IF([Campaign Performance Summary Star Schema].[Campaign Cell Response History Summary][Model View].[Campaign Cell Response History Summary].[Unique Responders Control Group] /[Campaign Performance Summary Star Schema].[Campaign Cell Contact History Summary][Model View].[Campaign Cell Contact History Summary].[Unique Recipients Control Group] is missing) THEN(0) ELSE([Campaign Performance Summary Star Schema].[Campaign Cell Response History Summary][Model View].[Campaign Cell Response History Summary].[Unique Responders Control Group] /[Campaign Performance Summary Star Schema].[Campaign Cell Contact History Summary][Model View].[Campaign Cell Contact History Summary].[Unique Recipients Control Group])  Unique Recipients Control Group float64 fact [Model View].[Campaign Cell Contact History Summary].[Unique Recipients Control Group]  Unique Responders Control Group float64 fact [Model View].[Campaign Cell Response History Summary].[Unique Responders Control Group]  Campaign Detailed Response Breakout Campaign Response Breakout Campaign ID int64 identifier [CampaignDS].[UARC_CRBO].[CAMPAIGNID]  Explore Count int32 fact IF([CampaignDS].[UARC_CRBO].[EXPLORE_COUNT] is missing) THEN(0) ELSE([CampaignDS].[UARC_CRBO].[EXPLORE_COUNT])  Explore Count Control Group int32 fact IF([CampaignDS].[UARC_CRBO].[EXPLORE_COUNT_CG] is missing) THEN(0) ELSE([CampaignDS].[UARC_CRBO].[EXPLORE_COUNT_CG])  Consider Count int32 fact IF([CampaignDS].[UARC_CRBO].[CONSIDER_COUNT] is missing) THEN(0) ELSE([CampaignDS].[UARC_CRBO].[CONSIDER_COUNT])  Consider Count Control Group int32 fact IF([CampaignDS].[UARC_CRBO].[CONSIDER_COUNT_CG] is missing) THEN(0) ELSE([CampaignDS].[UARC_CRBO].[CONSIDER_COUNT_CG])  Commit Count int32 fact IF([CampaignDS].[UARC_CRBO].[COMMIT_COUNT] is missing) THEN(0) ELSE([CampaignDS].[UARC_CRBO].[COMMIT_COUNT])  Commit Count Control Group int32 fact IF([CampaignDS].[UARC_CRBO].[COMMIT_COUNT_CG] is missing) THEN(0) ELSE([CampaignDS].[UARC_CRBO].[COMMIT_COUNT_CG])  Fulfill Count int32 fact IF([CampaignDS].[UARC_CRBO].[FULFILL_COUNT] is missing) THEN(0) ELSE([CampaignDS].[UARC_CRBO].[FULFILL_COUNT])  Fulfill Count Control Group int32 fact IF([CampaignDS].[UARC_CRBO].[FULFILL_COUNT_CG] is missing) THEN(0) ELSE([CampaignDS].[UARC_CRBO].[FULFILL_COUNT_CG])  Counts As Response (All) int32 fact IF([CampaignDS].[UARC_CRBO].[ALL_COUNTS_AS_RESP] is missing) THEN(0) ELSE([CampaignDS].[UARC_CRBO].[ALL_COUNTS_AS_RESP])  All Responses int32 fact IF([CampaignDS].[UARC_CRBO].[ALL_RESPONSES] is missing) THEN(0) ELSE([CampaignDS].[UARC_CRBO].[ALL_RESPONSES])  Usage Count int32 fact IF([CampaignDS].[UARC_CRBO].[USAGE_COUNT] is missing) THEN(0) ELSE([CampaignDS].[UARC_CRBO].[USAGE_COUNT])  Usage Count Control Group int32 fact IF([CampaignDS].[UARC_CRBO].[USAGE_COUNT_CG] is missing) THEN(0) ELSE([CampaignDS].[UARC_CRBO].[USAGE_COUNT_CG])  Campaign Offer Response Breakout Campaign ID int64 identifier [CampaignDS].[UARC_CORBO].[CAMPAIGNID]  Offer ID int64 identifier [CampaignDS].[UARC_CORBO].[OFFERID]  Explore Count int32 fact IF([CampaignDS].[UARC_CORBO].[EXPLORE_COUNT] is missing) THEN(0) ELSE([CampaignDS].[UARC_CORBO].[EXPLORE_COUNT])  Explore Count Control Group int32 fact IF([CampaignDS].[UARC_CORBO].[EXPLORE_COUNT_CG] is missing) THEN(0) ELSE([CampaignDS].[UARC_CORBO].[EXPLORE_COUNT_CG])  Consider Count int32 fact IF([CampaignDS].[UARC_CORBO].[CONSIDER_COUNT] is missing) THEN(0) ELSE([CampaignDS].[UARC_CORBO].[CONSIDER_COUNT])  Consider Count Control Group int32 fact IF([CampaignDS].[UARC_CORBO].[CONSIDER_COUNT_CG] is missing) THEN(0) ELSE([CampaignDS].[UARC_CORBO].[CONSIDER_COUNT_CG])  Commit Count int32 fact IF([CampaignDS].[UARC_CORBO].[COMMIT_COUNT] is missing) THEN(0) ELSE([CampaignDS].[UARC_CORBO].[COMMIT_COUNT])  Commit Count Control Group int32 fact IF([CampaignDS].[UARC_CORBO].[COMMIT_COUNT_CG] is missing) THEN(0) ELSE([CampaignDS].[UARC_CORBO].[COMMIT_COUNT_CG])  Fulfill Count int32 fact IF([CampaignDS].[UARC_CORBO].[FULFILL_COUNT] is missing) THEN(0) ELSE([CampaignDS].[UARC_CORBO].[FULFILL_COUNT])  Fulfill Count Control Group int32 fact IF([CampaignDS].[UARC_CORBO].[FULFILL_COUNT_CG] is missing) THEN(0) ELSE([CampaignDS].[UARC_CORBO].[FULFILL_COUNT_CG])  Counts As Response (All) int32 fact IF([CampaignDS].[UARC_CORBO].[ALL_COUNTS_AS_RESP] is missing) THEN(0) ELSE([CampaignDS].[UARC_CORBO].[ALL_COUNTS_AS_RESP])  All Responses int32 fact IF([CampaignDS].[UARC_CORBO].[ALL_RESPONSES] is missing) THEN(0) ELSE([CampaignDS].[UARC_CORBO].[ALL_RESPONSES])   Usage Count int32 fact IF([CampaignDS].[UARC_CORBO].[USAGE_COUNT] is missing) THEN(0) ELSE([CampaignDS].[UARC_CORBO].[USAGE_COUNT])  Usage Count Control Group int32 fact IF([CampaignDS].[UARC_CORBO].[USAGE_COUNT_CG] is missing) THEN(0) ELSE([CampaignDS].[UARC_CORBO].[USAGE_COUNT_CG])  Namespace/Folder Query Subject Query Item Type Usage Ref Obj/Expr. Campaign Offer Response Breakout Star Schema Campaign Response Breakout   (shortcut)   [Model View].[Campaign Response Breakout] Campaign Offer Response Breakout   (shortcut)   [Model View].[Campaign Offer Response Breakout] Campaign Response History Summary   (shortcut)   [Model View].[Campaign Response History Summary] Campaign Offer Response History Summary   (shortcut)   [Model View].[Campaign Offer Response History Summary] Campaign   (shortcut)   [Model View].[Campaign] Offer   (shortcut)   [Model View].[Offer] CampToOffer   (shortcut)   [Model View].[CampToOffer] Campaign Offer Response Breakout Star Schema Campaign Contact History Summary Campaign ID decimal identifier [Campaign Performance Summary Star Schema].[Campaign Contact History Summary][Model View].[Campaign Contact History Summary].[Campaign ID]  Number of Offers Given float64 fact total ([Campaign Performance Summary Star Schema].[Campaign Contact History Summary][Model View].[Campaign Contact History Summary].[Number of Offers Given] for [Campaign Performance Summary Star Schema].[Campaign Contact History Summary][Model View].[Campaign Contact History Summary].[Campaign ID] )  Number of Offers Given Control Group float64 fact total ([Campaign Performance Summary Star Schema].[Campaign Contact History Summary][Model View].[Campaign Contact History Summary].[Number of Offers Given Control Group] for [Campaign Performance Summary Star Schema].[Campaign Contact History Summary][Model View].[Campaign Contact History Summary].[Campaign ID] )  Unique Recipients float64 fact total ([Campaign Performance Summary Star Schema].[Campaign Contact History Summary][Model View].[Campaign Contact History Summary].[Unique Recipients] for [Campaign Performance Summary Star Schema].[Campaign Contact History Summary][Model View].[Campaign Contact History Summary].[Campaign ID] )  Unique Recipients Control Group float64 fact total ([Campaign Performance Summary Star Schema].[Campaign Contact History Summary][Model View].[Campaign Contact History Summary].[Unique Recipients Control Group] for [Campaign Performance Summary Star Schema].[Campaign Contact History Summary][Model View].[Campaign Contact History Summary].[Campaign ID] )  Number of Offer Versions float64 fact total ([Campaign Performance Summary Star Schema].[Campaign Contact History Summary][Model View].[Campaign Contact History Summary].[Number of Offer Versions] for [Campaign Performance Summary Star Schema].[Campaign Contact History Summary][Model View].[Campaign Contact History Summary].[Campaign ID] )  Number of Offer Versions Control Group float64 fact total ([Campaign Performance Summary Star Schema].[Campaign Contact History Summary][Model View].[Campaign Contact History Summary].[Number of Offer Versions Control Group] for [Campaign Performance Summary Star Schema].[Campaign Contact History Summary][Model View].[Campaign Contact History Summary].[Campaign ID] )  Campaign Offer Contact History Summary Campaign ID decimal identifier [Campaign Performance Summary Star Schema].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Campaign ID]  Offer ID decimal identifier [Campaign Performance Summary Star Schema].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Offer ID]  Number of Offers Given float64 fact total ([Campaign Performance Summary Star Schema].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Number of Offers Given] for [Campaign Performance Summary Star Schema].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Campaign ID] ,[Campaign Performance Summary Star Schema].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Offer ID] )  Number of Offers Given Control Group float64 fact total ([Campaign Performance Summary Star Schema].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Number of Offers Given Control Group] for [Campaign Performance Summary Star Schema].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Campaign ID] ,[Campaign Performance Summary Star Schema].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Offer ID] )  Unique Recipients float64 fact total ([Campaign Performance Summary Star Schema].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Unique Recipients] for [Campaign Performance Summary Star Schema].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Campaign ID] ,[Campaign Performance Summary Star Schema].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Offer ID] )  Unique Recipients Control Group float64 fact total ([Campaign Performance Summary Star Schema].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Unique Recipients Control Group] for [Campaign Performance Summary Star Schema].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Campaign ID] ,[Campaign Performance Summary Star Schema].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Offer ID] )  Number of Offer Versions float64 fact total ( [Campaign Performance Summary Star Schema].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Number of Offer Versions] for [Campaign Performance Summary Star Schema].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Campaign ID] ,[Campaign Performance Summary Star Schema].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Offer ID] )  Number of Offer Versions Control Group float64 fact total ([Campaign Performance Summary Star Schema].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Number of Offer Versions Control Group] for [Campaign Performance Summary Star Schema].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Campaign ID] ,[Campaign Performance Summary Star Schema].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Offer ID] )  Campaign Contact Statuses Breakout Campaign Contact Status Breakout Campaign ID decimal identifier [CampaignDS].[UARC_CCSBO].[CAMPAIGNID]  All Contacts float64 fact [CampaignDS].[UARC_CCSBO].[ALL_CONTACTS]  Counts As Contact (All) float64 fact [CampaignDS].[UARC_CCSBO].[ALL_COUNTS_AS_CONT]  Campaign Send Count float64 fact [CampaignDS].[UARC_CCSBO].[CAMP_SEND_COUNT]  Delivered Count float64 fact [CampaignDS].[UARC_CCSBO].[DELIVERED_COUNT]  Undelivered Count float64 fact [CampaignDS].[UARC_CCSBO].[UNDELIVERED_COUNT]  Control Count float64 fact [CampaignDS].[UARC_CCSBO].[CONTROL_COUNT]  Campaign Offer Contact Status Breakout Campaign ID decimal identifier [CampaignDS].[UARC_COCSBO].[CAMPAIGNID]  Offer ID decimal identifier [CampaignDS].[UARC_COCSBO].[OFFERID]  All Contacts float64 fact [CampaignDS].[UARC_COCSBO].[ALL_CONTACTS]  Counts As Contact (All) float64 fact [CampaignDS].[UARC_COCSBO].[ALL_COUNTS_AS_CONT]  Campaign Send Count float64 fact [CampaignDS].[UARC_COCSBO].[CAMP_SEND_COUNT]  Delivered Count float64 fact [CampaignDS].[UARC_COCSBO].[DELIVERED_COUNT]  Undelivered Count float64 fact [CampaignDS].[UARC_COCSBO].[UNDELIVERED_COUNT]  Control Count float64 fact [CampaignDS].[UARC_COCSBO].[CONTROL_COUNT]  Namespace/Folder Query Subject Query Item Type Usage Ref Obj/Expr. Campaign Offer Contact Statuses Breakout Star Schema Campaign Response History Summary   (shortcut)   [Model View].[Campaign Response History Summary] Campaign Offer Response History Summary   (shortcut)   [Model View].[Campaign Offer Response History Summary] Campaign   (shortcut)   [Model View].[Campaign] Offer   (shortcut)   [Model View].[Offer] CampToOffer   (shortcut)   [Model View].[CampToOffer] Campaign Contact Status Breakout   (shortcut)   [Model View].[Campaign Contact Status Breakout] Campaign Offer Contact Status Breakout   (shortcut)   [Model View].[Campaign Offer Contact Status Breakout] Campaign Offer Contact Statuses Breakout Star Schema Campaign Contact History Summary Campaign ID decimal identifier [Campaign Performance Summary Star Schema].[Campaign Contact History Summary][Model View].[Campaign Contact History Summary].[Campaign ID]  Number of Offers Given float64 fact total ([Campaign Performance Summary Star Schema].[Campaign Contact History Summary][Model View].[Campaign Contact History Summary].[Number of Offers Given] for [Campaign Performance Summary Star Schema].[Campaign Contact History Summary][Model View].[Campaign Contact History Summary].[Campaign ID] )  Number of Offers Given Control Group float64 fact total ([Campaign Performance Summary Star Schema].[Campaign Contact History Summary][Model View].[Campaign Contact History Summary].[Number of Offers Given Control Group] for [Campaign Performance Summary Star Schema].[Campaign Contact History Summary][Model View].[Campaign Contact History Summary].[Campaign ID] )  Unique Recipients float64 fact total ([Campaign Performance Summary Star Schema].[Campaign Contact History Summary][Model View].[Campaign Contact History Summary].[Unique Recipients] for [Campaign Performance Summary Star Schema].[Campaign Contact History Summary][Model View].[Campaign Contact History Summary].[Campaign ID] )  Unique Recipients Control Group float64 fact total ([Campaign Performance Summary Star Schema].[Campaign Contact History Summary][Model View].[Campaign Contact History Summary].[Unique Recipients Control Group] for [Campaign Performance Summary Star Schema].[Campaign Contact History Summary][Model View].[Campaign Contact History Summary].[Campaign ID] )  Number of Offer Versions float64 fact total ([Campaign Performance Summary Star Schema].[Campaign Contact History Summary][Model View].[Campaign Contact History Summary].[Number of Offer Versions] for [Campaign Performance Summary Star Schema].[Campaign Contact History Summary][Model View].[Campaign Contact History Summary].[Campaign ID] )  Number of Offer Versions Control Group float64 fact total ([Campaign Performance Summary Star Schema].[Campaign Contact History Summary][Model View].[Campaign Contact History Summary].[Number of Offer Versions Control Group] for [Campaign Performance Summary Star Schema].[Campaign Contact History Summary][Model View].[Campaign Contact History Summary].[Campaign ID] )  Campaign Offer Contact History Summary Campaign ID decimal identifier [Campaign Performance Summary Star Schema].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Campaign ID]  Offer ID decimal identifier [Campaign Performance Summary Star Schema].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Offer ID]  Number of Offers Given float64 fact total ([Campaign Performance Summary Star Schema].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Number of Offers Given] for [Campaign Performance Summary Star Schema].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Campaign ID] ,[Campaign Performance Summary Star Schema].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Offer ID] )  Number of Offers Given Control Group float64 fact total ([Campaign Performance Summary Star Schema].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Number of Offers Given Control Group] for [Campaign Performance Summary Star Schema].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Campaign ID] ,[Campaign Performance Summary Star Schema].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Offer ID] )  Unique Recipients float64 fact total ([Campaign Performance Summary Star Schema].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Unique Recipients] for [Campaign Performance Summary Star Schema].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Campaign ID] ,[Campaign Performance Summary Star Schema].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Offer ID] )  Unique Recipients Control Group float64 fact total ([Campaign Performance Summary Star Schema].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Unique Recipients Control Group] for [Campaign Performance Summary Star Schema].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Campaign ID] ,[Campaign Performance Summary Star Schema].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Offer ID] )  Number of Offer Versions float64 fact total ( [Campaign Performance Summary Star Schema].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Number of Offer Versions] for [Campaign Performance Summary Star Schema].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Campaign ID] ,[Campaign Performance Summary Star Schema].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Offer ID] )  Number of Offer Versions Control Group float64 fact total ([Campaign Performance Summary Star Schema].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Number of Offer Versions Control Group] for [Campaign Performance Summary Star Schema].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Campaign ID] ,[Campaign Performance Summary Star Schema].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Offer ID] )  Namespace/Folder Query Subject Query Item Type Usage Ref Obj/Expr. Offer Performance by Day Offer Contact History by Day Offer ID decimal identifier [CampaignDS].[UARC_OCH_DY].[OFFERID]  Actual Date dateTime attribute [CampaignDS].[UARC_OCH_DY].[ACTUALDATE]  Number of Offers Given float64 fact [CampaignDS].[UARC_OCH_DY].[NUM_OF_OFFERS]   Number of Offers Given Control Group float64 fact [CampaignDS].[UARC_OCH_DY].[NUM_OF_OFFERS_CG]   Number of Offer Versions float64 fact [CampaignDS].[UARC_OCH_DY].[NUM_OFF_VERS]  Number of Offer Versions Control Group float64 fact [CampaignDS].[UARC_OCH_DY].[NUM_OFF_VERS_CG]  Unique Recipients float64 fact [CampaignDS].[UARC_OCH_DY].[UNIQUE_RECIPIENTS]  Unique Recipients Control Group float64 fact [CampaignDS].[UARC_OCH_DY].[UNIQUE_RECIP_CG]  Offer Campaign Contact History by Day Offer ID decimal identifier [CampaignDS].[UARC_OCCH_DY].[OFFERID]  Campaign ID decimal identifier [CampaignDS].[UARC_OCCH_DY].[CAMPAIGNID]  Actual Date dateTime attribute [CampaignDS].[UARC_OCCH_DY].[ACTUALDATE]  Number of Offers Given float64 fact [CampaignDS].[UARC_OCCH_DY].[NUM_OF_OFFERS]   Number of Offers Given Control Group float64 fact [CampaignDS].[UARC_OCCH_DY].[NUM_OF_OFFERS_CG]   Number of Offer Versions float64 fact [CampaignDS].[UARC_OCCH_DY].[NUM_OFF_VERS]  Number of Offer Versions Control Group float64 fact [CampaignDS].[UARC_OCCH_DY].[NUM_OFF_VERS_CG]  Unique Recipients float64 fact [CampaignDS].[UARC_OCCH_DY].[UNIQUE_RECIPIENTS]  Unique Recipients Control Group float64 fact [CampaignDS].[UARC_OCCH_DY].[UNIQUE_RECIP_CG]  Offer Campaign Response History by Day Offer ID decimal identifier [CampaignDS].[UARC_OCRH_DY].[OFFERID]  Campaign ID decimal identifier [CampaignDS].[UARC_OCRH_DY].[CAMPAIGNID]  Actual Date dateTime attribute [CampaignDS].[UARC_OCRH_DY].[ACTUALDATE]  Response Transactions float64 fact [CampaignDS].[UARC_OCRH_DY].[RESP_TRANS]   Response Transactions Control Group float64 fact [CampaignDS].[UARC_OCRH_DY].[RESP_TRANS_CG]  Unique Responders float64 fact [CampaignDS].[UARC_OCRH_DY].[UNIQUE_RESPONDERS]  Unique Responders Control Group float64 fact [CampaignDS].[UARC_OCRH_DY].[UNIQUE_RESP_CG]  Not Contacted Responders float64 fact [CampaignDS].[UARC_OCRH_DY].[NOT_CONT_RESP]   Responses After Expiration float64 fact [CampaignDS].[UARC_OCRH_DY].[RESP_AFTER_EXP]   Responses After Expiration Control Group float64 fact [CampaignDS].[UARC_OCRH_DY].[RESP_AFTER_EXP_CG]  Revenue Per Response float64 fact [CampaignDS].[UARC_OCRH_DY].[REVENUE_PER_RESP]   Revenue Per Response Control Group float64 fact [CampaignDS].[UARC_OCRH_DY].[REV_PER_RESP_CG]  Gross Revenue float64 fact [CampaignDS].[UARC_OCRH_DY].[GROSS_REVENUE]  Gross Revenue Control Group float64 fact [CampaignDS].[UARC_OCRH_DY].[GROSS_REVENUE_CG]  Offer Response History by Day Offer Id decimal identifier [CampaignDS].[UARC_ORH_DY].[OFFERID]  Actual Date dateTime attribute [CampaignDS].[UARC_ORH_DY].[ACTUALDATE]  Response Transactions float64 fact [CampaignDS].[UARC_ORH_DY].[RESP_TRANS]  Response Transactions Control Group float64 fact [CampaignDS].[UARC_ORH_DY].[RESP_TRANS_CG]  Unique Responders float64 fact [CampaignDS].[UARC_ORH_DY].[UNIQUE_RESPONDERS]  Unique Responders Control Group float64 fact [CampaignDS].[UARC_ORH_DY].[UNIQUE_RESP_CG]  Not Contacted Responders float64 fact [CampaignDS].[UARC_ORH_DY].[NOT_CONT_RESP]  Responses After Expiration float64 fact [CampaignDS].[UARC_ORH_DY].[RESP_AFTER_EXP]  Responses After Expiration Control Group float64 fact [CampaignDS].[UARC_ORH_DY].[RESP_AFTER_EXP_CG]  Revenue Per Response float64 fact [CampaignDS].[UARC_ORH_DY].[REVENUE_PER_RESP]  Revenue Per Response Control Group float64 fact [CampaignDS].[UARC_ORH_DY].[REV_PER_RESP_CG]  Gross Revenue float64 fact [CampaignDS].[UARC_ORH_DY].[GROSS_REVENUE]  Gross Revenue Control Group float64 fact [CampaignDS].[UARC_ORH_DY].[GROSS_REVENUE_CG]  Namespace/Folder Query Subject Query Item Type Usage Ref Obj/Expr. Offer Performance by Day Star Schema Offer Contact History by Day   (shortcut)   [Model View].[Offer Contact History by Day] Offer Campaign Contact History by Day   (shortcut)   [Model View].[Offer Campaign Contact History by Day] Offer Campaign Response History by Day   (shortcut)   [Model View].[Offer Campaign Response History by Day] Offer Response History by Day   (shortcut)   [Model View].[Offer Response History by Day] Campaign   (shortcut)   [Model View].[Campaign] Offer   (shortcut)   [Model View].[Offer] Calendar   (shortcut)   [Model View].[Calendar] Offer Performance by Month Offer Contact History by Month Offer ID decimal identifier [CampaignDS].[UARC_OCH_MO].[OFFERID]  Month float64 attribute [CampaignDS].[UARC_OCH_MO].[MONTH]  Year float64 attribute [CampaignDS].[UARC_OCH_MO].[YEAR]  Number of Offers Given float64 fact [CampaignDS].[UARC_OCH_MO].[NUM_OF_OFFERS]   Number of Offers Given Control Group float64 fact [CampaignDS].[UARC_OCH_MO].[NUM_OF_OFFERS_CG]   Number of Offer Versions float64 fact [CampaignDS].[UARC_OCH_MO].[NUM_OFF_VERS]  Number of Offer Versions Control Group float64 fact [CampaignDS].[UARC_OCH_MO].[NUM_OFF_VERS_CG]  Unique Recipients float64 fact [CampaignDS].[UARC_OCH_MO].[UNIQUE_RECIPIENTS]  Unique Recipients Control Group float64 fact [CampaignDS].[UARC_OCH_MO].[UNIQUE_RECIP_CG]  Offer Campaign Contact History by Month Offer ID decimal identifier [CampaignDS].[UARC_OCCH_MO].[OFFERID]  Campaign ID decimal identifier [CampaignDS].[UARC_OCCH_MO].[CAMPAIGNID]  Month float64 attribute [CampaignDS].[UARC_OCCH_MO].[MONTH]  Year float64 attribute [CampaignDS].[UARC_OCCH_MO].[YEAR]  Number of Offers Given float64 fact [CampaignDS].[UARC_OCCH_MO].[NUM_OF_OFFERS]   Number of Offers Given Control Group float64 fact [CampaignDS].[UARC_OCCH_MO].[NUM_OF_OFFERS_CG]   Number of Offer Versions float64 fact [CampaignDS].[UARC_OCCH_MO].[NUM_OFF_VERS]  Number of Offer Versions Control Group float64 fact [CampaignDS].[UARC_OCCH_MO].[NUM_OFF_VERS_CG]  Unique Recipients float64 fact [CampaignDS].[UARC_OCCH_MO].[UNIQUE_RECIPIENTS]  Unique Recipients Control Group float64 fact [CampaignDS].[UARC_OCCH_MO].[UNIQUE_RECIP_CG]  Offer Campaign Response History by Month Offer ID decimal identifier [CampaignDS].[UARC_OCRH_MO].[OFFERID]  Campaign ID decimal identifier [CampaignDS].[UARC_OCRH_MO].[CAMPAIGNID]  Month decimal attribute [CampaignDS].[UARC_OCRH_MO].[MONTH]  Year decimal attribute [CampaignDS].[UARC_OCRH_MO].[YEAR]  Response Transactions float64 fact [CampaignDS].[UARC_OCRH_MO].[RESP_TRANS]   Response Transactions Control Group float64 fact [CampaignDS].[UARC_OCRH_MO].[RESP_TRANS_CG]  Unique Responders float64 fact [CampaignDS].[UARC_OCRH_MO].[UNIQUE_RESPONDERS]  Unique Responders Control Group float64 fact [CampaignDS].[UARC_OCRH_MO].[UNIQUE_RESP_CG]  Not Contacted Responders float64 fact [CampaignDS].[UARC_OCRH_MO].[NOT_CONT_RESP]   Responses After Expiration float64 fact [CampaignDS].[UARC_OCRH_MO].[RESP_AFTER_EXP]   Responses After Expiration Control Group float64 fact [CampaignDS].[UARC_OCRH_MO].[RESP_AFTER_EXP_CG]  Revenue Per Response float64 fact [CampaignDS].[UARC_OCRH_MO].[REVENUE_PER_RESP]   Revenue Per Response Control Group float64 fact [CampaignDS].[UARC_OCRH_MO].[REV_PER_RESP_CG]  Gross Revenue float64 fact [CampaignDS].[UARC_OCRH_MO].[GROSS_REVENUE]  Gross Revenue Control Group float64 fact [CampaignDS].[UARC_OCRH_MO].[GROSS_REVENUE_CG]  Offer Response History by Month Offer Id decimal identifier [CampaignDS].[UARC_ORH_MO].[OFFERID]  Month decimal attribute [CampaignDS].[UARC_ORH_MO].[MONTH]  Year decimal attribute [CampaignDS].[UARC_ORH_MO].[YEAR]  Response Transactions float64 fact [CampaignDS].[UARC_ORH_MO].[RESP_TRANS]  Response Transactions Control Group float64 fact [CampaignDS].[UARC_ORH_MO].[RESP_TRANS_CG]  Unique Responders float64 fact [CampaignDS].[UARC_ORH_MO].[UNIQUE_RESPONDERS]  Unique Respondersroup float64 fact [CampaignDS].[UARC_ORH_MO].[UNIQUE_RESP_CG]  Not Contacted Responders float64 fact [CampaignDS].[UARC_ORH_MO].[NOT_CONT_RESP]  Responses After Expiration float64 fact [CampaignDS].[UARC_ORH_MO].[RESP_AFTER_EXP]  Responses After Expiration Control Group float64 fact [CampaignDS].[UARC_ORH_MO].[RESP_AFTER_EXP_CG]  Revenue Per Response float64 fact [CampaignDS].[UARC_ORH_MO].[REVENUE_PER_RESP]  Revenue Per Response Control Group float64 fact [CampaignDS].[UARC_ORH_MO].[REV_PER_RESP_CG]  Gross Revenue float64 fact [CampaignDS].[UARC_ORH_MO].[GROSS_REVENUE]  Gross Revenue Control Group float64 fact [CampaignDS].[UARC_ORH_MO].[GROSS_REVENUE_CG]  Namespace/Folder Query Subject Query Item Type Usage Ref Obj/Expr. Offer Performance by Month Star Schema Offer Contact History by Month   (shortcut)   [Model View].[Offer Contact History by Month] Offer Campaign Contact History by Month   (shortcut)   [Model View].[Offer Campaign Contact History by Month] Offer Campaign Response History by Month   (shortcut)   [Model View].[Offer Campaign Response History by Month] Offer Response History by Month   (shortcut)   [Model View].[Offer Response History by Month] Campaign   (shortcut)   [Model View].[Campaign] Offer   (shortcut)   [Model View].[Offer] Calendar Month   (shortcut)   [Model View].[Calendar Month] Offer Performance Summary Offer Contact History Summary Offer ID decimal identifier [CampaignDS].[UARC_OCH_SUMMARY].[OFFERID]  Number of Offers Given float64 fact [CampaignDS].[UARC_OCH_SUMMARY].[NUM_OF_OFFERS]   Number of Offers Given Control Group float64 fact [CampaignDS].[UARC_OCH_SUMMARY].[NUM_OF_OFFERS_CG]   Number of Offer Versions float64 fact [CampaignDS].[UARC_OCH_SUMMARY].[NUM_OFF_VERS]  Number of Offer Versions Control Group float64 fact [CampaignDS].[UARC_OCH_SUMMARY].[NUM_OFF_VERS_CG]  Unique Recipients float64 fact [CampaignDS].[UARC_OCH_SUMMARY].[UNIQUE_RECIPIENTS]  Unique Recipients Control Group float64 fact [CampaignDS].[UARC_OCH_SUMMARY].[UNIQUE_RECIP_CG]  Offer Campaign Contact History Summary Offer ID decimal identifier [CampaignDS].[UARC_OCCH_SUMMARY].[OFFERID]  Campaign ID decimal identifier [CampaignDS].[UARC_OCCH_SUMMARY].[CAMPAIGNID]  Number of Offers Given float64 fact [CampaignDS].[UARC_OCCH_SUMMARY].[NUM_OF_OFFERS]   Number of Offers Given Control Group float64 fact [CampaignDS].[UARC_OCCH_SUMMARY].[NUM_OF_OFFERS_CG]   Number of Offer Versions float64 fact [CampaignDS].[UARC_OCCH_SUMMARY].[NUM_OFF_VERS]  Number of Offer Versions Control Group float64 fact [CampaignDS].[UARC_OCCH_SUMMARY].[NUM_OFF_VERS_CG]  Unique Recipients float64 fact [CampaignDS].[UARC_OCCH_SUMMARY].[UNIQUE_RECIPIENTS]  Unique Recipients Control Group float64 fact [CampaignDS].[UARC_OCCH_SUMMARY].[UNIQUE_RECIP_CG]  Offer Campaign Response History Summary Offer ID decimal identifier [CampaignDS].[UARC_OCRH_SUMMARY].[OFFERID]  Campaign ID decimal identifier [CampaignDS].[UARC_OCRH_SUMMARY].[CAMPAIGNID]  Response Transactions float64 fact [CampaignDS].[UARC_OCRH_SUMMARY].[RESP_TRANS]   Response Transactions Control Group float64 fact [CampaignDS].[UARC_OCRH_SUMMARY].[RESP_TRANS_CG]  Unique Responders float64 fact [CampaignDS].[UARC_OCRH_SUMMARY].[UNIQUE_RESPONDERS]  Unique Responders Control Group float64 fact [CampaignDS].[UARC_OCRH_SUMMARY].[UNIQUE_RESP_CG]  Not Contacted Responders float64 fact [CampaignDS].[UARC_OCRH_SUMMARY].[NOT_CONT_RESP]   Responses After Expiration float64 fact [CampaignDS].[UARC_OCRH_SUMMARY].[RESP_AFTER_EXP]   Responses After Expiration Control Group float64 fact [CampaignDS].[UARC_OCRH_SUMMARY].[RESP_AFTER_EXP_CG]  Revenue Per Response float64 fact IF( [CampaignDS].[UARC_OCRH_SUMMARY].[REVENUE_PER_RESP] is missing) THEN (0) ELSE ([CampaignDS].[UARC_OCRH_SUMMARY].[REVENUE_PER_RESP])  Revenue Per Response Control Group float64 fact IF ([CampaignDS].[UARC_OCRH_SUMMARY].[REV_PER_RESP_CG] is missing) THEN (0) ELSE ([CampaignDS].[UARC_OCRH_SUMMARY].[REV_PER_RESP_CG])  Gross Revenue float64 fact IF ([CampaignDS].[UARC_OCRH_SUMMARY].[GROSS_REVENUE] is missing) THEN (0) ELSE ([CampaignDS].[UARC_OCRH_SUMMARY].[GROSS_REVENUE])  Gross Revenue Control Group float64 fact IF ([CampaignDS].[UARC_OCRH_SUMMARY].[GROSS_REVENUE_CG] is missing) THEN (0) ELSE ([CampaignDS].[UARC_OCRH_SUMMARY].[GROSS_REVENUE_CG])  Offer Response History Summary Offer Id decimal identifier [CampaignDS].[UARC_ORH_SUMMARY].[OFFERID]  Response Transactions float64 fact [CampaignDS].[UARC_ORH_SUMMARY].[RESP_TRANS]  Response Transactions Control Group float64 fact [CampaignDS].[UARC_ORH_SUMMARY].[RESP_TRANS_CG]  Unique Responders float64 fact [CampaignDS].[UARC_ORH_SUMMARY].[UNIQUE_RESPONDERS]  Unique Responders Control Group float64 fact [CampaignDS].[UARC_ORH_SUMMARY].[UNIQUE_RESP_CG]  Not Contacted Responders float64 fact [CampaignDS].[UARC_ORH_SUMMARY].[NOT_CONT_RESP]  Responses After Expiration float64 fact [CampaignDS].[UARC_ORH_SUMMARY].[RESP_AFTER_EXP]  Responses After Expiration Control Group float64 fact [CampaignDS].[UARC_ORH_SUMMARY].[RESP_AFTER_EXP_CG]  Revenue Per Response float64 fact IF ([CampaignDS].[UARC_ORH_SUMMARY].[REVENUE_PER_RESP] is missing) THEN (0) ELSE ([CampaignDS].[UARC_ORH_SUMMARY].[REVENUE_PER_RESP])  Revenue Per Response Control Group float64 fact IF ([CampaignDS].[UARC_ORH_SUMMARY].[REV_PER_RESP_CG] is missing) THEN (0) ELSE ([CampaignDS].[UARC_ORH_SUMMARY].[REV_PER_RESP_CG])  Gross Revenue float64 fact IF([CampaignDS].[UARC_ORH_SUMMARY].[GROSS_REVENUE] is missing) THEN (0) ELSE ([CampaignDS].[UARC_ORH_SUMMARY].[GROSS_REVENUE])  Gross Revenue Control Group float64 fact IF ([CampaignDS].[UARC_ORH_SUMMARY].[GROSS_REVENUE_CG] is missing) THEN (0) ELSE ([CampaignDS].[UARC_ORH_SUMMARY].[GROSS_REVENUE_CG])  Offer Performance Metrics Summary Offer ID int64 fact [CampaignDS].[UARC_OPM_SUMMARY].[OFFERID]  Best Match int32 fact [CampaignDS].[UARC_OPM_SUMMARY].[BEST_MATCH]  Best Match Control Group int32 fact [CampaignDS].[UARC_OPM_SUMMARY].[BEST_MATCH_CG]  Fractional Match float64 fact [CampaignDS].[UARC_OPM_SUMMARY].[FRACTIONAL_MATCH]  Multiple Match float64 fact [CampaignDS].[UARC_OPM_SUMMARY].[MULTIPLE_MATCH]  Namespace/Folder Query Subject Query Item Type Usage Ref Obj/Expr. Offer Performance Summary Star Schema Offer Contact History Summary   (shortcut)   [Model View].[Offer Contact History Summary] Offer Campaign Contact History Summary   (shortcut)   [Model View].[Offer Campaign Contact History Summary] Offer Campaign Response History Summary   (shortcut)   [Model View].[Offer Campaign Response History Summary] Offer Response History Summary   (shortcut)   [Model View].[Offer Response History Summary] Offer Performance Metrics Summary   (shortcut)   [Model View].[Offer Performance Metrics Summary] Campaign   (shortcut)   [Model View].[Campaign] Offer   (shortcut)   [Model View].[Offer] Campaign Project by Offer Performance Campaign Offer Project Performance Summary Metrics Project ID float64 identifier   Project Total Cost float64 fact   Project Total Revenue float64 fact   Namespace/Folder Query Subject Query Item Type Usage Ref Obj/Expr. Campaign Project by Offer Performance Summary Star Schema Campaign Offer Response History Summary   (shortcut)   [Model View].[Campaign Offer Response History Summary] Offer Custom Attributes   (shortcut)   [Model View].[Offer Custom Attributes] Campaign   (shortcut)   [Model View].[Campaign] Offer   (shortcut)   [Model View].[Offer] CampToOffer   (shortcut)   [Model View].[CampToOffer] Project Performance Summary Metrics   (shortcut)   [Model View].[Project Performance Summary Metrics] Project Budget   (shortcut)   [MarketingOperationsMV].[Project Budget] Campaign Project by Offer Performance Summary Star Schema Distinct Campaigns for Offers Campaign ID decimal identifier   Campaign Project by Cell Performance Campaign Cell Offer Contact History Summary Campaign ID decimal identifier [CampaignDS].[UARC_CCOCH_SUMMARY].[CAMPAIGNID]  Cell ID decimal identifier [CampaignDS].[UARC_CCOCH_SUMMARY].[CELLID]  Offer ID decimal identifier [CampaignDS].[UARC_CCOCH_SUMMARY].[OFFERID]  Number of Offers Given float64 fact [CampaignDS].[UARC_CCOCH_SUMMARY].[NUM_OF_OFFERS]  Number of Offers Given Control Group float64 fact [CampaignDS].[UARC_CCOCH_SUMMARY].[NUM_OF_OFFERS_CG]  Unique Recipients float64 fact [CampaignDS].[UARC_CCOCH_SUMMARY].[UNIQUE_RECIPIENTS]  Unique Recipients Control Group float64 fact [CampaignDS].[UARC_CCOCH_SUMMARY].[UNIQUE_RECIP_CG]  Number of Offer Versions float64 fact [CampaignDS].[UARC_CCOCH_SUMMARY].[NUM_OFF_VERS]  Number of Offer Versions Control Group float64 fact [CampaignDS].[UARC_CCOCH_SUMMARY].[NUM_OFF_VERS_CG]  Campaign Cell Offer Response History Summary Campaign ID decimal identifier [CampaignDS].[UARC_CCORH_SUMMARY].[CAMPAIGNID]  Cell ID decimal identifier [CampaignDS].[UARC_CCORH_SUMMARY].[CELLID]  Offer ID decimal identifier [CampaignDS].[UARC_CCORH_SUMMARY].[OFFERID]  Response Transactions float64 fact [CampaignDS].[UARC_CCORH_SUMMARY].[RESP_TRANS]  Unique Responders float64 fact [CampaignDS].[UARC_CCORH_SUMMARY].[UNIQUE_RESPONDERS]  Unique Responders Control Group float64 fact [CampaignDS].[UARC_CCORH_SUMMARY].[UNIQUE_RESP_CG]  Not Contacted Responders float64 fact [CampaignDS].[UARC_CCORH_SUMMARY].[NOT_CONT_RESP]  Responses After Expiration float64 fact [CampaignDS].[UARC_CCORH_SUMMARY].[RESP_AFTER_EXP]  Responses After Expiration Control Group float64 fact [CampaignDS].[UARC_CCORH_SUMMARY].[RESP_AFTER_EXP_CG]  Response Transactions Control Group float64 fact [CampaignDS].[UARC_CCORH_SUMMARY].[RESP_TRANS_CG]  Revenue Per Response float64 fact IF([CampaignDS].[UARC_CCORH_SUMMARY].[REVENUE_PER_RESP] is missing) THEN(0) ELSE([CampaignDS].[UARC_CCORH_SUMMARY].[REVENUE_PER_RESP])  Revenue Per Response Control Group float64 fact IF([CampaignDS].[UARC_CCORH_SUMMARY].[REV_PER_RESP_CG] is missing) THEN(0) ELSE([CampaignDS].[UARC_CCORH_SUMMARY].[REV_PER_RESP_CG])  Gross Revenue float64 fact IF([CampaignDS].[UARC_CCORH_SUMMARY].[GROSS_REVENUE] is missing) THEN (0) ELSE([CampaignDS].[UARC_CCORH_SUMMARY].[GROSS_REVENUE])  Gross Revenue Control Group float64 fact IF([CampaignDS].[UARC_CCORH_SUMMARY].[GROSS_REVENUE_CG] is missing) THEN(0) ELSE([CampaignDS].[UARC_CCORH_SUMMARY].[GROSS_REVENUE_CG])  Project Performance Summary Metrics Project ID float64 identifier   Project Total Cost float64 fact   Project Total Revenue float64 fact   CCOCH and Offer Attributes Campaign ID decimal identifier [Model View].[Campaign Cell Offer Contact History Summary].[Campaign ID]  Cell ID decimal identifier [Model View].[Campaign Cell Offer Contact History Summary].[Cell ID]  Offer ID decimal identifier [Model View].[Campaign Cell Offer Contact History Summary].[Offer ID]  Number of Offers Given float64 fact [Model View].[Campaign Cell Offer Contact History Summary].[Number of Offers Given]  Number of Offers Given Control Group float64 fact [Model View].[Campaign Cell Offer Contact History Summary].[Number of Offers Given Control Group]  Unique Recipients float64 fact [Model View].[Campaign Cell Offer Contact History Summary].[Unique Recipients]  Unique Recipients Control Group float64 fact [Model View].[Campaign Cell Offer Contact History Summary].[Unique Recipients Control Group]  Number of Offer Versions float64 fact [Model View].[Campaign Cell Offer Contact History Summary].[Number of Offer Versions]  Number of Offer Versions Control Group float64 fact [Model View].[Campaign Cell Offer Contact History Summary].[Number of Offer Versions Control Group]  Offer Fulfillment Cost float64 fact [Model View].[Offer Custom Attributes].[Offer Fulfillment Cost]  Offer Fixed Cost float64 fact [Model View].[Offer Custom Attributes].[Offer Fixed Cost]  Actual Cost float64 fact [Model View].[CCOCH and Offer Attributes].[Unique Recipients] * [Model View].[CCOCH and Offer Attributes].[Offer Fulfillment Cost] + [Model View].[CCOCH and Offer Attributes].[Offer Fixed Cost]  Cell without Ctrl Cells Cell ID decimal identifier [CampaignDS].[UARC_CELL].[CELLID]  Cell Name characterLength16 attribute [CampaignDS].[UARC_CELL].[CELLNAME]  Cell Code characterLength16 attribute [CampaignDS].[UARC_CELL].[CELLCODE]  Control Cell ID decimal attribute [CampaignDS].[UARC_CELL].[CONTROLCELLID]  Is Control int64 attribute [CampaignDS].[UARC_CELL].[ISCONTROL]  Campaign ID decimal identifier [CampaignDS].[UARC_CELL].[CAMPAIGNID]  Namespace/Folder Query Subject Query Item Type Usage Ref Obj/Expr. Campaign Project by Cell Performance Summary Star Schema Campaign   (shortcut)   [Model View].[Campaign] Cell without Ctrl Cells   (shortcut)   [Model View].[Cell without Ctrl Cells] CCOCH and Offer Attributes   (shortcut)   [Model View].[CCOCH and Offer Attributes] Campaign Cell Offer Response History Summary   (shortcut)   [Model View].[Campaign Cell Offer Response History Summary] Project Performance Summary Metrics   (shortcut)   [Model View].[Project Performance Summary Metrics] Project Budget   (shortcut)   [MarketingOperationsMV].[Project Budget] Campaign Project by Cell Performance Summary Star Schema Distinct Campaigns for Cells Campaign ID decimal identifier