Unica Marketing Operations Cognos Framework Manager Model Specification


Project: MarketingOperationsModel
Supported Locale(s): en fr de es 
Package(s): Unica Marketing Operations Package
NameCM DataSource
MarketingOperationsDSMarketingOperationsDS

Parameter MapKey - Values
EnvironmentURL: http://localhost:7001/plan/callback.jsp?
Version: 8.1.0.00

model/MarketingOperationsModel.jpg
Folder: Business View
Folder: Model View
Folder: Import View


Business View
model/Business View.jpg
Namespace/FolderQuery SubjectQuery ItemTypeUsageRef Obj/Expr.
CommonUserUser IDfloat64identifier[MarketingOperationsMV].[User].[User ID] 
Last NamecharacterLength16attribute[MarketingOperationsMV].[User].[Last Name] 
First NamecharacterLength16attribute[MarketingOperationsMV].[User].[First Name] 
Email AddresscharacterLength16attribute[MarketingOperationsMV].[User].[Email Address] 
User Full Name - First LastcharacterLength16attribute[MarketingOperationsMV].[User].[User Full Name - First Last] 
User Full Name - Last, FirstcharacterLength16attribute[MarketingOperationsMV].[User].[User Full Name - Last, First] 
Last Modified DatedateTimeidentifier[MarketingOperationsMV].[User].[Last Modified Date] 
Login IDcharacterLength16attribute[MarketingOperationsMV].[User].[Login ID] 
Status CodecharacterLength16attribute[MarketingOperationsMV].[User].[Status Code] 
StatusStatus CodecharacterLength16identifier[MarketingOperationsMV].[Status].[Status Code] 
StatuscharacterLength16attribute[MarketingOperationsMV].[Status].[Status] 
Users Rolesuser_idfloat64identifier[MarketingOperationsMV].[Users Roles].[user_id] 
role_idfloat64identifier[MarketingOperationsMV].[Users Roles].[role_id] 
role_namecharacterLength16attribute[MarketingOperationsMV].[Users Roles].[role_name] 
TeamTeam IDfloat64identifier[MarketingOperationsMV].[Team Member].[Team ID] 
Team NamecharacterLength16attribute[MarketingOperationsMV].[Team].[Team Name] 
Team DescriptioncharacterLength16attribute[MarketingOperationsMV].[Team].[Team Description] 
Team Member IDfloat64identifier[MarketingOperationsMV].[User].[User ID] 
Team Member Name - First LastcharacterLength16attribute[MarketingOperationsMV].[User].[User Full Name - First Last] 
Team Member Type IDfloat64identifier[MarketingOperationsMV].[Member Type].[Member Type ID] 
Team Member Type NamecharacterLength16attribute[MarketingOperationsMV].[Member Type].[Member Type Name] 
List DefinitionsVendorVendor IDfloat64identifier[MarketingOperationsMV].[Vendor].[Vendor ID] 
Vendor CodecharacterLength16attribute[MarketingOperationsMV].[Vendor].[Vendor Code] 
Vendor NamecharacterLength16attribute[MarketingOperationsMV].[Vendor].[Vendor Name] 
Vendor DisplaycharacterLength16attribute[MarketingOperationsMV].[Vendor].[Vendor Display] 
Cost CategoryCost Category IDfloat64identifier[MarketingOperationsMV].[Cost Category].[Cost Category ID] 
Cost Category CodecharacterLength16attribute[MarketingOperationsMV].[Cost Category].[Cost Category Code] 
Cost Category NamecharacterLength16attribute[MarketingOperationsMV].[Cost Category].[Cost Category Name] 
Cost Category DisplaycharacterLength16attribute[MarketingOperationsMV].[Cost Category].[Cost Category Display] 
ProjectsProjectProject IDfloat64identifier[MarketingOperationsMV].[Project].[Project ID] 
Project NamecharacterLength16attribute[MarketingOperationsMV].[Project].[Project Name] 
Project CodecharacterLength16attribute[MarketingOperationsMV].[Project].[Project Code] 
Project DescriptioncharacterLength16attribute[MarketingOperationsMV].[Project].[Project Description] 
Project Start DatedateTimeattribute[MarketingOperationsMV].[Project].[Project Start Date] 
Project End DatedateTimeattribute[MarketingOperationsMV].[Project].[Project End Date] 
Project Actual Start DatedateTimeidentifier[MarketingOperationsMV].[Project].[Project Actual Start Date] 
Project Actual End DatedateTimeidentifier[MarketingOperationsMV].[Project].[Project Actual End Date] 
StatuscharacterLength16attribute[MarketingOperationsMV].[Project Status].[Status]  
Project Name (Code)characterLength16attribute[MarketingOperationsMV].[Project].[Project Name (Code)] 
Project URLcharacterLength16attribute[MarketingOperationsMV].[Project].[Project URL] 
Project Request FlagcharacterLength16attribute[MarketingOperationsMV].[Project].[Project Request Flag] 
Template NamecharacterLength16attribute[MarketingOperationsMV].[Project].[Template Name] 
Template DisplaycharacterLength16attribute[MarketingOperationsMV].[Project Template].[Template Display] 
Template Instance DisplaycharacterLength16attribute[MarketingOperationsBV].[Project Template].[Template Instance Display] 
Parent Project IDfloat64identifier[MarketingOperationsMV].[Project].[Parent Project ID] 
Project RequestsProject IDfloat64identifier[MarketingOperationsMV].[Project Requests].[Project ID] 
Project NamecharacterLength16attribute[MarketingOperationsMV].[Project Requests].[Project Name] 
Project CodecharacterLength16attribute[MarketingOperationsMV].[Project Requests].[Project Code] 
Project DescriptioncharacterLength16attribute[MarketingOperationsMV].[Project Requests].[Project Description] 
Project Start DatedateTimeidentifier[MarketingOperationsMV].[Project Requests].[Project Start Date] 
Project End DatedateTimeidentifier[MarketingOperationsMV].[Project Requests].[Project End Date] 
Project Actual Start DatedateTimeidentifier[MarketingOperationsMV].[Project Requests].[Project Actual Start Date] 
Project Actual End DatedateTimeidentifier[MarketingOperationsMV].[Project Requests].[Project Actual End Date] 
Project Request StatuscharacterLength16attribute[MarketingOperationsMV].[Project Requests].[Project Request Status] 
Project Request URLcharacterLength16attribute[MarketingOperationsMV].[Project Requests].[Project Request URL] 
Project Name (Code)characterLength16attribute[MarketingOperationsMV].[Project Requests].[Project Name (Code)] 
Project Request FlagcharacterLength16attribute[MarketingOperationsMV].[Project Requests].[Project Request Flag] 
Project Request IDfloat64identifier[MarketingOperationsMV].[Project Requests].[Project Request ID] 
Request Submit DatedateTimeidentifier[MarketingOperationsMV].[Project Requests].[Request Submit Date] 
Request Complete DatedateTimeidentifier[MarketingOperationsMV].[Project Requests].[Request Complete Date] 
Template NamecharacterLength16attribute[MarketingOperationsMV].[Project Requests].[Template Name] 
Request Parent Project IDfloat64identifier[MarketingOperationsMV].[Project Requests].[Request Parent Project ID] 
Project OwnerProject IDfloat64identifier[MarketingOperationsMV].[Project Owner].[Project ID] 
User IDfloat64identifier[MarketingOperationsMV].[Project Owner].[User ID] 
User Full Name - First LastcharacterLength16attribute[MarketingOperationsMV].[Project User][MarketingOperationsMV].[User].[User Full Name - First Last] 
User Full Name - Last, FirstcharacterLength16attribute[MarketingOperationsMV].[Project User][MarketingOperationsMV].[User].[User Full Name - Last, First] 
Email AddresscharacterLength16attribute[MarketingOperationsMV].[Project User][MarketingOperationsMV].[User].[Email Address] 
First NamecharacterLength16attribute[MarketingOperationsMV].[Project User][MarketingOperationsMV].[User].[First Name] 
Last NamecharacterLength16attribute[MarketingOperationsMV].[Project User][MarketingOperationsMV].[User].[Last Name] 
Project MemberProject IDfloat64identifier[MarketingOperationsMV].[Project Member].[Project ID] 
User IDfloat64identifier[MarketingOperationsMV].[Project Member].[User ID] 
Member Type IDfloat64identifier[MarketingOperationsMV].[Project Member].[Member Type ID] 
Project ApprovalProject IDfloat64fact[MarketingOperationsMV].[Project Approval].[Project ID] 
Approval IDfloat64identifier[MarketingOperationsMV].[Project Approval].[Approval ID] 
Approval NamecharacterLength16attribute[MarketingOperationsMV].[Project Approval].[Approval Name] 
Approval DescriptioncharacterLength16attribute[MarketingOperationsMV].[Project Approval].[Approval Description] 
Workflow Task IDfloat64fact[MarketingOperationsMV].[Project Approval].[Workflow Task ID] 
Approval DatedateTimeattribute[MarketingOperationsMV].[Project Approval].[Approval Date] 
Task Number NamecharacterLength16attribute[MarketingOperationsMV].[Shortcut to Task][MarketingOperationsMV].[Task].[Task Number Name] 
Approval Status CodecharacterLength16identifier[MarketingOperationsMV].[Approval Status].[Approval Status Code] 
Approval StatuscharacterLength16attribute[MarketingOperationsMV].[Approval Status].[Approval Status] 
Approval URLcharacterLength16attribute#sq($[Environment]{'URL'})# + 'type=approval&id=' + cast([MarketingOperationsBV].[Project Approval].[Approval ID],varchar(10)) 
Project TemplateTemplate NamecharacterLength16attribute[MarketingOperationsMV].[Project Template].[Template Name] 
Template DisplaycharacterLength16attribute[MarketingOperationsMV].[Project Template].[Template Display] 
Template Instance DisplaycharacterLength16attribute[MarketingOperationsMV].[Project Template].[Template Instance Display] 
Project StatusStatus CodecharacterLength16identifier[MarketingOperationsMV].[Project Status].[Status Code] 
StatuscharacterLength16attribute[MarketingOperationsMV].[Project Status].[Status] 
Namespace/FolderQuery SubjectQuery ItemTypeUsageRef Obj/Expr.
WorkflowTaskTask IDfloat64identifier[MarketingOperationsMV].[Task].[Task ID] 
Task NumbercharacterLength16attribute[MarketingOperationsMV].[Task].[Task Number] 
Task NamecharacterLength16attribute[MarketingOperationsMV].[Task].[Task Name] 
% Completefloat64attribute[MarketingOperationsMV].[Task].[% Complete] 
Forecast/Actual StartdateTimeattribute[MarketingOperationsMV].[Task].[Forecast/Actual Start] 
Forecast/Actual EnddateTimeattribute[MarketingOperationsMV].[Task].[Forecast/Actual End] 
Actual Durationfloat64attribute[MarketingOperationsMV].[Task].[Actual Duration] 
Actual Duration StringcharacterLength16attribute[MarketingOperationsMV].[Task].[Actual Duration String] 
Anchor?characterLength16attribute[MarketingOperationsMV].[Task].[Anchor?] 
Start DatedateTimeattribute[MarketingOperationsMV].[Task].[Start Date] 
End DatedateTimeattribute[MarketingOperationsMV].[Task].[End Date] 
Durationfloat64attribute[MarketingOperationsMV].[Task].[Duration] 
Duration StringcharacterLength16attribute[MarketingOperationsMV].[Task].[Duration String] 
NotescharacterLength16attribute[MarketingOperationsMV].[Task].[Notes] 
MilestonecharacterLength16attribute[MarketingOperationsMV].[Milestone].[Milestone] 
Project IDfloat64attribute[MarketingOperationsMV].[Task].[Project ID] 
StatuscharacterLength16attribute[MarketingOperationsMV].[Task Status].[Status] 
Project NamecharacterLength16attribute[MarketingOperationsMV].[Task Parent Project][MarketingOperationsMV].[Project].[Project Name] 
Project CodecharacterLength16attribute[MarketingOperationsMV].[Task Parent Project][MarketingOperationsMV].[Project].[Project Code] 
Project URLcharacterLength16attribute[MarketingOperationsMV].[Task Parent Project][MarketingOperationsMV].[Project].[Project URL] 
Effortfloat64fact[MarketingOperationsMV].[Task].[Effort] 
Effort StringcharacterLength16attribute[MarketingOperationsMV].[Task].[Effort String] 
Forecast/Actual Effortfloat64fact[MarketingOperationsMV].[Task].[Forecast/Actual Effort] 
Forecast/Actual Effort StringcharacterLength16attribute[MarketingOperationsMV].[Task].[Forecast/Actual Effort String] 
Link ObjectcharacterLength16attribute[MarketingOperationsMV].[Task].[Link Object] 
Task URLcharacterLength16attribute[MarketingOperationsMV].[Task].[Task URL] 
StageStage IDfloat64identifier[MarketingOperationsMV].[Stage].[Stage ID] 
Stage Numberfloat64attribute[MarketingOperationsMV].[Stage].[Stage Number] 
Stage NamecharacterLength16attribute[MarketingOperationsMV].[Stage].[Stage Name] 
Project IDfloat64attribute[MarketingOperationsMV].[Stage].[Project ID] 
Project NamecharacterLength16attribute[MarketingOperationsMV].[Stage Parent Project][MarketingOperationsMV].[Project].[Project Name] 
Project CodecharacterLength16attribute[MarketingOperationsMV].[Stage Parent Project][MarketingOperationsMV].[Project].[Project Code] 
Task MemberTask IDfloat64identifier[MarketingOperationsMV].[Task Member].[Task ID] 
User IDfloat64identifier[MarketingOperationsMV].[Task Member].[User ID] 
User Full Name - First LastcharacterLength16attribute[MarketingOperationsMV].[Task User][MarketingOperationsMV].[User].[User Full Name - First Last] 
User Full Name - Last, FirstcharacterLength16attribute[MarketingOperationsMV].[Task User][MarketingOperationsMV].[User].[User Full Name - Last, First] 
Email AddresscharacterLength16attribute[MarketingOperationsMV].[Task User][MarketingOperationsMV].[User].[Email Address] 
Task StatusStatus CodecharacterLength16identifier[MarketingOperationsMV].[Task Status].[Status Code] 
StatuscharacterLength16attribute[MarketingOperationsMV].[Task Status].[Status] 
Project BudgetsProject BudgetBudget IDfloat64identifier[MarketingOperationsMV].[Project Budget].[Budget ID] 
Project IDfloat64identifier[MarketingOperationsMV].[Project Budget].[Project ID] 
Budget Totalfloat64fact[MarketingOperationsMV].[Project Budget].[Budget Total] 
Forecast Totalfloat64fact[MarketingOperationsMV].[Project Budget].[Forecast Total] 
Actual Totalfloat64fact[MarketingOperationsMV].[Project Budget].[Actual Total] 
Committed Totalfloat64fact[MarketingOperationsMV].[Project Budget].[Committed Total] 
Committed Remaining Amountfloat64fact[MarketingOperationsMV].[Project Budget].[Committed Remaining Amount] 
Forecast Remaining Amountfloat64fact[MarketingOperationsMV].[Project Budget].[Forecast Remaining Amount] 
Actual Remaining Amountfloat64fact[MarketingOperationsMV].[Project Budget].[Actual Remaining Amount] 
Project Budget AmountQuarter IDfloat64identifier[MarketingOperationsMV].[Project Budget Amount][MarketingOperationsMV].[Budget Amount].[Quarter ID] 
Yearfloat64identifier[MarketingOperationsMV].[Project Budget Amount][MarketingOperationsMV].[Budget Amount].[Year] 
Monthfloat64identifier[MarketingOperationsMV].[Project Budget Amount][MarketingOperationsMV].[Budget Amount].[Month] 
Budget IDfloat64identifier[MarketingOperationsMV].[Project Budget Amount][MarketingOperationsMV].[Budget Amount].[Budget ID] 
Forecast Amountfloat64fact[MarketingOperationsMV].[Project Budget Amount][MarketingOperationsMV].[Budget Amount].[Forecast Amount] 
Committed Amountfloat64fact[MarketingOperationsMV].[Project Budget Amount][MarketingOperationsMV].[Budget Amount].[Committed Amount] 
Actual Amountfloat64fact[MarketingOperationsMV].[Project Budget Amount][MarketingOperationsMV].[Budget Amount].[Actual Amount] 
Budget Amountfloat64fact[MarketingOperationsMV].[Project Budget Amount][MarketingOperationsMV].[Budget Amount].[Budget Amount] 
Committed Remaining Amountfloat64fact[MarketingOperationsMV].[Project Budget Amount][MarketingOperationsMV].[Budget Amount].[Committed Remaining Amount] 
Forecast Remaining Amountfloat64fact[MarketingOperationsMV].[Project Budget Amount][MarketingOperationsMV].[Budget Amount].[Forecast Remaining Amount] 
Actual Remaining Amountfloat64fact[MarketingOperationsMV].[Project Budget Amount][MarketingOperationsMV].[Budget Amount].[Actual Remaining Amount] 
Quarter YearcharacterLength16attribute[MarketingOperationsMV].[Quarter].[Quarter Year] 
Fiscal YearcharacterLength16attribute[MarketingOperationsMV].[Quarter].[Fiscal Year] 
Project Line ItemProject IDfloat64identifier[MarketingOperationsMV].[Project Line Item].[Project ID] 
Expenditure DatedateTimeattribute[MarketingOperationsMV].[Project Line Item].[Expenditure Date] 
Quarter YearcharacterLength16attribute[MarketingOperationsMV].[Quarter for Project Line Item].[Quarter Year] 
Account IDfloat64attribute[MarketingOperationsMV].[Project Line Item].[Account ID] 
Account Name (Code)characterLength16attribute[MarketingOperationsMV].[Account].[Account Name (Code)] 
Cost Category IDfloat64attribute[MarketingOperationsMV].[Project Line Item].[Cost Category ID] 
Cost Category DisplaycharacterLength16attribute[MarketingOperationsMV].[Cost Category].[Cost Category Display] 
Committed Amountfloat64fact[MarketingOperationsMV].[Project Line Item].[Committed Amount] 
Forecast Amountfloat64fact[MarketingOperationsMV].[Project Line Item].[Forecast Amount] 
Item DescriptioncharacterLength16attribute[MarketingOperationsMV].[Project Line Item].[Item Description] 
Project Invoice CostProject IDfloat64attribute[MarketingOperationsMV].[Project Invoice Cost].[Project ID] 
Account IDfloat64attribute[MarketingOperationsMV].[Project Invoice Cost].[Account ID] 
Invoice IDfloat64identifier[MarketingOperationsMV].[Project Invoice Cost].[Invoice ID] 
Invoice NumbercharacterLength16attribute[MarketingOperationsMV].[Project Invoice Cost].[Invoice Number] 
Invoice URLcharacterLength16attribute[MarketingOperationsMV].[Project Invoice Cost].[Invoice URL] 
Vendor DisplaycharacterLength16attribute[MarketingOperationsMV].[Project Invoice Cost].[Vendor Display] 
Expenditure DatedateTimeidentifier[MarketingOperationsMV].[Project Invoice Cost].[Expenditure Date] 
Quarter YearcharacterLength16attribute[MarketingOperationsMV].[Quarter for Project Invoice Cost].[Quarter Year] 
Cost Item IDfloat64identifier[MarketingOperationsMV].[Project Invoice Cost].[Cost Item ID] 
Cost Item Numberfloat64attribute[MarketingOperationsMV].[Project Invoice Cost].[Cost Item Number] 
Item DescriptioncharacterLength16attribute[MarketingOperationsMV].[Project Invoice Cost].[Cost Item Description] 
Cost Category IDfloat64attribute[MarketingOperationsMV].[Project Invoice Cost].[Cost Category ID] 
Cost Category DisplaycharacterLength16attribute[MarketingOperationsMV].[Project Invoice Cost].[Cost Category Display] 
Item Costfloat64fact[MarketingOperationsMV].[Project Invoice Cost].[Item Cost] 
Project MetricsProject Metric ValueProject IDfloat64identifier[MarketingOperationsMV].[Project Metric Column Value].[Project ID] 
Metric IDcharacterLength16identifier[MarketingOperationsMV].[Project Metric Column Value].[Metric ID] 
Metric NamecharacterLength16attribute[MarketingOperationsMV].[Project Metric Column Value].[Metric Name] 
Display FormatcharacterLength16attribute[MarketingOperationsMV].[Project Metric Column Value].[Display Format] 
Display Orderfloat64fact[MarketingOperationsMV].[Project Metric Column Value].[Display Order] 
Column DisplaycharacterLength16attribute[MarketingOperationsMV].[Project Metric Column Value].[Column Display] 
Metric Valuefloat64fact[MarketingOperationsMV].[Project Metric Column Value].[Metric Value] 
Is Target?characterLength16attribute[MarketingOperationsMV].[Project Metric Column Value].[Is Target?] 
Dimension TypecharacterLength16attribute[MarketingOperationsMV].[Project Metric Column Value].[Dimension Type] 
Column Taborderfloat64identifier[MarketingOperationsMV].[Project Metric Column Value].[Column Taborder] 
Project Performance Summary MetricsPROJECT IDfloat64fact[MarketingOperationsMV].[Project Performance Summary Metrics].[PROJECT ID] 
DISPLAY FORMAT METRIC1characterLength16attribute[MarketingOperationsMV].[Project Performance Summary Metrics].[DISPLAY FORMAT METRIC1] 
ACTUAL VALUE METRIC1float64fact[MarketingOperationsMV].[Project Performance Summary Metrics].[ACTUAL VALUE METRIC1] 
TARGET VALUE METRIC1float64fact[MarketingOperationsMV].[Project Performance Summary Metrics].[TARGET VALUE METRIC1] 
OPTIMISTIC VALUE METRIC1float64fact[MarketingOperationsMV].[Project Performance Summary Metrics].[OPTIMISTIC VALUE METRIC1] 
PESSIMISTIC VALUE METRIC1float64fact[MarketingOperationsMV].[Project Performance Summary Metrics].[PESSIMISTIC VALUE METRIC1] 
DISPLAY FORMAT METRIC2characterLength16attribute[MarketingOperationsMV].[Project Performance Summary Metrics].[DISPLAY FORMAT METRIC2] 
ACTUAL VALUE METRIC2float64fact[MarketingOperationsMV].[Project Performance Summary Metrics].[ACTUAL VALUE METRIC2] 
TARGET VALUE METRIC2float64fact[MarketingOperationsMV].[Project Performance Summary Metrics].[TARGET VALUE METRIC2] 
OPTIMISTIC VALUE METRIC2float64fact[MarketingOperationsMV].[Project Performance Summary Metrics].[OPTIMISTIC VALUE METRIC2] 
PESSIMISTIC VALUE METRIC2float64fact[MarketingOperationsMV].[Project Performance Summary Metrics].[PESSIMISTIC VALUE METRIC2] 
DISPLAY FORMAT METRIC3characterLength16attribute[MarketingOperationsMV].[Project Performance Summary Metrics].[DISPLAY FORMAT METRIC3] 
ACTUAL VALUE METRIC3float64fact[MarketingOperationsMV].[Project Performance Summary Metrics].[ACTUAL VALUE METRIC3] 
TARGET VALUE METRIC3float64fact[MarketingOperationsMV].[Project Performance Summary Metrics].[TARGET VALUE METRIC3] 
OPTIMISTIC VALUE METRIC3float64fact[MarketingOperationsMV].[Project Performance Summary Metrics].[OPTIMISTIC VALUE METRIC3] 
PESSIMISTIC VALUE METRIC3float64fact[MarketingOperationsMV].[Project Performance Summary Metrics].[PESSIMISTIC VALUE METRIC3] 
DISPLAY FORMAT METRIC4characterLength16attribute[MarketingOperationsMV].[Project Performance Summary Metrics].[DISPLAY FORMAT METRIC4] 
ACTUAL VALUE METRIC4float64fact[MarketingOperationsMV].[Project Performance Summary Metrics].[ACTUAL VALUE METRIC4] 
TARGET VALUE METRIC4float64fact[MarketingOperationsMV].[Project Performance Summary Metrics].[TARGET VALUE METRIC4] 
OPTIMISTIC VALUE METRIC4float64fact[MarketingOperationsMV].[Project Performance Summary Metrics].[OPTIMISTIC VALUE METRIC4] 
PESSIMISTIC VALUE METRIC4float64fact[MarketingOperationsMV].[Project Performance Summary Metrics].[PESSIMISTIC VALUE METRIC4] 
DISPLAY FORMAT METRIC5characterLength16attribute[MarketingOperationsMV].[Project Performance Summary Metrics].[DISPLAY FORMAT METRIC5] 
ACTUAL VALUE METRIC5float64fact[MarketingOperationsMV].[Project Performance Summary Metrics].[ACTUAL VALUE METRIC5] 
TARGET VALUE METRIC5float64fact[MarketingOperationsMV].[Project Performance Summary Metrics].[TARGET VALUE METRIC5] 
OPTIMISTIC VALUE METRIC5float64fact[MarketingOperationsMV].[Project Performance Summary Metrics].[OPTIMISTIC VALUE METRIC5] 
PESSIMISTIC VALUE METRIC5float64fact[MarketingOperationsMV].[Project Performance Summary Metrics].[PESSIMISTIC VALUE METRIC5] 
Project Performance MetricsProject IDfloat64identifier[MarketingOperationsMV].[Project Metric].[Project ID] 
Metric IDcharacterLength16identifier[MarketingOperationsMV].[Project Metric].[Metric ID] 
Metric NamecharacterLength16attribute[MarketingOperationsMV].[Project Metric].[Metric Name] 
Display Orderfloat64fact[MarketingOperationsMV].[Project Metric].[Display Order] 
Metric Value 1float64fact[MarketingOperationsMV].[Project Metric].[Metric Value 1] 
Metric Value 2float64fact[MarketingOperationsMV].[Project Metric].[Metric Value 2] 
Metric Value 3float64fact[MarketingOperationsMV].[Project Metric].[Metric Value 3] 
Metric Value 4float64fact[MarketingOperationsMV].[Project Metric].[Metric Value 4] 
Metric Value 5float64fact[MarketingOperationsMV].[Project Metric].[Metric Value 5] 
ProgramsProgramProgram IDfloat64identifier[MarketingOperationsMV].[Program].[Program ID] 
Program NamecharacterLength16attribute[MarketingOperationsMV].[Program].[Program Name] 
Program CodecharacterLength16attribute[MarketingOperationsMV].[Program].[Program Code] 
Program DescriptioncharacterLength16attribute[MarketingOperationsMV].[Program].[Program Description] 
Program URLcharacterLength16attribute#sq($[Environment]{'URL'})# + 'type=program&id=' + cast(cast([MarketingOperationsBV].[Program].[Program ID],integer),varchar(10)) 
Program StatuscharacterLength16attribute[MarketingOperationsMV].[Program].[Program Status] 
Program Start DatedateTimeattribute[MarketingOperationsMV].[Program].[Program Start Date] 
Program End DatedateTimeattribute[MarketingOperationsMV].[Program].[Program End Date] 
Program Name (Code)characterLength16attribute[MarketingOperationsMV].[Program].[Program Name (Code)] 
Template NamecharacterLength16attribute[MarketingOperationsMV].[Program].[Template Name] 
Template DisplaycharacterLength16attribute[MarketingOperationsMV].[Program Template].[Template Display] 
Template Instance DisplaycharacterLength16attribute[MarketingOperationsMV].[Program Template].[Template Instance Display]  
Program ProjectProgram IDfloat64identifier[MarketingOperationsMV].[Program Project Ref].[Program ID] 
Project IDfloat64identifier[MarketingOperationsMV].[Program Project Ref].[Project ID] 
Project NamecharacterLength16attribute[MarketingOperationsMV].[Program Project][MarketingOperationsMV].[Project].[Project Name] 
Project CodecharacterLength16attribute[MarketingOperationsMV].[Program Project][MarketingOperationsMV].[Project].[Project Code] 
Project DescriptioncharacterLength16attribute[MarketingOperationsMV].[Program Project][MarketingOperationsMV].[Project].[Project Description] 
Project Start DatedateTimeidentifier[MarketingOperationsMV].[Program Project][MarketingOperationsMV].[Project].[Project Start Date] 
Project End DatedateTimeidentifier[MarketingOperationsMV].[Program Project][MarketingOperationsMV].[Project].[Project End Date] 
Project StatuscharacterLength16attribute[MarketingOperationsMV].[Program Project][MarketingOperationsMV].[Project].[Project Status] 
Project Name (Code)characterLength16attribute[MarketingOperationsMV].[Program Project][MarketingOperationsMV].[Project].[Project Name (Code)] 
Program OwnerProgram IDfloat64identifier[MarketingOperationsMV].[Program Owner].[Program ID] 
User IDfloat64identifier[MarketingOperationsMV].[Program Owner].[User ID] 
Member Type IDfloat64identifier[MarketingOperationsMV].[Program Owner].[Member Type ID] 
Program MemberProgram IDfloat64identifier[MarketingOperationsMV].[Program Member].[Program ID] 
User IDfloat64identifier[MarketingOperationsMV].[Program Member].[User ID] 
Member Type IDfloat64identifier[MarketingOperationsMV].[Program Member].[Member Type ID] 
Namespace/FolderQuery SubjectQuery ItemTypeUsageRef Obj/Expr.
Program BudgetsProgram BudgetBudget IDfloat64identifier[MarketingOperationsMV].[Program Budget].[Budget ID] 
Program IDfloat64identifier[MarketingOperationsMV].[Program Budget].[Program ID] 
Budget Totalfloat64fact[MarketingOperationsMV].[Program Budget].[Budget Total] 
Forecast Totalfloat64fact[MarketingOperationsMV].[Program Budget].[Forecast Total] 
Actual Totalfloat64fact[MarketingOperationsMV].[Program Budget].[Actual Total] 
Committed Totalfloat64fact[MarketingOperationsMV].[Program Budget].[Committed Total] 
Allocation Totalfloat64fact[MarketingOperationsMV].[Program Budget].[Allocation Total] 
Finalized DatedateTimeattribute[MarketingOperationsMV].[Program Budget].[Finalized Date] 
Program Budget AmountQuarter IDfloat64identifier[MarketingOperationsMV].[Program Budget Amount][MarketingOperationsMV].[Budget Amount].[Quarter ID] 
Yearfloat64identifier[MarketingOperationsMV].[Program Budget Amount][MarketingOperationsMV].[Budget Amount].[Year] 
Monthfloat64identifier[MarketingOperationsMV].[Program Budget Amount][MarketingOperationsMV].[Budget Amount].[Month] 
Budget IDfloat64identifier[MarketingOperationsMV].[Program Budget Amount][MarketingOperationsMV].[Budget Amount].[Budget ID] 
Forecast Amountfloat64fact[MarketingOperationsMV].[Program Budget Amount][MarketingOperationsMV].[Budget Amount].[Forecast Amount] 
Committed Amountfloat64fact[MarketingOperationsMV].[Program Budget Amount][MarketingOperationsMV].[Budget Amount].[Committed Amount] 
Actual Amountfloat64fact[MarketingOperationsMV].[Program Budget Amount][MarketingOperationsMV].[Budget Amount].[Actual Amount] 
Budget Amountfloat64fact[MarketingOperationsMV].[Program Budget Amount][MarketingOperationsMV].[Budget Amount].[Budget Amount] 
Allocated Amountfloat64fact[MarketingOperationsMV].[Program Budget Amount][MarketingOperationsMV].[Budget Amount].[Allocated Amount] 
Committed Remaining Amountfloat64fact[MarketingOperationsMV].[Program Budget Amount][MarketingOperationsMV].[Budget Amount].[Committed Remaining Amount] 
Forecast Remaining Amountfloat64fact[MarketingOperationsMV].[Program Budget Amount][MarketingOperationsMV].[Budget Amount].[Forecast Remaining Amount] 
Actual Remaining Amountfloat64fact[MarketingOperationsMV].[Program Budget Amount][MarketingOperationsMV].[Budget Amount].[Actual Remaining Amount] 
Allocated Remaining Amountfloat64fact[MarketingOperationsMV].[Program Budget Amount][MarketingOperationsMV].[Budget Amount].[Allocated Remaining Amount] 
Quarter YearcharacterLength16attribute[MarketingOperationsMV].[Quarter].[Quarter Year] 
Fiscal YearcharacterLength16attribute[MarketingOperationsMV].[Quarter].[Fiscal Year] 
Program Line ItemProgram IDfloat64identifier[MarketingOperationsMV].[Program Line Item].[Program ID] 
Expenditure DatedateTimeattribute[MarketingOperationsMV].[Program Line Item].[Expenditure Date] 
Quarter YearcharacterLength16attribute[MarketingOperationsMV].[Quarter for Program Line Item][MarketingOperationsMV].[Quarter].[Quarter Year] 
Account IDfloat64attribute[MarketingOperationsMV].[Program Line Item].[Account ID] 
Account Name (Code)characterLength16attribute[MarketingOperationsMV].[Account].[Account Name (Code)] 
Cost Category IDfloat64attribute[MarketingOperationsMV].[Program Line Item].[Cost Category ID] 
Cost Category DisplaycharacterLength16attribute[MarketingOperationsMV].[Cost Category].[Cost Category Display] 
Committed Amountfloat64fact[MarketingOperationsMV].[Program Line Item].[Committed Amount] 
Forecast Amountfloat64fact[MarketingOperationsMV].[Program Line Item].[Forecast Amount] 
Program Invoice CostProgram IDfloat64identifier[MarketingOperationsMV].[Program Invoice Cost].[Program ID] 
Invoice IDfloat64identifier[MarketingOperationsMV].[Program Invoice Cost].[Invoice ID] 
Invoice NumbercharacterLength16attribute[MarketingOperationsMV].[Program Invoice Cost].[Invoice Number] 
Quarter YearcharacterLength16attribute[MarketingOperationsMV].[Quarter for Program Invoice Cost][MarketingOperationsMV].[Quarter].[Quarter Year] 
Vendor DisplaycharacterLength16attribute[MarketingOperationsMV].[Program Invoice Cost].[Vendor Display] 
Expenditure DatedateTimeattribute[MarketingOperationsMV].[Program Invoice Cost].[Expenditure Date] 
Cost Item IDfloat64identifier[MarketingOperationsMV].[Program Invoice Cost].[Cost Item ID] 
Cost Item Numberfloat64attribute[MarketingOperationsMV].[Program Invoice Cost].[Cost Item Number] 
Item DescriptioncharacterLength16attribute[MarketingOperationsMV].[Program Invoice Cost].[Item Description] 
Account IDfloat64attribute[MarketingOperationsMV].[Program Invoice Cost].[Account ID] 
Account Name (Code)characterLength16attribute[MarketingOperationsMV].[Program Invoice Cost].[Account Name (Code)] 
Cost Category IDfloat64attribute[MarketingOperationsMV].[Program Invoice Cost].[Cost Category ID] 
Cost Category DisplaycharacterLength16attribute[MarketingOperationsMV].[Program Invoice Cost].[Cost Category Display] 
Item Costfloat64fact[MarketingOperationsMV].[Program Invoice Cost].[Item Cost] 
PlansPlanPlan IDfloat64fact[MarketingOperationsMV].[Plan].[Plan ID] 
Plan CodecharacterLength16attribute[MarketingOperationsMV].[Plan].[Plan Code] 
Plan NamecharacterLength16attribute[MarketingOperationsMV].[Plan].[Plan Name] 
Plan DescriptioncharacterLength16attribute[MarketingOperationsMV].[Plan].[Plan Description] 
Plan URLcharacterLength16attribute#sq($[Environment]{'URL'})# + 'type=plan&id=' + cast(cast([MarketingOperationsBV].[Plan].[Plan ID] ,integer),varchar(10)) 
Plan Status CodecharacterLength16attribute[MarketingOperationsMV].[Plan].[Plan Status Code] 
Plan Fiscal Yearfloat64attribute[MarketingOperationsMV].[Plan].[Plan Fiscal Year] 
Plan Business Area IDfloat64attribute[MarketingOperationsMV].[Plan].[Plan Business Area ID] 
Start DatedateTimeattribute[MarketingOperationsMV].[Plan].[Start Date] 
End DatedateTimeattribute[MarketingOperationsMV].[Plan].[End Date] 
Plan Name (Code)characterLength16attribute[MarketingOperationsMV].[Plan].[Plan Name (Code)] 
Plan Program AreaPlan IDfloat64attribute[MarketingOperationsMV].[Plan Program Area Ref].[Plan ID] 
Plan Program Area IDfloat64identifier[MarketingOperationsMV].[Plan Program Area Ref].[Plan Program Area ID] 
Program Area IDfloat64attribute[MarketingOperationsMV].[Plan Program Area Ref].[Program Area ID] 
Display Orderfloat64attribute[MarketingOperationsMV].[Plan Program Area Ref].[Display Order] 
Program Area NamecharacterLength16attribute[MarketingOperationsMV].[Plan Program Area][MarketingOperationsMV].[Program Area].[Program Area Name] 
Plan ProgramPlan IDfloat64identifier[MarketingOperationsMV].[Plan Program Ref].[Plan ID] 
Plan Program Area IDfloat64identifier[MarketingOperationsMV].[Plan Program Ref].[Plan Program Area ID] 
Program IDfloat64identifier[MarketingOperationsMV].[Plan Program Ref].[Program ID] 
Program NamecharacterLength16attribute[MarketingOperationsMV].[Plan Program][MarketingOperationsMV].[Program].[Program Name] 
Program CodecharacterLength16attribute[MarketingOperationsMV].[Plan Program][MarketingOperationsMV].[Program].[Program Code] 
Program DescriptioncharacterLength16attribute[MarketingOperationsMV].[Plan Program][MarketingOperationsMV].[Program].[Program Description] 
Program Start DatedateTimeattribute[MarketingOperationsMV].[Plan Program][MarketingOperationsMV].[Program].[Program Start Date] 
Program End DatedateTimeattribute[MarketingOperationsMV].[Plan Program][MarketingOperationsMV].[Program].[Program End Date] 
Program StatuscharacterLength16attribute[MarketingOperationsMV].[Plan Program][MarketingOperationsMV].[Program].[Program Status] 
Program Name (Code)characterLength16attribute[MarketingOperationsMV].[Plan Program][MarketingOperationsMV].[Program].[Program Name (Code)] 
Namespace/FolderQuery SubjectQuery ItemTypeUsageRef Obj/Expr.
Plan BudgetsPlan BudgetBudget IDfloat64identifier[MarketingOperationsMV].[Plan Budget].[Budget ID] 
Plan IDfloat64identifier[MarketingOperationsMV].[Plan Budget].[Plan ID] 
Budget Totalfloat64fact[MarketingOperationsMV].[Plan Budget].[Budget Total] 
Forecast Totalfloat64fact[MarketingOperationsMV].[Plan Budget].[Forecast Total] 
Actual Totalfloat64fact[MarketingOperationsMV].[Plan Budget].[Actual Total] 
Committed Totalfloat64fact[MarketingOperationsMV].[Plan Budget].[Committed Total] 
Allocated Totalfloat64fact[MarketingOperationsMV].[Plan Budget].[Allocated Total] 
Finalized DatedateTimeattribute[MarketingOperationsMV].[Plan Budget].[Finalized Date] 
Plan Budget AmountQuarter IDfloat64identifier[MarketingOperationsMV].[Plan Budget Amount][MarketingOperationsMV].[Budget Amount].[Quarter ID] 
Yearfloat64identifier[MarketingOperationsMV].[Plan Budget Amount][MarketingOperationsMV].[Budget Amount].[Year] 
Monthfloat64identifier[MarketingOperationsMV].[Plan Budget Amount][MarketingOperationsMV].[Budget Amount].[Month] 
Budget IDfloat64identifier[MarketingOperationsMV].[Plan Budget Amount][MarketingOperationsMV].[Budget Amount].[Budget ID] 
Forecast Amountfloat64fact[MarketingOperationsMV].[Plan Budget Amount][MarketingOperationsMV].[Budget Amount].[Forecast Amount] 
Committed Amountfloat64fact[MarketingOperationsMV].[Plan Budget Amount][MarketingOperationsMV].[Budget Amount].[Committed Amount] 
Actual Amountfloat64fact[MarketingOperationsMV].[Plan Budget Amount][MarketingOperationsMV].[Budget Amount].[Actual Amount] 
Budget Amountfloat64fact[MarketingOperationsMV].[Plan Budget Amount][MarketingOperationsMV].[Budget Amount].[Budget Amount] 
Allocated Amountfloat64fact[MarketingOperationsMV].[Plan Budget Amount][MarketingOperationsMV].[Budget Amount].[Allocated Amount] 
Committed Remaining Amountfloat64fact[MarketingOperationsMV].[Plan Budget Amount][MarketingOperationsMV].[Budget Amount].[Committed Remaining Amount] 
Forecast Remaining Amountfloat64fact[MarketingOperationsMV].[Plan Budget Amount][MarketingOperationsMV].[Budget Amount].[Forecast Remaining Amount] 
Actual Remaining Amountfloat64fact[MarketingOperationsMV].[Plan Budget Amount][MarketingOperationsMV].[Budget Amount].[Actual Remaining Amount] 
Allocated Remaining Amountfloat64fact[MarketingOperationsMV].[Plan Budget Amount][MarketingOperationsMV].[Budget Amount].[Allocated Remaining Amount] 
Quarter YearcharacterLength16attribute[MarketingOperationsMV].[Quarter].[Quarter Year] 
Fiscal YearcharacterLength16attribute[MarketingOperationsMV].[Quarter].[Fiscal Year] 
Program Area BudgetBudget IDfloat64identifier[MarketingOperationsMV].[Program Area Budget].[Budget ID] 
Plan Program Area IDfloat64identifier[MarketingOperationsMV].[Program Area Budget].[Plan Program Area ID] 
Budget Totalfloat64fact[MarketingOperationsMV].[Program Area Budget].[Budget Total] 
Forecast Totalfloat64fact[MarketingOperationsMV].[Program Area Budget].[Forecast Total] 
Actual Totalfloat64fact[MarketingOperationsMV].[Program Area Budget].[Actual Total] 
Committed Totalfloat64fact[MarketingOperationsMV].[Program Area Budget].[Committed Total] 
Finalized DatedateTimeattribute[MarketingOperationsMV].[Program Area Budget].[Finalized Date] 
Program Area Budget AmountQuarter IDfloat64identifier[MarketingOperationsMV].[Program Area Budget Amount][MarketingOperationsMV].[Budget Amount].[Quarter ID] 
Yearfloat64identifier[MarketingOperationsMV].[Program Area Budget Amount][MarketingOperationsMV].[Budget Amount].[Year] 
Monthfloat64identifier[MarketingOperationsMV].[Program Area Budget Amount][MarketingOperationsMV].[Budget Amount].[Month] 
Budget IDfloat64identifier[MarketingOperationsMV].[Program Area Budget Amount][MarketingOperationsMV].[Budget Amount].[Budget ID] 
Forecast Amountfloat64fact[MarketingOperationsMV].[Program Area Budget Amount][MarketingOperationsMV].[Budget Amount].[Forecast Amount] 
Committed Amountfloat64fact[MarketingOperationsMV].[Program Area Budget Amount][MarketingOperationsMV].[Budget Amount].[Committed Amount] 
Actual Amountfloat64fact[MarketingOperationsMV].[Program Area Budget Amount][MarketingOperationsMV].[Budget Amount].[Actual Amount] 
Budget Amountfloat64fact[MarketingOperationsMV].[Program Area Budget Amount][MarketingOperationsMV].[Budget Amount].[Budget Amount] 
Allocated Amountfloat64fact[MarketingOperationsMV].[Program Area Budget Amount][MarketingOperationsMV].[Budget Amount].[Allocated Amount] 
Committed Remaining Amountfloat64fact[MarketingOperationsMV].[Program Area Budget Amount][MarketingOperationsMV].[Budget Amount].[Committed Remaining Amount] 
Forecast Remaining Amountfloat64fact[MarketingOperationsMV].[Program Area Budget Amount][MarketingOperationsMV].[Budget Amount].[Forecast Remaining Amount] 
Actual Remaining Amountfloat64fact[MarketingOperationsMV].[Program Area Budget Amount][MarketingOperationsMV].[Budget Amount].[Actual Remaining Amount] 
Allocated Remaining Amountfloat64fact[MarketingOperationsMV].[Program Area Budget Amount][MarketingOperationsMV].[Budget Amount].[Allocated Remaining Amount] 
Quarter YearcharacterLength16attribute[MarketingOperationsMV].[Quarter].[Quarter Year] 
AccountsAccountAccount IDfloat64identifier[MarketingOperationsMV].[Account].[Account ID] 
Account NamecharacterLength16attribute[MarketingOperationsMV].[Account].[Account Name] 
Account CodecharacterLength16attribute[MarketingOperationsMV].[Account].[Account Code] 
Account Name (Code)characterLength16attribute[MarketingOperationsMV].[Account].[Account Name (Code)] 
Account DescriptioncharacterLength16attribute[MarketingOperationsMV].[Account].[Account Description] 
Account URLcharacterLength16attribute#sq($[Environment]{'URL'})# + 'type=account&id=' + cast(cast([MarketingOperationsBV].[Account].[Account ID],integer),varchar(10)) 
Parent Account Name (Code)characterLength16attribute[MarketingOperationsMV].[Parent Account][MarketingOperationsMV].[Account].[Account Name (Code)] 
Parent Account IDfloat64attribute[MarketingOperationsMV].[Account].[Parent Account ID] 
Account Budget AmountParent Account IDfloat64attribute[MarketingOperationsMV].[Account].[Parent Account ID] 
Account IDfloat64identifier[MarketingOperationsMV].[Account Budget].[Account ID] 
Quarter IDfloat64identifier[MarketingOperationsMV].[Account Budget Amount][MarketingOperationsMV].[Budget Amount].[Quarter ID] 
Yearfloat64identifier[MarketingOperationsMV].[Account Budget Amount][MarketingOperationsMV].[Budget Amount].[Year] 
Monthfloat64identifier[MarketingOperationsMV].[Account Budget Amount][MarketingOperationsMV].[Budget Amount].[Month] 
Budget IDfloat64identifier[MarketingOperationsMV].[Account Budget Amount][MarketingOperationsMV].[Budget Amount].[Budget ID] 
Forecast Amountfloat64fact[MarketingOperationsMV].[Account Budget Amount][MarketingOperationsMV].[Budget Amount].[Forecast Amount] 
Committed Amountfloat64fact[MarketingOperationsMV].[Account Budget Amount][MarketingOperationsMV].[Budget Amount].[Committed Amount] 
Actual Amountfloat64fact[MarketingOperationsMV].[Account Budget Amount][MarketingOperationsMV].[Budget Amount].[Actual Amount] 
Budget Amountfloat64fact[MarketingOperationsMV].[Account Budget Amount][MarketingOperationsMV].[Budget Amount].[Budget Amount] 
Allocated Amountfloat64fact[MarketingOperationsMV].[Account Budget Amount][MarketingOperationsMV].[Budget Amount].[Allocated Amount] 
Committed Remaining Amountfloat64fact[MarketingOperationsMV].[Account Budget Amount][MarketingOperationsMV].[Budget Amount].[Committed Remaining Amount] 
Forecast Remaining Amountfloat64fact[MarketingOperationsMV].[Account Budget Amount][MarketingOperationsMV].[Budget Amount].[Forecast Remaining Amount] 
Actual Remaining Amountfloat64fact[MarketingOperationsMV].[Account Budget Amount][MarketingOperationsMV].[Budget Amount].[Actual Remaining Amount] 
Allocated Remaining Amountfloat64fact[MarketingOperationsMV].[Account Budget Amount][MarketingOperationsMV].[Budget Amount].[Allocated Remaining Amount] 
Sub-Account Budget AmountAccount IDfloat64identifier[MarketingOperationsMV].[Sub-Account Budget Amount].[Account ID] 
Quarter_IDfloat64identifier[MarketingOperationsMV].[Sub-Account Budget Amount].[Quarter_ID] 
Year1float64identifier[MarketingOperationsMV].[Sub-Account Budget Amount].[Year1] 
Month1float64identifier[MarketingOperationsMV].[Sub-Account Budget Amount].[Month1] 
Budget_Amountfloat64fact[MarketingOperationsMV].[Sub-Account Budget Amount].[Budget_Amount] 
Forecast_Amountfloat64fact[MarketingOperationsMV].[Sub-Account Budget Amount].[Forecast_Amount] 
Committed_Amountfloat64fact[MarketingOperationsMV].[Sub-Account Budget Amount].[Committed_Amount] 
Actual_Amountfloat64fact[MarketingOperationsMV].[Sub-Account Budget Amount].[Actual_Amount] 
Quarter YearcharacterLength16attribute[MarketingOperationsMV].[Quarter].[Quarter Year] 
Parent AccountAccount IDfloat64identifier[MarketingOperationsMV].[Parent Account][MarketingOperationsMV].[Account].[Account ID] 
Account CodecharacterLength16attribute[MarketingOperationsMV].[Parent Account][MarketingOperationsMV].[Account].[Account Code] 
Account DescriptioncharacterLength16attribute[MarketingOperationsMV].[Parent Account][MarketingOperationsMV].[Account].[Account Description] 
Parent Account IDfloat64attribute[MarketingOperationsMV].[Parent Account][MarketingOperationsMV].[Account].[Parent Account ID] 
Account NamecharacterLength16attribute[MarketingOperationsMV].[Parent Account][MarketingOperationsMV].[Account].[Account Name] 
Account Name (Code)characterLength16attribute[MarketingOperationsMV].[Parent Account][MarketingOperationsMV].[Account].[Account Name (Code)] 
ApprovalsApprovalApproval IDfloat64identifier[MarketingOperationsMV].[Approval].[Approval ID] 
Approval NamecharacterLength16attribute[MarketingOperationsMV].[Approval].[Approval Name] 
Approval DescriptioncharacterLength16attribute[MarketingOperationsMV].[Approval].[Approval Description] 
Approval URLcharacterLength16attribute#sq($[Environment]{'URL'})# + 'type=approval&id=' + cast(cast([MarketingOperationsBV].[Approval].[Approval ID],integer),varchar(10)) 
Approval StatuscharacterLength16attribute[MarketingOperationsMV].[Approval Status].[Approval Status] 
Approval DatedateTimeattribute[MarketingOperationsMV].[Approval].[Approval Date] 
Source Object IDfloat64identifier[MarketingOperationsMV].[Approval].[Source Object ID] 
Source Object TypecharacterLength16attribute[MarketingOperationsMV].[Approval].[Source Object Type] 
Source Workflow Task IDfloat64identifier[MarketingOperationsMV].[Approval].[Source Workflow Task ID] 
Approval ItemApproval IDfloat64identifier[MarketingOperationsMV].[Approval Item].[Approval ID] 
Approval Item Orderfloat64attribute[MarketingOperationsMV].[Approval Item].[Approval Item Order] 
Approval Item NamecharacterLength16attribute[MarketingOperationsMV].[Approval Item].[Approval Item Name] 
ApproverApproval IDfloat64identifier[MarketingOperationsMV].[Approver].[Approval ID] 
Approver Orderfloat64attribute[MarketingOperationsMV].[Approver].[Approver Order] 
User IDfloat64identifier[MarketingOperationsMV].[Approver].[User ID] 
Is Required?characterLength16attribute[MarketingOperationsMV].[Approver].[Is Required?] 
Response DatedateTimeattribute[MarketingOperationsMV].[Approver].[Response Date] 
User Full Name - First LastcharacterLength16attribute[MarketingOperationsMV].[Approver User][MarketingOperationsMV].[User].[User Full Name - First Last] 
User Full Name - Last, FirstcharacterLength16attribute[MarketingOperationsMV].[Approver User][MarketingOperationsMV].[User].[User Full Name - Last, First] 
Approver StatuscharacterLength16attribute[MarketingOperationsMV].[Approver].[Approver Status] 
BudgetsBudget AmountQuarter IDfloat64identifier[MarketingOperationsMV].[Budget Amount].[Quarter ID] 
Yearfloat64identifier[MarketingOperationsMV].[Budget Amount].[Year] 
Monthfloat64identifier[MarketingOperationsMV].[Budget Amount].[Month] 
Budget IDfloat64identifier[MarketingOperationsMV].[Budget Amount].[Budget ID] 
Forecast Amountfloat64fact[MarketingOperationsMV].[Budget Amount].[Forecast Amount] 
Committed Amountfloat64fact[MarketingOperationsMV].[Budget Amount].[Committed Amount] 
Actual Amountfloat64fact[MarketingOperationsMV].[Budget Amount].[Actual Amount] 
Budget Amountfloat64fact[MarketingOperationsMV].[Budget Amount].[Budget Amount] 
Allocated Amountfloat64fact[MarketingOperationsMV].[Budget Amount].[Allocated Amount] 
Committed Remaining Amountfloat64fact[MarketingOperationsMV].[Budget Amount].[Committed Remaining Amount] 
Forecast Remaining Amountfloat64fact[MarketingOperationsMV].[Budget Amount].[Forecast Remaining Amount] 
Actual Remaining Amountfloat64fact[MarketingOperationsMV].[Budget Amount].[Actual Remaining Amount] 
Allocated Remaining Amountfloat64fact[MarketingOperationsMV].[Budget Amount].[Allocated Remaining Amount] 
Quarter DescriptioncharacterLength16attribute[MarketingOperationsMV].[Quarter].[Quarter Description] 
Quarter YearcharacterLength16attribute[MarketingOperationsMV].[Quarter].[Quarter Year] 
Month YearcharacterLength16attribute[MarketingOperationsMV].[Quarter].[Month Year] 
InvoicesInvoiceInvoice IDfloat64identifier[MarketingOperationsMV].[Invoice].[Invoice ID] 
Invoice NumbercharacterLength16attribute[MarketingOperationsMV].[Invoice].[Invoice Number] 
Vendor DisplaycharacterLength16attribute[MarketingOperationsMV].[Vendor].[Vendor Display] 
PO NumbercharacterLength16attribute[MarketingOperationsMV].[Invoice].[PO Number] 
Due DatedateTimeidentifier[MarketingOperationsMV].[Invoice].[Due Date] 
State CodecharacterLength16attribute[MarketingOperationsMV].[Invoice].[State Code] 
Invoice DatedateTimeidentifier[MarketingOperationsMV].[Invoice].[Invoice Date] 
Invoice URLcharacterLength16attribute[MarketingOperationsMV].[Invoice].[Invoice URL] 
NotescharacterLength16attribute[MarketingOperationsMV].[Invoice].[Notes] 
Payment TermscharacterLength16attribute[MarketingOperationsMV].[Invoice].[Payment Terms] 
Invoice Amountfloat64fact[MarketingOperationsMV].[Invoice].[Invoice Amount] 
Invoice CodecharacterLength16attribute[MarketingOperationsMV].[Invoice].[Invoice Code] 
Payable DatedateTimeattribute[MarketingOperationsMV].[Invoice].[Payable Date] 
Paid DatedateTimeattribute[MarketingOperationsMV].[Invoice].[Paid Date] 
Invoice Line ItemInvoice IDfloat64identifier[MarketingOperationsMV].[Invoice Line Item].[Invoice ID] 
Cost Item IDfloat64identifier[MarketingOperationsMV].[Invoice Line Item].[Cost Item ID] 
Cost Item Numberfloat64attribute[MarketingOperationsMV].[Invoice Line Item].[Cost Item Number] 
Item DescriptioncharacterLength16attribute[MarketingOperationsMV].[Invoice Line Item].[Item Description] 
Source Object TypecharacterLength16attribute[MarketingOperationsMV].[Invoice Line Item].[Source Object Type] 
Source Object IDfloat64attribute[MarketingOperationsMV].[Invoice Line Item].[Source Object ID] 
Source Object CodecharacterLength16attribute[MarketingOperationsMV].[Invoice Line Item].[Source Object Code] 
Account IDfloat64attribute[MarketingOperationsMV].[Invoice Line Item].[Account ID] 
Account CodecharacterLength16attribute[MarketingOperationsMV].[Invoice Line Item].[Account Code] 
Cost Category IDfloat64attribute[MarketingOperationsMV].[Invoice Line Item].[Cost Category ID] 
Cost Category CodecharacterLength16attribute[MarketingOperationsMV].[Invoice Line Item].[Cost Category Code] 
Quantityfloat64fact[MarketingOperationsMV].[Invoice Line Item].[Quantity] 
Unit Costfloat64fact[MarketingOperationsMV].[Invoice Line Item].[Unit Cost] 
Item Costfloat64fact[MarketingOperationsMV].[Invoice Line Item].[Item Cost] 
Custom AttributesProject Custom AttributesProject IDfloat64identifier[MarketingOperationsMV].[Project Custom Attributes].[Project ID] 
InitiativecharacterLength16attribute[MarketingOperationsMV].[Initiative].[Initiative] 
Channel NamecharacterLength16attribute[MarketingOperationsMV].[Channel].[CHANNEL_NAME] 
Business UnitcharacterLength16attribute[MarketingOperationsMV].[Business Unit].[Business Unit] 
Product FamilycharacterLength16attribute[MarketingOperationsMV].[Product Family].[Product Family] 
SegmentcharacterLength16attribute[MarketingOperationsMV].[Segment].[Segment] 
Budget PeriodcharacterLength16attribute[MarketingOperationsMV].[Budget Period].[budget_period_name] 
Project Performance Summary Custom MetricsProject IDfloat64fact[MarketingOperationsMV].[Project Performance Summary Custom Metrics].[Project ID] 
Total Revenuefloat64fact[MarketingOperationsMV].[Project Performance Summary Custom Metrics].[Total Revenue] 
ResponseRateActualfloat64fact[MarketingOperationsMV].[Project Performance Summary Custom Metrics].[ResponseRateActual] 
ResponseRateTargetfloat64fact[MarketingOperationsMV].[Project Performance Summary Custom Metrics].[ResponseRateTarget] 
Total Leads Generated (Actual)float64fact[MarketingOperationsMV].[Project Performance Summary Custom Metrics].[Total Leads Generated (Actual)] 
Total Leads Generated (Target)float64fact[MarketingOperationsMV].[Project Performance Summary Custom Metrics].[Total Leads Generated (Target)] 
Total Cost Passedfloat64fact[MarketingOperationsMV].[Project Performance Summary Custom Metrics].[Total Cost Passed] 
Program Performance Metricsprogram_idfloat64identifier[MarketingOperationsMV].[Program Metric].[program_id] 
metric_idcharacterLength16identifier[MarketingOperationsMV].[Program Metric].[metric_id] 
display_namecharacterLength16attribute[MarketingOperationsMV].[Program Metric].[display_name] 
display_orderfloat64fact[MarketingOperationsMV].[Program Metric].[display_order] 
metric_value1float64fact[MarketingOperationsMV].[Program Metric].[metric_value1] 
metric_value2float64fact[MarketingOperationsMV].[Program Metric].[metric_value2] 
metric_value3float64fact[MarketingOperationsMV].[Program Metric].[metric_value3] 
metric_value4float64fact[MarketingOperationsMV].[Program Metric].[metric_value4] 
metric_value5float64fact[MarketingOperationsMV].[Program Metric].[metric_value5] 
Namespace/FolderQuery SubjectQuery ItemTypeUsageRef Obj/Expr.
Projects and Requests Over Time
model/Projects and Requests Over Time.jpg
Requests Over Time (shortcut) [MarketingOperationsMV].[Requests Over Time]
Projects Over Time (shortcut) [MarketingOperationsMV].[Projects Over Time]
Projects Quarter (shortcut) [MarketingOperationsMV].[Projects Quarter]
Model View
model/Model View.jpg
Namespace/FolderQuery SubjectQuery ItemTypeUsageRef Obj/Expr.
CommonUserUser IDfloat64fact[MarketingOperationsDS].[uap_user].[USER_ID] 
Last NamecharacterLength16attributeIF ([MarketingOperationsDS].[uap_user].[LAST_NAME] is missing) THEN ('') ELSE ([MarketingOperationsDS].[uap_user].[LAST_NAME]) 
First NamecharacterLength16attributeIF ([MarketingOperationsDS].[uap_user].[FIRST_NAME] is missing) THEN ('') ELSE ([MarketingOperationsDS].[uap_user].[FIRST_NAME]) 
Email AddresscharacterLength16attribute[MarketingOperationsDS].[uap_user].[EMAIL_ID] 
User Full Name - First LastcharacterLength16attributeIF ([MarketingOperationsMV].[User].[First Name] ='') THEN ([MarketingOperationsMV].[User].[Last Name]) ELSE ([MarketingOperationsMV].[User].[First Name] + ' ' + [MarketingOperationsMV].[User].[Last Name]) 
User Full Name - Last, FirstcharacterLength16attributeIF ([MarketingOperationsMV].[User].[Last Name] ='') THEN ([MarketingOperationsMV].[User].[First Name]) ELSE ([MarketingOperationsMV].[User].[Last Name] + ', ' + [MarketingOperationsMV].[User].[First Name]) 
Last Modified DatedateTimeidentifier[MarketingOperationsDS].[uap_user].[LAST_MOD_DATE] 
Login IDcharacterLength16attribute[MarketingOperationsDS].[uap_user].[LOGIN_ID] 
Status CodecharacterLength16attribute[MarketingOperationsDS].[uap_user].[STATUS_CODE] 
Member TypeMember Type IDfloat64identifier[MarketingOperationsDS].[uap_member_type].[mem_type_id] 
Member Type NamecharacterLength16attribute[MarketingOperationsDS].[uap_member_type].[mem_name] 
StatusStatus CodecharacterLength16identifier[MarketingOperationsDS].[uap_status].[STATUS_CODE] 
StatuscharacterLength16attribute[MarketingOperationsDS].[uap_status].[STATUS_DESC] 
TemplateTemplate IDfloat64identifier[MarketingOperationsDS].[UAP_TT_TEMPLATES].[TEMPLATE_ID] 
Object Typefloat64attribute[MarketingOperationsDS].[UAP_TT_TEMPLATES].[OBJECT_TYPE] 
Template NamecharacterLength16attribute[MarketingOperationsDS].[UAP_TT_TEMPLATES].[TEMPLATE_NAME] 
Template DisplaycharacterLength16attribute[MarketingOperationsDS].[UAP_TT_TEMPLATES].[ACTUAL_DISPLAY] 
Template Instance DisplaycharacterLength16attribute[MarketingOperationsDS].[UAP_TT_TEMPLATES].[DISPLAY] 
User Rolesrole_idfloat64identifier[MarketingOperationsDS].[uap_user_roles].[ROLE_ID] 
sec_policy_idfloat64identifier[MarketingOperationsDS].[uap_user_roles].[SEC_POLICY_ID] 
user_idfloat64identifier[MarketingOperationsDS].[uap_user_roles].[USER_ID] 
Rolesrole_idfloat64identifier[MarketingOperationsDS].[uap_roles].[ROLE_ID] 
role_namecharacterLength16attribute[MarketingOperationsDS].[uap_roles].[ROLE_NAME] 
role_desccharacterLength16attribute[MarketingOperationsDS].[uap_roles].[ROLE_DESC] 
sec_policy_idfloat64fact[MarketingOperationsDS].[uap_roles].[SEC_POLICY_ID] 
Users Rolesuser_idfloat64identifier[MarketingOperationsMV].[User Roles].[user_id] 
role_idfloat64identifier[MarketingOperationsMV].[User Roles].[role_id] 
role_namecharacterLength16attribute[MarketingOperationsMV].[Roles].[role_name] 
TeamTeam IDfloat64identifier[MarketingOperationsDS].[UAP_TEAMS].[TEAM_ID] 
Team NamecharacterLength16attribute[MarketingOperationsDS].[UAP_TEAMS].[NAME] 
Team DescriptioncharacterLength16attribute[MarketingOperationsDS].[UAP_TEAMS].[DESCRIPTION] 
Team SkillsetscharacterLength16attribute[MarketingOperationsDS].[UAP_TEAMS].[SKILLSETS] 
Team Status IDfloat64identifier[MarketingOperationsDS].[UAP_TEAMS].[STATUS] 
Team MemberTeam IDfloat64identifier[MarketingOperationsDS].[UAP_TEAM_MEMBERS].[TEAM_ID] 
Team Member IDfloat64identifier[MarketingOperationsDS].[UAP_TEAM_MEMBERS].[USER_ID] 
Team Member Type IDfloat64identifier[MarketingOperationsDS].[UAP_TEAM_MEMBERS].[MEM_TYPE_ID] 
List DefinitionsVendorVendor IDfloat64identifier[MarketingOperationsDS].[uap_ml_vendor].[VENDOR_ID] 
Vendor CodecharacterLength16attribute[MarketingOperationsDS].[uap_ml_vendor].[CODE] 
Vendor NamecharacterLength16attribute[MarketingOperationsDS].[uap_ml_vendor].[NAME] 
Vendor DisplaycharacterLength16attribute[MarketingOperationsDS].[uap_ml_vendor].[DISPLAY] 
Program AreaProgram Area IDfloat64identifier[MarketingOperationsDS].[uap_prgm_area].[PRGM_AREA_ID] 
Program Area NamecharacterLength16attribute[MarketingOperationsDS].[uap_prgm_area].[NAME] 
Cost CategoryCost Category IDfloat64identifier[MarketingOperationsDS].[uap_ml_cost_cat].[COST_CAT_ID] 
Cost Category CodecharacterLength16attribute[MarketingOperationsDS].[uap_ml_cost_cat].[CODE] 
Cost Category NamecharacterLength16attribute[MarketingOperationsDS].[uap_ml_cost_cat].[NAME] 
Cost Category DisplaycharacterLength16attribute[MarketingOperationsDS].[uap_ml_cost_cat].[DISPLAY] 
ProjectsProject User (shortcut) [MarketingOperationsMV].[User]
Shortcut to Task (shortcut) [MarketingOperationsMV].[Task]
ProjectsProjectProject IDfloat64identifier[MarketingOperationsDS].[uap_projects].[PROJECT_ID] 
Project NamecharacterLength16attribute[MarketingOperationsDS].[uap_projects].[NAME] 
Project CodecharacterLength16attribute[MarketingOperationsDS].[uap_projects].[PROJ_CODE] 
Project DescriptioncharacterLength16attribute[MarketingOperationsDS].[uap_projects].[DESCRIPTION] 
Project Start DatedateTimeidentifier[MarketingOperationsDS].[uap_projects].[START_DATE] 
Project End DatedateTimeidentifier[MarketingOperationsDS].[uap_projects].[END_DATE] 
Project Actual Start DatedateTimeidentifier[MarketingOperationsDS].[uap_projects].[ACTUAL_ST_DATE] 
Project Actual End DatedateTimeidentifier[MarketingOperationsDS].[uap_projects].[ACTUAL_END_DATE] 
Project StatuscharacterLength16attribute[MarketingOperationsDS].[uap_projects].[STATE_CODE] 
Project URLcharacterLength16attribute#sq($[Environment]{'URL'})# + 'type=project&id=' + cast(cast([MarketingOperationsMV].[Project].[Project ID], integer), varchar(10)) 
Project Name (Code)characterLength16attribute[MarketingOperationsMV].[Project].[Project Name] + ' (' + [MarketingOperationsMV].[Project].[Project Code] + ')' 
Project Request FlagcharacterLength16attribute[MarketingOperationsDS].[uap_projects].[FLAG_PROJ_REQUEST] 
Template NamecharacterLength16attribute[MarketingOperationsDS].[uap_projects].[TEMPLATE_NAME] 
Parent Project IDfloat64identifier[MarketingOperationsDS].[uap_projects].[PARENT_PROJ_ID] 
Project RequestsProject IDfloat64identifier[MarketingOperationsDS].[uap_projects].[PROJECT_ID] 
Project NamecharacterLength16attribute[MarketingOperationsDS].[uap_projects].[NAME] 
Project CodecharacterLength16attribute[MarketingOperationsDS].[uap_projects].[PROJ_CODE] 
Project DescriptioncharacterLength16attribute[MarketingOperationsDS].[uap_projects].[DESCRIPTION] 
Project Start DatedateTimeidentifier[MarketingOperationsDS].[uap_projects].[START_DATE] 
Project End DatedateTimeidentifier[MarketingOperationsDS].[uap_projects].[END_DATE] 
Project Actual Start DatedateTimeidentifier[MarketingOperationsDS].[uap_projects].[ACTUAL_ST_DATE] 
Project Actual End DatedateTimeidentifier[MarketingOperationsDS].[uap_projects].[ACTUAL_END_DATE] 
Project Request StatuscharacterLength16attribute[MarketingOperationsDS].[uap_projects].[STATE_CODE] 
Project Request URLcharacterLength16attribute#sq($[Environment]{'URL'})# + 'type=projectrequest&id=' + cast(cast([MarketingOperationsMV].[Project Requests].[Project ID], integer), varchar(10)) 
Project Name (Code)characterLength16attribute[MarketingOperationsMV].[Project Requests].[Project Name] + ' (' + [MarketingOperationsMV].[Project Requests].[Project Code] + ')' 
Project Request FlagcharacterLength16attribute[MarketingOperationsDS].[uap_projects].[FLAG_PROJ_REQUEST] 
Project Request IDfloat64identifier[MarketingOperationsDS].[uap_projects].[PROJ_REQUEST_ID] 
Request Submit DatedateTimeidentifier[MarketingOperationsDS].[uap_projects].[REQ_SUBMIT_DATE] 
Request Complete DatedateTimeidentifier[MarketingOperationsDS].[uap_projects].[REQ_COMP_DATE] 
Template NamecharacterLength16attribute[MarketingOperationsDS].[uap_projects].[TEMPLATE_NAME] 
Request Parent Project IDfloat64identifier[MarketingOperationsDS].[uap_projects].[PARENT_PROJ_ID] 
Project OwnerProject IDfloat64identifier[MarketingOperationsDS].[uap_proj_users].[PROJECT_ID] 
User IDfloat64identifier[MarketingOperationsDS].[uap_proj_users].[USER_ID] 
Member Type IDfloat64identifier[MarketingOperationsDS].[uap_proj_users].[MEM_TYPE_ID] 
Project MemberProject IDfloat64identifier[MarketingOperationsDS].[uap_proj_users].[PROJECT_ID] 
User IDfloat64identifier[MarketingOperationsDS].[uap_proj_users].[USER_ID] 
Member Type IDfloat64identifier[MarketingOperationsDS].[uap_proj_users].[MEM_TYPE_ID] 
Project StatusStatus CodecharacterLength16identifier[MarketingOperationsDS].[uap_status].[STATUS_CODE] 
StatuscharacterLength16attribute[MarketingOperationsDS].[uap_status].[STATUS_DESC] 
Project ApprovalApproval IDfloat64identifier[MarketingOperationsDS].[UAP_APPROVALS].[APPROVAL_ID] 
Approval NamecharacterLength16attribute[MarketingOperationsDS].[UAP_APPROVALS].[NAME] 
Approval DescriptioncharacterLength16attribute[MarketingOperationsDS].[UAP_APPROVALS].[DESCRIPTION] 
Approval Status CodecharacterLength16attribute[MarketingOperationsDS].[UAP_APPROVALS].[STATE_CODE] 
Approval DatedateTimeattribute[MarketingOperationsDS].[UAP_APPROVALS].[APPROVAL_DATE] 
Project IDfloat64attribute[MarketingOperationsDS].[UAP_APPROVALS].[SRC_OBJECT_ID] 
Workflow Task IDfloat64attribute[MarketingOperationsDS].[UAP_APPROVALS].[SRC_WF_STEP] 
Project TemplateTemplate IDfloat64identifier[MarketingOperationsMV].[Template].[Template ID] 
Object Typefloat64attribute[MarketingOperationsMV].[Template].[Object Type] 
Template NamecharacterLength16attribute[MarketingOperationsMV].[Template].[Template Name] 
Template DisplaycharacterLength16attribute[MarketingOperationsMV].[Template].[Template Display] 
Template Instance DisplaycharacterLength16attribute[MarketingOperationsMV].[Template].[Template Instance Display] 
Namespace/FolderQuery SubjectQuery ItemTypeUsageRef Obj/Expr.
Workflow
model/Workflow.jpg
Task Parent Project (shortcut) [MarketingOperationsMV].[Project]
Stage Parent Project (shortcut) [MarketingOperationsMV].[Project]
Task User (shortcut) [MarketingOperationsMV].[User]
WorkflowTask StatusStatus CodecharacterLength16identifier[MarketingOperationsDS].[uap_status].[STATUS_CODE] 
StatuscharacterLength16attribute[MarketingOperationsDS].[uap_status].[STATUS_DESC] 
MilestoneMilestone Type IDfloat64identifier[MarketingOperationsDS].[uap_wf_milestone].[MILESTONE_TYPE] 
MilestonecharacterLength16attribute[MarketingOperationsDS].[uap_wf_milestone].[MILESTONE_DESC] 
TaskTask IDfloat64identifier[MarketingOperationsDS].[uap_workflow].[WF_NO] 
Task NumbercharacterLength16attribute[MarketingOperationsDS].[uap_workflow].[DISPLAY_ID] 
Task NamecharacterLength16attribute[MarketingOperationsDS].[uap_workflow].[NAME] 
StatuscharacterLength16attributeIF([MarketingOperationsDS].[uap_workflow].[STATUS_CODE]='' or [MarketingOperationsDS].[uap_workflow].[STATUS_CODE] is null) THEN ('PENDING') ELSE([MarketingOperationsDS].[uap_workflow].[STATUS_CODE]) 
% Completefloat64attribute[MarketingOperationsDS].[uap_workflow].[PCNT_COMP] 
Forecast/Actual StartdateTimeattribute[MarketingOperationsDS].[uap_workflow].[FORECAST_ST] 
Forecast/Actual EnddateTimeattribute[MarketingOperationsDS].[uap_workflow].[FORECAST_END] 
Durationfloat64attribute[MarketingOperationsDS].[uap_workflow].[DURATION] 
Duration StringcharacterLength16attribute[MarketingOperationsDS].[uap_workflow].[DURATION_STR] 
Actual Durationfloat64attribute[MarketingOperationsDS].[uap_workflow].[ACTUAL_DURATION] 
Actual Duration StringcharacterLength16attribute[MarketingOperationsDS].[uap_workflow].[ACTUAL_DURATION_STR] 
Anchor?characterLength16attribute[MarketingOperationsDS].[uap_workflow].[FLAG_ANCHOR] 
Start DatedateTimeattribute[MarketingOperationsDS].[uap_workflow].[START_DATE] 
End DatedateTimeattribute[MarketingOperationsDS].[uap_workflow].[END_DATE] 
Milestone Type IDfloat64attribute[MarketingOperationsDS].[uap_workflow].[MILESTONE_TYPE] 
NotescharacterLength16attribute[MarketingOperationsDS].[uap_workflow].[NOTES] 
Project IDfloat64attribute[MarketingOperationsDS].[uap_workflow].[PROJECT_ID] 
Parent Stage IDfloat64attribute[MarketingOperationsDS].[uap_workflow].[PARENT_STAGE] 
Link?characterLength16attribute[MarketingOperationsDS].[uap_workflow].[FLAG_LINK] 
Link IDfloat64attribute[MarketingOperationsDS].[uap_workflow].[LINK_ID] 
Link ObjectcharacterLength16attribute[MarketingOperationsDS].[uap_workflow].[LINK_OBJECT] 
Task Number NamecharacterLength16attribute[MarketingOperationsMV].[Task].[Task Number] + ' ' + [MarketingOperationsMV].[Task].[Task Name]  
Effortfloat64fact[MarketingOperationsDS].[uap_workflow].[EFFORT] 
Effort StringcharacterLength16attribute[MarketingOperationsDS].[uap_workflow].[EFFORT_STR] 
Forecast/Actual Effortfloat64fact[MarketingOperationsDS].[uap_workflow].[ACTUAL_EFFORT] 
Forecast/Actual Effort StringcharacterLength16attribute[MarketingOperationsDS].[uap_workflow].[ACTUAL_EFFORT_STR] 
Task URLcharacterLength16attribute#sq($[Environment]{'URL'})# + 'type=task&id=' + cast(cast([MarketingOperationsMV].[Task].[Task ID] ,integer),varchar(10)) 
StageStage IDfloat64identifier[MarketingOperationsDS].[uap_workflow].[WF_NO] 
Stage Numberfloat64attribute[MarketingOperationsDS].[uap_workflow].[DISPLAY_ORDER] 
Stage NamecharacterLength16attribute[MarketingOperationsDS].[uap_workflow].[NAME] 
Project IDfloat64attribute[MarketingOperationsDS].[uap_workflow].[PROJECT_ID] 
Task MemberTask IDfloat64identifier[MarketingOperationsDS].[uap_wf_users].[WF_NO] 
User IDfloat64identifier[MarketingOperationsDS].[uap_wf_users].[USER_ID] 
Project Budgets
model/Project Budgets.jpg
Project Budget Reference (shortcut) [MarketingOperationsMV].[Budget]
Project Budget Amount (shortcut) [MarketingOperationsMV].[Budget Amount]
Project BudgetsProject BudgetBudget IDfloat64identifier[MarketingOperationsDS].[uap_proj_budget].[BUDGET_ID] 
Project IDfloat64identifier[MarketingOperationsDS].[uap_proj_budget].[PROJECT_ID] 
Budget Totalfloat64fact[MarketingOperationsDS].[uap_proj_budget].[BUDGET_TOTAL] 
Forecast Totalfloat64fact[MarketingOperationsDS].[uap_proj_budget].[FORECAST_TOTAL] 
Actual Totalfloat64fact[MarketingOperationsDS].[uap_proj_budget].[ACTUAL_TOTAL] 
Committed Totalfloat64fact[MarketingOperationsDS].[uap_proj_budget].[COMMITTED_TOTAL] 
Committed Remaining Amountfloat64fact[MarketingOperationsMV].[Project Budget].[Budget Total] - [MarketingOperationsMV].[Project Budget].[Committed Total]  
Forecast Remaining Amountfloat64fact[MarketingOperationsMV].[Project Budget].[Budget Total] - [MarketingOperationsMV].[Project Budget].[Forecast Total]  
Actual Remaining Amountfloat64fact[MarketingOperationsMV].[Project Budget].[Budget Total] - [MarketingOperationsMV].[Project Budget].[Actual Total]  
Project Line ItemProject IDfloat64identifier[MarketingOperationsDS].[uap_proj_cost].[PROJECT_ID] 
Cost Item IDfloat64identifier[MarketingOperationsDS].[uap_proj_cost].[COST_ITEM_ID] 
Version IDfloat64attribute[MarketingOperationsDS].[uap_proj_cost].[VERSION_ID] 
Cost Item Numberfloat64attribute[MarketingOperationsDS].[uap_proj_cost].[COST_ITEM_NO] 
Account IDfloat64attribute[MarketingOperationsDS].[uap_proj_cost].[ACCOUNT_ID] 
Account CodecharacterLength16attribute[MarketingOperationsDS].[uap_proj_cost].[ACCOUNT_CODE] 
Forecast Amountfloat64fact[MarketingOperationsDS].[uap_proj_cost].[FORECAST_AMT] 
Committed Amountfloat64fact[MarketingOperationsDS].[uap_proj_cost].[COMMITTED_AMT] 
Expenditure DatedateTimeattribute[MarketingOperationsDS].[uap_proj_cost].[EXPENDITURE_DATE] 
Cost Category IDfloat64attribute[MarketingOperationsDS].[uap_proj_cost].[COST_CAT_ID] 
Cost Category CodecharacterLength16attribute[MarketingOperationsDS].[uap_proj_cost].[COST_CAT_CODE] 
Item DescriptioncharacterLength16attribute[MarketingOperationsDS].[uap_proj_cost].[COST_ITEM_DESC] 
Project Invoice Line ItemInvoice IDfloat64identifier[MarketingOperationsDS].[UAP_INVOICE_ITEMS].[INVOICE_ID] 
Cost Item IDfloat64identifier[MarketingOperationsDS].[UAP_INVOICE_ITEMS].[COST_ITEM_ID] 
Cost Item Numberfloat64attribute[MarketingOperationsDS].[UAP_INVOICE_ITEMS].[COST_ITEM_NO] 
Cost Item DescriptioncharacterLength16attribute[MarketingOperationsDS].[UAP_INVOICE_ITEMS].[COST_ITEM_DESC] 
Source Object TypecharacterLength16attribute[MarketingOperationsDS].[UAP_INVOICE_ITEMS].[SRC_OBJ_TYPE] 
Source Object IDfloat64attribute[MarketingOperationsDS].[UAP_INVOICE_ITEMS].[SRC_OBJ_ID] 
Source Object CodecharacterLength16attribute[MarketingOperationsDS].[UAP_INVOICE_ITEMS].[SRC_OBJ_CODE] 
Account IDfloat64attribute[MarketingOperationsDS].[UAP_INVOICE_ITEMS].[ACCOUNT_ID] 
Account CodecharacterLength16attribute[MarketingOperationsDS].[UAP_INVOICE_ITEMS].[ACCOUNT_CODE] 
Cost Category IDfloat64attribute[MarketingOperationsDS].[UAP_INVOICE_ITEMS].[COST_CAT_ID] 
Cost Category CodecharacterLength16attribute[MarketingOperationsDS].[UAP_INVOICE_ITEMS].[COST_CAT_CODE] 
Quantityfloat64fact[MarketingOperationsDS].[UAP_INVOICE_ITEMS].[QUANTITY] 
Unit Costfloat64fact[MarketingOperationsDS].[UAP_INVOICE_ITEMS].[UNIT_COST] 
Item Costfloat64fact[MarketingOperationsDS].[UAP_INVOICE_ITEMS].[ITEM_COST] 
Project Invoice CostProject IDfloat64attribute[MarketingOperationsMV].[Project Invoice Line Item].[Source Object ID] 
Invoice IDfloat64identifier[MarketingOperationsMV].[Project Invoice Line Item].[Invoice ID] 
Invoice NumbercharacterLength16attribute[MarketingOperationsMV].[Invoice].[Invoice Number] 
Invoice URLcharacterLength16attribute[MarketingOperationsMV].[Invoice].[Invoice URL] 
Vendor DisplaycharacterLength16attribute[MarketingOperationsMV].[Vendor].[Vendor Display] 
Expenditure DatedateTimeidentifierif ([MarketingOperationsMV].[Invoice].[Paid Date] = null) THEN ([MarketingOperationsMV].[Invoice].[Due Date]) ELSE ([MarketingOperationsMV].[Invoice].[Paid Date] ) 
Cost Item IDfloat64identifier[MarketingOperationsMV].[Project Invoice Line Item].[Cost Item ID] 
Cost Item Numberfloat64attribute[MarketingOperationsMV].[Project Invoice Line Item].[Cost Item Number] 
Cost Item DescriptioncharacterLength16attribute[MarketingOperationsMV].[Project Invoice Line Item].[Cost Item Description] 
Account IDfloat64attribute[MarketingOperationsMV].[Project Invoice Line Item].[Account ID] 
Cost Category IDfloat64attribute[MarketingOperationsMV].[Project Invoice Line Item].[Cost Category ID] 
Cost Category DisplaycharacterLength16attribute[MarketingOperationsMV].[Cost Category].[Cost Category Display] 
Item Costfloat64fact[MarketingOperationsMV].[Project Invoice Line Item].[Item Cost] 
Quarter for Project Line ItemQuarter IDfloat64identifier[MarketingOperationsDS].[uap_quarters].[QUARTER_ID] 
Yearfloat64identifier[MarketingOperationsDS].[uap_quarters].[YEAR] 
Monthfloat64identifier[MarketingOperationsDS].[uap_quarters].[MONTH] 
Quarter DescriptioncharacterLength16attribute[MarketingOperationsDS].[uap_quarters].[DESCRIPTION] 
Quarter YearcharacterLength16attributesubstring ([MarketingOperationsMV].[Quarter for Project Line Item].[Quarter Description] , position ( '(' , [MarketingOperationsMV].[Quarter for Project Line Item].[Quarter Description] ) + 1, 7) 
Month YearcharacterLength16attributesubstring ( [MarketingOperationsMV].[Quarter for Project Line Item].[Quarter Description], 0, position('(', [MarketingOperationsMV].[Quarter for Project Line Item].[Quarter Description]) - 1) 
Quarter for Project Invoice CostQuarter IDfloat64identifier[MarketingOperationsDS].[uap_quarters].[QUARTER_ID] 
Yearfloat64identifier[MarketingOperationsDS].[uap_quarters].[YEAR] 
Monthfloat64identifier[MarketingOperationsDS].[uap_quarters].[MONTH] 
Quarter DescriptioncharacterLength16attribute[MarketingOperationsDS].[uap_quarters].[DESCRIPTION] 
Quarter YearcharacterLength16attributesubstring ([MarketingOperationsMV].[Quarter for Project Invoice Cost].[Quarter Description] , position ( '(' , [MarketingOperationsMV].[Quarter for Project Invoice Cost].[Quarter Description] ) + 1, 7) 
Month YearcharacterLength16attributesubstring ( [MarketingOperationsMV].[Quarter for Project Invoice Cost].[Quarter Description], 0, position('(', [MarketingOperationsMV].[Quarter for Project Invoice Cost].[Quarter Description]) - 1) 
Project MetricsProject MetricMetric IDcharacterLength16identifier[MarketingOperationsDS].[uap_proj_metrics].[METRIC_ID] 
Metric NamecharacterLength16attribute[MarketingOperationsDS].[uap_proj_metrics].[DISPLAY_NAME] 
Display Orderfloat64fact[MarketingOperationsDS].[uap_proj_metrics].[DISPLAY_ORDER] 
UnitscharacterLength16attribute[MarketingOperationsDS].[uap_proj_metrics].[UNITS] 
Input MethodcharacterLength16attribute[MarketingOperationsDS].[uap_proj_metrics].[INPUT_METHOD] 
Display FormatcharacterLength16attribute[MarketingOperationsDS].[uap_proj_metrics].[DISPLAY_FORMAT] 
Metric Value 1float64fact[MarketingOperationsDS].[uap_proj_metrics].[METRIC_VALUE1] 
Metric Value 3float64fact[MarketingOperationsDS].[uap_proj_metrics].[METRIC_VALUE3] 
Metric Value 2float64fact[MarketingOperationsDS].[uap_proj_metrics].[METRIC_VALUE2] 
Metric DescriptioncharacterLength16attribute[MarketingOperationsDS].[uap_proj_metrics].[DESCRIPTION] 
FormulacharacterLength16attribute[MarketingOperationsDS].[uap_proj_metrics].[FORMULA] 
Metric Value 4float64fact[MarketingOperationsDS].[uap_proj_metrics].[METRIC_VALUE4] 
Metric Precisionfloat64fact[MarketingOperationsDS].[uap_proj_metrics].[METRIC_PRECISION] 
Metric Value 5float64fact[MarketingOperationsDS].[uap_proj_metrics].[METRIC_VALUE5] 
Metric Columnsfloat64fact[MarketingOperationsDS].[uap_proj_metrics].[METRIC_COLUMNS] 
Project IDfloat64identifier[MarketingOperationsDS].[uap_proj_metrics].[PROJECT_ID] 
Metric Group IDcharacterLength16attribute[MarketingOperationsDS].[uap_proj_metrics].[GRP_ID] 
Metric NaN 1characterLength16attribute[MarketingOperationsDS].[uap_proj_metrics].[METRIC1_NAN] 
Metric NaN 2characterLength16attribute[MarketingOperationsDS].[uap_proj_metrics].[METRIC2_NAN] 
Metric NaN 3characterLength16attribute[MarketingOperationsDS].[uap_proj_metrics].[METRIC3_NAN] 
Metric NaN 4characterLength16attribute[MarketingOperationsDS].[uap_proj_metrics].[METRIC4_NAN] 
Metric NaN 5characterLength16attribute[MarketingOperationsDS].[uap_proj_metrics].[METRIC5_NAN] 
Planned Valuefloat64fact[MarketingOperationsDS].[uap_proj_metrics].[PLANNED_VALUE] 
Planed NaNcharacterLength16attribute[MarketingOperationsDS].[uap_proj_metrics].[PLANNED_NAN] 
Is Planned Value?characterLength16attribute[MarketingOperationsDS].[uap_proj_metrics].[IS_PLANNED_VALUE] 
Show as Rollup?characterLength16attribute[MarketingOperationsDS].[uap_proj_metrics].[SHOW_AS_ROLLUP] 
Is Visible?characterLength16attribute[MarketingOperationsDS].[uap_proj_metrics].[IS_VISIBLE] 
Project Metrics NewProject IDfloat64identifier[MarketingOperationsMV].[Project Metric].[Project ID] 
Metric IDcharacterLength16identifier[MarketingOperationsMV].[Project Metric].[Metric ID] 
Metric NamecharacterLength16attribute[MarketingOperationsMV].[Project Metric].[Metric Name] 
Display Orderfloat64fact[MarketingOperationsMV].[Project Metric].[Display Order] 
Display FormatcharacterLength16attribute[MarketingOperationsMV].[Project Metric].[Display Format] 
Project Metric ColumnProject IDfloat64identifier[MarketingOperationsDS].[uap_metric_cols].[PROJECT_ID] 
Column Taborderfloat64identifier[MarketingOperationsDS].[uap_metric_cols].[COL_TABORDER] 
Column DisplaycharacterLength16attribute[MarketingOperationsDS].[uap_metric_cols].[COL_DISPLAY] 
Is Target?characterLength16attribute[MarketingOperationsDS].[uap_metric_cols].[FLAG_TARGET] 
Dimension TypecharacterLength16attribute[MarketingOperationsDS].[uap_metric_cols].[DIMENSION_TYPE] 
Project Metric Column ValueProject IDfloat64identifier[MarketingOperationsMV].[Project Metric].[Project ID] 
Metric IDcharacterLength16identifier[MarketingOperationsMV].[Project Metric].[Metric ID] 
Metric NamecharacterLength16attribute[MarketingOperationsMV].[Project Metric].[Metric Name] 
Display FormatcharacterLength16attribute[MarketingOperationsMV].[Project Metrics New].[Display Format] 
Display Orderfloat64fact[MarketingOperationsMV].[Project Metrics New].[Display Order] 
Column DisplaycharacterLength16attribute[MarketingOperationsMV].[Project Metric Column].[Column Display] 
Metric Valuefloat64factif ([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?characterLength16attribute[MarketingOperationsMV].[Project Metric Column].[Is Target?] 
Dimension TypecharacterLength16attribute[MarketingOperationsMV].[Project Metric Column].[Dimension Type] 
Column Taborderfloat64identifier[MarketingOperationsMV].[Project Metric Column].[Column Taborder] 
Project Performance Summary MetricsPROJECT IDfloat64fact 
DISPLAY FORMAT METRIC1characterLength16attribute 
ACTUAL VALUE METRIC1float64fact 
TARGET VALUE METRIC1float64fact 
OPTIMISTIC VALUE METRIC1float64fact 
PESSIMISTIC VALUE METRIC1float64fact 
DISPLAY FORMAT METRIC2characterLength16attribute 
ACTUAL VALUE METRIC2float64fact 
TARGET VALUE METRIC2float64fact 
OPTIMISTIC VALUE METRIC2float64fact 
PESSIMISTIC VALUE METRIC2float64fact 
DISPLAY FORMAT METRIC3characterLength16attribute 
ACTUAL VALUE METRIC3float64fact 
TARGET VALUE METRIC3float64fact 
OPTIMISTIC VALUE METRIC3float64fact 
PESSIMISTIC VALUE METRIC3float64fact 
DISPLAY FORMAT METRIC4characterLength16attribute 
ACTUAL VALUE METRIC4float64fact 
TARGET VALUE METRIC4float64fact 
OPTIMISTIC VALUE METRIC4float64fact 
PESSIMISTIC VALUE METRIC4float64fact 
DISPLAY FORMAT METRIC5characterLength16attribute 
ACTUAL VALUE METRIC5float64fact 
TARGET VALUE METRIC5float64fact 
OPTIMISTIC VALUE METRIC5float64fact 
PESSIMISTIC VALUE METRIC5float64fact 
ProgramsProgram Project (shortcut) [MarketingOperationsMV].[Project]
Program User (shortcut) [MarketingOperationsMV].[User]
ProgramsProgramProgram IDfloat64identifier[MarketingOperationsDS].[uap_programs].[PROGRAM_ID] 
Program NamecharacterLength16attribute[MarketingOperationsDS].[uap_programs].[NAME] 
Program CodecharacterLength16attribute[MarketingOperationsDS].[uap_programs].[PROGRAM_CODE] 
Program DescriptioncharacterLength16attribute[MarketingOperationsDS].[uap_programs].[DESCRIPTION] 
Program Start DatedateTimeattribute[MarketingOperationsDS].[uap_programs].[START_DATE] 
Program End DatedateTimeattribute[MarketingOperationsDS].[uap_programs].[END_DATE] 
Program StatuscharacterLength16attribute[MarketingOperationsDS].[uap_programs].[STATE_CODE] 
Program Name (Code)characterLength16attribute[MarketingOperationsMV].[Program].[Program Name] + ' (' + [MarketingOperationsMV].[Program].[Program Code] + ')' 
Template NamecharacterLength16attribute[MarketingOperationsDS].[uap_programs].[TEMPLATE_NAME] 
Program Project RefProject IDfloat64identifier[MarketingOperationsDS].[uap_prgrm_project].[PROJECT_ID] 
Program IDfloat64identifier[MarketingOperationsDS].[uap_prgrm_project].[PROGRAM_ID] 
Program OwnerProgram IDfloat64identifier[MarketingOperationsDS].[uap_prgrm_users].[PROGRAM_ID] 
User IDfloat64identifier[MarketingOperationsDS].[uap_prgrm_users].[USER_ID] 
Member Type IDfloat64identifier[MarketingOperationsDS].[uap_prgrm_users].[MEM_TYPE_ID] 
Program MemberProgram IDfloat64identifier[MarketingOperationsDS].[uap_prgrm_users].[PROGRAM_ID] 
User IDfloat64identifier[MarketingOperationsDS].[uap_prgrm_users].[USER_ID] 
Member Type IDfloat64identifier[MarketingOperationsDS].[uap_prgrm_users].[MEM_TYPE_ID] 
Program TemplateTemplate IDfloat64identifier[MarketingOperationsMV].[Template].[Template ID] 
Object Typefloat64attribute[MarketingOperationsMV].[Template].[Object Type] 
Template NamecharacterLength16attribute[MarketingOperationsMV].[Template].[Template Name] 
Template DisplaycharacterLength16attribute[MarketingOperationsMV].[Template].[Template Display] 
Template Instance DisplaycharacterLength16attribute[MarketingOperationsMV].[Template].[Template Instance Display]  
Namespace/FolderQuery SubjectQuery ItemTypeUsageRef Obj/Expr.
Program Budgets
model/Program Budgets.jpg
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 BudgetsProgram BudgetBudget IDfloat64identifier[MarketingOperationsDS].[uap_prgrm_budget].[BUDGET_ID] 
Program IDfloat64identifier[MarketingOperationsDS].[uap_prgrm_budget].[PROGRAM_ID] 
Budget Totalfloat64fact[MarketingOperationsDS].[uap_prgrm_budget].[BUDGET_TOTAL] 
Forecast Totalfloat64fact[MarketingOperationsDS].[uap_prgrm_budget].[FORECAST_TOTAL] 
Actual Totalfloat64fact[MarketingOperationsDS].[uap_prgrm_budget].[ACTUAL_TOTAL] 
Committed Totalfloat64fact[MarketingOperationsDS].[uap_prgrm_budget].[COMMITTED_TOTAL] 
Allocation Totalfloat64fact[MarketingOperationsDS].[uap_prgrm_budget].[ALLOC_TOTAL] 
Finalized DatedateTimeattribute[MarketingOperationsDS].[uap_prgrm_budget].[FINALIZED_DATE] 
Program Invoice Line ItemInvoice IDfloat64identifier[MarketingOperationsDS].[UAP_INVOICE_ITEMS].[INVOICE_ID] 
Cost Item IDfloat64identifier[MarketingOperationsDS].[UAP_INVOICE_ITEMS].[COST_ITEM_ID] 
Cost Item Numberfloat64attribute[MarketingOperationsDS].[UAP_INVOICE_ITEMS].[COST_ITEM_NO] 
Item DescriptioncharacterLength16attribute[MarketingOperationsDS].[UAP_INVOICE_ITEMS].[COST_ITEM_DESC] 
Source Object TypecharacterLength16attribute[MarketingOperationsDS].[UAP_INVOICE_ITEMS].[SRC_OBJ_TYPE] 
Source Object IDfloat64attribute[MarketingOperationsDS].[UAP_INVOICE_ITEMS].[SRC_OBJ_ID] 
Source Object CodecharacterLength16attribute[MarketingOperationsDS].[UAP_INVOICE_ITEMS].[SRC_OBJ_CODE] 
Account IDfloat64attribute[MarketingOperationsDS].[UAP_INVOICE_ITEMS].[ACCOUNT_ID] 
Account CodecharacterLength16attribute[MarketingOperationsDS].[UAP_INVOICE_ITEMS].[ACCOUNT_CODE] 
Cost Category IDfloat64attribute[MarketingOperationsDS].[UAP_INVOICE_ITEMS].[COST_CAT_ID] 
Cost Category CodecharacterLength16attribute[MarketingOperationsDS].[UAP_INVOICE_ITEMS].[COST_CAT_CODE] 
Quantityfloat64fact[MarketingOperationsDS].[UAP_INVOICE_ITEMS].[QUANTITY] 
Unit Costfloat64fact[MarketingOperationsDS].[UAP_INVOICE_ITEMS].[UNIT_COST] 
Item Costfloat64fact[MarketingOperationsDS].[UAP_INVOICE_ITEMS].[ITEM_COST] 
Program Invoice CostProgram IDfloat64identifier[MarketingOperationsMV].[Program].[Program ID] 
Invoice IDfloat64identifier[MarketingOperationsMV].[Program Invoice Line Item].[Invoice ID] 
Invoice NumbercharacterLength16attribute[MarketingOperationsMV].[Invoice].[Invoice Number] 
Vendor DisplaycharacterLength16attribute[MarketingOperationsMV].[Vendor].[Vendor Display] 
Expenditure DatedateTimeattribute[MarketingOperationsMV].[Invoice].[Paid Date] 
Cost Item IDfloat64identifier[MarketingOperationsMV].[Program Invoice Line Item].[Cost Item ID] 
Cost Item Numberfloat64attribute[MarketingOperationsMV].[Program Invoice Line Item].[Cost Item Number] 
Item DescriptioncharacterLength16attribute[MarketingOperationsMV].[Program Invoice Line Item].[Item Description] 
Account IDfloat64attribute[MarketingOperationsMV].[Program Invoice Line Item].[Account ID] 
Account Name (Code)characterLength16attribute[MarketingOperationsMV].[Account].[Account Name (Code)] 
Cost Category IDfloat64attribute[MarketingOperationsMV].[Program Invoice Line Item].[Cost Category ID] 
Cost Category DisplaycharacterLength16attribute[MarketingOperationsMV].[Cost Category].[Cost Category Display] 
Item Costfloat64fact[MarketingOperationsMV].[Program Invoice Line Item].[Item Cost] 
Program Line ItemProgram IDfloat64identifier[MarketingOperationsDS].[uap_prgrm_cost].[PROGRAM_ID] 
Cost Item IDfloat64identifier[MarketingOperationsDS].[uap_prgrm_cost].[COST_ITEM_ID] 
Version IDfloat64attribute[MarketingOperationsDS].[uap_prgrm_cost].[VERSION_ID] 
Cost Item Numberfloat64attribute[MarketingOperationsDS].[uap_prgrm_cost].[COST_ITEM_NO] 
Cost Item DescriptioncharacterLength16attribute[MarketingOperationsDS].[uap_prgrm_cost].[COST_ITEM_DESC] 
Account IDfloat64attribute[MarketingOperationsDS].[uap_prgrm_cost].[ACCOUNT_ID] 
Account CodecharacterLength16attribute[MarketingOperationsDS].[uap_prgrm_cost].[ACCOUNT_CODE] 
Forecast Amountfloat64fact[MarketingOperationsDS].[uap_prgrm_cost].[FORECAST_AMT] 
Committed Amountfloat64fact[MarketingOperationsDS].[uap_prgrm_cost].[COMMITTED_AMT] 
Expenditure DatedateTimeattribute[MarketingOperationsDS].[uap_prgrm_cost].[EXPENDITURE_DATE] 
Cost Category IDfloat64attribute[MarketingOperationsDS].[uap_prgrm_cost].[COST_CAT_ID] 
Cost Category CodecharacterLength16attribute[MarketingOperationsDS].[uap_prgrm_cost].[COST_CAT_CODE] 
Program MetricsProgram Metricprogram_idfloat64identifier[MarketingOperationsDS].[uap_prgrm_metrics].[PROGRAM_ID] 
metric_idcharacterLength16identifier[MarketingOperationsDS].[uap_prgrm_metrics].[METRIC_ID] 
show_as_rollupcharacterLength16identifier[MarketingOperationsDS].[uap_prgrm_metrics].[SHOW_AS_ROLLUP] 
display_namecharacterLength16attribute[MarketingOperationsDS].[uap_prgrm_metrics].[DISPLAY_NAME] 
display_orderfloat64fact[MarketingOperationsDS].[uap_prgrm_metrics].[DISPLAY_ORDER] 
input_methodcharacterLength16attribute[MarketingOperationsDS].[uap_prgrm_metrics].[INPUT_METHOD] 
formulacharacterLength16attribute[MarketingOperationsDS].[uap_prgrm_metrics].[FORMULA] 
unitscharacterLength16attribute[MarketingOperationsDS].[uap_prgrm_metrics].[UNITS] 
display_formatcharacterLength16attribute[MarketingOperationsDS].[uap_prgrm_metrics].[DISPLAY_FORMAT] 
metric_precisionfloat64fact[MarketingOperationsDS].[uap_prgrm_metrics].[METRIC_PRECISION] 
descriptioncharacterLength16attribute[MarketingOperationsDS].[uap_prgrm_metrics].[DESCRIPTION] 
metric_columnsfloat64fact[MarketingOperationsDS].[uap_prgrm_metrics].[METRIC_COLUMNS] 
metric_value1float64fact[MarketingOperationsDS].[uap_prgrm_metrics].[METRIC_VALUE1] 
metric_value2float64fact[MarketingOperationsDS].[uap_prgrm_metrics].[METRIC_VALUE2] 
metric_value3float64fact[MarketingOperationsDS].[uap_prgrm_metrics].[METRIC_VALUE3] 
metric_value4float64fact[MarketingOperationsDS].[uap_prgrm_metrics].[METRIC_VALUE4] 
metric_value5float64fact[MarketingOperationsDS].[uap_prgrm_metrics].[METRIC_VALUE5] 
metric_rollup1float64fact[MarketingOperationsDS].[uap_prgrm_metrics].[METRIC_ROLLUP1] 
metric_rollup2float64fact[MarketingOperationsDS].[uap_prgrm_metrics].[METRIC_ROLLUP2] 
metric_rollup3float64fact[MarketingOperationsDS].[uap_prgrm_metrics].[METRIC_ROLLUP3] 
metric_rollup4float64fact[MarketingOperationsDS].[uap_prgrm_metrics].[METRIC_ROLLUP4] 
metric_rollup5float64fact[MarketingOperationsDS].[uap_prgrm_metrics].[METRIC_ROLLUP5] 
metric1_nancharacterLength16attribute[MarketingOperationsDS].[uap_prgrm_metrics].[METRIC1_NAN] 
metric2_nancharacterLength16attribute[MarketingOperationsDS].[uap_prgrm_metrics].[METRIC2_NAN] 
metric3_nancharacterLength16attribute[MarketingOperationsDS].[uap_prgrm_metrics].[METRIC3_NAN] 
metric4_nancharacterLength16attribute[MarketingOperationsDS].[uap_prgrm_metrics].[METRIC4_NAN] 
metric5_nancharacterLength16attribute[MarketingOperationsDS].[uap_prgrm_metrics].[METRIC5_NAN] 
planned_valuefloat64fact[MarketingOperationsDS].[uap_prgrm_metrics].[PLANNED_VALUE] 
planned_nancharacterLength16attribute[MarketingOperationsDS].[uap_prgrm_metrics].[PLANNED_NAN] 
grp_idcharacterLength16attribute[MarketingOperationsDS].[uap_prgrm_metrics].[GRP_ID] 
is_planned_valuecharacterLength16attribute[MarketingOperationsDS].[uap_prgrm_metrics].[IS_PLANNED_VALUE] 
alloc_totalfloat64fact[MarketingOperationsDS].[uap_prgrm_metrics].[ALLOC_TOTAL] 
is_visiblecharacterLength16attribute[MarketingOperationsDS].[uap_prgrm_metrics].[IS_VISIBLE] 
PlansPlan Program (shortcut) [MarketingOperationsMV].[Program]
Plan Program Area (shortcut) [MarketingOperationsMV].[Program Area]
Plan User (shortcut) [MarketingOperationsMV].[User]
PlansPlanPlan IDfloat64fact[MarketingOperationsDS].[uap_plans].[PLAN_ID] 
Plan CodecharacterLength16attribute[MarketingOperationsDS].[uap_plans].[PLAN_CODE] 
Plan NamecharacterLength16attribute[MarketingOperationsDS].[uap_plans].[NAME] 
Plan DescriptioncharacterLength16attribute[MarketingOperationsDS].[uap_plans].[DESCRIPTION] 
Plan Status CodecharacterLength16attribute[MarketingOperationsDS].[uap_plans].[STATE_CODE] 
Plan Fiscal Yearfloat64attribute[MarketingOperationsDS].[uap_plans].[FISCAL_YEAR] 
Plan Business Area IDfloat64attribute[MarketingOperationsDS].[uap_plans].[BUS_AREA_ID] 
Start DatedateTimeattribute[MarketingOperationsDS].[uap_plans].[ACTUAL_ST_DATE] 
End DatedateTimeattribute[MarketingOperationsDS].[uap_plans].[ACTUAL_END_DATE] 
Plan Name (Code)characterLength16attribute[MarketingOperationsMV].[Plan].[Plan Name] + ' (' + [MarketingOperationsMV].[Plan].[Plan Code] + ')' 
Plan Program Area RefPlan Program Area IDfloat64identifier[MarketingOperationsDS].[uap_plan_parea].[PLAN_PAREA_ID] 
Plan IDfloat64attribute[MarketingOperationsDS].[uap_plan_parea].[PLAN_ID] 
Program Area IDfloat64attribute[MarketingOperationsDS].[uap_plan_parea].[PRGM_AREA_ID] 
Display Orderfloat64attribute[MarketingOperationsDS].[uap_plan_parea].[DISPLAY_ORDER] 
Plan Program RefPlan IDfloat64identifier[MarketingOperationsDS].[uap_plan_prgrm].[PLAN_ID] 
Program IDfloat64identifier[MarketingOperationsDS].[uap_plan_prgrm].[PROGRAM_ID] 
Plan Program Area IDfloat64identifier[MarketingOperationsDS].[uap_plan_prgrm].[PLAN_PAREA_ID] 
Plan MemberPlan IDfloat64identifier[MarketingOperationsDS].[uap_plan_users].[PLAN_ID] 
Member Type IDfloat64attribute[MarketingOperationsDS].[uap_plan_users].[MEM_TYPE_ID] 
User IDfloat64identifier[MarketingOperationsDS].[uap_plan_users].[USER_ID] 
Namespace/FolderQuery SubjectQuery ItemTypeUsageRef Obj/Expr.
Plan Budgets
model/Plan Budgets.jpg
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 BudgetsPlan BudgetBudget IDfloat64identifier[MarketingOperationsDS].[uap_plan_budget].[BUDGET_ID] 
Plan IDfloat64identifier[MarketingOperationsDS].[uap_plan_budget].[PLAN_ID] 
Budget Totalfloat64fact[MarketingOperationsDS].[uap_plan_budget].[BUDGET_TOTAL] 
Forecast Totalfloat64fact[MarketingOperationsDS].[uap_plan_budget].[FORECAST_TOTAL] 
Actual Totalfloat64fact[MarketingOperationsDS].[uap_plan_budget].[ACTUAL_TOTAL] 
Committed Totalfloat64fact[MarketingOperationsDS].[uap_plan_budget].[COMMITTED_TOTAL] 
Allocated Totalfloat64fact[MarketingOperationsDS].[uap_plan_budget].[ALLOC_TOTAL] 
Finalized DatedateTimeattribute[MarketingOperationsDS].[uap_plan_budget].[FINALIZED_DATE] 
Program Area BudgetBudget IDfloat64identifier[MarketingOperationsDS].[uap_parea_budget].[BUDGET_ID] 
Plan Program Area IDfloat64identifier[MarketingOperationsDS].[uap_parea_budget].[PLAN_PAREA_ID] 
Budget Totalfloat64fact[MarketingOperationsDS].[uap_parea_budget].[BUDGET_TOTAL] 
Forecast Totalfloat64fact[MarketingOperationsDS].[uap_parea_budget].[FORECAST_TOTAL] 
Actual Totalfloat64fact[MarketingOperationsDS].[uap_parea_budget].[ACTUAL_TOTAL] 
Committed Totalfloat64fact[MarketingOperationsDS].[uap_parea_budget].[COMMITTED_TOTAL] 
Finalized DatedateTimeattribute[MarketingOperationsDS].[uap_parea_budget].[FINALIZED_DATE] 
AccountsParent Account (shortcut) [MarketingOperationsMV].[Account]
Account Budget Amount (shortcut) [MarketingOperationsMV].[Budget Amount]
Account Budget Reference (shortcut) [MarketingOperationsMV].[Budget]
AccountsAccountAccount IDfloat64identifier[MarketingOperationsDS].[UAP_ACCOUNTS].[ACCOUNT_ID] 
Account CodecharacterLength16attribute[MarketingOperationsDS].[UAP_ACCOUNTS].[ACCOUNT_CODE] 
Account DescriptioncharacterLength16attribute[MarketingOperationsDS].[UAP_ACCOUNTS].[ACCOUNT_DESC] 
Parent Account IDfloat64attribute[MarketingOperationsDS].[UAP_ACCOUNTS].[SRC_ACCOUNT_ID] 
Account NamecharacterLength16attribute[MarketingOperationsDS].[UAP_ACCOUNTS].[ACCOUNT_NAME] 
Account Name (Code)characterLength16attribute[MarketingOperationsMV].[Account].[Account Name] + ' (' + [MarketingOperationsMV].[Account].[Account Code] + ')' 
Account BudgetAccount IDfloat64identifier[MarketingOperationsDS].[UAP_ACT_BUDGET].[ACCOUNT_ID] 
Budget IDfloat64identifier[MarketingOperationsDS].[UAP_ACT_BUDGET].[BUDGET_ID] 
Sub-Account Budget AmountAccount IDfloat64identifier 
Quarter_IDfloat64identifier 
Year1float64identifier 
Month1float64identifier 
Budget_Amountfloat64fact 
Forecast_Amountfloat64fact 
Committed_Amountfloat64fact 
Actual_Amountfloat64fact 
ApprovalsApprover User (shortcut) [MarketingOperationsMV].[User]
ApprovalsApprovalApproval IDfloat64identifier[MarketingOperationsDS].[UAP_APPROVALS].[APPROVAL_ID] 
Approval NamecharacterLength16attribute[MarketingOperationsDS].[UAP_APPROVALS].[NAME] 
Approval DescriptioncharacterLength16attribute[MarketingOperationsDS].[UAP_APPROVALS].[DESCRIPTION] 
Approval Status CodecharacterLength16attribute[MarketingOperationsDS].[UAP_APPROVALS].[STATE_CODE] 
Approval DatedateTimeattribute[MarketingOperationsDS].[UAP_APPROVALS].[APPROVAL_DATE] 
Source Object IDfloat64identifier[MarketingOperationsDS].[UAP_APPROVALS].[SRC_OBJECT_ID] 
Source Object TypecharacterLength16attribute[MarketingOperationsDS].[UAP_APPROVALS].[SRC_OBJECT] 
Source Workflow Task IDfloat64identifier[MarketingOperationsDS].[UAP_APPROVALS].[SRC_WF_STEP] 
Approval ItemApproval IDfloat64identifier[MarketingOperationsDS].[UAP_APPR_ITEMS].[APPROVAL_ID] 
Approval Item Orderfloat64attribute[MarketingOperationsDS].[UAP_APPR_ITEMS].[APPR_ITEM_SEQ] 
Approval Item NamecharacterLength16attribute[MarketingOperationsDS].[UAP_APPR_ITEMS].[ORIG_FILE_NAME] 
ApproverApproval IDfloat64identifier[MarketingOperationsDS].[UAP_APPROVER_LIST].[APPROVAL_ID] 
Approver StatuscharacterLength16attribute[MarketingOperationsDS].[UAP_APPROVER_LIST].[STATUS_CODE] 
Approver Orderfloat64attribute[MarketingOperationsDS].[UAP_APPROVER_LIST].[APPR_ORDER] 
User IDfloat64identifier[MarketingOperationsDS].[UAP_APPROVER_LIST].[USER_ID] 
Is Required?characterLength16attribute[MarketingOperationsDS].[UAP_APPROVER_LIST].[REQUIRED] 
Response DatedateTimeattribute[MarketingOperationsDS].[UAP_APPROVER_LIST].[RESP_DATE] 
Approval StatusApproval Status CodecharacterLength16identifier[MarketingOperationsDS].[uap_status].[STATUS_CODE] 
Approval StatuscharacterLength16attribute[MarketingOperationsDS].[uap_status].[STATUS_DESC] 
BudgetsBudget AmountQuarter IDfloat64identifier[MarketingOperationsDS].[uap_budget_amt].[QUARTER_ID] 
Yearfloat64identifier[MarketingOperationsDS].[uap_budget_amt].[YEAR] 
Monthfloat64identifier[MarketingOperationsDS].[uap_budget_amt].[MONTH] 
Budget IDfloat64identifier[MarketingOperationsDS].[uap_budget_amt].[BUDGET_ID] 
Forecast Amountfloat64fact[MarketingOperationsDS].[uap_budget_amt].[FORECAST_AMT] 
Committed Amountfloat64fact[MarketingOperationsDS].[uap_budget_amt].[COMMITTED_AMT] 
Actual Amountfloat64fact[MarketingOperationsDS].[uap_budget_amt].[ACTUAL_AMT] 
Budget Amountfloat64fact[MarketingOperationsDS].[uap_budget_amt].[BUDGET_AMT] 
Allocated Amountfloat64fact[MarketingOperationsDS].[uap_budget_amt].[ALLOC_AMT] 
Committed Remaining Amountfloat64factIF ( [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 Amountfloat64factIF ( [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 Amountfloat64factIF ( [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 Amountfloat64factIF ( [MarketingOperationsMV].[Budget Amount].[Allocated Amount] is null ) THEN ( [MarketingOperationsMV].[Budget Amount].[Budget Amount] ) ELSE ( [MarketingOperationsMV].[Budget Amount].[Budget Amount] - [MarketingOperationsMV].[Budget Amount].[Allocated Amount] ) 
QuarterQuarter IDfloat64identifier[MarketingOperationsDS].[uap_quarters].[QUARTER_ID] 
Yearfloat64identifier[MarketingOperationsDS].[uap_quarters].[YEAR] 
Monthfloat64identifier[MarketingOperationsDS].[uap_quarters].[MONTH] 
Quarter DescriptioncharacterLength16attribute[MarketingOperationsDS].[uap_quarters].[DESCRIPTION] 
Quarter YearcharacterLength16attributesubstring ([MarketingOperationsMV].[Quarter].[Quarter Description] , position ( '(' , [MarketingOperationsMV].[Quarter].[Quarter Description] ) + 1, 7) 
Month YearcharacterLength16attributesubstring ( [MarketingOperationsMV].[Quarter].[Quarter Description], 0, position('(', [MarketingOperationsMV].[Quarter].[Quarter Description]) - 1) 
Fiscal YearcharacterLength16attributesubstring ([MarketingOperationsMV].[Quarter].[Quarter Description] , 5,4) 
BudgetBudget IDfloat64identifier[MarketingOperationsDS].[uap_budgets].[BUDGET_ID] 
InvoicesInvoiceInvoice IDfloat64identifier[MarketingOperationsDS].[UAP_INVOICES].[INVOICE_ID] 
Invoice NumbercharacterLength16attribute[MarketingOperationsDS].[UAP_INVOICES].[INVOICE_NO] 
Vendor IDfloat64attribute[MarketingOperationsDS].[UAP_INVOICES].[VENDOR_ID] 
PO NumbercharacterLength16attribute[MarketingOperationsDS].[UAP_INVOICES].[PO_NO] 
Due DatedateTimeidentifier[MarketingOperationsDS].[UAP_INVOICES].[DUE_DATE] 
Status CodecharacterLength16attribute[MarketingOperationsDS].[UAP_INVOICES].[STATUS_CODE] 
State CodecharacterLength16attribute[MarketingOperationsDS].[UAP_INVOICES].[STATE_CODE] 
Invoice DatedateTimeidentifier[MarketingOperationsDS].[UAP_INVOICES].[SUBMIT_DATE] 
NotescharacterLength16attribute[MarketingOperationsDS].[UAP_INVOICES].[NOTES] 
Payment TermscharacterLength16attribute[MarketingOperationsDS].[UAP_INVOICES].[PAYMENT_TERMS] 
Invoice Amountfloat64fact[MarketingOperationsDS].[UAP_INVOICES].[INVOICE_AMOUNT] 
Invoice CodecharacterLength16attribute[MarketingOperationsDS].[UAP_INVOICES].[INVOICE_CODE] 
Payable DatedateTimeattribute[MarketingOperationsDS].[UAP_INVOICES].[PAYABLE_DATE] 
Paid DatedateTimeattribute[MarketingOperationsDS].[UAP_INVOICES].[PAID_DATE] 
Invoice URLcharacterLength16attribute#sq($[Environment]{'URL'})# + 'type=invoice&id=' + cast(cast([MarketingOperationsMV].[Invoice].[Invoice ID],integer),varchar(10)) 
Invoice Line ItemInvoice IDfloat64identifier[MarketingOperationsDS].[UAP_INVOICE_ITEMS].[INVOICE_ID] 
Cost Item IDfloat64identifier[MarketingOperationsDS].[UAP_INVOICE_ITEMS].[COST_ITEM_ID] 
Cost Item Numberfloat64attribute[MarketingOperationsDS].[UAP_INVOICE_ITEMS].[COST_ITEM_NO] 
Item DescriptioncharacterLength16attribute[MarketingOperationsDS].[UAP_INVOICE_ITEMS].[COST_ITEM_DESC] 
Source Object TypecharacterLength16attribute[MarketingOperationsDS].[UAP_INVOICE_ITEMS].[SRC_OBJ_TYPE] 
Source Object IDfloat64attribute[MarketingOperationsDS].[UAP_INVOICE_ITEMS].[SRC_OBJ_ID] 
Source Object CodecharacterLength16attribute[MarketingOperationsDS].[UAP_INVOICE_ITEMS].[SRC_OBJ_CODE] 
Account IDfloat64attribute[MarketingOperationsDS].[UAP_INVOICE_ITEMS].[ACCOUNT_ID] 
Account CodecharacterLength16attribute[MarketingOperationsDS].[UAP_INVOICE_ITEMS].[ACCOUNT_CODE] 
Cost Category IDfloat64attribute[MarketingOperationsDS].[UAP_INVOICE_ITEMS].[COST_CAT_ID] 
Cost Category CodecharacterLength16attribute[MarketingOperationsDS].[UAP_INVOICE_ITEMS].[COST_CAT_CODE] 
Quantityfloat64fact[MarketingOperationsDS].[UAP_INVOICE_ITEMS].[QUANTITY] 
Unit Costfloat64fact[MarketingOperationsDS].[UAP_INVOICE_ITEMS].[UNIT_COST] 
Item Costfloat64fact[MarketingOperationsDS].[UAP_INVOICE_ITEMS].[ITEM_COST] 
Custom AttributesProject Custom AttributesProject IDfloat64identifier[MarketingOperationsDS].[DYN_PROJECTATTS].[PROJECT_ID] 
Initiative IDfloat64fact[MarketingOperationsDS].[DYN_PROJECTATTS].[INIT_TYPE_ID] 
Segment IDfloat64fact[MarketingOperationsDS].[DYN_PROJECTATTS].[SEGMENT_ID] 
Channel_Idfloat64fact[MarketingOperationsDS].[DYN_PROJECTATTS].[CHANNEL_ID] 
Business Unit IDfloat64fact[MarketingOperationsDS].[DYN_PROJECTATTS].[BUSINESS_UNIT_ID] 
Product Family IDfloat64fact[MarketingOperationsDS].[DYN_PROJECTATTS].[PROD_FAMILY_ID] 
Budget Period Idfloat64fact[MarketingOperationsDS].[DYN_PROJECTATTS].[BUDGET_PERIOD_ID] 
Business UnitBusiness Unit IDfloat64identifier[MarketingOperationsDS].[LKUP_BUSINESS_UNIT].[BUSINESS_UNIT_ID] 
Business UnitcharacterLength16attribute[MarketingOperationsDS].[LKUP_BUSINESS_UNIT].[BUSINESS_UNIT_NAME] 
InitiativeInitiative IDfloat64identifier[MarketingOperationsDS].[LKUP_INITIATIVE].[INIT_TYPE_ID] 
InitiativecharacterLength16attribute[MarketingOperationsDS].[LKUP_INITIATIVE].[INIT_TYPE_NAME] 
Product FamilyProduct Family IDfloat64identifier[MarketingOperationsDS].[LKUP_PROD_FAMILY].[PROD_FAMILY_ID] 
Product FamilycharacterLength16attribute[MarketingOperationsDS].[LKUP_PROD_FAMILY].[PROD_FAMILY_NAME] 
SegmentSegment IDfloat64identifier[MarketingOperationsDS].[LKUP_SEGMENTS].[SEGMENT_ID] 
SegmentcharacterLength16attribute[MarketingOperationsDS].[LKUP_SEGMENTS].[SEGMENT_NAME] 
Project Performance Summary Custom MetricsProject IDfloat64fact 
Total Revenuefloat64fact 
ResponseRateActualfloat64fact 
ResponseRateTargetfloat64fact 
Total Leads Generated (Actual)float64fact 
Total Leads Generated (Target)float64fact 
Total Cost Passedfloat64fact 
ChannelCHANNEL_IDfloat64identifier[MarketingOperationsDS].[LKUP_CHANNEL].[CHANNEL_ID] 
CHANNEL_NAMEcharacterLength16attribute[MarketingOperationsDS].[LKUP_CHANNEL].[CHANNEL_NAME] 
Budget Periodbudget_period_idfloat64identifier[MarketingOperationsDS].[LKUP_BUDGET_PERIOD].[BUDGET_PERIOD_ID] 
budget_period_namecharacterLength16attribute[MarketingOperationsDS].[LKUP_BUDGET_PERIOD].[BUDGET_PERIOD_NAME] 
DashboardsRequests Over TimeProject IDfloat64identifier[MarketingOperationsMV].[Project Requests].[Project ID] 
Project NamecharacterLength16attribute[MarketingOperationsMV].[Project Requests].[Project Name] 
Project CodecharacterLength16attribute[MarketingOperationsMV].[Project Requests].[Project Code] 
Project DescriptioncharacterLength16attribute[MarketingOperationsMV].[Project Requests].[Project Description] 
Project Start DatedateTimeidentifier[MarketingOperationsMV].[Project Requests].[Project Start Date] 
Project End DatedateTimeidentifier[MarketingOperationsMV].[Project Requests].[Project End Date] 
Project Actual Start DatedateTimeidentifier[MarketingOperationsMV].[Project Requests].[Project Actual Start Date] 
Project Actual End DatedateTimeidentifier[MarketingOperationsMV].[Project Requests].[Project Actual End Date] 
Project Request StatuscharacterLength16attribute[MarketingOperationsMV].[Project Requests].[Project Request Status] 
Project URLcharacterLength16attribute[MarketingOperationsMV].[Project Requests].[Project Request URL] 
Project Name (Code)characterLength16attribute[MarketingOperationsMV].[Project Requests].[Project Name (Code)] 
Project Request FlagcharacterLength16attribute[MarketingOperationsMV].[Project Requests].[Project Request Flag] 
Project Request IDfloat64identifier[MarketingOperationsMV].[Project Requests].[Project Request ID] 
Request Submit DatedateTimeidentifier[MarketingOperationsMV].[Project Requests].[Request Submit Date] 
Request Complete DatedateTimeidentifier[MarketingOperationsMV].[Project Requests].[Request Complete Date] 
Request Submit Monthint32identifierextract(month, [MarketingOperationsMV].[Requests Over Time].[Request Submit Date] ) -1 
Request Submit Yearint32identifierextract (year, [MarketingOperationsMV].[Requests Over Time].[Request Submit Date] ) 
Template NamecharacterLength16attribute[MarketingOperationsMV].[Project Requests].[Template Name] 
Request Parent Project IDfloat64identifier[MarketingOperationsMV].[Project Requests].[Request Parent Project ID] 
Projects Over TimeProject IDfloat64identifier[MarketingOperationsMV].[Project].[Project ID] 
Project NamecharacterLength16attribute[MarketingOperationsMV].[Project].[Project Name] 
Project CodecharacterLength16attribute[MarketingOperationsMV].[Project].[Project Code] 
Project DescriptioncharacterLength16attribute[MarketingOperationsMV].[Project].[Project Description] 
Project Start DatedateTimeidentifier[MarketingOperationsMV].[Project].[Project Start Date] 
Project End DatedateTimeidentifier[MarketingOperationsMV].[Project].[Project End Date] 
Project Actual Start DatedateTimeidentifier[MarketingOperationsMV].[Project].[Project Actual Start Date] 
Project Actual End DatedateTimeidentifier[MarketingOperationsMV].[Project].[Project Actual End Date] 
Project Actual End Monthfloat64identifierextract(month, [MarketingOperationsMV].[Projects Over Time].[Project Actual End Date] ) -1 
Project Actual End Yearfloat64identifierextract(year, [MarketingOperationsMV].[Projects Over Time].[Project Actual End Date] ) 
Project Status CodecharacterLength16identifier[MarketingOperationsMV].[Project Status].[Status Code] 
Project StatuscharacterLength16attribute[MarketingOperationsMV].[Project Status].[Status] 
Project URLcharacterLength16attribute[MarketingOperationsMV].[Project].[Project URL] 
Project Name (Code)characterLength16attribute[MarketingOperationsMV].[Project].[Project Name (Code)] 
Project Request FlagcharacterLength16attribute[MarketingOperationsMV].[Project].[Project Request Flag] 
Template NamecharacterLength16attribute[MarketingOperationsMV].[Project].[Template Name] 
Parent Project IDfloat64identifier[MarketingOperationsMV].[Project].[Parent Project ID] 
Projects QuarterQuarter IDfloat64identifier[MarketingOperationsDS].[uap_quarters].[QUARTER_ID] 
Yearfloat64identifier[MarketingOperationsDS].[uap_quarters].[YEAR] 
Monthfloat64identifier[MarketingOperationsDS].[uap_quarters].[MONTH] 
Quarter DescriptioncharacterLength16attribute[MarketingOperationsDS].[uap_quarters].[DESCRIPTION] 
Quarter YearcharacterLength16attributesubstring ([MarketingOperationsMV].[Projects Quarter].[Quarter Description] , position ( '(' , [MarketingOperationsMV].[Projects Quarter].[Quarter Description] ) + 1, 7) 
Month YearcharacterLength16attributesubstring ( [MarketingOperationsMV].[Projects Quarter].[Quarter Description], 1, position('(', [MarketingOperationsMV].[Projects Quarter].[Quarter Description]) - 1) 
Fiscal YearcharacterLength16attributesubstring ([MarketingOperationsMV].[Projects Quarter].[Quarter Description] , 5,4) 
Namespace/FolderQuery SubjectQuery ItemTypeUsageRef Obj/Expr.
Projects and Requests Over Time Star Schema
model/Projects and Requests Over Time Star Schema.jpg
Requests Over Time (shortcut) [MarketingOperationsMV].[Requests Over Time]
Projects Over Time (shortcut) [MarketingOperationsMV].[Projects Over Time]
Projects Quarter (shortcut) [MarketingOperationsMV].[Projects Quarter]
Import View
model/Import View.jpg
Namespace/FolderQuery SubjectQuery ItemTypeUsageRef Obj/Expr.
Commonuap_member_typemem_type_idfloat64identifier 
mem_namecharacterLength16attribute 
object_typecharacterLength16attribute 
uap_userUSER_IDfloat64fact 
LAST_NAMEcharacterLength16attribute 
FIRST_NAMEcharacterLength16attribute 
LAST_MOD_DATEdateTimeidentifier 
LOGIN_IDcharacterLength16attribute 
EMAIL_IDcharacterLength16attribute 
STATUS_CODEcharacterLength16attribute 
LOCALEcharacterLength16attribute 
uap_statusSTATUS_CODEcharacterLength16attribute 
STATUS_DESCcharacterLength16attribute 
UAP_TT_TEMPLATESTEMPLATE_IDfloat64identifier 
OBJECT_TYPEfloat64fact 
TEMPLATE_NAMEcharacterLength16attribute 
ACTUAL_DISPLAYcharacterLength16attribute 
DISPLAYcharacterLength16attribute 
uap_rolesROLE_IDfloat64fact 
ROLE_NAMEcharacterLength16attribute 
ROLE_DESCcharacterLength16attribute 
SEC_POLICY_IDfloat64fact 
uap_user_rolesROLE_IDfloat64fact 
SEC_POLICY_IDfloat64fact 
USER_IDfloat64fact 
UAP_TEAMSTEAM_IDfloat64identifier 
NAMEcharacterLength16attribute 
DESCRIPTIONcharacterLength16attribute 
SKILLSETScharacterLength16attribute 
STATUSfloat64fact 
UAP_TEAM_MEMBERSTEAM_IDfloat64identifier 
USER_IDfloat64identifier 
MEM_TYPE_IDfloat64identifier 
List Definitionsuap_managed_listLIST_IDfloat64fact 
LIST_CODEcharacterLength16attribute 
LIST_NAMEcharacterLength16attribute 
LIST_TABLEcharacterLength16attribute 
KEY_COLUMNcharacterLength16attribute 
DESCRIPTIONcharacterLength16attribute 
FLAG_CODE_FIRSTcharacterLength16attribute 
uap_ml_bus_areaBUS_AREA_IDfloat64fact 
CODEcharacterLength16attribute 
NAMEcharacterLength16attribute 
DISPLAYcharacterLength16attribute 
DISPLAY_NOfloat64fact 
FLAG_ENABLEDcharacterLength16attribute 
uap_ml_cost_catCOST_CAT_IDfloat64fact 
CODEcharacterLength16attribute 
NAMEcharacterLength16attribute 
DISPLAYcharacterLength16attribute 
DISPLAY_NOfloat64fact 
FLAG_ENABLEDcharacterLength16attribute 
uap_ml_vendorVENDOR_IDfloat64fact 
CODEcharacterLength16attribute 
NAMEcharacterLength16attribute 
DISPLAYcharacterLength16attribute 
DISPLAY_NOfloat64fact 
FLAG_ENABLEDcharacterLength16attribute 
uap_prgm_areaPRGM_AREA_IDfloat64fact 
NAMEcharacterLength16attribute 
DISPLAYcharacterLength16attribute 
CODEcharacterLength16attribute 
DISPLAY_NOfloat64fact 
FLAG_ENABLEDcharacterLength16attribute 
Projectsuap_proj_usersPROJECT_IDfloat64fact 
USER_IDfloat64fact 
MEM_TYPE_IDfloat64fact 
TEAM_IDfloat64fact 
uap_projectsPROJECT_IDfloat64fact 
NAMEcharacterLength16attribute 
DESCRIPTIONcharacterLength16attribute 
STATUS_CODEcharacterLength16attribute 
START_DATEdateTimeidentifier 
END_DATEdateTimeidentifier 
DURATIONfloat64fact 
CREATED_BYfloat64fact 
CREATED_DATEdateTimeidentifier 
MODIFIED_BYfloat64fact 
LAST_MOD_DATEdateTimeidentifier 
PCNT_COMPfloat64fact 
FLAG_ANCHORcharacterLength16attribute 
REQ_COMP_DATEdateTimeidentifier 
WF_STEPSfloat64fact 
STATE_CODEcharacterLength16attribute 
TEMPLATE_NAMEcharacterLength16attribute 
METRIC_TEMPLATEcharacterLength16attribute 
ERROR_CODEcharacterLength16attribute 
ACTUAL_ST_DATEdateTimeidentifier 
PROJ_CODEcharacterLength16attribute 
FLAG_PROJ_REQUESTcharacterLength16attribute 
PROJ_REQUEST_IDfloat64fact 
SEC_POLICY_IDfloat64fact 
REQ_SUBMIT_DATEdateTimeidentifier 
ACTUAL_END_DATEdateTimeidentifier 
CAMPAIGN_IDfloat64fact 
MT_MOD_DATEdateTimeidentifier 
MT_FINALIZED_DATEdateTimeidentifier 
MT_IMPORT_DATEdateTimeidentifier 
PARENT_PROJ_IDfloat64fact 
ROOT_PROJ_IDfloat64fact 
PROJ_LEVELfloat64fact 
SEC_POLICY_MODELfloat64fact 
uap_wf_depWF_NOfloat64fact 
DEP_SEQfloat64fact 
PROJECT_IDfloat64fact 
DEP_WF_NOfloat64fact 
uap_wf_milestoneMILESTONE_TYPEfloat64fact 
MILESTONE_DESCcharacterLength16attribute 
uap_wf_usersWF_NOfloat64fact 
USER_IDfloat64fact 
EST_USAGEfloat64fact 
ACT_USAGEfloat64fact 
uap_workflowWF_NOfloat64fact 
NAMEcharacterLength16attribute 
DISPLAY_ORDERfloat64fact 
FLAG_STAGEcharacterLength16attribute 
START_DATEdateTimeidentifier 
END_DATEdateTimeidentifier 
FLAG_ANCHORcharacterLength16attribute 
DURATIONfloat64fact 
ACTUAL_DURATIONfloat64fact 
DURATION_STRcharacterLength16attribute 
ACTUAL_DURATION_STRcharacterLength16attribute 
PCNT_COMPfloat64fact 
PROJECT_IDfloat64fact 
FLAG_LINKcharacterLength16attribute 
FORECAST_STdateTimeidentifier 
LINK_IDfloat64fact 
PARENT_STAGEfloat64fact 
STATUS_CODEcharacterLength16attribute 
NOTEScharacterLength16attribute 
MILESTONE_TYPEfloat64fact 
DISPLAY_IDcharacterLength16attribute 
LINK_OBJECTcharacterLength16attribute 
STATE_CODEcharacterLength16attribute 
FORECAST_ENDdateTimeidentifier 
ACTUAL_EFFORTfloat64fact 
EFFORTfloat64fact 
ACTUAL_EFFORT_STRcharacterLength16attribute 
EFFORT_STRcharacterLength16attribute 
ENABLE_ATTACHMENTfloat64fact 
REQUIREDcharacterLength16attribute 
ENFORCE_DEPcharacterLength16attribute 
SCHEDULING_MASKfloat64fact 
TASK_CODEcharacterLength16attribute 
uap_proj_budgetBUDGET_IDfloat64fact 
PROJECT_IDfloat64fact 
BUDGET_TOTALfloat64fact 
FORECAST_TOTALfloat64fact 
ACTUAL_TOTALfloat64fact 
COMMITTED_TOTALfloat64fact 
FINALIZED_DATEdateTimeidentifier 
uap_proj_costPROJECT_IDfloat64fact 
COST_ITEM_IDfloat64fact 
VERSION_IDfloat64fact 
COST_ITEM_NOfloat64fact 
ACCOUNT_IDfloat64fact 
ACCOUNT_CODEcharacterLength16attribute 
FORECAST_AMTfloat64fact 
COMMITTED_AMTfloat64fact 
EXPENDITURE_DATEdateTimeidentifier 
CREATED_DATEdateTimeidentifier 
CREATED_BYfloat64fact 
LAST_MOD_DATEdateTimeidentifier 
MODIFIED_BYfloat64fact 
COST_CAT_IDfloat64fact 
COST_CAT_CODEcharacterLength16attribute 
COST_ITEM_DESCcharacterLength16attribute 
VENDOR_IDfloat64fact 
VENDOR_CODEcharacterLength16attribute 
uap_proj_metricsMETRIC_IDcharacterLength16identifier 
DISPLAY_NAMEcharacterLength16attribute 
DISPLAY_ORDERfloat64fact 
UNITScharacterLength16attribute 
INPUT_METHODcharacterLength16attribute 
DISPLAY_FORMATcharacterLength16attribute 
METRIC_VALUE1float64fact 
METRIC_VALUE3float64fact 
METRIC_VALUE2float64fact 
DESCRIPTIONcharacterLength16attribute 
FORMULAcharacterLength16attribute 
METRIC_VALUE4float64fact 
METRIC_PRECISIONfloat64fact 
METRIC_VALUE5float64fact 
METRIC_COLUMNSfloat64fact 
PROJECT_IDfloat64identifier 
GRP_IDcharacterLength16attribute 
METRIC1_NANcharacterLength16attribute 
METRIC2_NANcharacterLength16attribute 
METRIC3_NANcharacterLength16attribute 
METRIC4_NANcharacterLength16attribute 
METRIC5_NANcharacterLength16attribute 
PLANNED_VALUEfloat64fact 
PLANNED_NANcharacterLength16attribute 
IS_PLANNED_VALUEcharacterLength16attribute 
SHOW_AS_ROLLUPcharacterLength16attribute 
IS_VISIBLEcharacterLength16attribute 
uap_metric_colsPROJECT_IDfloat64identifier 
COL_TABORDERfloat64identifier 
COL_DISPLAYcharacterLength16attribute 
FLAG_TARGETcharacterLength16attribute 
DIMENSION_TYPEcharacterLength16attribute 
Programsuap_prgrm_budgetBUDGET_IDfloat64fact 
PROGRAM_IDfloat64fact 
BUDGET_TOTALfloat64fact 
FORECAST_TOTALfloat64fact 
ACTUAL_TOTALfloat64fact 
COMMITTED_TOTALfloat64fact 
ALLOC_TOTALfloat64fact 
FINALIZED_DATEdateTimeidentifier 
LINE_ITEM_TOTALfloat64fact 
uap_prgrm_costPROGRAM_IDfloat64fact 
COST_ITEM_IDfloat64fact 
VERSION_IDfloat64fact 
COST_ITEM_NOfloat64fact 
COST_ITEM_DESCcharacterLength16attribute 
ACCOUNT_IDfloat64fact 
ACCOUNT_CODEcharacterLength16attribute 
FORECAST_AMTfloat64fact 
COMMITTED_AMTfloat64fact 
EXPENDITURE_DATEdateTimeidentifier 
CREATED_DATEdateTimeidentifier 
CREATED_BYfloat64fact 
LAST_MOD_DATEdateTimeidentifier 
MODIFIED_BYfloat64fact 
COST_CAT_IDfloat64fact 
COST_CAT_CODEcharacterLength16attribute 
VENDOR_IDfloat64fact 
VENDOR_CODEcharacterLength16attribute 
uap_prgrm_projectPROJECT_IDfloat64fact 
PROGRAM_IDfloat64fact 
PLAN_IDfloat64fact 
PLAN_PAREA_IDfloat64fact 
uap_prgrm_usersPROGRAM_IDfloat64fact 
USER_IDfloat64fact 
MEM_TYPE_IDfloat64fact 
uap_programsPROGRAM_IDfloat64fact 
NAMEcharacterLength16attribute 
DESCRIPTIONcharacterLength16attribute 
TEMPLATE_NAMEcharacterLength16attribute 
PROGRAM_CODEcharacterLength16attribute 
STATUS_CODEcharacterLength16attribute 
STATE_CODEcharacterLength16attribute 
START_DATEdateTimeidentifier 
END_DATEdateTimeidentifier 
ACTUAL_ST_DATEdateTimeidentifier 
ACTUAL_END_DATEdateTimeidentifier 
METRIC_TEMPLATEcharacterLength16attribute 
CREATED_BYfloat64fact 
CREATED_DATEdateTimeidentifier 
MODIFIED_BYfloat64fact 
LAST_MOD_DATEdateTimeidentifier 
SEC_POLICY_IDfloat64fact 
MT_MOD_DATEdateTimeidentifier 
MT_FINALIZED_DATEdateTimeidentifier 
uap_prgrm_metricsPROGRAM_IDfloat64fact 
METRIC_IDcharacterLength16attribute 
SHOW_AS_ROLLUPcharacterLength16attribute 
DISPLAY_NAMEcharacterLength16attribute 
DISPLAY_ORDERfloat64fact 
INPUT_METHODcharacterLength16attribute 
FORMULAcharacterLength16attribute 
UNITScharacterLength16attribute 
DISPLAY_FORMATcharacterLength16attribute 
METRIC_PRECISIONfloat64fact 
DESCRIPTIONcharacterLength16attribute 
METRIC_COLUMNSfloat64fact 
METRIC_VALUE1float64fact 
METRIC_VALUE2float64fact 
METRIC_VALUE3float64fact 
METRIC_VALUE4float64fact 
METRIC_VALUE5float64fact 
METRIC_ROLLUP1float64fact 
METRIC_ROLLUP2float64fact 
METRIC_ROLLUP3float64fact 
METRIC_ROLLUP4float64fact 
METRIC_ROLLUP5float64fact 
METRIC1_NANcharacterLength16attribute 
METRIC2_NANcharacterLength16attribute 
METRIC3_NANcharacterLength16attribute 
METRIC4_NANcharacterLength16attribute 
METRIC5_NANcharacterLength16attribute 
PLANNED_VALUEfloat64fact 
PLANNED_NANcharacterLength16attribute 
GRP_IDcharacterLength16attribute 
IS_PLANNED_VALUEcharacterLength16attribute 
ALLOC_TOTALfloat64fact 
IS_VISIBLEcharacterLength16attribute 
Plansuap_parea_budgetBUDGET_IDfloat64fact 
PLAN_PAREA_IDfloat64fact 
BUDGET_TOTALfloat64fact 
FORECAST_TOTALfloat64fact 
ACTUAL_TOTALfloat64fact 
COMMITTED_TOTALfloat64fact 
FINALIZED_DATEdateTimeidentifier 
uap_plan_budgetBUDGET_IDfloat64fact 
PLAN_IDfloat64fact 
BUDGET_TOTALfloat64fact 
FORECAST_TOTALfloat64fact 
ACTUAL_TOTALfloat64fact 
COMMITTED_TOTALfloat64fact 
ALLOC_TOTALfloat64fact 
FINALIZED_DATEdateTimeidentifier 
uap_plan_pareaPLAN_PAREA_IDfloat64fact 
PLAN_IDfloat64fact 
PRGM_AREA_IDfloat64fact 
DISPLAY_ORDERfloat64fact 
uap_plan_prgrmPLAN_IDfloat64fact 
PROGRAM_IDfloat64fact 
PLAN_PAREA_IDfloat64fact 
uap_plan_usersPLAN_IDfloat64fact 
MEM_TYPE_IDfloat64fact 
USER_IDfloat64fact 
uap_plansPLAN_IDfloat64fact 
NAMEcharacterLength16attribute 
DESCRIPTIONcharacterLength16attribute 
SEC_POLICY_IDfloat64fact 
STATUS_CODEcharacterLength16attribute 
STATE_CODEcharacterLength16attribute 
METRIC_TEMPLATEcharacterLength16attribute 
CREATED_DATEdateTimeidentifier 
CREATED_BYfloat64fact 
LAST_MOD_DATEdateTimeidentifier 
FISCAL_YEARfloat64fact 
PLAN_CODEcharacterLength16attribute 
BUS_AREA_IDfloat64fact 
MODIFIED_BYfloat64fact 
ACTUAL_ST_DATEdateTimeidentifier 
ACTUAL_END_DATEdateTimeidentifier 
AccountsUAP_ACCOUNTSACCOUNT_IDfloat64identifier 
ACCOUNT_CODEcharacterLength16attribute 
ACCOUNT_DESCcharacterLength16attribute 
SRC_ACCOUNT_IDfloat64fact 
CREATED_DATEdateTimeidentifier 
CREATED_BYfloat64fact 
LAST_MOD_DATEdateTimeidentifier 
MODIFIED_BYfloat64fact 
SEC_POLICY_IDfloat64fact 
FLAG_ENABLEDcharacterLength16attribute 
ACCOUNT_NAMEcharacterLength16attribute 
UAP_ACT_BUDGETACCOUNT_IDfloat64identifier 
BUDGET_IDfloat64identifier 
ApprovalsUAP_APPROVALSAPPROVAL_IDfloat64identifier 
NAMEcharacterLength16attribute 
DESCRIPTIONcharacterLength16attribute 
SUBMIT_DATEdateTimeidentifier 
CREATED_BYfloat64fact 
STATE_CODEcharacterLength16attribute 
CREATE_DATEdateTimeidentifier 
SRC_OBJECT_IDfloat64fact 
APPROVAL_DATEdateTimeattribute 
SRC_WF_STEPfloat64fact 
SEC_POLICY_IDfloat64fact 
STATUS_CODEcharacterLength16attribute 
LAST_MOD_DATEdateTimeidentifier 
COMPLETED_DATEdateTimeidentifier 
SRC_OBJECTcharacterLength16attribute 
METHODfloat64fact 
RESUBMIT_COUNTfloat64fact 
UAP_APPROVER_LISTAPPROVAL_IDfloat64identifier 
APPROVER_SEQfloat64identifier 
STATUS_CODEcharacterLength16attribute 
APPR_ORDERfloat64fact 
USER_IDfloat64fact 
REQUIREDcharacterLength16attribute 
INSTRUCTIONScharacterLength16attribute 
RESP_DATEdateTimeidentifier 
TEAM_IDfloat64fact 
UAP_APPR_ITEMSAPPR_ITEM_SEQfloat64identifier 
CREATE_DATEdateTimeidentifier 
NOTEScharacterLength16attribute 
ITEM_STATUScharacterLength16attribute 
USER_IDfloat64fact 
ORIG_FILE_NAMEcharacterLength16attribute 
APPROVAL_IDfloat64identifier 
MARKUP_FILE_NAMEcharacterLength16attribute 
ORIG_FILE_SIZEcharacterLength16attribute 
ORIG_FILE_MIMEcharacterLength16attribute 
LAST_MOD_DATEdateTimeidentifier 
OBJECT_IDfloat64fact 
OBJECT_TYPE_IDfloat64fact 
Budgetsuap_budget_amtQUARTER_IDfloat64fact 
YEARfloat64fact 
MONTHfloat64fact 
BUDGET_IDfloat64fact 
FORECAST_AMTfloat64fact 
COMMITTED_AMTfloat64fact 
ACTUAL_AMTfloat64fact 
BUDGET_AMTfloat64fact 
ALLOC_AMTfloat64fact 
LINE_ITEM_AMTfloat64fact 
uap_budgetsBUDGET_IDfloat64fact 
BUDGET_PERIODcharacterLength16attribute 
CREATED_DATEdateTimeidentifier 
CREATED_BYfloat64fact 
LAST_MOD_DATEdateTimeidentifier 
MODIFIED_BYfloat64fact 
uap_quartersQUARTER_IDfloat64fact 
YEARfloat64fact 
MONTHfloat64fact 
DESCRIPTIONcharacterLength16attribute 
InvoicesUAP_INVOICESINVOICE_IDfloat64identifier 
INVOICE_NOcharacterLength16attribute 
VENDOR_IDfloat64fact 
PO_NOcharacterLength16attribute 
DUE_DATEdateTimeidentifier 
STATUS_CODEcharacterLength16attribute 
STATE_CODEcharacterLength16attribute 
SUBMIT_DATEdateTimeidentifier 
CREATED_BYfloat64fact 
CREATED_DATEdateTimeidentifier 
LAST_MOD_DATEdateTimeidentifier 
MODIFIED_BYfloat64fact 
NOTEScharacterLength16attribute 
PAYMENT_TERMScharacterLength16attribute 
INVOICE_AMOUNTfloat64fact 
INVOICE_CODEcharacterLength16attribute 
PAYABLE_DATEdateTimeidentifier 
PAID_DATEdateTimeidentifier 
SEC_POLICY_IDfloat64fact 
UAP_INVOICE_ITEMSINVOICE_IDfloat64identifier 
COST_ITEM_IDfloat64identifier 
COST_ITEM_NOfloat64fact 
COST_ITEM_DESCcharacterLength16attribute 
SRC_OBJ_TYPEcharacterLength16attribute 
SRC_OBJ_IDfloat64fact 
SRC_OBJ_CODEcharacterLength16attribute 
ACCOUNT_IDfloat64fact 
ACCOUNT_CODEcharacterLength16attribute 
COST_CAT_IDfloat64fact 
COST_CAT_CODEcharacterLength16attribute 
QUANTITYfloat64fact 
UNIT_COSTfloat64fact 
ITEM_COSTfloat64fact 
Custom AttributesDYN_PROJECTATTSPROJECT_IDfloat64fact 
INIT_TYPE_IDfloat64fact 
SEGMENT_IDfloat64fact 
CHANNEL_IDfloat64fact 
BUSINESS_UNIT_IDfloat64fact 
PROD_FAMILY_IDfloat64fact 
BUDGET_PERIOD_IDfloat64fact 
LKUP_BUSINESS_UNITBUSINESS_UNIT_IDfloat64identifier 
BUSINESS_UNIT_NAMEcharacterLength16attribute 
LKUP_INITIATIVEINIT_TYPE_IDfloat64identifier 
INIT_TYPE_NAMEcharacterLength16attribute 
LKUP_PROD_FAMILYPROD_FAMILY_NAMEcharacterLength16attribute 
PROD_FAMILY_IDfloat64identifier 
LKUP_SEGMENTSSEGMENT_IDfloat64identifier 
SEGMENT_NAMEcharacterLength16attribute 
LKUP_CHANNELCHANNEL_IDfloat64identifier 
CHANNEL_NAMEcharacterLength16attribute 
LKUP_BUDGET_PERIODBUDGET_PERIOD_IDfloat64fact 
BUDGET_PERIOD_NAMEcharacterLength16attribute 
Copyright

© Copyright Unica Corporation 2003 - 2010. All rights reserved.

Unica Corporation
Reservoir Place North
170 Tracer Lane
Waltham, MA 02451-1379
Examples and Data

All software and related documentation is subject to restrictions on use and disclosure as set forth in the Unica Software License and Services Agreement, with restricted rights for U.S. government users and applicable export regulations.

Companies, names, and data used in examples herein are fictitious unless otherwise noted.

Trademarks and Patents

Unica®, the Unica logo, Affinium®, MarketingCentral®, MarketSoft®, MarketSoft logo, DemandMore®, Leads to Revenue®, NetTracker®, My NetTracker®, and Ask NetTracker® are registered trademarks of Unica Corporation with the U.S. Patent and Trademark Office.

Affinium Campaign™, Affinium Campaign Collaborate™, Affinium Campaign eMessage™, Affinium Campaign Interact™, Affinium Campaign Optimize™, Affinium Detect™, Affinium Leads™, Affinium Leads Referral™, Affinium Leads Contact™, Affinium Model™, Affinium NetInsight™, Affinium Insight™, Affinium Plan™, Affinium Mart™, Universal Dynamic Interconnect™, Interconnect Modules™, Marketic™, Powering Marketing Success™, Drill Anywhere™, Marketing Objects™, Trend Anything™, Customer Value Maximization™, MAP™, One-to-One Optimization™, and Right-time Marketing™ are trademarks of Unica Corporation. All other trademarks are the property of their respective owners.

Portions of the software described in this document are covered by U.S. Patent Numbers: 6,317,752, 6,269,325, 6,542,894, and 6,782,390.

The NetTracker, Affinium Insight, and Affinium NetInsight products are licensed under the following patents and patent publications: US5,675,510, US6,115,680, US6,108,637, US5,796,952, US6,138,155, US6,653,696, US6,763,386, AU0701813, BR9609217, CA2223919, EP0843946, JP03317705, MX193614, NO09705728, AU735285, CA2246746, CN1174316, CN1547123, CN1547124, DK870234, DE69720186, ES2195170, AU727170, BR9808033, CA2284530, CN1251669, IL131871, JP2000514942, KR341110, NZ337756, WO9641495, EP0870234, EP1130526, EP1168196, US20040078292, WO9810349, US20050114511, US20040221033, WO9843380.

Markup functionality in Affinium Plan is enabled through use of third-party software components from AdLib™ eDocument Solutions and Adobe® Acrobat®. "Powered by AdLib™."

NOTICE: This document contains confidential and proprietary information of Unica Corporation ("Unica"). Use, duplication, or disclosure without the express written consent of Unica Corporation is prohibited.