Unica Marketing Operations Cognos Framework Manager Model Specification

Business View

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]
		Parent Project ID	float64	identifier	[MarketingOperationsMV].[Project].[Parent Project ID]
	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]
		Request Parent Project ID	float64	identifier	[MarketingOperationsMV].[Project Requests].[Request Parent Project ID]
	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]
Template Instance Display			characterLength16	attribute	[MarketingOperationsMV].[Program Template].[Template Instance 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	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]

Model View

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]
		Parent Project ID	float64	identifier	[MarketingOperationsDS].[uap_projects].[PARENT_PROJ_ID]
	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]
		Request Parent Project ID	float64	identifier	[MarketingOperationsDS].[uap_projects].[PARENT_PROJ_ID]
	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 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 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 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]
		Template Instance Display	characterLength16	attribute	[MarketingOperationsMV].[Template].[Template Instance 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]
		Request Parent Project ID	float64	identifier	[MarketingOperationsMV].[Project Requests].[Request Parent Project ID]
	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]
		Parent Project ID	float64	identifier	[MarketingOperationsMV].[Project].[Parent Project ID]
	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], 1, 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]

Import View