Namespace/Folder | Query Subject | Query Item | Type | Usage | Ref Obj/Expr. |
Common | User | User ID | float64 | identifier | [MarketingOperationsMV].[User].[User ID] |
Last Name | characterLength16 | attribute | [MarketingOperationsMV].[User].[Last Name] |
First Name | characterLength16 | attribute | [MarketingOperationsMV].[User].[First Name] |
Email Address | characterLength16 | attribute | [MarketingOperationsMV].[User].[Email Address] |
User Full Name - First Last | characterLength16 | attribute | [MarketingOperationsMV].[User].[User Full Name - First Last] |
User Full Name - Last, First | characterLength16 | attribute | [MarketingOperationsMV].[User].[User Full Name - Last, First] |
Last Modified Date | dateTime | identifier | [MarketingOperationsMV].[User].[Last Modified Date] |
Login ID | characterLength16 | attribute | [MarketingOperationsMV].[User].[Login ID] |
Status Code | characterLength16 | attribute | [MarketingOperationsMV].[User].[Status Code] |
Status | Status Code | characterLength16 | identifier | [MarketingOperationsMV].[Status].[Status Code] |
Status | characterLength16 | attribute | [MarketingOperationsMV].[Status].[Status] |
Users Roles | user_id | float64 | identifier | [MarketingOperationsMV].[Users Roles].[user_id] |
role_id | float64 | identifier | [MarketingOperationsMV].[Users Roles].[role_id] |
role_name | characterLength16 | attribute | [MarketingOperationsMV].[Users Roles].[role_name] |
Team | Team ID | float64 | identifier | [MarketingOperationsMV].[Team Member].[Team ID] |
Team Name | characterLength16 | attribute | [MarketingOperationsMV].[Team].[Team Name] |
Team Description | characterLength16 | attribute | [MarketingOperationsMV].[Team].[Team Description] |
Team Member ID | float64 | identifier | [MarketingOperationsMV].[User].[User ID] |
Team Member Name - First Last | characterLength16 | attribute | [MarketingOperationsMV].[User].[User Full Name - First Last] |
Team Member Type ID | float64 | identifier | [MarketingOperationsMV].[Member Type].[Member Type ID] |
Team Member Type Name | characterLength16 | attribute | [MarketingOperationsMV].[Member Type].[Member Type Name] |
List Definitions | Vendor | Vendor ID | float64 | identifier | [MarketingOperationsMV].[Vendor].[Vendor ID] |
Vendor Code | characterLength16 | attribute | [MarketingOperationsMV].[Vendor].[Vendor Code] |
Vendor Name | characterLength16 | attribute | [MarketingOperationsMV].[Vendor].[Vendor Name] |
Vendor Display | characterLength16 | attribute | [MarketingOperationsMV].[Vendor].[Vendor Display] |
Cost Category | Cost Category ID | float64 | identifier | [MarketingOperationsMV].[Cost Category].[Cost Category ID] |
Cost Category Code | characterLength16 | attribute | [MarketingOperationsMV].[Cost Category].[Cost Category Code] |
Cost Category Name | characterLength16 | attribute | [MarketingOperationsMV].[Cost Category].[Cost Category Name] |
Cost Category Display | characterLength16 | attribute | [MarketingOperationsMV].[Cost Category].[Cost Category Display] |
Projects | Project | Project ID | float64 | identifier | [MarketingOperationsMV].[Project].[Project ID] |
Project Name | characterLength16 | attribute | [MarketingOperationsMV].[Project].[Project Name] |
Project Code | characterLength16 | attribute | [MarketingOperationsMV].[Project].[Project Code] |
Project Description | characterLength16 | attribute | [MarketingOperationsMV].[Project].[Project Description] |
Project Start Date | dateTime | attribute | [MarketingOperationsMV].[Project].[Project Start Date] |
Project End Date | dateTime | attribute | [MarketingOperationsMV].[Project].[Project End Date] |
Project Actual Start Date | dateTime | identifier | [MarketingOperationsMV].[Project].[Project Actual Start Date] |
Project Actual End Date | dateTime | identifier | [MarketingOperationsMV].[Project].[Project Actual End Date] |
Status | characterLength16 | attribute | [MarketingOperationsMV].[Project Status].[Status] |
Project Name (Code) | characterLength16 | attribute | [MarketingOperationsMV].[Project].[Project Name (Code)] |
Project URL | characterLength16 | attribute | [MarketingOperationsMV].[Project].[Project URL] |
Project Request Flag | characterLength16 | attribute | [MarketingOperationsMV].[Project].[Project Request Flag] |
Template Name | characterLength16 | attribute | [MarketingOperationsMV].[Project].[Template Name] |
Template Display | characterLength16 | attribute | [MarketingOperationsMV].[Project Template].[Template Display] |
Template Instance Display | characterLength16 | attribute | [MarketingOperationsBV].[Project Template].[Template Instance Display] |
Parent Project ID | float64 | identifier | [MarketingOperationsMV].[Project].[Parent Project ID] |
Project Requests | Project ID | float64 | identifier | [MarketingOperationsMV].[Project Requests].[Project ID] |
Project Name | characterLength16 | attribute | [MarketingOperationsMV].[Project Requests].[Project Name] |
Project Code | characterLength16 | attribute | [MarketingOperationsMV].[Project Requests].[Project Code] |
Project Description | characterLength16 | attribute | [MarketingOperationsMV].[Project Requests].[Project Description] |
Project Start Date | dateTime | identifier | [MarketingOperationsMV].[Project Requests].[Project Start Date] |
Project End Date | dateTime | identifier | [MarketingOperationsMV].[Project Requests].[Project End Date] |
Project Actual Start Date | dateTime | identifier | [MarketingOperationsMV].[Project Requests].[Project Actual Start Date] |
Project Actual End Date | dateTime | identifier | [MarketingOperationsMV].[Project Requests].[Project Actual End Date] |
Project Request Status | characterLength16 | attribute | [MarketingOperationsMV].[Project Requests].[Project Request Status] |
Project Request URL | characterLength16 | attribute | [MarketingOperationsMV].[Project Requests].[Project Request URL] |
Project Name (Code) | characterLength16 | attribute | [MarketingOperationsMV].[Project Requests].[Project Name (Code)] |
Project Request Flag | characterLength16 | attribute | [MarketingOperationsMV].[Project Requests].[Project Request Flag] |
Project Request ID | float64 | identifier | [MarketingOperationsMV].[Project Requests].[Project Request ID] |
Request Submit Date | dateTime | identifier | [MarketingOperationsMV].[Project Requests].[Request Submit Date] |
Request Complete Date | dateTime | identifier | [MarketingOperationsMV].[Project Requests].[Request Complete Date] |
Template Name | characterLength16 | attribute | [MarketingOperationsMV].[Project Requests].[Template Name] |
Request Parent Project ID | float64 | identifier | [MarketingOperationsMV].[Project Requests].[Request Parent Project ID] |
Project Owner | Project ID | float64 | identifier | [MarketingOperationsMV].[Project Owner].[Project ID] |
User ID | float64 | identifier | [MarketingOperationsMV].[Project Owner].[User ID] |
User Full Name - First Last | characterLength16 | attribute | [MarketingOperationsMV].[Project User][MarketingOperationsMV].[User].[User Full Name - First Last] |
User Full Name - Last, First | characterLength16 | attribute | [MarketingOperationsMV].[Project User][MarketingOperationsMV].[User].[User Full Name - Last, First] |
Email Address | characterLength16 | attribute | [MarketingOperationsMV].[Project User][MarketingOperationsMV].[User].[Email Address] |
First Name | characterLength16 | attribute | [MarketingOperationsMV].[Project User][MarketingOperationsMV].[User].[First Name] |
Last Name | characterLength16 | attribute | [MarketingOperationsMV].[Project User][MarketingOperationsMV].[User].[Last Name] |
Project Member | Project ID | float64 | identifier | [MarketingOperationsMV].[Project Member].[Project ID] |
User ID | float64 | identifier | [MarketingOperationsMV].[Project Member].[User ID] |
Member Type ID | float64 | identifier | [MarketingOperationsMV].[Project Member].[Member Type ID] |
Project Approval | Project ID | float64 | fact | [MarketingOperationsMV].[Project Approval].[Project ID] |
Approval ID | float64 | identifier | [MarketingOperationsMV].[Project Approval].[Approval ID] |
Approval Name | characterLength16 | attribute | [MarketingOperationsMV].[Project Approval].[Approval Name] |
Approval Description | characterLength16 | attribute | [MarketingOperationsMV].[Project Approval].[Approval Description] |
Workflow Task ID | float64 | fact | [MarketingOperationsMV].[Project Approval].[Workflow Task ID] |
Approval Date | dateTime | attribute | [MarketingOperationsMV].[Project Approval].[Approval Date] |
Task Number Name | characterLength16 | attribute | [MarketingOperationsMV].[Shortcut to Task][MarketingOperationsMV].[Task].[Task Number Name] |
Approval Status Code | characterLength16 | identifier | [MarketingOperationsMV].[Approval Status].[Approval Status Code] |
Approval Status | characterLength16 | attribute | [MarketingOperationsMV].[Approval Status].[Approval Status] |
Approval URL | characterLength16 | attribute | #sq($[Environment]{'URL'})# + 'type=approval&id=' + cast([MarketingOperationsBV].[Project Approval].[Approval ID],varchar(10)) |
Project Template | Template Name | characterLength16 | attribute | [MarketingOperationsMV].[Project Template].[Template Name] |
Template Display | characterLength16 | attribute | [MarketingOperationsMV].[Project Template].[Template Display] |
Template Instance Display | characterLength16 | attribute | [MarketingOperationsMV].[Project Template].[Template Instance Display] |
Project Status | Status Code | characterLength16 | identifier | [MarketingOperationsMV].[Project Status].[Status Code] |
Status | characterLength16 | attribute | [MarketingOperationsMV].[Project Status].[Status] |
Namespace/Folder | Query Subject | Query Item | Type | Usage | Ref Obj/Expr. |
Workflow | Task | Task ID | float64 | identifier | [MarketingOperationsMV].[Task].[Task ID] |
Task Number | characterLength16 | attribute | [MarketingOperationsMV].[Task].[Task Number] |
Task Name | characterLength16 | attribute | [MarketingOperationsMV].[Task].[Task Name] |
% Complete | float64 | attribute | [MarketingOperationsMV].[Task].[% Complete] |
Forecast/Actual Start | dateTime | attribute | [MarketingOperationsMV].[Task].[Forecast/Actual Start] |
Forecast/Actual End | dateTime | attribute | [MarketingOperationsMV].[Task].[Forecast/Actual End] |
Actual Duration | float64 | attribute | [MarketingOperationsMV].[Task].[Actual Duration] |
Actual Duration String | characterLength16 | attribute | [MarketingOperationsMV].[Task].[Actual Duration String] |
Anchor? | characterLength16 | attribute | [MarketingOperationsMV].[Task].[Anchor?] |
Start Date | dateTime | attribute | [MarketingOperationsMV].[Task].[Start Date] |
End Date | dateTime | attribute | [MarketingOperationsMV].[Task].[End Date] |
Duration | float64 | attribute | [MarketingOperationsMV].[Task].[Duration] |
Duration String | characterLength16 | attribute | [MarketingOperationsMV].[Task].[Duration String] |
Notes | characterLength16 | attribute | [MarketingOperationsMV].[Task].[Notes] |
Milestone | characterLength16 | attribute | [MarketingOperationsMV].[Milestone].[Milestone] |
Project ID | float64 | attribute | [MarketingOperationsMV].[Task].[Project ID] |
Status | characterLength16 | attribute | [MarketingOperationsMV].[Task Status].[Status] |
Project Name | characterLength16 | attribute | [MarketingOperationsMV].[Task Parent Project][MarketingOperationsMV].[Project].[Project Name] |
Project Code | characterLength16 | attribute | [MarketingOperationsMV].[Task Parent Project][MarketingOperationsMV].[Project].[Project Code] |
Project URL | characterLength16 | attribute | [MarketingOperationsMV].[Task Parent Project][MarketingOperationsMV].[Project].[Project URL] |
Effort | float64 | fact | [MarketingOperationsMV].[Task].[Effort] |
Effort String | characterLength16 | attribute | [MarketingOperationsMV].[Task].[Effort String] |
Forecast/Actual Effort | float64 | fact | [MarketingOperationsMV].[Task].[Forecast/Actual Effort] |
Forecast/Actual Effort String | characterLength16 | attribute | [MarketingOperationsMV].[Task].[Forecast/Actual Effort String] |
Link Object | characterLength16 | attribute | [MarketingOperationsMV].[Task].[Link Object] |
Task URL | characterLength16 | attribute | [MarketingOperationsMV].[Task].[Task URL] |
Stage | Stage ID | float64 | identifier | [MarketingOperationsMV].[Stage].[Stage ID] |
Stage Number | float64 | attribute | [MarketingOperationsMV].[Stage].[Stage Number] |
Stage Name | characterLength16 | attribute | [MarketingOperationsMV].[Stage].[Stage Name] |
Project ID | float64 | attribute | [MarketingOperationsMV].[Stage].[Project ID] |
Project Name | characterLength16 | attribute | [MarketingOperationsMV].[Stage Parent Project][MarketingOperationsMV].[Project].[Project Name] |
Project Code | characterLength16 | attribute | [MarketingOperationsMV].[Stage Parent Project][MarketingOperationsMV].[Project].[Project Code] |
Task Member | Task ID | float64 | identifier | [MarketingOperationsMV].[Task Member].[Task ID] |
User ID | float64 | identifier | [MarketingOperationsMV].[Task Member].[User ID] |
User Full Name - First Last | characterLength16 | attribute | [MarketingOperationsMV].[Task User][MarketingOperationsMV].[User].[User Full Name - First Last] |
User Full Name - Last, First | characterLength16 | attribute | [MarketingOperationsMV].[Task User][MarketingOperationsMV].[User].[User Full Name - Last, First] |
Email Address | characterLength16 | attribute | [MarketingOperationsMV].[Task User][MarketingOperationsMV].[User].[Email Address] |
Task Status | Status Code | characterLength16 | identifier | [MarketingOperationsMV].[Task Status].[Status Code] |
Status | characterLength16 | attribute | [MarketingOperationsMV].[Task Status].[Status] |
Project Budgets | Project Budget | Budget ID | float64 | identifier | [MarketingOperationsMV].[Project Budget].[Budget ID] |
Project ID | float64 | identifier | [MarketingOperationsMV].[Project Budget].[Project ID] |
Budget Total | float64 | fact | [MarketingOperationsMV].[Project Budget].[Budget Total] |
Forecast Total | float64 | fact | [MarketingOperationsMV].[Project Budget].[Forecast Total] |
Actual Total | float64 | fact | [MarketingOperationsMV].[Project Budget].[Actual Total] |
Committed Total | float64 | fact | [MarketingOperationsMV].[Project Budget].[Committed Total] |
Committed Remaining Amount | float64 | fact | [MarketingOperationsMV].[Project Budget].[Committed Remaining Amount] |
Forecast Remaining Amount | float64 | fact | [MarketingOperationsMV].[Project Budget].[Forecast Remaining Amount] |
Actual Remaining Amount | float64 | fact | [MarketingOperationsMV].[Project Budget].[Actual Remaining Amount] |
Project Budget Amount | Quarter ID | float64 | identifier | [MarketingOperationsMV].[Project Budget Amount][MarketingOperationsMV].[Budget Amount].[Quarter ID] |
Year | float64 | identifier | [MarketingOperationsMV].[Project Budget Amount][MarketingOperationsMV].[Budget Amount].[Year] |
Month | float64 | identifier | [MarketingOperationsMV].[Project Budget Amount][MarketingOperationsMV].[Budget Amount].[Month] |
Budget ID | float64 | identifier | [MarketingOperationsMV].[Project Budget Amount][MarketingOperationsMV].[Budget Amount].[Budget ID] |
Forecast Amount | float64 | fact | [MarketingOperationsMV].[Project Budget Amount][MarketingOperationsMV].[Budget Amount].[Forecast Amount] |
Committed Amount | float64 | fact | [MarketingOperationsMV].[Project Budget Amount][MarketingOperationsMV].[Budget Amount].[Committed Amount] |
Actual Amount | float64 | fact | [MarketingOperationsMV].[Project Budget Amount][MarketingOperationsMV].[Budget Amount].[Actual Amount] |
Budget Amount | float64 | fact | [MarketingOperationsMV].[Project Budget Amount][MarketingOperationsMV].[Budget Amount].[Budget Amount] |
Committed Remaining Amount | float64 | fact | [MarketingOperationsMV].[Project Budget Amount][MarketingOperationsMV].[Budget Amount].[Committed Remaining Amount] |
Forecast Remaining Amount | float64 | fact | [MarketingOperationsMV].[Project Budget Amount][MarketingOperationsMV].[Budget Amount].[Forecast Remaining Amount] |
Actual Remaining Amount | float64 | fact | [MarketingOperationsMV].[Project Budget Amount][MarketingOperationsMV].[Budget Amount].[Actual Remaining Amount] |
Quarter Year | characterLength16 | attribute | [MarketingOperationsMV].[Quarter].[Quarter Year] |
Fiscal Year | characterLength16 | attribute | [MarketingOperationsMV].[Quarter].[Fiscal Year] |
Project Line Item | Project ID | float64 | identifier | [MarketingOperationsMV].[Project Line Item].[Project ID] |
Expenditure Date | dateTime | attribute | [MarketingOperationsMV].[Project Line Item].[Expenditure Date] |
Quarter Year | characterLength16 | attribute | [MarketingOperationsMV].[Quarter for Project Line Item].[Quarter Year] |
Account ID | float64 | attribute | [MarketingOperationsMV].[Project Line Item].[Account ID] |
Account Name (Code) | characterLength16 | attribute | [MarketingOperationsMV].[Account].[Account Name (Code)] |
Cost Category ID | float64 | attribute | [MarketingOperationsMV].[Project Line Item].[Cost Category ID] |
Cost Category Display | characterLength16 | attribute | [MarketingOperationsMV].[Cost Category].[Cost Category Display] |
Committed Amount | float64 | fact | [MarketingOperationsMV].[Project Line Item].[Committed Amount] |
Forecast Amount | float64 | fact | [MarketingOperationsMV].[Project Line Item].[Forecast Amount] |
Item Description | characterLength16 | attribute | [MarketingOperationsMV].[Project Line Item].[Item Description] |
Project Invoice Cost | Project ID | float64 | attribute | [MarketingOperationsMV].[Project Invoice Cost].[Project ID] |
Account ID | float64 | attribute | [MarketingOperationsMV].[Project Invoice Cost].[Account ID] |
Invoice ID | float64 | identifier | [MarketingOperationsMV].[Project Invoice Cost].[Invoice ID] |
Invoice Number | characterLength16 | attribute | [MarketingOperationsMV].[Project Invoice Cost].[Invoice Number] |
Invoice URL | characterLength16 | attribute | [MarketingOperationsMV].[Project Invoice Cost].[Invoice URL] |
Vendor Display | characterLength16 | attribute | [MarketingOperationsMV].[Project Invoice Cost].[Vendor Display] |
Expenditure Date | dateTime | identifier | [MarketingOperationsMV].[Project Invoice Cost].[Expenditure Date] |
Quarter Year | characterLength16 | attribute | [MarketingOperationsMV].[Quarter for Project Invoice Cost].[Quarter Year] |
Cost Item ID | float64 | identifier | [MarketingOperationsMV].[Project Invoice Cost].[Cost Item ID] |
Cost Item Number | float64 | attribute | [MarketingOperationsMV].[Project Invoice Cost].[Cost Item Number] |
Item Description | characterLength16 | attribute | [MarketingOperationsMV].[Project Invoice Cost].[Cost Item Description] |
Cost Category ID | float64 | attribute | [MarketingOperationsMV].[Project Invoice Cost].[Cost Category ID] |
Cost Category Display | characterLength16 | attribute | [MarketingOperationsMV].[Project Invoice Cost].[Cost Category Display] |
Item Cost | float64 | fact | [MarketingOperationsMV].[Project Invoice Cost].[Item Cost] |
Project Metrics | Project Metric Value | Project ID | float64 | identifier | [MarketingOperationsMV].[Project Metric Column Value].[Project ID] |
Metric ID | characterLength16 | identifier | [MarketingOperationsMV].[Project Metric Column Value].[Metric ID] |
Metric Name | characterLength16 | attribute | [MarketingOperationsMV].[Project Metric Column Value].[Metric Name] |
Display Format | characterLength16 | attribute | [MarketingOperationsMV].[Project Metric Column Value].[Display Format] |
Display Order | float64 | fact | [MarketingOperationsMV].[Project Metric Column Value].[Display Order] |
Column Display | characterLength16 | attribute | [MarketingOperationsMV].[Project Metric Column Value].[Column Display] |
Metric Value | float64 | fact | [MarketingOperationsMV].[Project Metric Column Value].[Metric Value] |
Is Target? | characterLength16 | attribute | [MarketingOperationsMV].[Project Metric Column Value].[Is Target?] |
Dimension Type | characterLength16 | attribute | [MarketingOperationsMV].[Project Metric Column Value].[Dimension Type] |
Column Taborder | float64 | identifier | [MarketingOperationsMV].[Project Metric Column Value].[Column Taborder] |
Project Performance Summary Metrics | PROJECT ID | float64 | fact | [MarketingOperationsMV].[Project Performance Summary Metrics].[PROJECT ID] |
DISPLAY FORMAT METRIC1 | characterLength16 | attribute | [MarketingOperationsMV].[Project Performance Summary Metrics].[DISPLAY FORMAT METRIC1] |
ACTUAL VALUE METRIC1 | float64 | fact | [MarketingOperationsMV].[Project Performance Summary Metrics].[ACTUAL VALUE METRIC1] |
TARGET VALUE METRIC1 | float64 | fact | [MarketingOperationsMV].[Project Performance Summary Metrics].[TARGET VALUE METRIC1] |
OPTIMISTIC VALUE METRIC1 | float64 | fact | [MarketingOperationsMV].[Project Performance Summary Metrics].[OPTIMISTIC VALUE METRIC1] |
PESSIMISTIC VALUE METRIC1 | float64 | fact | [MarketingOperationsMV].[Project Performance Summary Metrics].[PESSIMISTIC VALUE METRIC1] |
DISPLAY FORMAT METRIC2 | characterLength16 | attribute | [MarketingOperationsMV].[Project Performance Summary Metrics].[DISPLAY FORMAT METRIC2] |
ACTUAL VALUE METRIC2 | float64 | fact | [MarketingOperationsMV].[Project Performance Summary Metrics].[ACTUAL VALUE METRIC2] |
TARGET VALUE METRIC2 | float64 | fact | [MarketingOperationsMV].[Project Performance Summary Metrics].[TARGET VALUE METRIC2] |
OPTIMISTIC VALUE METRIC2 | float64 | fact | [MarketingOperationsMV].[Project Performance Summary Metrics].[OPTIMISTIC VALUE METRIC2] |
PESSIMISTIC VALUE METRIC2 | float64 | fact | [MarketingOperationsMV].[Project Performance Summary Metrics].[PESSIMISTIC VALUE METRIC2] |
DISPLAY FORMAT METRIC3 | characterLength16 | attribute | [MarketingOperationsMV].[Project Performance Summary Metrics].[DISPLAY FORMAT METRIC3] |
ACTUAL VALUE METRIC3 | float64 | fact | [MarketingOperationsMV].[Project Performance Summary Metrics].[ACTUAL VALUE METRIC3] |
TARGET VALUE METRIC3 | float64 | fact | [MarketingOperationsMV].[Project Performance Summary Metrics].[TARGET VALUE METRIC3] |
OPTIMISTIC VALUE METRIC3 | float64 | fact | [MarketingOperationsMV].[Project Performance Summary Metrics].[OPTIMISTIC VALUE METRIC3] |
PESSIMISTIC VALUE METRIC3 | float64 | fact | [MarketingOperationsMV].[Project Performance Summary Metrics].[PESSIMISTIC VALUE METRIC3] |
DISPLAY FORMAT METRIC4 | characterLength16 | attribute | [MarketingOperationsMV].[Project Performance Summary Metrics].[DISPLAY FORMAT METRIC4] |
ACTUAL VALUE METRIC4 | float64 | fact | [MarketingOperationsMV].[Project Performance Summary Metrics].[ACTUAL VALUE METRIC4] |
TARGET VALUE METRIC4 | float64 | fact | [MarketingOperationsMV].[Project Performance Summary Metrics].[TARGET VALUE METRIC4] |
OPTIMISTIC VALUE METRIC4 | float64 | fact | [MarketingOperationsMV].[Project Performance Summary Metrics].[OPTIMISTIC VALUE METRIC4] |
PESSIMISTIC VALUE METRIC4 | float64 | fact | [MarketingOperationsMV].[Project Performance Summary Metrics].[PESSIMISTIC VALUE METRIC4] |
DISPLAY FORMAT METRIC5 | characterLength16 | attribute | [MarketingOperationsMV].[Project Performance Summary Metrics].[DISPLAY FORMAT METRIC5] |
ACTUAL VALUE METRIC5 | float64 | fact | [MarketingOperationsMV].[Project Performance Summary Metrics].[ACTUAL VALUE METRIC5] |
TARGET VALUE METRIC5 | float64 | fact | [MarketingOperationsMV].[Project Performance Summary Metrics].[TARGET VALUE METRIC5] |
OPTIMISTIC VALUE METRIC5 | float64 | fact | [MarketingOperationsMV].[Project Performance Summary Metrics].[OPTIMISTIC VALUE METRIC5] |
PESSIMISTIC VALUE METRIC5 | float64 | fact | [MarketingOperationsMV].[Project Performance Summary Metrics].[PESSIMISTIC VALUE METRIC5] |
Project Performance Metrics | Project ID | float64 | identifier | [MarketingOperationsMV].[Project Metric].[Project ID] |
Metric ID | characterLength16 | identifier | [MarketingOperationsMV].[Project Metric].[Metric ID] |
Metric Name | characterLength16 | attribute | [MarketingOperationsMV].[Project Metric].[Metric Name] |
Display Order | float64 | fact | [MarketingOperationsMV].[Project Metric].[Display Order] |
Metric Value 1 | float64 | fact | [MarketingOperationsMV].[Project Metric].[Metric Value 1] |
Metric Value 2 | float64 | fact | [MarketingOperationsMV].[Project Metric].[Metric Value 2] |
Metric Value 3 | float64 | fact | [MarketingOperationsMV].[Project Metric].[Metric Value 3] |
Metric Value 4 | float64 | fact | [MarketingOperationsMV].[Project Metric].[Metric Value 4] |
Metric Value 5 | float64 | fact | [MarketingOperationsMV].[Project Metric].[Metric Value 5] |
|
Programs | Program | Program ID | float64 | identifier | [MarketingOperationsMV].[Program].[Program ID] |
Program Name | characterLength16 | attribute | [MarketingOperationsMV].[Program].[Program Name] |
Program Code | characterLength16 | attribute | [MarketingOperationsMV].[Program].[Program Code] |
Program Description | characterLength16 | attribute | [MarketingOperationsMV].[Program].[Program Description] |
Program URL | characterLength16 | attribute | #sq($[Environment]{'URL'})# + 'type=program&id=' + cast(cast([MarketingOperationsBV].[Program].[Program ID],integer),varchar(10)) |
Program Status | characterLength16 | attribute | [MarketingOperationsMV].[Program].[Program Status] |
Program Start Date | dateTime | attribute | [MarketingOperationsMV].[Program].[Program Start Date] |
Program End Date | dateTime | attribute | [MarketingOperationsMV].[Program].[Program End Date] |
Program Name (Code) | characterLength16 | attribute | [MarketingOperationsMV].[Program].[Program Name (Code)] |
Template Name | characterLength16 | attribute | [MarketingOperationsMV].[Program].[Template Name] |
Template Display | characterLength16 | attribute | [MarketingOperationsMV].[Program Template].[Template Display] |
Template Instance Display | characterLength16 | attribute | [MarketingOperationsMV].[Program Template].[Template Instance Display] |
Program Project | Program ID | float64 | identifier | [MarketingOperationsMV].[Program Project Ref].[Program ID] |
Project ID | float64 | identifier | [MarketingOperationsMV].[Program Project Ref].[Project ID] |
Project Name | characterLength16 | attribute | [MarketingOperationsMV].[Program Project][MarketingOperationsMV].[Project].[Project Name] |
Project Code | characterLength16 | attribute | [MarketingOperationsMV].[Program Project][MarketingOperationsMV].[Project].[Project Code] |
Project Description | characterLength16 | attribute | [MarketingOperationsMV].[Program Project][MarketingOperationsMV].[Project].[Project Description] |
Project Start Date | dateTime | identifier | [MarketingOperationsMV].[Program Project][MarketingOperationsMV].[Project].[Project Start Date] |
Project End Date | dateTime | identifier | [MarketingOperationsMV].[Program Project][MarketingOperationsMV].[Project].[Project End Date] |
Project Status | characterLength16 | attribute | [MarketingOperationsMV].[Program Project][MarketingOperationsMV].[Project].[Project Status] |
Project Name (Code) | characterLength16 | attribute | [MarketingOperationsMV].[Program Project][MarketingOperationsMV].[Project].[Project Name (Code)] |
Program Owner | Program ID | float64 | identifier | [MarketingOperationsMV].[Program Owner].[Program ID] |
User ID | float64 | identifier | [MarketingOperationsMV].[Program Owner].[User ID] |
Member Type ID | float64 | identifier | [MarketingOperationsMV].[Program Owner].[Member Type ID] |
Program Member | Program ID | float64 | identifier | [MarketingOperationsMV].[Program Member].[Program ID] |
User ID | float64 | identifier | [MarketingOperationsMV].[Program Member].[User ID] |
Member Type ID | float64 | identifier | [MarketingOperationsMV].[Program Member].[Member Type ID] |
Namespace/Folder | Query Subject | Query Item | Type | Usage | Ref Obj/Expr. |
Program Budgets | Program Budget | Budget ID | float64 | identifier | [MarketingOperationsMV].[Program Budget].[Budget ID] |
Program ID | float64 | identifier | [MarketingOperationsMV].[Program Budget].[Program ID] |
Budget Total | float64 | fact | [MarketingOperationsMV].[Program Budget].[Budget Total] |
Forecast Total | float64 | fact | [MarketingOperationsMV].[Program Budget].[Forecast Total] |
Actual Total | float64 | fact | [MarketingOperationsMV].[Program Budget].[Actual Total] |
Committed Total | float64 | fact | [MarketingOperationsMV].[Program Budget].[Committed Total] |
Allocation Total | float64 | fact | [MarketingOperationsMV].[Program Budget].[Allocation Total] |
Finalized Date | dateTime | attribute | [MarketingOperationsMV].[Program Budget].[Finalized Date] |
Program Budget Amount | Quarter ID | float64 | identifier | [MarketingOperationsMV].[Program Budget Amount][MarketingOperationsMV].[Budget Amount].[Quarter ID] |
Year | float64 | identifier | [MarketingOperationsMV].[Program Budget Amount][MarketingOperationsMV].[Budget Amount].[Year] |
Month | float64 | identifier | [MarketingOperationsMV].[Program Budget Amount][MarketingOperationsMV].[Budget Amount].[Month] |
Budget ID | float64 | identifier | [MarketingOperationsMV].[Program Budget Amount][MarketingOperationsMV].[Budget Amount].[Budget ID] |
Forecast Amount | float64 | fact | [MarketingOperationsMV].[Program Budget Amount][MarketingOperationsMV].[Budget Amount].[Forecast Amount] |
Committed Amount | float64 | fact | [MarketingOperationsMV].[Program Budget Amount][MarketingOperationsMV].[Budget Amount].[Committed Amount] |
Actual Amount | float64 | fact | [MarketingOperationsMV].[Program Budget Amount][MarketingOperationsMV].[Budget Amount].[Actual Amount] |
Budget Amount | float64 | fact | [MarketingOperationsMV].[Program Budget Amount][MarketingOperationsMV].[Budget Amount].[Budget Amount] |
Allocated Amount | float64 | fact | [MarketingOperationsMV].[Program Budget Amount][MarketingOperationsMV].[Budget Amount].[Allocated Amount] |
Committed Remaining Amount | float64 | fact | [MarketingOperationsMV].[Program Budget Amount][MarketingOperationsMV].[Budget Amount].[Committed Remaining Amount] |
Forecast Remaining Amount | float64 | fact | [MarketingOperationsMV].[Program Budget Amount][MarketingOperationsMV].[Budget Amount].[Forecast Remaining Amount] |
Actual Remaining Amount | float64 | fact | [MarketingOperationsMV].[Program Budget Amount][MarketingOperationsMV].[Budget Amount].[Actual Remaining Amount] |
Allocated Remaining Amount | float64 | fact | [MarketingOperationsMV].[Program Budget Amount][MarketingOperationsMV].[Budget Amount].[Allocated Remaining Amount] |
Quarter Year | characterLength16 | attribute | [MarketingOperationsMV].[Quarter].[Quarter Year] |
Fiscal Year | characterLength16 | attribute | [MarketingOperationsMV].[Quarter].[Fiscal Year] |
Program Line Item | Program ID | float64 | identifier | [MarketingOperationsMV].[Program Line Item].[Program ID] |
Expenditure Date | dateTime | attribute | [MarketingOperationsMV].[Program Line Item].[Expenditure Date] |
Quarter Year | characterLength16 | attribute | [MarketingOperationsMV].[Quarter for Program Line Item][MarketingOperationsMV].[Quarter].[Quarter Year] |
Account ID | float64 | attribute | [MarketingOperationsMV].[Program Line Item].[Account ID] |
Account Name (Code) | characterLength16 | attribute | [MarketingOperationsMV].[Account].[Account Name (Code)] |
Cost Category ID | float64 | attribute | [MarketingOperationsMV].[Program Line Item].[Cost Category ID] |
Cost Category Display | characterLength16 | attribute | [MarketingOperationsMV].[Cost Category].[Cost Category Display] |
Committed Amount | float64 | fact | [MarketingOperationsMV].[Program Line Item].[Committed Amount] |
Forecast Amount | float64 | fact | [MarketingOperationsMV].[Program Line Item].[Forecast Amount] |
Program Invoice Cost | Program ID | float64 | identifier | [MarketingOperationsMV].[Program Invoice Cost].[Program ID] |
Invoice ID | float64 | identifier | [MarketingOperationsMV].[Program Invoice Cost].[Invoice ID] |
Invoice Number | characterLength16 | attribute | [MarketingOperationsMV].[Program Invoice Cost].[Invoice Number] |
Quarter Year | characterLength16 | attribute | [MarketingOperationsMV].[Quarter for Program Invoice Cost][MarketingOperationsMV].[Quarter].[Quarter Year] |
Vendor Display | characterLength16 | attribute | [MarketingOperationsMV].[Program Invoice Cost].[Vendor Display] |
Expenditure Date | dateTime | attribute | [MarketingOperationsMV].[Program Invoice Cost].[Expenditure Date] |
Cost Item ID | float64 | identifier | [MarketingOperationsMV].[Program Invoice Cost].[Cost Item ID] |
Cost Item Number | float64 | attribute | [MarketingOperationsMV].[Program Invoice Cost].[Cost Item Number] |
Item Description | characterLength16 | attribute | [MarketingOperationsMV].[Program Invoice Cost].[Item Description] |
Account ID | float64 | attribute | [MarketingOperationsMV].[Program Invoice Cost].[Account ID] |
Account Name (Code) | characterLength16 | attribute | [MarketingOperationsMV].[Program Invoice Cost].[Account Name (Code)] |
Cost Category ID | float64 | attribute | [MarketingOperationsMV].[Program Invoice Cost].[Cost Category ID] |
Cost Category Display | characterLength16 | attribute | [MarketingOperationsMV].[Program Invoice Cost].[Cost Category Display] |
Item Cost | float64 | fact | [MarketingOperationsMV].[Program Invoice Cost].[Item Cost] |
|
Plans | Plan | Plan ID | float64 | fact | [MarketingOperationsMV].[Plan].[Plan ID] |
Plan Code | characterLength16 | attribute | [MarketingOperationsMV].[Plan].[Plan Code] |
Plan Name | characterLength16 | attribute | [MarketingOperationsMV].[Plan].[Plan Name] |
Plan Description | characterLength16 | attribute | [MarketingOperationsMV].[Plan].[Plan Description] |
Plan URL | characterLength16 | attribute | #sq($[Environment]{'URL'})# + 'type=plan&id=' + cast(cast([MarketingOperationsBV].[Plan].[Plan ID] ,integer),varchar(10)) |
Plan Status Code | characterLength16 | attribute | [MarketingOperationsMV].[Plan].[Plan Status Code] |
Plan Fiscal Year | float64 | attribute | [MarketingOperationsMV].[Plan].[Plan Fiscal Year] |
Plan Business Area ID | float64 | attribute | [MarketingOperationsMV].[Plan].[Plan Business Area ID] |
Start Date | dateTime | attribute | [MarketingOperationsMV].[Plan].[Start Date] |
End Date | dateTime | attribute | [MarketingOperationsMV].[Plan].[End Date] |
Plan Name (Code) | characterLength16 | attribute | [MarketingOperationsMV].[Plan].[Plan Name (Code)] |
Plan Program Area | Plan ID | float64 | attribute | [MarketingOperationsMV].[Plan Program Area Ref].[Plan ID] |
Plan Program Area ID | float64 | identifier | [MarketingOperationsMV].[Plan Program Area Ref].[Plan Program Area ID] |
Program Area ID | float64 | attribute | [MarketingOperationsMV].[Plan Program Area Ref].[Program Area ID] |
Display Order | float64 | attribute | [MarketingOperationsMV].[Plan Program Area Ref].[Display Order] |
Program Area Name | characterLength16 | attribute | [MarketingOperationsMV].[Plan Program Area][MarketingOperationsMV].[Program Area].[Program Area Name] |
Plan Program | Plan ID | float64 | identifier | [MarketingOperationsMV].[Plan Program Ref].[Plan ID] |
Plan Program Area ID | float64 | identifier | [MarketingOperationsMV].[Plan Program Ref].[Plan Program Area ID] |
Program ID | float64 | identifier | [MarketingOperationsMV].[Plan Program Ref].[Program ID] |
Program Name | characterLength16 | attribute | [MarketingOperationsMV].[Plan Program][MarketingOperationsMV].[Program].[Program Name] |
Program Code | characterLength16 | attribute | [MarketingOperationsMV].[Plan Program][MarketingOperationsMV].[Program].[Program Code] |
Program Description | characterLength16 | attribute | [MarketingOperationsMV].[Plan Program][MarketingOperationsMV].[Program].[Program Description] |
Program Start Date | dateTime | attribute | [MarketingOperationsMV].[Plan Program][MarketingOperationsMV].[Program].[Program Start Date] |
Program End Date | dateTime | attribute | [MarketingOperationsMV].[Plan Program][MarketingOperationsMV].[Program].[Program End Date] |
Program Status | characterLength16 | attribute | [MarketingOperationsMV].[Plan Program][MarketingOperationsMV].[Program].[Program Status] |
Program Name (Code) | characterLength16 | attribute | [MarketingOperationsMV].[Plan Program][MarketingOperationsMV].[Program].[Program Name (Code)] |
Namespace/Folder | Query Subject | Query Item | Type | Usage | Ref Obj/Expr. |
Plan Budgets | Plan Budget | Budget ID | float64 | identifier | [MarketingOperationsMV].[Plan Budget].[Budget ID] |
Plan ID | float64 | identifier | [MarketingOperationsMV].[Plan Budget].[Plan ID] |
Budget Total | float64 | fact | [MarketingOperationsMV].[Plan Budget].[Budget Total] |
Forecast Total | float64 | fact | [MarketingOperationsMV].[Plan Budget].[Forecast Total] |
Actual Total | float64 | fact | [MarketingOperationsMV].[Plan Budget].[Actual Total] |
Committed Total | float64 | fact | [MarketingOperationsMV].[Plan Budget].[Committed Total] |
Allocated Total | float64 | fact | [MarketingOperationsMV].[Plan Budget].[Allocated Total] |
Finalized Date | dateTime | attribute | [MarketingOperationsMV].[Plan Budget].[Finalized Date] |
Plan Budget Amount | Quarter ID | float64 | identifier | [MarketingOperationsMV].[Plan Budget Amount][MarketingOperationsMV].[Budget Amount].[Quarter ID] |
Year | float64 | identifier | [MarketingOperationsMV].[Plan Budget Amount][MarketingOperationsMV].[Budget Amount].[Year] |
Month | float64 | identifier | [MarketingOperationsMV].[Plan Budget Amount][MarketingOperationsMV].[Budget Amount].[Month] |
Budget ID | float64 | identifier | [MarketingOperationsMV].[Plan Budget Amount][MarketingOperationsMV].[Budget Amount].[Budget ID] |
Forecast Amount | float64 | fact | [MarketingOperationsMV].[Plan Budget Amount][MarketingOperationsMV].[Budget Amount].[Forecast Amount] |
Committed Amount | float64 | fact | [MarketingOperationsMV].[Plan Budget Amount][MarketingOperationsMV].[Budget Amount].[Committed Amount] |
Actual Amount | float64 | fact | [MarketingOperationsMV].[Plan Budget Amount][MarketingOperationsMV].[Budget Amount].[Actual Amount] |
Budget Amount | float64 | fact | [MarketingOperationsMV].[Plan Budget Amount][MarketingOperationsMV].[Budget Amount].[Budget Amount] |
Allocated Amount | float64 | fact | [MarketingOperationsMV].[Plan Budget Amount][MarketingOperationsMV].[Budget Amount].[Allocated Amount] |
Committed Remaining Amount | float64 | fact | [MarketingOperationsMV].[Plan Budget Amount][MarketingOperationsMV].[Budget Amount].[Committed Remaining Amount] |
Forecast Remaining Amount | float64 | fact | [MarketingOperationsMV].[Plan Budget Amount][MarketingOperationsMV].[Budget Amount].[Forecast Remaining Amount] |
Actual Remaining Amount | float64 | fact | [MarketingOperationsMV].[Plan Budget Amount][MarketingOperationsMV].[Budget Amount].[Actual Remaining Amount] |
Allocated Remaining Amount | float64 | fact | [MarketingOperationsMV].[Plan Budget Amount][MarketingOperationsMV].[Budget Amount].[Allocated Remaining Amount] |
Quarter Year | characterLength16 | attribute | [MarketingOperationsMV].[Quarter].[Quarter Year] |
Fiscal Year | characterLength16 | attribute | [MarketingOperationsMV].[Quarter].[Fiscal Year] |
Program Area Budget | Budget ID | float64 | identifier | [MarketingOperationsMV].[Program Area Budget].[Budget ID] |
Plan Program Area ID | float64 | identifier | [MarketingOperationsMV].[Program Area Budget].[Plan Program Area ID] |
Budget Total | float64 | fact | [MarketingOperationsMV].[Program Area Budget].[Budget Total] |
Forecast Total | float64 | fact | [MarketingOperationsMV].[Program Area Budget].[Forecast Total] |
Actual Total | float64 | fact | [MarketingOperationsMV].[Program Area Budget].[Actual Total] |
Committed Total | float64 | fact | [MarketingOperationsMV].[Program Area Budget].[Committed Total] |
Finalized Date | dateTime | attribute | [MarketingOperationsMV].[Program Area Budget].[Finalized Date] |
Program Area Budget Amount | Quarter ID | float64 | identifier | [MarketingOperationsMV].[Program Area Budget Amount][MarketingOperationsMV].[Budget Amount].[Quarter ID] |
Year | float64 | identifier | [MarketingOperationsMV].[Program Area Budget Amount][MarketingOperationsMV].[Budget Amount].[Year] |
Month | float64 | identifier | [MarketingOperationsMV].[Program Area Budget Amount][MarketingOperationsMV].[Budget Amount].[Month] |
Budget ID | float64 | identifier | [MarketingOperationsMV].[Program Area Budget Amount][MarketingOperationsMV].[Budget Amount].[Budget ID] |
Forecast Amount | float64 | fact | [MarketingOperationsMV].[Program Area Budget Amount][MarketingOperationsMV].[Budget Amount].[Forecast Amount] |
Committed Amount | float64 | fact | [MarketingOperationsMV].[Program Area Budget Amount][MarketingOperationsMV].[Budget Amount].[Committed Amount] |
Actual Amount | float64 | fact | [MarketingOperationsMV].[Program Area Budget Amount][MarketingOperationsMV].[Budget Amount].[Actual Amount] |
Budget Amount | float64 | fact | [MarketingOperationsMV].[Program Area Budget Amount][MarketingOperationsMV].[Budget Amount].[Budget Amount] |
Allocated Amount | float64 | fact | [MarketingOperationsMV].[Program Area Budget Amount][MarketingOperationsMV].[Budget Amount].[Allocated Amount] |
Committed Remaining Amount | float64 | fact | [MarketingOperationsMV].[Program Area Budget Amount][MarketingOperationsMV].[Budget Amount].[Committed Remaining Amount] |
Forecast Remaining Amount | float64 | fact | [MarketingOperationsMV].[Program Area Budget Amount][MarketingOperationsMV].[Budget Amount].[Forecast Remaining Amount] |
Actual Remaining Amount | float64 | fact | [MarketingOperationsMV].[Program Area Budget Amount][MarketingOperationsMV].[Budget Amount].[Actual Remaining Amount] |
Allocated Remaining Amount | float64 | fact | [MarketingOperationsMV].[Program Area Budget Amount][MarketingOperationsMV].[Budget Amount].[Allocated Remaining Amount] |
Quarter Year | characterLength16 | attribute | [MarketingOperationsMV].[Quarter].[Quarter Year] |
|
Accounts | Account | Account ID | float64 | identifier | [MarketingOperationsMV].[Account].[Account ID] |
Account Name | characterLength16 | attribute | [MarketingOperationsMV].[Account].[Account Name] |
Account Code | characterLength16 | attribute | [MarketingOperationsMV].[Account].[Account Code] |
Account Name (Code) | characterLength16 | attribute | [MarketingOperationsMV].[Account].[Account Name (Code)] |
Account Description | characterLength16 | attribute | [MarketingOperationsMV].[Account].[Account Description] |
Account URL | characterLength16 | attribute | #sq($[Environment]{'URL'})# + 'type=account&id=' + cast(cast([MarketingOperationsBV].[Account].[Account ID],integer),varchar(10)) |
Parent Account Name (Code) | characterLength16 | attribute | [MarketingOperationsMV].[Parent Account][MarketingOperationsMV].[Account].[Account Name (Code)] |
Parent Account ID | float64 | attribute | [MarketingOperationsMV].[Account].[Parent Account ID] |
Account Budget Amount | Parent Account ID | float64 | attribute | [MarketingOperationsMV].[Account].[Parent Account ID] |
Account ID | float64 | identifier | [MarketingOperationsMV].[Account Budget].[Account ID] |
Quarter ID | float64 | identifier | [MarketingOperationsMV].[Account Budget Amount][MarketingOperationsMV].[Budget Amount].[Quarter ID] |
Year | float64 | identifier | [MarketingOperationsMV].[Account Budget Amount][MarketingOperationsMV].[Budget Amount].[Year] |
Month | float64 | identifier | [MarketingOperationsMV].[Account Budget Amount][MarketingOperationsMV].[Budget Amount].[Month] |
Budget ID | float64 | identifier | [MarketingOperationsMV].[Account Budget Amount][MarketingOperationsMV].[Budget Amount].[Budget ID] |
Forecast Amount | float64 | fact | [MarketingOperationsMV].[Account Budget Amount][MarketingOperationsMV].[Budget Amount].[Forecast Amount] |
Committed Amount | float64 | fact | [MarketingOperationsMV].[Account Budget Amount][MarketingOperationsMV].[Budget Amount].[Committed Amount] |
Actual Amount | float64 | fact | [MarketingOperationsMV].[Account Budget Amount][MarketingOperationsMV].[Budget Amount].[Actual Amount] |
Budget Amount | float64 | fact | [MarketingOperationsMV].[Account Budget Amount][MarketingOperationsMV].[Budget Amount].[Budget Amount] |
Allocated Amount | float64 | fact | [MarketingOperationsMV].[Account Budget Amount][MarketingOperationsMV].[Budget Amount].[Allocated Amount] |
Committed Remaining Amount | float64 | fact | [MarketingOperationsMV].[Account Budget Amount][MarketingOperationsMV].[Budget Amount].[Committed Remaining Amount] |
Forecast Remaining Amount | float64 | fact | [MarketingOperationsMV].[Account Budget Amount][MarketingOperationsMV].[Budget Amount].[Forecast Remaining Amount] |
Actual Remaining Amount | float64 | fact | [MarketingOperationsMV].[Account Budget Amount][MarketingOperationsMV].[Budget Amount].[Actual Remaining Amount] |
Allocated Remaining Amount | float64 | fact | [MarketingOperationsMV].[Account Budget Amount][MarketingOperationsMV].[Budget Amount].[Allocated Remaining Amount] |
Sub-Account Budget Amount | Account ID | float64 | identifier | [MarketingOperationsMV].[Sub-Account Budget Amount].[Account ID] |
Quarter_ID | float64 | identifier | [MarketingOperationsMV].[Sub-Account Budget Amount].[Quarter_ID] |
Year1 | float64 | identifier | [MarketingOperationsMV].[Sub-Account Budget Amount].[Year1] |
Month1 | float64 | identifier | [MarketingOperationsMV].[Sub-Account Budget Amount].[Month1] |
Budget_Amount | float64 | fact | [MarketingOperationsMV].[Sub-Account Budget Amount].[Budget_Amount] |
Forecast_Amount | float64 | fact | [MarketingOperationsMV].[Sub-Account Budget Amount].[Forecast_Amount] |
Committed_Amount | float64 | fact | [MarketingOperationsMV].[Sub-Account Budget Amount].[Committed_Amount] |
Actual_Amount | float64 | fact | [MarketingOperationsMV].[Sub-Account Budget Amount].[Actual_Amount] |
Quarter Year | characterLength16 | attribute | [MarketingOperationsMV].[Quarter].[Quarter Year] |
Parent Account | Account ID | float64 | identifier | [MarketingOperationsMV].[Parent Account][MarketingOperationsMV].[Account].[Account ID] |
Account Code | characterLength16 | attribute | [MarketingOperationsMV].[Parent Account][MarketingOperationsMV].[Account].[Account Code] |
Account Description | characterLength16 | attribute | [MarketingOperationsMV].[Parent Account][MarketingOperationsMV].[Account].[Account Description] |
Parent Account ID | float64 | attribute | [MarketingOperationsMV].[Parent Account][MarketingOperationsMV].[Account].[Parent Account ID] |
Account Name | characterLength16 | attribute | [MarketingOperationsMV].[Parent Account][MarketingOperationsMV].[Account].[Account Name] |
Account Name (Code) | characterLength16 | attribute | [MarketingOperationsMV].[Parent Account][MarketingOperationsMV].[Account].[Account Name (Code)] |
Approvals | Approval | Approval ID | float64 | identifier | [MarketingOperationsMV].[Approval].[Approval ID] |
Approval Name | characterLength16 | attribute | [MarketingOperationsMV].[Approval].[Approval Name] |
Approval Description | characterLength16 | attribute | [MarketingOperationsMV].[Approval].[Approval Description] |
Approval URL | characterLength16 | attribute | #sq($[Environment]{'URL'})# + 'type=approval&id=' + cast(cast([MarketingOperationsBV].[Approval].[Approval ID],integer),varchar(10)) |
Approval Status | characterLength16 | attribute | [MarketingOperationsMV].[Approval Status].[Approval Status] |
Approval Date | dateTime | attribute | [MarketingOperationsMV].[Approval].[Approval Date] |
Source Object ID | float64 | identifier | [MarketingOperationsMV].[Approval].[Source Object ID] |
Source Object Type | characterLength16 | attribute | [MarketingOperationsMV].[Approval].[Source Object Type] |
Source Workflow Task ID | float64 | identifier | [MarketingOperationsMV].[Approval].[Source Workflow Task ID] |
Approval Item | Approval ID | float64 | identifier | [MarketingOperationsMV].[Approval Item].[Approval ID] |
Approval Item Order | float64 | attribute | [MarketingOperationsMV].[Approval Item].[Approval Item Order] |
Approval Item Name | characterLength16 | attribute | [MarketingOperationsMV].[Approval Item].[Approval Item Name] |
Approver | Approval ID | float64 | identifier | [MarketingOperationsMV].[Approver].[Approval ID] |
Approver Order | float64 | attribute | [MarketingOperationsMV].[Approver].[Approver Order] |
User ID | float64 | identifier | [MarketingOperationsMV].[Approver].[User ID] |
Is Required? | characterLength16 | attribute | [MarketingOperationsMV].[Approver].[Is Required?] |
Response Date | dateTime | attribute | [MarketingOperationsMV].[Approver].[Response Date] |
User Full Name - First Last | characterLength16 | attribute | [MarketingOperationsMV].[Approver User][MarketingOperationsMV].[User].[User Full Name - First Last] |
User Full Name - Last, First | characterLength16 | attribute | [MarketingOperationsMV].[Approver User][MarketingOperationsMV].[User].[User Full Name - Last, First] |
Approver Status | characterLength16 | attribute | [MarketingOperationsMV].[Approver].[Approver Status] |
Budgets | Budget Amount | Quarter ID | float64 | identifier | [MarketingOperationsMV].[Budget Amount].[Quarter ID] |
Year | float64 | identifier | [MarketingOperationsMV].[Budget Amount].[Year] |
Month | float64 | identifier | [MarketingOperationsMV].[Budget Amount].[Month] |
Budget ID | float64 | identifier | [MarketingOperationsMV].[Budget Amount].[Budget ID] |
Forecast Amount | float64 | fact | [MarketingOperationsMV].[Budget Amount].[Forecast Amount] |
Committed Amount | float64 | fact | [MarketingOperationsMV].[Budget Amount].[Committed Amount] |
Actual Amount | float64 | fact | [MarketingOperationsMV].[Budget Amount].[Actual Amount] |
Budget Amount | float64 | fact | [MarketingOperationsMV].[Budget Amount].[Budget Amount] |
Allocated Amount | float64 | fact | [MarketingOperationsMV].[Budget Amount].[Allocated Amount] |
Committed Remaining Amount | float64 | fact | [MarketingOperationsMV].[Budget Amount].[Committed Remaining Amount] |
Forecast Remaining Amount | float64 | fact | [MarketingOperationsMV].[Budget Amount].[Forecast Remaining Amount] |
Actual Remaining Amount | float64 | fact | [MarketingOperationsMV].[Budget Amount].[Actual Remaining Amount] |
Allocated Remaining Amount | float64 | fact | [MarketingOperationsMV].[Budget Amount].[Allocated Remaining Amount] |
Quarter Description | characterLength16 | attribute | [MarketingOperationsMV].[Quarter].[Quarter Description] |
Quarter Year | characterLength16 | attribute | [MarketingOperationsMV].[Quarter].[Quarter Year] |
Month Year | characterLength16 | attribute | [MarketingOperationsMV].[Quarter].[Month Year] |
Invoices | Invoice | Invoice ID | float64 | identifier | [MarketingOperationsMV].[Invoice].[Invoice ID] |
Invoice Number | characterLength16 | attribute | [MarketingOperationsMV].[Invoice].[Invoice Number] |
Vendor Display | characterLength16 | attribute | [MarketingOperationsMV].[Vendor].[Vendor Display] |
PO Number | characterLength16 | attribute | [MarketingOperationsMV].[Invoice].[PO Number] |
Due Date | dateTime | identifier | [MarketingOperationsMV].[Invoice].[Due Date] |
State Code | characterLength16 | attribute | [MarketingOperationsMV].[Invoice].[State Code] |
Invoice Date | dateTime | identifier | [MarketingOperationsMV].[Invoice].[Invoice Date] |
Invoice URL | characterLength16 | attribute | [MarketingOperationsMV].[Invoice].[Invoice URL] |
Notes | characterLength16 | attribute | [MarketingOperationsMV].[Invoice].[Notes] |
Payment Terms | characterLength16 | attribute | [MarketingOperationsMV].[Invoice].[Payment Terms] |
Invoice Amount | float64 | fact | [MarketingOperationsMV].[Invoice].[Invoice Amount] |
Invoice Code | characterLength16 | attribute | [MarketingOperationsMV].[Invoice].[Invoice Code] |
Payable Date | dateTime | attribute | [MarketingOperationsMV].[Invoice].[Payable Date] |
Paid Date | dateTime | attribute | [MarketingOperationsMV].[Invoice].[Paid Date] |
Invoice Line Item | Invoice ID | float64 | identifier | [MarketingOperationsMV].[Invoice Line Item].[Invoice ID] |
Cost Item ID | float64 | identifier | [MarketingOperationsMV].[Invoice Line Item].[Cost Item ID] |
Cost Item Number | float64 | attribute | [MarketingOperationsMV].[Invoice Line Item].[Cost Item Number] |
Item Description | characterLength16 | attribute | [MarketingOperationsMV].[Invoice Line Item].[Item Description] |
Source Object Type | characterLength16 | attribute | [MarketingOperationsMV].[Invoice Line Item].[Source Object Type] |
Source Object ID | float64 | attribute | [MarketingOperationsMV].[Invoice Line Item].[Source Object ID] |
Source Object Code | characterLength16 | attribute | [MarketingOperationsMV].[Invoice Line Item].[Source Object Code] |
Account ID | float64 | attribute | [MarketingOperationsMV].[Invoice Line Item].[Account ID] |
Account Code | characterLength16 | attribute | [MarketingOperationsMV].[Invoice Line Item].[Account Code] |
Cost Category ID | float64 | attribute | [MarketingOperationsMV].[Invoice Line Item].[Cost Category ID] |
Cost Category Code | characterLength16 | attribute | [MarketingOperationsMV].[Invoice Line Item].[Cost Category Code] |
Quantity | float64 | fact | [MarketingOperationsMV].[Invoice Line Item].[Quantity] |
Unit Cost | float64 | fact | [MarketingOperationsMV].[Invoice Line Item].[Unit Cost] |
Item Cost | float64 | fact | [MarketingOperationsMV].[Invoice Line Item].[Item Cost] |
Custom Attributes | Project Custom Attributes | Project ID | float64 | identifier | [MarketingOperationsMV].[Project Custom Attributes].[Project ID] |
Initiative | characterLength16 | attribute | [MarketingOperationsMV].[Initiative].[Initiative] |
Channel Name | characterLength16 | attribute | [MarketingOperationsMV].[Channel].[CHANNEL_NAME] |
Business Unit | characterLength16 | attribute | [MarketingOperationsMV].[Business Unit].[Business Unit] |
Product Family | characterLength16 | attribute | [MarketingOperationsMV].[Product Family].[Product Family] |
Segment | characterLength16 | attribute | [MarketingOperationsMV].[Segment].[Segment] |
Budget Period | characterLength16 | attribute | [MarketingOperationsMV].[Budget Period].[budget_period_name] |
Project Performance Summary Custom Metrics | Project ID | float64 | fact | [MarketingOperationsMV].[Project Performance Summary Custom Metrics].[Project ID] |
Total Revenue | float64 | fact | [MarketingOperationsMV].[Project Performance Summary Custom Metrics].[Total Revenue] |
ResponseRateActual | float64 | fact | [MarketingOperationsMV].[Project Performance Summary Custom Metrics].[ResponseRateActual] |
ResponseRateTarget | float64 | fact | [MarketingOperationsMV].[Project Performance Summary Custom Metrics].[ResponseRateTarget] |
Total Leads Generated (Actual) | float64 | fact | [MarketingOperationsMV].[Project Performance Summary Custom Metrics].[Total Leads Generated (Actual)] |
Total Leads Generated (Target) | float64 | fact | [MarketingOperationsMV].[Project Performance Summary Custom Metrics].[Total Leads Generated (Target)] |
Total Cost Passed | float64 | fact | [MarketingOperationsMV].[Project Performance Summary Custom Metrics].[Total Cost Passed] |
Program Performance Metrics | program_id | float64 | identifier | [MarketingOperationsMV].[Program Metric].[program_id] |
metric_id | characterLength16 | identifier | [MarketingOperationsMV].[Program Metric].[metric_id] |
display_name | characterLength16 | attribute | [MarketingOperationsMV].[Program Metric].[display_name] |
display_order | float64 | fact | [MarketingOperationsMV].[Program Metric].[display_order] |
metric_value1 | float64 | fact | [MarketingOperationsMV].[Program Metric].[metric_value1] |
metric_value2 | float64 | fact | [MarketingOperationsMV].[Program Metric].[metric_value2] |
metric_value3 | float64 | fact | [MarketingOperationsMV].[Program Metric].[metric_value3] |
metric_value4 | float64 | fact | [MarketingOperationsMV].[Program Metric].[metric_value4] |
metric_value5 | float64 | fact | [MarketingOperationsMV].[Program Metric].[metric_value5] |
Namespace/Folder | Query Subject | Query Item | Type | Usage | Ref Obj/Expr. |
Projects and Requests Over Time
 | Requests Over Time | | (shortcut) | | [MarketingOperationsMV].[Requests Over Time] |
Projects Over Time | | (shortcut) | | [MarketingOperationsMV].[Projects Over Time] |
Projects Quarter | | (shortcut) | | [MarketingOperationsMV].[Projects Quarter] |
|
Namespace/Folder | Query Subject | Query Item | Type | Usage | Ref Obj/Expr. |
Common | User | User ID | float64 | fact | [MarketingOperationsDS].[uap_user].[USER_ID] |
Last Name | characterLength16 | attribute | IF ([MarketingOperationsDS].[uap_user].[LAST_NAME] is missing)
THEN ('')
ELSE ([MarketingOperationsDS].[uap_user].[LAST_NAME]) |
First Name | characterLength16 | attribute | IF ([MarketingOperationsDS].[uap_user].[FIRST_NAME] is missing)
THEN ('')
ELSE ([MarketingOperationsDS].[uap_user].[FIRST_NAME]) |
Email Address | characterLength16 | attribute | [MarketingOperationsDS].[uap_user].[EMAIL_ID] |
User Full Name - First Last | characterLength16 | attribute | IF ([MarketingOperationsMV].[User].[First Name] ='')
THEN ([MarketingOperationsMV].[User].[Last Name])
ELSE ([MarketingOperationsMV].[User].[First Name] + ' ' + [MarketingOperationsMV].[User].[Last Name]) |
User Full Name - Last, First | characterLength16 | attribute | IF ([MarketingOperationsMV].[User].[Last Name] ='')
THEN ([MarketingOperationsMV].[User].[First Name])
ELSE ([MarketingOperationsMV].[User].[Last Name] + ', ' + [MarketingOperationsMV].[User].[First Name]) |
Last Modified Date | dateTime | identifier | [MarketingOperationsDS].[uap_user].[LAST_MOD_DATE] |
Login ID | characterLength16 | attribute | [MarketingOperationsDS].[uap_user].[LOGIN_ID] |
Status Code | characterLength16 | attribute | [MarketingOperationsDS].[uap_user].[STATUS_CODE] |
Member Type | Member Type ID | float64 | identifier | [MarketingOperationsDS].[uap_member_type].[mem_type_id] |
Member Type Name | characterLength16 | attribute | [MarketingOperationsDS].[uap_member_type].[mem_name] |
Status | Status Code | characterLength16 | identifier | [MarketingOperationsDS].[uap_status].[STATUS_CODE] |
Status | characterLength16 | attribute | [MarketingOperationsDS].[uap_status].[STATUS_DESC] |
Template | Template ID | float64 | identifier | [MarketingOperationsDS].[UAP_TT_TEMPLATES].[TEMPLATE_ID] |
Object Type | float64 | attribute | [MarketingOperationsDS].[UAP_TT_TEMPLATES].[OBJECT_TYPE] |
Template Name | characterLength16 | attribute | [MarketingOperationsDS].[UAP_TT_TEMPLATES].[TEMPLATE_NAME] |
Template Display | characterLength16 | attribute | [MarketingOperationsDS].[UAP_TT_TEMPLATES].[ACTUAL_DISPLAY] |
Template Instance Display | characterLength16 | attribute | [MarketingOperationsDS].[UAP_TT_TEMPLATES].[DISPLAY] |
User Roles | role_id | float64 | identifier | [MarketingOperationsDS].[uap_user_roles].[ROLE_ID] |
sec_policy_id | float64 | identifier | [MarketingOperationsDS].[uap_user_roles].[SEC_POLICY_ID] |
user_id | float64 | identifier | [MarketingOperationsDS].[uap_user_roles].[USER_ID] |
Roles | role_id | float64 | identifier | [MarketingOperationsDS].[uap_roles].[ROLE_ID] |
role_name | characterLength16 | attribute | [MarketingOperationsDS].[uap_roles].[ROLE_NAME] |
role_desc | characterLength16 | attribute | [MarketingOperationsDS].[uap_roles].[ROLE_DESC] |
sec_policy_id | float64 | fact | [MarketingOperationsDS].[uap_roles].[SEC_POLICY_ID] |
Users Roles | user_id | float64 | identifier | [MarketingOperationsMV].[User Roles].[user_id] |
role_id | float64 | identifier | [MarketingOperationsMV].[User Roles].[role_id] |
role_name | characterLength16 | attribute | [MarketingOperationsMV].[Roles].[role_name] |
Team | Team ID | float64 | identifier | [MarketingOperationsDS].[UAP_TEAMS].[TEAM_ID] |
Team Name | characterLength16 | attribute | [MarketingOperationsDS].[UAP_TEAMS].[NAME] |
Team Description | characterLength16 | attribute | [MarketingOperationsDS].[UAP_TEAMS].[DESCRIPTION] |
Team Skillsets | characterLength16 | attribute | [MarketingOperationsDS].[UAP_TEAMS].[SKILLSETS] |
Team Status ID | float64 | identifier | [MarketingOperationsDS].[UAP_TEAMS].[STATUS] |
Team Member | Team ID | float64 | identifier | [MarketingOperationsDS].[UAP_TEAM_MEMBERS].[TEAM_ID] |
Team Member ID | float64 | identifier | [MarketingOperationsDS].[UAP_TEAM_MEMBERS].[USER_ID] |
Team Member Type ID | float64 | identifier | [MarketingOperationsDS].[UAP_TEAM_MEMBERS].[MEM_TYPE_ID] |
List Definitions | Vendor | Vendor ID | float64 | identifier | [MarketingOperationsDS].[uap_ml_vendor].[VENDOR_ID] |
Vendor Code | characterLength16 | attribute | [MarketingOperationsDS].[uap_ml_vendor].[CODE] |
Vendor Name | characterLength16 | attribute | [MarketingOperationsDS].[uap_ml_vendor].[NAME] |
Vendor Display | characterLength16 | attribute | [MarketingOperationsDS].[uap_ml_vendor].[DISPLAY] |
Program Area | Program Area ID | float64 | identifier | [MarketingOperationsDS].[uap_prgm_area].[PRGM_AREA_ID] |
Program Area Name | characterLength16 | attribute | [MarketingOperationsDS].[uap_prgm_area].[NAME] |
Cost Category | Cost Category ID | float64 | identifier | [MarketingOperationsDS].[uap_ml_cost_cat].[COST_CAT_ID] |
Cost Category Code | characterLength16 | attribute | [MarketingOperationsDS].[uap_ml_cost_cat].[CODE] |
Cost Category Name | characterLength16 | attribute | [MarketingOperationsDS].[uap_ml_cost_cat].[NAME] |
Cost Category Display | characterLength16 | attribute | [MarketingOperationsDS].[uap_ml_cost_cat].[DISPLAY] |
Projects | Project User | | (shortcut) | | [MarketingOperationsMV].[User] |
Shortcut to Task | | (shortcut) | | [MarketingOperationsMV].[Task] |
Projects | Project | Project ID | float64 | identifier | [MarketingOperationsDS].[uap_projects].[PROJECT_ID] |
Project Name | characterLength16 | attribute | [MarketingOperationsDS].[uap_projects].[NAME] |
Project Code | characterLength16 | attribute | [MarketingOperationsDS].[uap_projects].[PROJ_CODE] |
Project Description | characterLength16 | attribute | [MarketingOperationsDS].[uap_projects].[DESCRIPTION] |
Project Start Date | dateTime | identifier | [MarketingOperationsDS].[uap_projects].[START_DATE] |
Project End Date | dateTime | identifier | [MarketingOperationsDS].[uap_projects].[END_DATE] |
Project Actual Start Date | dateTime | identifier | [MarketingOperationsDS].[uap_projects].[ACTUAL_ST_DATE] |
Project Actual End Date | dateTime | identifier | [MarketingOperationsDS].[uap_projects].[ACTUAL_END_DATE] |
Project Status | characterLength16 | attribute | [MarketingOperationsDS].[uap_projects].[STATE_CODE] |
Project URL | characterLength16 | attribute | #sq($[Environment]{'URL'})# + 'type=project&id=' + cast(cast([MarketingOperationsMV].[Project].[Project ID], integer), varchar(10)) |
Project Name (Code) | characterLength16 | attribute | [MarketingOperationsMV].[Project].[Project Name] + ' (' + [MarketingOperationsMV].[Project].[Project Code] + ')' |
Project Request Flag | characterLength16 | attribute | [MarketingOperationsDS].[uap_projects].[FLAG_PROJ_REQUEST] |
Template Name | characterLength16 | attribute | [MarketingOperationsDS].[uap_projects].[TEMPLATE_NAME] |
Parent Project ID | float64 | identifier | [MarketingOperationsDS].[uap_projects].[PARENT_PROJ_ID] |
Project Requests | Project ID | float64 | identifier | [MarketingOperationsDS].[uap_projects].[PROJECT_ID] |
Project Name | characterLength16 | attribute | [MarketingOperationsDS].[uap_projects].[NAME] |
Project Code | characterLength16 | attribute | [MarketingOperationsDS].[uap_projects].[PROJ_CODE] |
Project Description | characterLength16 | attribute | [MarketingOperationsDS].[uap_projects].[DESCRIPTION] |
Project Start Date | dateTime | identifier | [MarketingOperationsDS].[uap_projects].[START_DATE] |
Project End Date | dateTime | identifier | [MarketingOperationsDS].[uap_projects].[END_DATE] |
Project Actual Start Date | dateTime | identifier | [MarketingOperationsDS].[uap_projects].[ACTUAL_ST_DATE] |
Project Actual End Date | dateTime | identifier | [MarketingOperationsDS].[uap_projects].[ACTUAL_END_DATE] |
Project Request Status | characterLength16 | attribute | [MarketingOperationsDS].[uap_projects].[STATE_CODE] |
Project Request URL | characterLength16 | attribute | #sq($[Environment]{'URL'})# + 'type=projectrequest&id=' + cast(cast([MarketingOperationsMV].[Project Requests].[Project ID], integer), varchar(10)) |
Project Name (Code) | characterLength16 | attribute | [MarketingOperationsMV].[Project Requests].[Project Name] + ' (' + [MarketingOperationsMV].[Project Requests].[Project Code] + ')' |
Project Request Flag | characterLength16 | attribute | [MarketingOperationsDS].[uap_projects].[FLAG_PROJ_REQUEST] |
Project Request ID | float64 | identifier | [MarketingOperationsDS].[uap_projects].[PROJ_REQUEST_ID] |
Request Submit Date | dateTime | identifier | [MarketingOperationsDS].[uap_projects].[REQ_SUBMIT_DATE] |
Request Complete Date | dateTime | identifier | [MarketingOperationsDS].[uap_projects].[REQ_COMP_DATE] |
Template Name | characterLength16 | attribute | [MarketingOperationsDS].[uap_projects].[TEMPLATE_NAME] |
Request Parent Project ID | float64 | identifier | [MarketingOperationsDS].[uap_projects].[PARENT_PROJ_ID] |
Project Owner | Project ID | float64 | identifier | [MarketingOperationsDS].[uap_proj_users].[PROJECT_ID] |
User ID | float64 | identifier | [MarketingOperationsDS].[uap_proj_users].[USER_ID] |
Member Type ID | float64 | identifier | [MarketingOperationsDS].[uap_proj_users].[MEM_TYPE_ID] |
Project Member | Project ID | float64 | identifier | [MarketingOperationsDS].[uap_proj_users].[PROJECT_ID] |
User ID | float64 | identifier | [MarketingOperationsDS].[uap_proj_users].[USER_ID] |
Member Type ID | float64 | identifier | [MarketingOperationsDS].[uap_proj_users].[MEM_TYPE_ID] |
Project Status | Status Code | characterLength16 | identifier | [MarketingOperationsDS].[uap_status].[STATUS_CODE] |
Status | characterLength16 | attribute | [MarketingOperationsDS].[uap_status].[STATUS_DESC] |
Project Approval | Approval ID | float64 | identifier | [MarketingOperationsDS].[UAP_APPROVALS].[APPROVAL_ID] |
Approval Name | characterLength16 | attribute | [MarketingOperationsDS].[UAP_APPROVALS].[NAME] |
Approval Description | characterLength16 | attribute | [MarketingOperationsDS].[UAP_APPROVALS].[DESCRIPTION] |
Approval Status Code | characterLength16 | attribute | [MarketingOperationsDS].[UAP_APPROVALS].[STATE_CODE] |
Approval Date | dateTime | attribute | [MarketingOperationsDS].[UAP_APPROVALS].[APPROVAL_DATE] |
Project ID | float64 | attribute | [MarketingOperationsDS].[UAP_APPROVALS].[SRC_OBJECT_ID] |
Workflow Task ID | float64 | attribute | [MarketingOperationsDS].[UAP_APPROVALS].[SRC_WF_STEP] |
Project Template | Template ID | float64 | identifier | [MarketingOperationsMV].[Template].[Template ID] |
Object Type | float64 | attribute | [MarketingOperationsMV].[Template].[Object Type] |
Template Name | characterLength16 | attribute | [MarketingOperationsMV].[Template].[Template Name] |
Template Display | characterLength16 | attribute | [MarketingOperationsMV].[Template].[Template Display] |
Template Instance Display | characterLength16 | attribute | [MarketingOperationsMV].[Template].[Template Instance Display] |
Namespace/Folder | Query Subject | Query Item | Type | Usage | Ref Obj/Expr. |
Workflow
 | Task Parent Project | | (shortcut) | | [MarketingOperationsMV].[Project] |
Stage Parent Project | | (shortcut) | | [MarketingOperationsMV].[Project] |
Task User | | (shortcut) | | [MarketingOperationsMV].[User] |
Workflow | Task Status | Status Code | characterLength16 | identifier | [MarketingOperationsDS].[uap_status].[STATUS_CODE] |
Status | characterLength16 | attribute | [MarketingOperationsDS].[uap_status].[STATUS_DESC] |
Milestone | Milestone Type ID | float64 | identifier | [MarketingOperationsDS].[uap_wf_milestone].[MILESTONE_TYPE] |
Milestone | characterLength16 | attribute | [MarketingOperationsDS].[uap_wf_milestone].[MILESTONE_DESC] |
Task | Task ID | float64 | identifier | [MarketingOperationsDS].[uap_workflow].[WF_NO] |
Task Number | characterLength16 | attribute | [MarketingOperationsDS].[uap_workflow].[DISPLAY_ID] |
Task Name | characterLength16 | attribute | [MarketingOperationsDS].[uap_workflow].[NAME] |
Status | characterLength16 | attribute | IF([MarketingOperationsDS].[uap_workflow].[STATUS_CODE]='' or [MarketingOperationsDS].[uap_workflow].[STATUS_CODE] is null)
THEN ('PENDING')
ELSE([MarketingOperationsDS].[uap_workflow].[STATUS_CODE]) |
% Complete | float64 | attribute | [MarketingOperationsDS].[uap_workflow].[PCNT_COMP] |
Forecast/Actual Start | dateTime | attribute | [MarketingOperationsDS].[uap_workflow].[FORECAST_ST] |
Forecast/Actual End | dateTime | attribute | [MarketingOperationsDS].[uap_workflow].[FORECAST_END] |
Duration | float64 | attribute | [MarketingOperationsDS].[uap_workflow].[DURATION] |
Duration String | characterLength16 | attribute | [MarketingOperationsDS].[uap_workflow].[DURATION_STR] |
Actual Duration | float64 | attribute | [MarketingOperationsDS].[uap_workflow].[ACTUAL_DURATION] |
Actual Duration String | characterLength16 | attribute | [MarketingOperationsDS].[uap_workflow].[ACTUAL_DURATION_STR] |
Anchor? | characterLength16 | attribute | [MarketingOperationsDS].[uap_workflow].[FLAG_ANCHOR] |
Start Date | dateTime | attribute | [MarketingOperationsDS].[uap_workflow].[START_DATE] |
End Date | dateTime | attribute | [MarketingOperationsDS].[uap_workflow].[END_DATE] |
Milestone Type ID | float64 | attribute | [MarketingOperationsDS].[uap_workflow].[MILESTONE_TYPE] |
Notes | characterLength16 | attribute | [MarketingOperationsDS].[uap_workflow].[NOTES] |
Project ID | float64 | attribute | [MarketingOperationsDS].[uap_workflow].[PROJECT_ID] |
Parent Stage ID | float64 | attribute | [MarketingOperationsDS].[uap_workflow].[PARENT_STAGE] |
Link? | characterLength16 | attribute | [MarketingOperationsDS].[uap_workflow].[FLAG_LINK] |
Link ID | float64 | attribute | [MarketingOperationsDS].[uap_workflow].[LINK_ID] |
Link Object | characterLength16 | attribute | [MarketingOperationsDS].[uap_workflow].[LINK_OBJECT] |
Task Number Name | characterLength16 | attribute | [MarketingOperationsMV].[Task].[Task Number] + ' ' + [MarketingOperationsMV].[Task].[Task Name] |
Effort | float64 | fact | [MarketingOperationsDS].[uap_workflow].[EFFORT] |
Effort String | characterLength16 | attribute | [MarketingOperationsDS].[uap_workflow].[EFFORT_STR] |
Forecast/Actual Effort | float64 | fact | [MarketingOperationsDS].[uap_workflow].[ACTUAL_EFFORT] |
Forecast/Actual Effort String | characterLength16 | attribute | [MarketingOperationsDS].[uap_workflow].[ACTUAL_EFFORT_STR] |
Task URL | characterLength16 | attribute | #sq($[Environment]{'URL'})# + 'type=task&id=' + cast(cast([MarketingOperationsMV].[Task].[Task ID] ,integer),varchar(10)) |
Stage | Stage ID | float64 | identifier | [MarketingOperationsDS].[uap_workflow].[WF_NO] |
Stage Number | float64 | attribute | [MarketingOperationsDS].[uap_workflow].[DISPLAY_ORDER] |
Stage Name | characterLength16 | attribute | [MarketingOperationsDS].[uap_workflow].[NAME] |
Project ID | float64 | attribute | [MarketingOperationsDS].[uap_workflow].[PROJECT_ID] |
Task Member | Task ID | float64 | identifier | [MarketingOperationsDS].[uap_wf_users].[WF_NO] |
User ID | float64 | identifier | [MarketingOperationsDS].[uap_wf_users].[USER_ID] |
Project Budgets
 | Project Budget Reference | | (shortcut) | | [MarketingOperationsMV].[Budget] |
Project Budget Amount | | (shortcut) | | [MarketingOperationsMV].[Budget Amount] |
Project Budgets | Project Budget | Budget ID | float64 | identifier | [MarketingOperationsDS].[uap_proj_budget].[BUDGET_ID] |
Project ID | float64 | identifier | [MarketingOperationsDS].[uap_proj_budget].[PROJECT_ID] |
Budget Total | float64 | fact | [MarketingOperationsDS].[uap_proj_budget].[BUDGET_TOTAL] |
Forecast Total | float64 | fact | [MarketingOperationsDS].[uap_proj_budget].[FORECAST_TOTAL] |
Actual Total | float64 | fact | [MarketingOperationsDS].[uap_proj_budget].[ACTUAL_TOTAL] |
Committed Total | float64 | fact | [MarketingOperationsDS].[uap_proj_budget].[COMMITTED_TOTAL] |
Committed Remaining Amount | float64 | fact | [MarketingOperationsMV].[Project Budget].[Budget Total] - [MarketingOperationsMV].[Project Budget].[Committed Total] |
Forecast Remaining Amount | float64 | fact | [MarketingOperationsMV].[Project Budget].[Budget Total] - [MarketingOperationsMV].[Project Budget].[Forecast Total] |
Actual Remaining Amount | float64 | fact | [MarketingOperationsMV].[Project Budget].[Budget Total] - [MarketingOperationsMV].[Project Budget].[Actual Total] |
Project Line Item | Project ID | float64 | identifier | [MarketingOperationsDS].[uap_proj_cost].[PROJECT_ID] |
Cost Item ID | float64 | identifier | [MarketingOperationsDS].[uap_proj_cost].[COST_ITEM_ID] |
Version ID | float64 | attribute | [MarketingOperationsDS].[uap_proj_cost].[VERSION_ID] |
Cost Item Number | float64 | attribute | [MarketingOperationsDS].[uap_proj_cost].[COST_ITEM_NO] |
Account ID | float64 | attribute | [MarketingOperationsDS].[uap_proj_cost].[ACCOUNT_ID] |
Account Code | characterLength16 | attribute | [MarketingOperationsDS].[uap_proj_cost].[ACCOUNT_CODE] |
Forecast Amount | float64 | fact | [MarketingOperationsDS].[uap_proj_cost].[FORECAST_AMT] |
Committed Amount | float64 | fact | [MarketingOperationsDS].[uap_proj_cost].[COMMITTED_AMT] |
Expenditure Date | dateTime | attribute | [MarketingOperationsDS].[uap_proj_cost].[EXPENDITURE_DATE] |
Cost Category ID | float64 | attribute | [MarketingOperationsDS].[uap_proj_cost].[COST_CAT_ID] |
Cost Category Code | characterLength16 | attribute | [MarketingOperationsDS].[uap_proj_cost].[COST_CAT_CODE] |
Item Description | characterLength16 | attribute | [MarketingOperationsDS].[uap_proj_cost].[COST_ITEM_DESC] |
Project Invoice Line Item | Invoice ID | float64 | identifier | [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[INVOICE_ID] |
Cost Item ID | float64 | identifier | [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[COST_ITEM_ID] |
Cost Item Number | float64 | attribute | [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[COST_ITEM_NO] |
Cost Item Description | characterLength16 | attribute | [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[COST_ITEM_DESC] |
Source Object Type | characterLength16 | attribute | [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[SRC_OBJ_TYPE] |
Source Object ID | float64 | attribute | [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[SRC_OBJ_ID] |
Source Object Code | characterLength16 | attribute | [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[SRC_OBJ_CODE] |
Account ID | float64 | attribute | [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[ACCOUNT_ID] |
Account Code | characterLength16 | attribute | [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[ACCOUNT_CODE] |
Cost Category ID | float64 | attribute | [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[COST_CAT_ID] |
Cost Category Code | characterLength16 | attribute | [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[COST_CAT_CODE] |
Quantity | float64 | fact | [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[QUANTITY] |
Unit Cost | float64 | fact | [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[UNIT_COST] |
Item Cost | float64 | fact | [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[ITEM_COST] |
Project Invoice Cost | Project ID | float64 | attribute | [MarketingOperationsMV].[Project Invoice Line Item].[Source Object ID] |
Invoice ID | float64 | identifier | [MarketingOperationsMV].[Project Invoice Line Item].[Invoice ID] |
Invoice Number | characterLength16 | attribute | [MarketingOperationsMV].[Invoice].[Invoice Number] |
Invoice URL | characterLength16 | attribute | [MarketingOperationsMV].[Invoice].[Invoice URL] |
Vendor Display | characterLength16 | attribute | [MarketingOperationsMV].[Vendor].[Vendor Display] |
Expenditure Date | dateTime | identifier | if ([MarketingOperationsMV].[Invoice].[Paid Date] = null) THEN ([MarketingOperationsMV].[Invoice].[Due Date]) ELSE ([MarketingOperationsMV].[Invoice].[Paid Date] ) |
Cost Item ID | float64 | identifier | [MarketingOperationsMV].[Project Invoice Line Item].[Cost Item ID] |
Cost Item Number | float64 | attribute | [MarketingOperationsMV].[Project Invoice Line Item].[Cost Item Number] |
Cost Item Description | characterLength16 | attribute | [MarketingOperationsMV].[Project Invoice Line Item].[Cost Item Description] |
Account ID | float64 | attribute | [MarketingOperationsMV].[Project Invoice Line Item].[Account ID] |
Cost Category ID | float64 | attribute | [MarketingOperationsMV].[Project Invoice Line Item].[Cost Category ID] |
Cost Category Display | characterLength16 | attribute | [MarketingOperationsMV].[Cost Category].[Cost Category Display] |
Item Cost | float64 | fact | [MarketingOperationsMV].[Project Invoice Line Item].[Item Cost] |
Quarter for Project Line Item | Quarter ID | float64 | identifier | [MarketingOperationsDS].[uap_quarters].[QUARTER_ID] |
Year | float64 | identifier | [MarketingOperationsDS].[uap_quarters].[YEAR] |
Month | float64 | identifier | [MarketingOperationsDS].[uap_quarters].[MONTH] |
Quarter Description | characterLength16 | attribute | [MarketingOperationsDS].[uap_quarters].[DESCRIPTION] |
Quarter Year | characterLength16 | attribute | substring ([MarketingOperationsMV].[Quarter for Project Line Item].[Quarter Description] , position ( '(' , [MarketingOperationsMV].[Quarter for Project Line Item].[Quarter Description] ) + 1, 7) |
Month Year | characterLength16 | attribute | substring ( [MarketingOperationsMV].[Quarter for Project Line Item].[Quarter Description], 0, position('(', [MarketingOperationsMV].[Quarter for Project Line Item].[Quarter Description]) - 1) |
Quarter for Project Invoice Cost | Quarter ID | float64 | identifier | [MarketingOperationsDS].[uap_quarters].[QUARTER_ID] |
Year | float64 | identifier | [MarketingOperationsDS].[uap_quarters].[YEAR] |
Month | float64 | identifier | [MarketingOperationsDS].[uap_quarters].[MONTH] |
Quarter Description | characterLength16 | attribute | [MarketingOperationsDS].[uap_quarters].[DESCRIPTION] |
Quarter Year | characterLength16 | attribute | substring ([MarketingOperationsMV].[Quarter for Project Invoice Cost].[Quarter Description] , position ( '(' , [MarketingOperationsMV].[Quarter for Project Invoice Cost].[Quarter Description] ) + 1, 7) |
Month Year | characterLength16 | attribute | substring ( [MarketingOperationsMV].[Quarter for Project Invoice Cost].[Quarter Description], 0, position('(', [MarketingOperationsMV].[Quarter for Project Invoice Cost].[Quarter Description]) - 1) |
Project Metrics | Project Metric | Metric ID | characterLength16 | identifier | [MarketingOperationsDS].[uap_proj_metrics].[METRIC_ID] |
Metric Name | characterLength16 | attribute | [MarketingOperationsDS].[uap_proj_metrics].[DISPLAY_NAME] |
Display Order | float64 | fact | [MarketingOperationsDS].[uap_proj_metrics].[DISPLAY_ORDER] |
Units | characterLength16 | attribute | [MarketingOperationsDS].[uap_proj_metrics].[UNITS] |
Input Method | characterLength16 | attribute | [MarketingOperationsDS].[uap_proj_metrics].[INPUT_METHOD] |
Display Format | characterLength16 | attribute | [MarketingOperationsDS].[uap_proj_metrics].[DISPLAY_FORMAT] |
Metric Value 1 | float64 | fact | [MarketingOperationsDS].[uap_proj_metrics].[METRIC_VALUE1] |
Metric Value 3 | float64 | fact | [MarketingOperationsDS].[uap_proj_metrics].[METRIC_VALUE3] |
Metric Value 2 | float64 | fact | [MarketingOperationsDS].[uap_proj_metrics].[METRIC_VALUE2] |
Metric Description | characterLength16 | attribute | [MarketingOperationsDS].[uap_proj_metrics].[DESCRIPTION] |
Formula | characterLength16 | attribute | [MarketingOperationsDS].[uap_proj_metrics].[FORMULA] |
Metric Value 4 | float64 | fact | [MarketingOperationsDS].[uap_proj_metrics].[METRIC_VALUE4] |
Metric Precision | float64 | fact | [MarketingOperationsDS].[uap_proj_metrics].[METRIC_PRECISION] |
Metric Value 5 | float64 | fact | [MarketingOperationsDS].[uap_proj_metrics].[METRIC_VALUE5] |
Metric Columns | float64 | fact | [MarketingOperationsDS].[uap_proj_metrics].[METRIC_COLUMNS] |
Project ID | float64 | identifier | [MarketingOperationsDS].[uap_proj_metrics].[PROJECT_ID] |
Metric Group ID | characterLength16 | attribute | [MarketingOperationsDS].[uap_proj_metrics].[GRP_ID] |
Metric NaN 1 | characterLength16 | attribute | [MarketingOperationsDS].[uap_proj_metrics].[METRIC1_NAN] |
Metric NaN 2 | characterLength16 | attribute | [MarketingOperationsDS].[uap_proj_metrics].[METRIC2_NAN] |
Metric NaN 3 | characterLength16 | attribute | [MarketingOperationsDS].[uap_proj_metrics].[METRIC3_NAN] |
Metric NaN 4 | characterLength16 | attribute | [MarketingOperationsDS].[uap_proj_metrics].[METRIC4_NAN] |
Metric NaN 5 | characterLength16 | attribute | [MarketingOperationsDS].[uap_proj_metrics].[METRIC5_NAN] |
Planned Value | float64 | fact | [MarketingOperationsDS].[uap_proj_metrics].[PLANNED_VALUE] |
Planed NaN | characterLength16 | attribute | [MarketingOperationsDS].[uap_proj_metrics].[PLANNED_NAN] |
Is Planned Value? | characterLength16 | attribute | [MarketingOperationsDS].[uap_proj_metrics].[IS_PLANNED_VALUE] |
Show as Rollup? | characterLength16 | attribute | [MarketingOperationsDS].[uap_proj_metrics].[SHOW_AS_ROLLUP] |
Is Visible? | characterLength16 | attribute | [MarketingOperationsDS].[uap_proj_metrics].[IS_VISIBLE] |
Project Metrics New | Project ID | float64 | identifier | [MarketingOperationsMV].[Project Metric].[Project ID] |
Metric ID | characterLength16 | identifier | [MarketingOperationsMV].[Project Metric].[Metric ID] |
Metric Name | characterLength16 | attribute | [MarketingOperationsMV].[Project Metric].[Metric Name] |
Display Order | float64 | fact | [MarketingOperationsMV].[Project Metric].[Display Order] |
Display Format | characterLength16 | attribute | [MarketingOperationsMV].[Project Metric].[Display Format] |
Project Metric Column | Project ID | float64 | identifier | [MarketingOperationsDS].[uap_metric_cols].[PROJECT_ID] |
Column Taborder | float64 | identifier | [MarketingOperationsDS].[uap_metric_cols].[COL_TABORDER] |
Column Display | characterLength16 | attribute | [MarketingOperationsDS].[uap_metric_cols].[COL_DISPLAY] |
Is Target? | characterLength16 | attribute | [MarketingOperationsDS].[uap_metric_cols].[FLAG_TARGET] |
Dimension Type | characterLength16 | attribute | [MarketingOperationsDS].[uap_metric_cols].[DIMENSION_TYPE] |
Project Metric Column Value | Project ID | float64 | identifier | [MarketingOperationsMV].[Project Metric].[Project ID] |
Metric ID | characterLength16 | identifier | [MarketingOperationsMV].[Project Metric].[Metric ID] |
Metric Name | characterLength16 | attribute | [MarketingOperationsMV].[Project Metric].[Metric Name] |
Display Format | characterLength16 | attribute | [MarketingOperationsMV].[Project Metrics New].[Display Format] |
Display Order | float64 | fact | [MarketingOperationsMV].[Project Metrics New].[Display Order] |
Column Display | characterLength16 | attribute | [MarketingOperationsMV].[Project Metric Column].[Column Display] |
Metric Value | float64 | fact | if ([MarketingOperationsMV].[Project Metric Column].[Column Taborder] = 0) then ([MarketingOperationsMV].[Project Metric].[Metric Value 1] )
else if ([MarketingOperationsMV].[Project Metric Column].[Column Taborder] = 1) then ([MarketingOperationsMV].[Project Metric].[Metric Value 3] )
else if ([MarketingOperationsMV].[Project Metric Column].[Column Taborder] = 2) then ([MarketingOperationsMV].[Project Metric].[Metric Value 2] )
else if ([MarketingOperationsMV].[Project Metric Column].[Column Taborder] = 3) then ([MarketingOperationsMV].[Project Metric].[Metric Value 4] )
else ([MarketingOperationsMV].[Project Metric].[Metric Value 5] ) |
Is Target? | characterLength16 | attribute | [MarketingOperationsMV].[Project Metric Column].[Is Target?] |
Dimension Type | characterLength16 | attribute | [MarketingOperationsMV].[Project Metric Column].[Dimension Type] |
Column Taborder | float64 | identifier | [MarketingOperationsMV].[Project Metric Column].[Column Taborder] |
Project Performance Summary Metrics | PROJECT ID | float64 | fact | |
DISPLAY FORMAT METRIC1 | characterLength16 | attribute | |
ACTUAL VALUE METRIC1 | float64 | fact | |
TARGET VALUE METRIC1 | float64 | fact | |
OPTIMISTIC VALUE METRIC1 | float64 | fact | |
PESSIMISTIC VALUE METRIC1 | float64 | fact | |
DISPLAY FORMAT METRIC2 | characterLength16 | attribute | |
ACTUAL VALUE METRIC2 | float64 | fact | |
TARGET VALUE METRIC2 | float64 | fact | |
OPTIMISTIC VALUE METRIC2 | float64 | fact | |
PESSIMISTIC VALUE METRIC2 | float64 | fact | |
DISPLAY FORMAT METRIC3 | characterLength16 | attribute | |
ACTUAL VALUE METRIC3 | float64 | fact | |
TARGET VALUE METRIC3 | float64 | fact | |
OPTIMISTIC VALUE METRIC3 | float64 | fact | |
PESSIMISTIC VALUE METRIC3 | float64 | fact | |
DISPLAY FORMAT METRIC4 | characterLength16 | attribute | |
ACTUAL VALUE METRIC4 | float64 | fact | |
TARGET VALUE METRIC4 | float64 | fact | |
OPTIMISTIC VALUE METRIC4 | float64 | fact | |
PESSIMISTIC VALUE METRIC4 | float64 | fact | |
DISPLAY FORMAT METRIC5 | characterLength16 | attribute | |
ACTUAL VALUE METRIC5 | float64 | fact | |
TARGET VALUE METRIC5 | float64 | fact | |
OPTIMISTIC VALUE METRIC5 | float64 | fact | |
PESSIMISTIC VALUE METRIC5 | float64 | fact | |
|
Programs | Program Project | | (shortcut) | | [MarketingOperationsMV].[Project] |
Program User | | (shortcut) | | [MarketingOperationsMV].[User] |
Programs | Program | Program ID | float64 | identifier | [MarketingOperationsDS].[uap_programs].[PROGRAM_ID] |
Program Name | characterLength16 | attribute | [MarketingOperationsDS].[uap_programs].[NAME] |
Program Code | characterLength16 | attribute | [MarketingOperationsDS].[uap_programs].[PROGRAM_CODE] |
Program Description | characterLength16 | attribute | [MarketingOperationsDS].[uap_programs].[DESCRIPTION] |
Program Start Date | dateTime | attribute | [MarketingOperationsDS].[uap_programs].[START_DATE] |
Program End Date | dateTime | attribute | [MarketingOperationsDS].[uap_programs].[END_DATE] |
Program Status | characterLength16 | attribute | [MarketingOperationsDS].[uap_programs].[STATE_CODE] |
Program Name (Code) | characterLength16 | attribute | [MarketingOperationsMV].[Program].[Program Name] + ' (' + [MarketingOperationsMV].[Program].[Program Code] + ')' |
Template Name | characterLength16 | attribute | [MarketingOperationsDS].[uap_programs].[TEMPLATE_NAME] |
Program Project Ref | Project ID | float64 | identifier | [MarketingOperationsDS].[uap_prgrm_project].[PROJECT_ID] |
Program ID | float64 | identifier | [MarketingOperationsDS].[uap_prgrm_project].[PROGRAM_ID] |
Program Owner | Program ID | float64 | identifier | [MarketingOperationsDS].[uap_prgrm_users].[PROGRAM_ID] |
User ID | float64 | identifier | [MarketingOperationsDS].[uap_prgrm_users].[USER_ID] |
Member Type ID | float64 | identifier | [MarketingOperationsDS].[uap_prgrm_users].[MEM_TYPE_ID] |
Program Member | Program ID | float64 | identifier | [MarketingOperationsDS].[uap_prgrm_users].[PROGRAM_ID] |
User ID | float64 | identifier | [MarketingOperationsDS].[uap_prgrm_users].[USER_ID] |
Member Type ID | float64 | identifier | [MarketingOperationsDS].[uap_prgrm_users].[MEM_TYPE_ID] |
Program Template | Template ID | float64 | identifier | [MarketingOperationsMV].[Template].[Template ID] |
Object Type | float64 | attribute | [MarketingOperationsMV].[Template].[Object Type] |
Template Name | characterLength16 | attribute | [MarketingOperationsMV].[Template].[Template Name] |
Template Display | characterLength16 | attribute | [MarketingOperationsMV].[Template].[Template Display] |
Template Instance Display | characterLength16 | attribute | [MarketingOperationsMV].[Template].[Template Instance Display] |
Namespace/Folder | Query Subject | Query Item | Type | Usage | Ref Obj/Expr. |
Program Budgets
 | Program Budget Reference | | (shortcut) | | [MarketingOperationsMV].[Budget] |
Program Budget Amount | | (shortcut) | | [MarketingOperationsMV].[Budget Amount] |
Quarter for Program Invoice Cost | | (shortcut) | | [MarketingOperationsMV].[Quarter] |
Quarter for Program Line Item | | (shortcut) | | [MarketingOperationsMV].[Quarter] |
Program Budgets | Program Budget | Budget ID | float64 | identifier | [MarketingOperationsDS].[uap_prgrm_budget].[BUDGET_ID] |
Program ID | float64 | identifier | [MarketingOperationsDS].[uap_prgrm_budget].[PROGRAM_ID] |
Budget Total | float64 | fact | [MarketingOperationsDS].[uap_prgrm_budget].[BUDGET_TOTAL] |
Forecast Total | float64 | fact | [MarketingOperationsDS].[uap_prgrm_budget].[FORECAST_TOTAL] |
Actual Total | float64 | fact | [MarketingOperationsDS].[uap_prgrm_budget].[ACTUAL_TOTAL] |
Committed Total | float64 | fact | [MarketingOperationsDS].[uap_prgrm_budget].[COMMITTED_TOTAL] |
Allocation Total | float64 | fact | [MarketingOperationsDS].[uap_prgrm_budget].[ALLOC_TOTAL] |
Finalized Date | dateTime | attribute | [MarketingOperationsDS].[uap_prgrm_budget].[FINALIZED_DATE] |
Program Invoice Line Item | Invoice ID | float64 | identifier | [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[INVOICE_ID] |
Cost Item ID | float64 | identifier | [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[COST_ITEM_ID] |
Cost Item Number | float64 | attribute | [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[COST_ITEM_NO] |
Item Description | characterLength16 | attribute | [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[COST_ITEM_DESC] |
Source Object Type | characterLength16 | attribute | [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[SRC_OBJ_TYPE] |
Source Object ID | float64 | attribute | [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[SRC_OBJ_ID] |
Source Object Code | characterLength16 | attribute | [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[SRC_OBJ_CODE] |
Account ID | float64 | attribute | [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[ACCOUNT_ID] |
Account Code | characterLength16 | attribute | [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[ACCOUNT_CODE] |
Cost Category ID | float64 | attribute | [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[COST_CAT_ID] |
Cost Category Code | characterLength16 | attribute | [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[COST_CAT_CODE] |
Quantity | float64 | fact | [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[QUANTITY] |
Unit Cost | float64 | fact | [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[UNIT_COST] |
Item Cost | float64 | fact | [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[ITEM_COST] |
Program Invoice Cost | Program ID | float64 | identifier | [MarketingOperationsMV].[Program].[Program ID] |
Invoice ID | float64 | identifier | [MarketingOperationsMV].[Program Invoice Line Item].[Invoice ID] |
Invoice Number | characterLength16 | attribute | [MarketingOperationsMV].[Invoice].[Invoice Number] |
Vendor Display | characterLength16 | attribute | [MarketingOperationsMV].[Vendor].[Vendor Display] |
Expenditure Date | dateTime | attribute | [MarketingOperationsMV].[Invoice].[Paid Date] |
Cost Item ID | float64 | identifier | [MarketingOperationsMV].[Program Invoice Line Item].[Cost Item ID] |
Cost Item Number | float64 | attribute | [MarketingOperationsMV].[Program Invoice Line Item].[Cost Item Number] |
Item Description | characterLength16 | attribute | [MarketingOperationsMV].[Program Invoice Line Item].[Item Description] |
Account ID | float64 | attribute | [MarketingOperationsMV].[Program Invoice Line Item].[Account ID] |
Account Name (Code) | characterLength16 | attribute | [MarketingOperationsMV].[Account].[Account Name (Code)] |
Cost Category ID | float64 | attribute | [MarketingOperationsMV].[Program Invoice Line Item].[Cost Category ID] |
Cost Category Display | characterLength16 | attribute | [MarketingOperationsMV].[Cost Category].[Cost Category Display] |
Item Cost | float64 | fact | [MarketingOperationsMV].[Program Invoice Line Item].[Item Cost] |
Program Line Item | Program ID | float64 | identifier | [MarketingOperationsDS].[uap_prgrm_cost].[PROGRAM_ID] |
Cost Item ID | float64 | identifier | [MarketingOperationsDS].[uap_prgrm_cost].[COST_ITEM_ID] |
Version ID | float64 | attribute | [MarketingOperationsDS].[uap_prgrm_cost].[VERSION_ID] |
Cost Item Number | float64 | attribute | [MarketingOperationsDS].[uap_prgrm_cost].[COST_ITEM_NO] |
Cost Item Description | characterLength16 | attribute | [MarketingOperationsDS].[uap_prgrm_cost].[COST_ITEM_DESC] |
Account ID | float64 | attribute | [MarketingOperationsDS].[uap_prgrm_cost].[ACCOUNT_ID] |
Account Code | characterLength16 | attribute | [MarketingOperationsDS].[uap_prgrm_cost].[ACCOUNT_CODE] |
Forecast Amount | float64 | fact | [MarketingOperationsDS].[uap_prgrm_cost].[FORECAST_AMT] |
Committed Amount | float64 | fact | [MarketingOperationsDS].[uap_prgrm_cost].[COMMITTED_AMT] |
Expenditure Date | dateTime | attribute | [MarketingOperationsDS].[uap_prgrm_cost].[EXPENDITURE_DATE] |
Cost Category ID | float64 | attribute | [MarketingOperationsDS].[uap_prgrm_cost].[COST_CAT_ID] |
Cost Category Code | characterLength16 | attribute | [MarketingOperationsDS].[uap_prgrm_cost].[COST_CAT_CODE] |
Program Metrics | Program Metric | program_id | float64 | identifier | [MarketingOperationsDS].[uap_prgrm_metrics].[PROGRAM_ID] |
metric_id | characterLength16 | identifier | [MarketingOperationsDS].[uap_prgrm_metrics].[METRIC_ID] |
show_as_rollup | characterLength16 | identifier | [MarketingOperationsDS].[uap_prgrm_metrics].[SHOW_AS_ROLLUP] |
display_name | characterLength16 | attribute | [MarketingOperationsDS].[uap_prgrm_metrics].[DISPLAY_NAME] |
display_order | float64 | fact | [MarketingOperationsDS].[uap_prgrm_metrics].[DISPLAY_ORDER] |
input_method | characterLength16 | attribute | [MarketingOperationsDS].[uap_prgrm_metrics].[INPUT_METHOD] |
formula | characterLength16 | attribute | [MarketingOperationsDS].[uap_prgrm_metrics].[FORMULA] |
units | characterLength16 | attribute | [MarketingOperationsDS].[uap_prgrm_metrics].[UNITS] |
display_format | characterLength16 | attribute | [MarketingOperationsDS].[uap_prgrm_metrics].[DISPLAY_FORMAT] |
metric_precision | float64 | fact | [MarketingOperationsDS].[uap_prgrm_metrics].[METRIC_PRECISION] |
description | characterLength16 | attribute | [MarketingOperationsDS].[uap_prgrm_metrics].[DESCRIPTION] |
metric_columns | float64 | fact | [MarketingOperationsDS].[uap_prgrm_metrics].[METRIC_COLUMNS] |
metric_value1 | float64 | fact | [MarketingOperationsDS].[uap_prgrm_metrics].[METRIC_VALUE1] |
metric_value2 | float64 | fact | [MarketingOperationsDS].[uap_prgrm_metrics].[METRIC_VALUE2] |
metric_value3 | float64 | fact | [MarketingOperationsDS].[uap_prgrm_metrics].[METRIC_VALUE3] |
metric_value4 | float64 | fact | [MarketingOperationsDS].[uap_prgrm_metrics].[METRIC_VALUE4] |
metric_value5 | float64 | fact | [MarketingOperationsDS].[uap_prgrm_metrics].[METRIC_VALUE5] |
metric_rollup1 | float64 | fact | [MarketingOperationsDS].[uap_prgrm_metrics].[METRIC_ROLLUP1] |
metric_rollup2 | float64 | fact | [MarketingOperationsDS].[uap_prgrm_metrics].[METRIC_ROLLUP2] |
metric_rollup3 | float64 | fact | [MarketingOperationsDS].[uap_prgrm_metrics].[METRIC_ROLLUP3] |
metric_rollup4 | float64 | fact | [MarketingOperationsDS].[uap_prgrm_metrics].[METRIC_ROLLUP4] |
metric_rollup5 | float64 | fact | [MarketingOperationsDS].[uap_prgrm_metrics].[METRIC_ROLLUP5] |
metric1_nan | characterLength16 | attribute | [MarketingOperationsDS].[uap_prgrm_metrics].[METRIC1_NAN] |
metric2_nan | characterLength16 | attribute | [MarketingOperationsDS].[uap_prgrm_metrics].[METRIC2_NAN] |
metric3_nan | characterLength16 | attribute | [MarketingOperationsDS].[uap_prgrm_metrics].[METRIC3_NAN] |
metric4_nan | characterLength16 | attribute | [MarketingOperationsDS].[uap_prgrm_metrics].[METRIC4_NAN] |
metric5_nan | characterLength16 | attribute | [MarketingOperationsDS].[uap_prgrm_metrics].[METRIC5_NAN] |
planned_value | float64 | fact | [MarketingOperationsDS].[uap_prgrm_metrics].[PLANNED_VALUE] |
planned_nan | characterLength16 | attribute | [MarketingOperationsDS].[uap_prgrm_metrics].[PLANNED_NAN] |
grp_id | characterLength16 | attribute | [MarketingOperationsDS].[uap_prgrm_metrics].[GRP_ID] |
is_planned_value | characterLength16 | attribute | [MarketingOperationsDS].[uap_prgrm_metrics].[IS_PLANNED_VALUE] |
alloc_total | float64 | fact | [MarketingOperationsDS].[uap_prgrm_metrics].[ALLOC_TOTAL] |
is_visible | characterLength16 | attribute | [MarketingOperationsDS].[uap_prgrm_metrics].[IS_VISIBLE] |
|
Plans | Plan Program | | (shortcut) | | [MarketingOperationsMV].[Program] |
Plan Program Area | | (shortcut) | | [MarketingOperationsMV].[Program Area] |
Plan User | | (shortcut) | | [MarketingOperationsMV].[User] |
Plans | Plan | Plan ID | float64 | fact | [MarketingOperationsDS].[uap_plans].[PLAN_ID] |
Plan Code | characterLength16 | attribute | [MarketingOperationsDS].[uap_plans].[PLAN_CODE] |
Plan Name | characterLength16 | attribute | [MarketingOperationsDS].[uap_plans].[NAME] |
Plan Description | characterLength16 | attribute | [MarketingOperationsDS].[uap_plans].[DESCRIPTION] |
Plan Status Code | characterLength16 | attribute | [MarketingOperationsDS].[uap_plans].[STATE_CODE] |
Plan Fiscal Year | float64 | attribute | [MarketingOperationsDS].[uap_plans].[FISCAL_YEAR] |
Plan Business Area ID | float64 | attribute | [MarketingOperationsDS].[uap_plans].[BUS_AREA_ID] |
Start Date | dateTime | attribute | [MarketingOperationsDS].[uap_plans].[ACTUAL_ST_DATE] |
End Date | dateTime | attribute | [MarketingOperationsDS].[uap_plans].[ACTUAL_END_DATE] |
Plan Name (Code) | characterLength16 | attribute | [MarketingOperationsMV].[Plan].[Plan Name] + ' (' + [MarketingOperationsMV].[Plan].[Plan Code] + ')' |
Plan Program Area Ref | Plan Program Area ID | float64 | identifier | [MarketingOperationsDS].[uap_plan_parea].[PLAN_PAREA_ID] |
Plan ID | float64 | attribute | [MarketingOperationsDS].[uap_plan_parea].[PLAN_ID] |
Program Area ID | float64 | attribute | [MarketingOperationsDS].[uap_plan_parea].[PRGM_AREA_ID] |
Display Order | float64 | attribute | [MarketingOperationsDS].[uap_plan_parea].[DISPLAY_ORDER] |
Plan Program Ref | Plan ID | float64 | identifier | [MarketingOperationsDS].[uap_plan_prgrm].[PLAN_ID] |
Program ID | float64 | identifier | [MarketingOperationsDS].[uap_plan_prgrm].[PROGRAM_ID] |
Plan Program Area ID | float64 | identifier | [MarketingOperationsDS].[uap_plan_prgrm].[PLAN_PAREA_ID] |
Plan Member | Plan ID | float64 | identifier | [MarketingOperationsDS].[uap_plan_users].[PLAN_ID] |
Member Type ID | float64 | attribute | [MarketingOperationsDS].[uap_plan_users].[MEM_TYPE_ID] |
User ID | float64 | identifier | [MarketingOperationsDS].[uap_plan_users].[USER_ID] |
Namespace/Folder | Query Subject | Query Item | Type | Usage | Ref Obj/Expr. |
Plan Budgets
 | Plan Budget Reference | | (shortcut) | | [MarketingOperationsMV].[Budget] |
Plan Budget Amount | | (shortcut) | | [MarketingOperationsMV].[Budget Amount] |
Program Area Budget Reference | | (shortcut) | | [MarketingOperationsMV].[Budget] |
Program Area Budget Amount | | (shortcut) | | [MarketingOperationsMV].[Budget Amount] |
Plan Budgets | Plan Budget | Budget ID | float64 | identifier | [MarketingOperationsDS].[uap_plan_budget].[BUDGET_ID] |
Plan ID | float64 | identifier | [MarketingOperationsDS].[uap_plan_budget].[PLAN_ID] |
Budget Total | float64 | fact | [MarketingOperationsDS].[uap_plan_budget].[BUDGET_TOTAL] |
Forecast Total | float64 | fact | [MarketingOperationsDS].[uap_plan_budget].[FORECAST_TOTAL] |
Actual Total | float64 | fact | [MarketingOperationsDS].[uap_plan_budget].[ACTUAL_TOTAL] |
Committed Total | float64 | fact | [MarketingOperationsDS].[uap_plan_budget].[COMMITTED_TOTAL] |
Allocated Total | float64 | fact | [MarketingOperationsDS].[uap_plan_budget].[ALLOC_TOTAL] |
Finalized Date | dateTime | attribute | [MarketingOperationsDS].[uap_plan_budget].[FINALIZED_DATE] |
Program Area Budget | Budget ID | float64 | identifier | [MarketingOperationsDS].[uap_parea_budget].[BUDGET_ID] |
Plan Program Area ID | float64 | identifier | [MarketingOperationsDS].[uap_parea_budget].[PLAN_PAREA_ID] |
Budget Total | float64 | fact | [MarketingOperationsDS].[uap_parea_budget].[BUDGET_TOTAL] |
Forecast Total | float64 | fact | [MarketingOperationsDS].[uap_parea_budget].[FORECAST_TOTAL] |
Actual Total | float64 | fact | [MarketingOperationsDS].[uap_parea_budget].[ACTUAL_TOTAL] |
Committed Total | float64 | fact | [MarketingOperationsDS].[uap_parea_budget].[COMMITTED_TOTAL] |
Finalized Date | dateTime | attribute | [MarketingOperationsDS].[uap_parea_budget].[FINALIZED_DATE] |
|
Accounts | Parent Account | | (shortcut) | | [MarketingOperationsMV].[Account] |
Account Budget Amount | | (shortcut) | | [MarketingOperationsMV].[Budget Amount] |
Account Budget Reference | | (shortcut) | | [MarketingOperationsMV].[Budget] |
Accounts | Account | Account ID | float64 | identifier | [MarketingOperationsDS].[UAP_ACCOUNTS].[ACCOUNT_ID] |
Account Code | characterLength16 | attribute | [MarketingOperationsDS].[UAP_ACCOUNTS].[ACCOUNT_CODE] |
Account Description | characterLength16 | attribute | [MarketingOperationsDS].[UAP_ACCOUNTS].[ACCOUNT_DESC] |
Parent Account ID | float64 | attribute | [MarketingOperationsDS].[UAP_ACCOUNTS].[SRC_ACCOUNT_ID] |
Account Name | characterLength16 | attribute | [MarketingOperationsDS].[UAP_ACCOUNTS].[ACCOUNT_NAME] |
Account Name (Code) | characterLength16 | attribute | [MarketingOperationsMV].[Account].[Account Name] + ' (' + [MarketingOperationsMV].[Account].[Account Code] + ')' |
Account Budget | Account ID | float64 | identifier | [MarketingOperationsDS].[UAP_ACT_BUDGET].[ACCOUNT_ID] |
Budget ID | float64 | identifier | [MarketingOperationsDS].[UAP_ACT_BUDGET].[BUDGET_ID] |
Sub-Account Budget Amount | Account ID | float64 | identifier | |
Quarter_ID | float64 | identifier | |
Year1 | float64 | identifier | |
Month1 | float64 | identifier | |
Budget_Amount | float64 | fact | |
Forecast_Amount | float64 | fact | |
Committed_Amount | float64 | fact | |
Actual_Amount | float64 | fact | |
Approvals | Approver User | | (shortcut) | | [MarketingOperationsMV].[User] |
Approvals | Approval | Approval ID | float64 | identifier | [MarketingOperationsDS].[UAP_APPROVALS].[APPROVAL_ID] |
Approval Name | characterLength16 | attribute | [MarketingOperationsDS].[UAP_APPROVALS].[NAME] |
Approval Description | characterLength16 | attribute | [MarketingOperationsDS].[UAP_APPROVALS].[DESCRIPTION] |
Approval Status Code | characterLength16 | attribute | [MarketingOperationsDS].[UAP_APPROVALS].[STATE_CODE] |
Approval Date | dateTime | attribute | [MarketingOperationsDS].[UAP_APPROVALS].[APPROVAL_DATE] |
Source Object ID | float64 | identifier | [MarketingOperationsDS].[UAP_APPROVALS].[SRC_OBJECT_ID] |
Source Object Type | characterLength16 | attribute | [MarketingOperationsDS].[UAP_APPROVALS].[SRC_OBJECT] |
Source Workflow Task ID | float64 | identifier | [MarketingOperationsDS].[UAP_APPROVALS].[SRC_WF_STEP] |
Approval Item | Approval ID | float64 | identifier | [MarketingOperationsDS].[UAP_APPR_ITEMS].[APPROVAL_ID] |
Approval Item Order | float64 | attribute | [MarketingOperationsDS].[UAP_APPR_ITEMS].[APPR_ITEM_SEQ] |
Approval Item Name | characterLength16 | attribute | [MarketingOperationsDS].[UAP_APPR_ITEMS].[ORIG_FILE_NAME] |
Approver | Approval ID | float64 | identifier | [MarketingOperationsDS].[UAP_APPROVER_LIST].[APPROVAL_ID] |
Approver Status | characterLength16 | attribute | [MarketingOperationsDS].[UAP_APPROVER_LIST].[STATUS_CODE] |
Approver Order | float64 | attribute | [MarketingOperationsDS].[UAP_APPROVER_LIST].[APPR_ORDER] |
User ID | float64 | identifier | [MarketingOperationsDS].[UAP_APPROVER_LIST].[USER_ID] |
Is Required? | characterLength16 | attribute | [MarketingOperationsDS].[UAP_APPROVER_LIST].[REQUIRED] |
Response Date | dateTime | attribute | [MarketingOperationsDS].[UAP_APPROVER_LIST].[RESP_DATE] |
Approval Status | Approval Status Code | characterLength16 | identifier | [MarketingOperationsDS].[uap_status].[STATUS_CODE] |
Approval Status | characterLength16 | attribute | [MarketingOperationsDS].[uap_status].[STATUS_DESC] |
Budgets | Budget Amount | Quarter ID | float64 | identifier | [MarketingOperationsDS].[uap_budget_amt].[QUARTER_ID] |
Year | float64 | identifier | [MarketingOperationsDS].[uap_budget_amt].[YEAR] |
Month | float64 | identifier | [MarketingOperationsDS].[uap_budget_amt].[MONTH] |
Budget ID | float64 | identifier | [MarketingOperationsDS].[uap_budget_amt].[BUDGET_ID] |
Forecast Amount | float64 | fact | [MarketingOperationsDS].[uap_budget_amt].[FORECAST_AMT] |
Committed Amount | float64 | fact | [MarketingOperationsDS].[uap_budget_amt].[COMMITTED_AMT] |
Actual Amount | float64 | fact | [MarketingOperationsDS].[uap_budget_amt].[ACTUAL_AMT] |
Budget Amount | float64 | fact | [MarketingOperationsDS].[uap_budget_amt].[BUDGET_AMT] |
Allocated Amount | float64 | fact | [MarketingOperationsDS].[uap_budget_amt].[ALLOC_AMT] |
Committed Remaining Amount | float64 | fact | IF ( [MarketingOperationsMV].[Budget Amount].[Committed Amount] is null ) THEN
([MarketingOperationsMV].[Budget Amount].[Budget Amount] )
ELSE
( [MarketingOperationsMV].[Budget Amount].[Budget Amount] - [MarketingOperationsMV].[Budget Amount].[Committed Amount] ) |
Forecast Remaining Amount | float64 | fact | IF ( [MarketingOperationsMV].[Budget Amount].[Forecast Amount] is null ) THEN
( [MarketingOperationsMV].[Budget Amount].[Budget Amount] )
ELSE
( [MarketingOperationsMV].[Budget Amount].[Budget Amount] - [MarketingOperationsMV].[Budget Amount].[Forecast Amount] ) |
Actual Remaining Amount | float64 | fact | IF ( [MarketingOperationsMV].[Budget Amount].[Actual Amount] is null) THEN
( [MarketingOperationsMV].[Budget Amount].[Budget Amount] )
ELSE
( [MarketingOperationsMV].[Budget Amount].[Budget Amount] - [MarketingOperationsMV].[Budget Amount].[Actual Amount] ) |
Allocated Remaining Amount | float64 | fact | IF ( [MarketingOperationsMV].[Budget Amount].[Allocated Amount] is null ) THEN
( [MarketingOperationsMV].[Budget Amount].[Budget Amount] )
ELSE
( [MarketingOperationsMV].[Budget Amount].[Budget Amount] - [MarketingOperationsMV].[Budget Amount].[Allocated Amount] ) |
Quarter | Quarter ID | float64 | identifier | [MarketingOperationsDS].[uap_quarters].[QUARTER_ID] |
Year | float64 | identifier | [MarketingOperationsDS].[uap_quarters].[YEAR] |
Month | float64 | identifier | [MarketingOperationsDS].[uap_quarters].[MONTH] |
Quarter Description | characterLength16 | attribute | [MarketingOperationsDS].[uap_quarters].[DESCRIPTION] |
Quarter Year | characterLength16 | attribute | substring ([MarketingOperationsMV].[Quarter].[Quarter Description] , position ( '(' , [MarketingOperationsMV].[Quarter].[Quarter Description] ) + 1, 7) |
Month Year | characterLength16 | attribute | substring ( [MarketingOperationsMV].[Quarter].[Quarter Description], 0, position('(', [MarketingOperationsMV].[Quarter].[Quarter Description]) - 1) |
Fiscal Year | characterLength16 | attribute | substring ([MarketingOperationsMV].[Quarter].[Quarter Description] , 5,4) |
Budget | Budget ID | float64 | identifier | [MarketingOperationsDS].[uap_budgets].[BUDGET_ID] |
Invoices | Invoice | Invoice ID | float64 | identifier | [MarketingOperationsDS].[UAP_INVOICES].[INVOICE_ID] |
Invoice Number | characterLength16 | attribute | [MarketingOperationsDS].[UAP_INVOICES].[INVOICE_NO] |
Vendor ID | float64 | attribute | [MarketingOperationsDS].[UAP_INVOICES].[VENDOR_ID] |
PO Number | characterLength16 | attribute | [MarketingOperationsDS].[UAP_INVOICES].[PO_NO] |
Due Date | dateTime | identifier | [MarketingOperationsDS].[UAP_INVOICES].[DUE_DATE] |
Status Code | characterLength16 | attribute | [MarketingOperationsDS].[UAP_INVOICES].[STATUS_CODE] |
State Code | characterLength16 | attribute | [MarketingOperationsDS].[UAP_INVOICES].[STATE_CODE] |
Invoice Date | dateTime | identifier | [MarketingOperationsDS].[UAP_INVOICES].[SUBMIT_DATE] |
Notes | characterLength16 | attribute | [MarketingOperationsDS].[UAP_INVOICES].[NOTES] |
Payment Terms | characterLength16 | attribute | [MarketingOperationsDS].[UAP_INVOICES].[PAYMENT_TERMS] |
Invoice Amount | float64 | fact | [MarketingOperationsDS].[UAP_INVOICES].[INVOICE_AMOUNT] |
Invoice Code | characterLength16 | attribute | [MarketingOperationsDS].[UAP_INVOICES].[INVOICE_CODE] |
Payable Date | dateTime | attribute | [MarketingOperationsDS].[UAP_INVOICES].[PAYABLE_DATE] |
Paid Date | dateTime | attribute | [MarketingOperationsDS].[UAP_INVOICES].[PAID_DATE] |
Invoice URL | characterLength16 | attribute | #sq($[Environment]{'URL'})# + 'type=invoice&id=' + cast(cast([MarketingOperationsMV].[Invoice].[Invoice ID],integer),varchar(10)) |
Invoice Line Item | Invoice ID | float64 | identifier | [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[INVOICE_ID] |
Cost Item ID | float64 | identifier | [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[COST_ITEM_ID] |
Cost Item Number | float64 | attribute | [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[COST_ITEM_NO] |
Item Description | characterLength16 | attribute | [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[COST_ITEM_DESC] |
Source Object Type | characterLength16 | attribute | [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[SRC_OBJ_TYPE] |
Source Object ID | float64 | attribute | [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[SRC_OBJ_ID] |
Source Object Code | characterLength16 | attribute | [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[SRC_OBJ_CODE] |
Account ID | float64 | attribute | [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[ACCOUNT_ID] |
Account Code | characterLength16 | attribute | [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[ACCOUNT_CODE] |
Cost Category ID | float64 | attribute | [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[COST_CAT_ID] |
Cost Category Code | characterLength16 | attribute | [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[COST_CAT_CODE] |
Quantity | float64 | fact | [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[QUANTITY] |
Unit Cost | float64 | fact | [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[UNIT_COST] |
Item Cost | float64 | fact | [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[ITEM_COST] |
Custom Attributes | Project Custom Attributes | Project ID | float64 | identifier | [MarketingOperationsDS].[DYN_PROJECTATTS].[PROJECT_ID] |
Initiative ID | float64 | fact | [MarketingOperationsDS].[DYN_PROJECTATTS].[INIT_TYPE_ID] |
Segment ID | float64 | fact | [MarketingOperationsDS].[DYN_PROJECTATTS].[SEGMENT_ID] |
Channel_Id | float64 | fact | [MarketingOperationsDS].[DYN_PROJECTATTS].[CHANNEL_ID] |
Business Unit ID | float64 | fact | [MarketingOperationsDS].[DYN_PROJECTATTS].[BUSINESS_UNIT_ID] |
Product Family ID | float64 | fact | [MarketingOperationsDS].[DYN_PROJECTATTS].[PROD_FAMILY_ID] |
Budget Period Id | float64 | fact | [MarketingOperationsDS].[DYN_PROJECTATTS].[BUDGET_PERIOD_ID] |
Business Unit | Business Unit ID | float64 | identifier | [MarketingOperationsDS].[LKUP_BUSINESS_UNIT].[BUSINESS_UNIT_ID] |
Business Unit | characterLength16 | attribute | [MarketingOperationsDS].[LKUP_BUSINESS_UNIT].[BUSINESS_UNIT_NAME] |
Initiative | Initiative ID | float64 | identifier | [MarketingOperationsDS].[LKUP_INITIATIVE].[INIT_TYPE_ID] |
Initiative | characterLength16 | attribute | [MarketingOperationsDS].[LKUP_INITIATIVE].[INIT_TYPE_NAME] |
Product Family | Product Family ID | float64 | identifier | [MarketingOperationsDS].[LKUP_PROD_FAMILY].[PROD_FAMILY_ID] |
Product Family | characterLength16 | attribute | [MarketingOperationsDS].[LKUP_PROD_FAMILY].[PROD_FAMILY_NAME] |
Segment | Segment ID | float64 | identifier | [MarketingOperationsDS].[LKUP_SEGMENTS].[SEGMENT_ID] |
Segment | characterLength16 | attribute | [MarketingOperationsDS].[LKUP_SEGMENTS].[SEGMENT_NAME] |
Project Performance Summary Custom Metrics | Project ID | float64 | fact | |
Total Revenue | float64 | fact | |
ResponseRateActual | float64 | fact | |
ResponseRateTarget | float64 | fact | |
Total Leads Generated (Actual) | float64 | fact | |
Total Leads Generated (Target) | float64 | fact | |
Total Cost Passed | float64 | fact | |
Channel | CHANNEL_ID | float64 | identifier | [MarketingOperationsDS].[LKUP_CHANNEL].[CHANNEL_ID] |
CHANNEL_NAME | characterLength16 | attribute | [MarketingOperationsDS].[LKUP_CHANNEL].[CHANNEL_NAME] |
Budget Period | budget_period_id | float64 | identifier | [MarketingOperationsDS].[LKUP_BUDGET_PERIOD].[BUDGET_PERIOD_ID] |
budget_period_name | characterLength16 | attribute | [MarketingOperationsDS].[LKUP_BUDGET_PERIOD].[BUDGET_PERIOD_NAME] |
Dashboards | Requests Over Time | Project ID | float64 | identifier | [MarketingOperationsMV].[Project Requests].[Project ID] |
Project Name | characterLength16 | attribute | [MarketingOperationsMV].[Project Requests].[Project Name] |
Project Code | characterLength16 | attribute | [MarketingOperationsMV].[Project Requests].[Project Code] |
Project Description | characterLength16 | attribute | [MarketingOperationsMV].[Project Requests].[Project Description] |
Project Start Date | dateTime | identifier | [MarketingOperationsMV].[Project Requests].[Project Start Date] |
Project End Date | dateTime | identifier | [MarketingOperationsMV].[Project Requests].[Project End Date] |
Project Actual Start Date | dateTime | identifier | [MarketingOperationsMV].[Project Requests].[Project Actual Start Date] |
Project Actual End Date | dateTime | identifier | [MarketingOperationsMV].[Project Requests].[Project Actual End Date] |
Project Request Status | characterLength16 | attribute | [MarketingOperationsMV].[Project Requests].[Project Request Status] |
Project URL | characterLength16 | attribute | [MarketingOperationsMV].[Project Requests].[Project Request URL] |
Project Name (Code) | characterLength16 | attribute | [MarketingOperationsMV].[Project Requests].[Project Name (Code)] |
Project Request Flag | characterLength16 | attribute | [MarketingOperationsMV].[Project Requests].[Project Request Flag] |
Project Request ID | float64 | identifier | [MarketingOperationsMV].[Project Requests].[Project Request ID] |
Request Submit Date | dateTime | identifier | [MarketingOperationsMV].[Project Requests].[Request Submit Date] |
Request Complete Date | dateTime | identifier | [MarketingOperationsMV].[Project Requests].[Request Complete Date] |
Request Submit Month | int32 | identifier | extract(month, [MarketingOperationsMV].[Requests Over Time].[Request Submit Date] ) -1 |
Request Submit Year | int32 | identifier | extract (year, [MarketingOperationsMV].[Requests Over Time].[Request Submit Date] ) |
Template Name | characterLength16 | attribute | [MarketingOperationsMV].[Project Requests].[Template Name] |
Request Parent Project ID | float64 | identifier | [MarketingOperationsMV].[Project Requests].[Request Parent Project ID] |
Projects Over Time | Project ID | float64 | identifier | [MarketingOperationsMV].[Project].[Project ID] |
Project Name | characterLength16 | attribute | [MarketingOperationsMV].[Project].[Project Name] |
Project Code | characterLength16 | attribute | [MarketingOperationsMV].[Project].[Project Code] |
Project Description | characterLength16 | attribute | [MarketingOperationsMV].[Project].[Project Description] |
Project Start Date | dateTime | identifier | [MarketingOperationsMV].[Project].[Project Start Date] |
Project End Date | dateTime | identifier | [MarketingOperationsMV].[Project].[Project End Date] |
Project Actual Start Date | dateTime | identifier | [MarketingOperationsMV].[Project].[Project Actual Start Date] |
Project Actual End Date | dateTime | identifier | [MarketingOperationsMV].[Project].[Project Actual End Date] |
Project Actual End Month | float64 | identifier | extract(month, [MarketingOperationsMV].[Projects Over Time].[Project Actual End Date] ) -1 |
Project Actual End Year | float64 | identifier | extract(year, [MarketingOperationsMV].[Projects Over Time].[Project Actual End Date] ) |
Project Status Code | characterLength16 | identifier | [MarketingOperationsMV].[Project Status].[Status Code] |
Project Status | characterLength16 | attribute | [MarketingOperationsMV].[Project Status].[Status] |
Project URL | characterLength16 | attribute | [MarketingOperationsMV].[Project].[Project URL] |
Project Name (Code) | characterLength16 | attribute | [MarketingOperationsMV].[Project].[Project Name (Code)] |
Project Request Flag | characterLength16 | attribute | [MarketingOperationsMV].[Project].[Project Request Flag] |
Template Name | characterLength16 | attribute | [MarketingOperationsMV].[Project].[Template Name] |
Parent Project ID | float64 | identifier | [MarketingOperationsMV].[Project].[Parent Project ID] |
Projects Quarter | Quarter ID | float64 | identifier | [MarketingOperationsDS].[uap_quarters].[QUARTER_ID] |
Year | float64 | identifier | [MarketingOperationsDS].[uap_quarters].[YEAR] |
Month | float64 | identifier | [MarketingOperationsDS].[uap_quarters].[MONTH] |
Quarter Description | characterLength16 | attribute | [MarketingOperationsDS].[uap_quarters].[DESCRIPTION] |
Quarter Year | characterLength16 | attribute | substring ([MarketingOperationsMV].[Projects Quarter].[Quarter Description] , position ( '(' , [MarketingOperationsMV].[Projects Quarter].[Quarter Description] ) + 1, 7) |
Month Year | characterLength16 | attribute | substring ( [MarketingOperationsMV].[Projects Quarter].[Quarter Description], 1, position('(', [MarketingOperationsMV].[Projects Quarter].[Quarter Description]) - 1) |
Fiscal Year | characterLength16 | attribute | substring ([MarketingOperationsMV].[Projects Quarter].[Quarter Description] , 5,4) |
Namespace/Folder | Query Subject | Query Item | Type | Usage | Ref Obj/Expr. |
Projects and Requests Over Time Star Schema
 | Requests Over Time | | (shortcut) | | [MarketingOperationsMV].[Requests Over Time] |
Projects Over Time | | (shortcut) | | [MarketingOperationsMV].[Projects Over Time] |
Projects Quarter | | (shortcut) | | [MarketingOperationsMV].[Projects Quarter] |
|
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.