Unica Campaign Interact Cognos Framework Manager Model Specification


Project: InteractModel
Supported Locale(s): en fr de es 
Package(s): Unica Interact Package
NameCM DataSource
InteractDTDSInteractDTDS
InteractRTDSInteractRTDS
InteractLearningDSInteractLearningDS

Parameter MapKey - Values
EnvironmentRedirect URL: http://localhost:7001/Campaign/redirectToSummary.do?type=
Version: 8.1.0.00

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


Business View
model/Business View.jpg
Namespace/FolderQuery SubjectQuery ItemTypeUsageRef Obj/Expr.
Interactive Channel by Offer PerformanceInteractive Channel by Offer Performance SummaryOffer IDdecimalidentifier[Interactive Channel by Offer Performance Summary Star Schema].[Interactive Channel by Offer Number of Times Presented][Interact Model].[Interactive Channel by Offer Number of Times Presented].[Offer ID] 
Offer NamecharacterLength16attribute[Interactive Channel by Offer Performance Summary Star Schema].[Offer][Interact Model].[Offer].[Offer Name] 
Offer Code 1characterLength16attribute[Interactive Channel by Offer Performance Summary Star Schema].[Offer][Interact Model].[Offer].[Offer Code 1] 
Interactive Channel IDdecimalidentifier[Interactive Channel by Offer Performance Summary Star Schema].[Interactive Channel by Offer Elig Opps][Interact Model].[Interactive Channel by Offer Elig Opps].[Interactive Channel ID] 
Interactive ChannelcharacterLength16attribute[Interactive Channel by Offer Performance Summary Star Schema].[Interactive Channel by Offer Elig Opps][Interact Model].[Interactive Channel by Offer Elig Opps].[Interactive Channel] 
Interaction Point IDdecimalidentifier[Interactive Channel by Offer Performance Summary Star Schema].[Interactive Channel by Offer Elig Opps][Interact Model].[Interactive Channel by Offer Elig Opps].[Interaction Point ID] 
Interaction PointcharacterLength16attribute[Interactive Channel by Offer Performance Summary Star Schema].[Interactive Channel by Offer Elig Opps][Interact Model].[Interactive Channel by Offer Elig Opps].[Interaction Point] 
Presentedfloat64factIF([Interactive Channel by Offer Performance Summary Star Schema].[Interactive Channel by Offer Number of Times Presented][Interact Model].[Interactive Channel by Offer Number of Times Presented].[Presented] is missing) THEN(0) ELSE([Interactive Channel by Offer Performance Summary Star Schema].[Interactive Channel by Offer Number of Times Presented][Interact Model].[Interactive Channel by Offer Number of Times Presented].[Presented]) 
Presented Model-Drivenfloat64factIF([Interactive Channel by Offer Performance Summary Star Schema].[Interactive Channel by Offer Number of Times Presented][Interact Model].[Interactive Channel by Offer Number of Times Presented].[Presented Model-Driven] is missing) THEN(0) ELSE([Interactive Channel by Offer Performance Summary Star Schema].[Interactive Channel by Offer Number of Times Presented][Interact Model].[Interactive Channel by Offer Number of Times Presented].[Presented Model-Driven]) 
Presented Randomfloat64factIF([Interactive Channel by Offer Performance Summary Star Schema].[Interactive Channel by Offer Number of Times Presented][Interact Model].[Interactive Channel by Offer Number of Times Presented].[Presented Random] is missing) THEN(0) ELSE([Interactive Channel by Offer Performance Summary Star Schema].[Interactive Channel by Offer Number of Times Presented][Interact Model].[Interactive Channel by Offer Number of Times Presented].[Presented Random]) 
Eligible Opportunitiesfloat64factIF([Interactive Channel by Offer Performance Summary Star Schema].[Interactive Channel by Offer Elig Opps][Interact Model].[Interactive Channel by Offer Elig Opps].[Eligible Opportunities] is missing) THEN(0) ELSE([Interactive Channel by Offer Performance Summary Star Schema].[Interactive Channel by Offer Elig Opps][Interact Model].[Interactive Channel by Offer Elig Opps].[Eligible Opportunities]) 
Acceptedfloat64factIF([Interactive Channel by Offer Performance Summary Star Schema].[Interactive Channel by Offer Response History][Interact Model].[Interactive Channel by Offer Response History].[Accepted] is missing) THEN(0) ELSE([Interactive Channel by Offer Performance Summary Star Schema].[Interactive Channel by Offer Response History][Interact Model].[Interactive Channel by Offer Response History].[Accepted]) 
Accepted Model-Drivenfloat64factIF([Interactive Channel by Offer Performance Summary Star Schema].[Interactive Channel by Offer Response History][Interact Model].[Interactive Channel by Offer Response History].[Accepted Model-Driven] is missing) THEN(0) ELSE([Interactive Channel by Offer Performance Summary Star Schema].[Interactive Channel by Offer Response History][Interact Model].[Interactive Channel by Offer Response History].[Accepted Model-Driven]) 
Accepted Randomfloat64factIF([Interactive Channel by Offer Performance Summary Star Schema].[Interactive Channel by Offer Response History][Interact Model].[Interactive Channel by Offer Response History].[Accepted Random] is missing) THEN(0) ELSE([Interactive Channel by Offer Performance Summary Star Schema].[Interactive Channel by Offer Response History][Interact Model].[Interactive Channel by Offer Response History].[Accepted Random]) 
Rejectedfloat64factIF([Interactive Channel by Offer Performance Summary Star Schema].[Interactive Channel by Offer Response History][Interact Model].[Interactive Channel by Offer Response History].[Rejected] is missing) THEN(0) ELSE([Interactive Channel by Offer Performance Summary Star Schema].[Interactive Channel by Offer Response History][Interact Model].[Interactive Channel by Offer Response History].[Rejected]) 
Interactive Channel by Offer Performance Last 14 DaysOffer IDdecimalidentifier[Interactive Channel by Offer Performance by Day Star Schema].[Interactive Channel by Offer Elig Opps by Day][Interact Model].[Interactive Channel by Offer Elig Opps by Day].[Offer ID]  
Offer NamecharacterLength16attribute[Interactive Channel by Offer Performance by Day Star Schema].[Offer][Interact Model].[Offer].[Offer Name] 
Offer Code 1characterLength16attribute[Interactive Channel by Offer Performance by Day Star Schema].[Offer][Interact Model].[Offer].[Offer Code 1] 
Interactive Channel IDdecimalidentifier[Interactive Channel by Offer Performance by Day Star Schema].[Interactive Channel by Offer Elig Opps by Day][Interact Model].[Interactive Channel by Offer Elig Opps by Day].[Interactive Channel ID]  
Interactive ChannelcharacterLength16attribute[Interactive Channel by Offer Performance by Day Star Schema].[Interactive Channel by Offer Elig Opps by Day][Interact Model].[Interactive Channel by Offer Elig Opps by Day].[Interactive Channel]  
Interaction Point IDdecimalidentifier[Interactive Channel by Offer Performance by Day Star Schema].[Interactive Channel by Offer Elig Opps by Day][Interact Model].[Interactive Channel by Offer Elig Opps by Day].[Interaction Point ID]  
Interaction PointcharacterLength16attribute[Interactive Channel by Offer Performance by Day Star Schema].[Interactive Channel by Offer Elig Opps by Day][Interact Model].[Interactive Channel by Offer Elig Opps by Day].[Interaction Point]  
Actual DatedateTimeattribute[Interactive Channel by Offer Performance by Day Star Schema].[Calendar][Interact Model].[Calendar].[Actual Date]  
Presentedfloat64factIF([Interactive Channel by Offer Performance by Day Star Schema].[Interactive Channel by Offer Number of Times Presented by Day][Interact Model].[Interactive Channel by Offer Number of Times Presented by Day].[Presented] is missing) THEN(0) ELSE([Interactive Channel by Offer Performance by Day Star Schema].[Interactive Channel by Offer Number of Times Presented by Day][Interact Model].[Interactive Channel by Offer Number of Times Presented by Day].[Presented]) 
Presented Model-Drivenfloat64factIF([Interactive Channel by Offer Performance by Day Star Schema].[Interactive Channel by Offer Number of Times Presented by Day][Interact Model].[Interactive Channel by Offer Number of Times Presented by Day].[Presented Model-Driven] is missing) THEN(0) ELSE([Interactive Channel by Offer Performance by Day Star Schema].[Interactive Channel by Offer Number of Times Presented by Day][Interact Model].[Interactive Channel by Offer Number of Times Presented by Day].[Presented Model-Driven]) 
Presented Randomfloat64factIF([Interactive Channel by Offer Performance by Day Star Schema].[Interactive Channel by Offer Number of Times Presented by Day][Interact Model].[Interactive Channel by Offer Number of Times Presented by Day].[Presented Random] is missing) THEN(0) ELSE([Interactive Channel by Offer Performance by Day Star Schema].[Interactive Channel by Offer Number of Times Presented by Day][Interact Model].[Interactive Channel by Offer Number of Times Presented by Day].[Presented Random]) 
Eligible Opportunitiesfloat64factIF([Interactive Channel by Offer Performance by Day Star Schema].[Interactive Channel by Offer Elig Opps by Day][Interact Model].[Interactive Channel by Offer Elig Opps by Day].[Eligible Opportunities] is missing) THEN(0) ELSE([Interactive Channel by Offer Performance by Day Star Schema].[Interactive Channel by Offer Elig Opps by Day][Interact Model].[Interactive Channel by Offer Elig Opps by Day].[Eligible Opportunities]) 
Acceptedfloat64factIF([Interactive Channel by Offer Performance by Day Star Schema].[Interactive Channel by Offer Response History by Day][Interact Model].[Interactive Channel by Offer Response History by Day].[Accepted] is missing) THEN(0) ELSE([Interactive Channel by Offer Performance by Day Star Schema].[Interactive Channel by Offer Response History by Day][Interact Model].[Interactive Channel by Offer Response History by Day].[Accepted]) 
Accepted Model-Drivenfloat64factIF([Interactive Channel by Offer Performance by Day Star Schema].[Interactive Channel by Offer Response History by Day][Interact Model].[Interactive Channel by Offer Response History by Day].[Accepted Model-Driven] is missing) THEN(0) ELSE([Interactive Channel by Offer Performance by Day Star Schema].[Interactive Channel by Offer Response History by Day][Interact Model].[Interactive Channel by Offer Response History by Day].[Accepted Model-Driven]) 
Accepted Randomfloat64factIF([Interactive Channel by Offer Performance by Day Star Schema].[Interactive Channel by Offer Response History by Day][Interact Model].[Interactive Channel by Offer Response History by Day].[Accepted Random] is missing) THEN(0) ELSE([Interactive Channel by Offer Performance by Day Star Schema].[Interactive Channel by Offer Response History by Day][Interact Model].[Interactive Channel by Offer Response History by Day].[Accepted Random]) 
Rejectedfloat64factIF([Interactive Channel by Offer Performance by Day Star Schema].[Interactive Channel by Offer Response History by Day][Interact Model].[Interactive Channel by Offer Response History by Day].[Rejected] is missing) THEN(0) ELSE([Interactive Channel by Offer Performance by Day Star Schema].[Interactive Channel by Offer Response History by Day][Interact Model].[Interactive Channel by Offer Response History by Day].[Rejected]) 
Interactive Channel by Offer Performance by HourOffer IDdecimalidentifier[Interactive Channel by Offer Performance by Hour Star Schema].[Interactive Channel by Offer Number of Times Presented by Hour][Interact Model].[Interactive Channel by Offer Number of Times Presented by Hour].[Offer ID] 
Offer NamecharacterLength16attribute[Interactive Channel by Offer Performance by Hour Star Schema].[Offer][Interact Model].[Offer].[Offer Name] 
Offer Code 1characterLength16attribute[Interactive Channel by Offer Performance by Hour Star Schema].[Offer][Interact Model].[Offer].[Offer Code 1] 
Interactive Channel IDdecimalidentifier[Interactive Channel by Offer Performance by Hour Star Schema].[Interactive Channel by Offer Number of Times Presented by Hour][Interact Model].[Interactive Channel by Offer Number of Times Presented by Hour].[Interactive Channel ID] 
Interactive ChannelcharacterLength16attribute[Interactive Channel by Offer Performance by Hour Star Schema].[Interactive Channel by Offer Number of Times Presented by Hour][Interact Model].[Interactive Channel by Offer Number of Times Presented by Hour].[Interactive Channel] 
Interaction Point IDfloat64identifier[Interactive Channel by Offer Performance by Hour Star Schema].[Interactive Channel by Offer Number of Times Presented by Hour][Interact Model].[Interactive Channel by Offer Number of Times Presented by Hour].[Interaction Point ID] 
Interaction PointcharacterLength16attribute[Interactive Channel by Offer Performance by Hour Star Schema].[Interactive Channel by Offer Number of Times Presented by Hour][Interact Model].[Interactive Channel by Offer Number of Times Presented by Hour].[Interaction Point] 
Hourint64attribute[Interactive Channel by Offer Performance by Hour Star Schema].[Interactive Channel by Offer Number of Times Presented by Hour][Interact Model].[Interactive Channel by Offer Number of Times Presented by Hour].[Hour] 
Actual DatedateTimeattribute[Interactive Channel by Offer Performance by Hour Star Schema].[Interactive Channel by Offer Number of Times Presented by Hour][Interact Model].[Interactive Channel by Offer Number of Times Presented by Hour].[Actual Date] 
Presentedfloat64factIF([Interactive Channel by Offer Performance by Hour Star Schema].[Interactive Channel by Offer Number of Times Presented by Hour][Interact Model].[Interactive Channel by Offer Number of Times Presented by Hour].[Presented] is missing) THEN(0) ELSE([Interactive Channel by Offer Performance by Hour Star Schema].[Interactive Channel by Offer Number of Times Presented by Hour][Interact Model].[Interactive Channel by Offer Number of Times Presented by Hour].[Presented]) 
Presented Model-Drivenfloat64factIF([Interactive Channel by Offer Performance by Hour Star Schema].[Interactive Channel by Offer Number of Times Presented by Hour][Interact Model].[Interactive Channel by Offer Number of Times Presented by Hour].[Presented Model-Driven] is missing) THEN(0) ELSE([Interactive Channel by Offer Performance by Hour Star Schema].[Interactive Channel by Offer Number of Times Presented by Hour][Interact Model].[Interactive Channel by Offer Number of Times Presented by Hour].[Presented Model-Driven]) 
Presented Randomfloat64factIF([Interactive Channel by Offer Performance by Hour Star Schema].[Interactive Channel by Offer Number of Times Presented by Hour][Interact Model].[Interactive Channel by Offer Number of Times Presented by Hour].[Presented Random] is missing) THEN(0) ELSE([Interactive Channel by Offer Performance by Hour Star Schema].[Interactive Channel by Offer Number of Times Presented by Hour][Interact Model].[Interactive Channel by Offer Number of Times Presented by Hour].[Presented Random]) 
Acceptedfloat64factIF([Interactive Channel by Offer Performance by Hour Star Schema].[Interactive Channel by Offer Respone History by Hour][Interact Model].[Interactive Channel by Offer Respone History by Hour].[Accepted] is missing) THEN(0) ELSE([Interactive Channel by Offer Performance by Hour Star Schema].[Interactive Channel by Offer Respone History by Hour][Interact Model].[Interactive Channel by Offer Respone History by Hour].[Accepted]) 
Accepted Model-Drivenfloat64factIF([Interactive Channel by Offer Performance by Hour Star Schema].[Interactive Channel by Offer Respone History by Hour][Interact Model].[Interactive Channel by Offer Respone History by Hour].[Accepted Model-Driven] is missing) THEN(0) ELSE([Interactive Channel by Offer Performance by Hour Star Schema].[Interactive Channel by Offer Respone History by Hour][Interact Model].[Interactive Channel by Offer Respone History by Hour].[Accepted Model-Driven]) 
Accepted Randomfloat64factIF([Interactive Channel by Offer Performance by Hour Star Schema].[Interactive Channel by Offer Respone History by Hour][Interact Model].[Interactive Channel by Offer Respone History by Hour].[Accepted Random] is missing) THEN(0) ELSE([Interactive Channel by Offer Performance by Hour Star Schema].[Interactive Channel by Offer Respone History by Hour][Interact Model].[Interactive Channel by Offer Respone History by Hour].[Accepted Random]) 
Rejectedfloat64factIF([Interactive Channel by Offer Performance by Hour Star Schema].[Interactive Channel by Offer Respone History by Hour][Interact Model].[Interactive Channel by Offer Respone History by Hour].[Rejected] is missing) THEN(0) ELSE([Interactive Channel by Offer Performance by Hour Star Schema].[Interactive Channel by Offer Respone History by Hour][Interact Model].[Interactive Channel by Offer Respone History by Hour].[Rejected]) 
Interactive Channel by Segment PerformanceInteractive Channel by Segment Performancy SummaryInteractive Channel IDdecimalidentifier[Interactive Channel by Segment Summary Star Schema].[Interactive Channel by Segment Number of Times Presented][Interact Model].[Interactive Channel by Segment Number of Times Presented].[Interactive Channel ID] 
Interactive ChannelcharacterLength16attribute[Interactive Channel by Segment Summary Star Schema].[Interactive Channel by Segment Number of Times Presented][Interact Model].[Interactive Channel by Segment Number of Times Presented].[Interactive Channel] 
Interaction Point IDfloat64identifier[Interactive Channel by Segment Summary Star Schema].[Interactive Channel by Segment Number of Times Presented][Interact Model].[Interactive Channel by Segment Number of Times Presented].[Interaction Point ID] 
Interaction PointcharacterLength16attribute[Interactive Channel by Segment Summary Star Schema].[Interactive Channel by Segment Number of Times Presented][Interact Model].[Interactive Channel by Segment Number of Times Presented].[Interaction Point] 
Segment IDdecimalidentifier[Interactive Channel by Segment Summary Star Schema].[Interactive Channel by Segment Number of Times Presented][Interact Model].[Interactive Channel by Segment Number of Times Presented].[Segment ID] 
SegmentcharacterLength16attribute[Interactive Channel by Segment Summary Star Schema].[Interactive Channel by Segment Number of Times Presented][Interact Model].[Interactive Channel by Segment Number of Times Presented].[Segment] 
Presentedfloat64factIF([Interactive Channel by Segment Summary Star Schema].[Interactive Channel by Segment Number of Times Presented][Interact Model].[Interactive Channel by Segment Number of Times Presented].[Presented] is missing) THEN(0) ELSE([Interactive Channel by Segment Summary Star Schema].[Interactive Channel by Segment Number of Times Presented][Interact Model].[Interactive Channel by Segment Number of Times Presented].[Presented]) 
Presented Model-Drivenfloat64factIF([Interactive Channel by Segment Summary Star Schema].[Interactive Channel by Segment Number of Times Presented][Interact Model].[Interactive Channel by Segment Number of Times Presented].[Presented Model-Driven] is missing) THEN(0) ELSE([Interactive Channel by Segment Summary Star Schema].[Interactive Channel by Segment Number of Times Presented][Interact Model].[Interactive Channel by Segment Number of Times Presented].[Presented Model-Driven]) 
Presented Randomfloat64factIF([Interactive Channel by Segment Summary Star Schema].[Interactive Channel by Segment Number of Times Presented][Interact Model].[Interactive Channel by Segment Number of Times Presented].[Presented Random] is missing) THEN(0) ELSE([Interactive Channel by Segment Summary Star Schema].[Interactive Channel by Segment Number of Times Presented][Interact Model].[Interactive Channel by Segment Number of Times Presented].[Presented Random]) 
Defaultedfloat64factIF([Interactive Channel by Segment Summary Star Schema].[Interactive Channel by Segment Times Defaulted][Interact Model].[Interactive Channel by Segment Times Defaulted].[Defaulted] is missing) THEN(0) ELSE([Interactive Channel by Segment Summary Star Schema].[Interactive Channel by Segment Times Defaulted][Interact Model].[Interactive Channel by Segment Times Defaulted].[Defaulted]) 
Acceptedfloat64factIF([Interactive Channel by Segment Summary Star Schema].[Interactive Channel by Segment Response History][Interact Model].[Interactive Channel by Segment Response History].[Accepted] is missing) THEN(0) ELSE([Interactive Channel by Segment Summary Star Schema].[Interactive Channel by Segment Response History][Interact Model].[Interactive Channel by Segment Response History].[Accepted]) 
Accepted Model-Drivenfloat64factIF([Interactive Channel by Segment Summary Star Schema].[Interactive Channel by Segment Response History][Interact Model].[Interactive Channel by Segment Response History].[Accepted Model-Driven] is missing) THEN(0) ELSE([Interactive Channel by Segment Summary Star Schema].[Interactive Channel by Segment Response History][Interact Model].[Interactive Channel by Segment Response History].[Accepted Model-Driven]) 
Accepted Randomfloat64factIF([Interactive Channel by Segment Summary Star Schema].[Interactive Channel by Segment Response History][Interact Model].[Interactive Channel by Segment Response History].[Accepted Random] is missing) THEN(0) ELSE([Interactive Channel by Segment Summary Star Schema].[Interactive Channel by Segment Response History][Interact Model].[Interactive Channel by Segment Response History].[Accepted Random]) 
Rejectedfloat64factIF([Interactive Channel by Segment Summary Star Schema].[Interactive Channel by Segment Response History][Interact Model].[Interactive Channel by Segment Response History].[Rejected] is missing) THEN(0) ELSE([Interactive Channel by Segment Summary Star Schema].[Interactive Channel by Segment Response History][Interact Model].[Interactive Channel by Segment Response History].[Rejected]) 
Interactive Channel by Segment Performance by DayInteractive Channel IDdecimalidentifier[Interactive Channel by Segment by Day Star Schema].[Interactive Channel by Segment Number of Times Presented by Day][Interact Model].[Interactive Channel by Segment Number of Times Presented by Day].[Interactive Channel ID] 
Interactive ChannelcharacterLength16attribute[Interactive Channel by Segment by Day Star Schema].[Interactive Channel by Segment Number of Times Presented by Day][Interact Model].[Interactive Channel by Segment Number of Times Presented by Day].[Interactive Channel] 
Interaction Point IDfloat64identifier[Interactive Channel by Segment by Day Star Schema].[Interactive Channel by Segment Number of Times Presented by Day][Interact Model].[Interactive Channel by Segment Number of Times Presented by Day].[Interaction Point ID] 
Interaction PointcharacterLength16attribute[Interactive Channel by Segment by Day Star Schema].[Interactive Channel by Segment Number of Times Presented by Day][Interact Model].[Interactive Channel by Segment Number of Times Presented by Day].[Interaction Point] 
Segment IDdecimalidentifier[Interactive Channel by Segment by Day Star Schema].[Interactive Channel by Segment Number of Times Presented by Day][Interact Model].[Interactive Channel by Segment Number of Times Presented by Day].[Segment ID] 
SegmentcharacterLength16attribute[Interactive Channel by Segment by Day Star Schema].[Interactive Channel by Segment Number of Times Presented by Day][Interact Model].[Interactive Channel by Segment Number of Times Presented by Day].[Segment] 
Actual DatedateTimeidentifier[Interactive Channel by Segment by Day Star Schema].[Interactive Channel by Segment Number of Times Presented by Day][Interact Model].[Interactive Channel by Segment Number of Times Presented by Day].[Actual Date] 
Presentedfloat64factIF([Interactive Channel by Segment by Day Star Schema].[Interactive Channel by Segment Number of Times Presented by Day][Interact Model].[Interactive Channel by Segment Number of Times Presented by Day].[Presented] is missing) THEN(0) ELSE([Interactive Channel by Segment by Day Star Schema].[Interactive Channel by Segment Number of Times Presented by Day][Interact Model].[Interactive Channel by Segment Number of Times Presented by Day].[Presented]) 
Presented Model-Drivenfloat64factIF([Interactive Channel by Segment by Day Star Schema].[Interactive Channel by Segment Number of Times Presented by Day][Interact Model].[Interactive Channel by Segment Number of Times Presented by Day].[Presented Model-Driven] is missing) THEN(0) ELSE([Interactive Channel by Segment by Day Star Schema].[Interactive Channel by Segment Number of Times Presented by Day][Interact Model].[Interactive Channel by Segment Number of Times Presented by Day].[Presented Model-Driven]) 
Presented Randomfloat64factIF([Interactive Channel by Segment by Day Star Schema].[Interactive Channel by Segment Number of Times Presented by Day][Interact Model].[Interactive Channel by Segment Number of Times Presented by Day].[Presented Random] is missing) THEN(0) ELSE([Interactive Channel by Segment by Day Star Schema].[Interactive Channel by Segment Number of Times Presented by Day][Interact Model].[Interactive Channel by Segment Number of Times Presented by Day].[Presented Random]) 
Acceptedfloat64factIF([Interactive Channel by Segment by Day Star Schema].[Interactive Channel by Segment Response History by Day][Interact Model].[Interactive Channel by Segment Response History by Day].[Accepted] is missing) THEN(0) ELSE([Interactive Channel by Segment by Day Star Schema].[Interactive Channel by Segment Response History by Day][Interact Model].[Interactive Channel by Segment Response History by Day].[Accepted]) 
Accepted Model-Drivenfloat64factIF([Interactive Channel by Segment by Day Star Schema].[Interactive Channel by Segment Response History by Day][Interact Model].[Interactive Channel by Segment Response History by Day].[Accepted Model-Driven] is missing) THEN(0) ELSE([Interactive Channel by Segment by Day Star Schema].[Interactive Channel by Segment Response History by Day][Interact Model].[Interactive Channel by Segment Response History by Day].[Accepted Model-Driven]) 
Accepted Randomfloat64factIF([Interactive Channel by Segment by Day Star Schema].[Interactive Channel by Segment Response History by Day][Interact Model].[Interactive Channel by Segment Response History by Day].[Accepted Random] is missing) THEN(0) ELSE([Interactive Channel by Segment by Day Star Schema].[Interactive Channel by Segment Response History by Day][Interact Model].[Interactive Channel by Segment Response History by Day].[Accepted Random]) 
Rejectedfloat64factIF([Interactive Channel by Segment by Day Star Schema].[Interactive Channel by Segment Response History by Day][Interact Model].[Interactive Channel by Segment Response History by Day].[Rejected] is missing) THEN(0) ELSE([Interactive Channel by Segment by Day Star Schema].[Interactive Channel by Segment Response History by Day][Interact Model].[Interactive Channel by Segment Response History by Day].[Rejected]) 
Interactive Channel by Segment Performance by HourInteractive Channel IDdecimalidentifier[Interactive Channel by Segment by Hour Star Schema].[Interactive Channel by Segment Number of Times Presented by Hour][Interact Model].[Interactive Channel by Segment Number of Times Presented by Hour].[Interactive Channel ID] 
Interactive ChannelcharacterLength16attribute[Interactive Channel by Segment by Hour Star Schema].[Interactive Channel by Segment Number of Times Presented by Hour][Interact Model].[Interactive Channel by Segment Number of Times Presented by Hour].[Interactive Channel] 
Interaction Point IDfloat64identifier[Interactive Channel by Segment by Hour Star Schema].[Interactive Channel by Segment Number of Times Presented by Hour][Interact Model].[Interactive Channel by Segment Number of Times Presented by Hour].[Interaction Point ID] 
Interaction PointcharacterLength16attribute[Interactive Channel by Segment by Hour Star Schema].[Interactive Channel by Segment Number of Times Presented by Hour][Interact Model].[Interactive Channel by Segment Number of Times Presented by Hour].[Interaction Point] 
Segment IDdecimalidentifier[Interactive Channel by Segment by Hour Star Schema].[Interactive Channel by Segment Number of Times Presented by Hour][Interact Model].[Interactive Channel by Segment Number of Times Presented by Hour].[Segment ID] 
SegmentcharacterLength16attribute[Interactive Channel by Segment by Hour Star Schema].[Interactive Channel by Segment Number of Times Presented by Hour][Interact Model].[Interactive Channel by Segment Number of Times Presented by Hour].[Segment] 
Hourint64identifier[Interactive Channel by Segment by Hour Star Schema].[Interactive Channel by Segment Number of Times Presented by Hour][Interact Model].[Interactive Channel by Segment Number of Times Presented by Hour].[Hour] 
Actual DatedateTimeidentifier[Interactive Channel by Segment by Hour Star Schema].[Interactive Channel by Segment Number of Times Presented by Hour][Interact Model].[Interactive Channel by Segment Number of Times Presented by Hour].[Actual Date] 
Presentedfloat64factIF([Interactive Channel by Segment by Hour Star Schema].[Interactive Channel by Segment Number of Times Presented by Hour][Interact Model].[Interactive Channel by Segment Number of Times Presented by Hour].[Presented] is missing) THEN(0) ELSE([Interactive Channel by Segment by Hour Star Schema].[Interactive Channel by Segment Number of Times Presented by Hour][Interact Model].[Interactive Channel by Segment Number of Times Presented by Hour].[Presented]) 
Presented Model-Drivenfloat64factIF([Interactive Channel by Segment by Hour Star Schema].[Interactive Channel by Segment Number of Times Presented by Hour][Interact Model].[Interactive Channel by Segment Number of Times Presented by Hour].[Presented Model-Driven] is missing) THEN(0) ELSE([Interactive Channel by Segment by Hour Star Schema].[Interactive Channel by Segment Number of Times Presented by Hour][Interact Model].[Interactive Channel by Segment Number of Times Presented by Hour].[Presented Model-Driven]) 
Presented Randomfloat64factIF([Interactive Channel by Segment by Hour Star Schema].[Interactive Channel by Segment Number of Times Presented by Hour][Interact Model].[Interactive Channel by Segment Number of Times Presented by Hour].[Presented Random] is missing) THEN(0) ELSE([Interactive Channel by Segment by Hour Star Schema].[Interactive Channel by Segment Number of Times Presented by Hour][Interact Model].[Interactive Channel by Segment Number of Times Presented by Hour].[Presented Random]) 
Acceptedfloat64factIF([Interactive Channel by Segment by Hour Star Schema].[Interactive Channel by Segment Response History by Hour][Interact Model].[Interactive Channel by Segment Response History by Hour].[Accepted] is missing) THEN(0) ELSE([Interactive Channel by Segment by Hour Star Schema].[Interactive Channel by Segment Response History by Hour][Interact Model].[Interactive Channel by Segment Response History by Hour].[Accepted]) 
Accepted Model-Drivenfloat64factIF([Interactive Channel by Segment by Hour Star Schema].[Interactive Channel by Segment Response History by Hour][Interact Model].[Interactive Channel by Segment Response History by Hour].[Accepted Model-Driven] is missing) THEN(0) ELSE([Interactive Channel by Segment by Hour Star Schema].[Interactive Channel by Segment Response History by Hour][Interact Model].[Interactive Channel by Segment Response History by Hour].[Accepted Model-Driven]) 
Accepted Randomfloat64factIF([Interactive Channel by Segment by Hour Star Schema].[Interactive Channel by Segment Response History by Hour][Interact Model].[Interactive Channel by Segment Response History by Hour].[Accepted Random] is missing) THEN(0) ELSE([Interactive Channel by Segment by Hour Star Schema].[Interactive Channel by Segment Response History by Hour][Interact Model].[Interactive Channel by Segment Response History by Hour].[Accepted Random]) 
Rejectedfloat64factIF([Interactive Channel by Segment by Hour Star Schema].[Interactive Channel by Segment Response History by Hour][Interact Model].[Interactive Channel by Segment Response History by Hour].[Rejected] is missing) THEN(0) ELSE([Interactive Channel by Segment by Hour Star Schema].[Interactive Channel by Segment Response History by Hour][Interact Model].[Interactive Channel by Segment Response History by Hour].[Rejected]) 
Namespace/FolderQuery SubjectQuery ItemTypeUsageRef Obj/Expr.
Cumulative Interactive Channel by Segment by Day
model/Cumulative Interactive Channel by Segment by Day.jpg
Cumulative Interactive Channel by Segment Number of Times Presented by Day (shortcut) [Interact Model].[Cumulative Interactive Channel by Segment Number of Times Presented by Day]
Cumulative Interactive Channel by Segment Response History by Day (shortcut) [Interact Model].[Cumulative Interactive Channel by Segment Response History by Day]
Last 14 Days Calendar (shortcut) [Interact Model].[Last 14 Days Calendar]
Interactive Channel by Interaction Point PerformanceInteractive Channel by Interaction Point Performance SummaryInteractive Channel IDdecimalidentifier[Interactive Channel by IP Summary Star Schema].[Interactive Channel by IP Number of Times Presented][Interact Model].[Interactive Channel by IP Number of Times Presented].[Interactive Channel ID] 
Interactive ChannelcharacterLength16attribute[Interactive Channel by IP Summary Star Schema].[Interactive Channel by IP Number of Times Presented][Interact Model].[Interactive Channel by IP Number of Times Presented].[Interactive Channel] 
Interaction Point IDfloat64identifier[Interactive Channel by IP Summary Star Schema].[Interactive Channel by IP Number of Times Presented][Interact Model].[Interactive Channel by IP Number of Times Presented].[Interaction Point ID] 
Interaction PointcharacterLength16attribute[Interactive Channel by IP Summary Star Schema].[Interactive Channel by IP Number of Times Presented][Interact Model].[Interactive Channel by IP Number of Times Presented].[Interaction Point] 
Presentedfloat64factIF([Interactive Channel by IP Summary Star Schema].[Interactive Channel by IP Number of Times Presented][Interact Model].[Interactive Channel by IP Number of Times Presented].[Presented] is missing) THEN(0) ELSE([Interactive Channel by IP Summary Star Schema].[Interactive Channel by IP Number of Times Presented][Interact Model].[Interactive Channel by IP Number of Times Presented].[Presented]) 
Presented Model-Drivenfloat64factIF([Interactive Channel by IP Summary Star Schema].[Interactive Channel by IP Number of Times Presented][Interact Model].[Interactive Channel by IP Number of Times Presented].[Presented Model-Driven] is missing) THEN(0) ELSE([Interactive Channel by IP Summary Star Schema].[Interactive Channel by IP Number of Times Presented][Interact Model].[Interactive Channel by IP Number of Times Presented].[Presented Model-Driven]) 
Presented Randomfloat64factIF([Interactive Channel by IP Summary Star Schema].[Interactive Channel by IP Number of Times Presented][Interact Model].[Interactive Channel by IP Number of Times Presented].[Presented Random] is missing) THEN(0) ELSE([Interactive Channel by IP Summary Star Schema].[Interactive Channel by IP Number of Times Presented][Interact Model].[Interactive Channel by IP Number of Times Presented].[Presented Random]) 
Defaultedfloat64factIF([Interactive Channel by IP Summary Star Schema].[Interactive Channel by IP Times Defaulted][Interact Model].[Interactive Channel by IP Times Defaulted].[Defaulted] is missing) THEN(0) ELSE([Interactive Channel by IP Summary Star Schema].[Interactive Channel by IP Times Defaulted][Interact Model].[Interactive Channel by IP Times Defaulted].[Defaulted]) 
Acceptedfloat64factIF([Interactive Channel by IP Summary Star Schema].[Interactive Channel by IP Response History][Interact Model].[Interactive Channel by IP Response History].[Accepted] is missing) THEN(0) ELSE([Interactive Channel by IP Summary Star Schema].[Interactive Channel by IP Response History][Interact Model].[Interactive Channel by IP Response History].[Accepted]) 
Accepted Model-Drivenfloat64factIF([Interactive Channel by IP Summary Star Schema].[Interactive Channel by IP Response History][Interact Model].[Interactive Channel by IP Response History].[Accepted Model-Driven] is missing) THEN(0) ELSE([Interactive Channel by IP Summary Star Schema].[Interactive Channel by IP Response History][Interact Model].[Interactive Channel by IP Response History].[Accepted Model-Driven]) 
Accepted Randomfloat64factIF([Interactive Channel by IP Summary Star Schema].[Interactive Channel by IP Response History][Interact Model].[Interactive Channel by IP Response History].[Accepted Random] is missing) THEN(0) ELSE([Interactive Channel by IP Summary Star Schema].[Interactive Channel by IP Response History][Interact Model].[Interactive Channel by IP Response History].[Accepted Random]) 
Rejectedfloat64factIF([Interactive Channel by IP Summary Star Schema].[Interactive Channel by IP Response History][Interact Model].[Interactive Channel by IP Response History].[Rejected] is missing) THEN(0) ELSE([Interactive Channel by IP Summary Star Schema].[Interactive Channel by IP Response History][Interact Model].[Interactive Channel by IP Response History].[Rejected]) 
Interactive Channel by Interaction Point Performance Last 7 DaysInteractive Channel IDdecimalidentifier[Interactive Channel by IP by Day Star Schema].[InteractiveChannelToCalendar][Interact Model].[InteractiveChannelToCalendar].[Interactive Channel ID]  
Interactive ChannelcharacterLength16attribute[Interactive Channel by IP by Day Star Schema].[InteractiveChannelToCalendar][Interact Model].[InteractiveChannelToCalendar].[Interactive Channel]  
Interaction Point IDfloat64identifier[Interactive Channel by IP by Day Star Schema].[InteractiveChannelToCalendar][Interact Model].[InteractiveChannelToCalendar].[Interaction Point ID]  
Interaction PointcharacterLength16attribute[Interactive Channel by IP by Day Star Schema].[InteractiveChannelToCalendar][Interact Model].[InteractiveChannelToCalendar].[Interaction Point]  
Actual DatedateTimeidentifier[Interactive Channel by IP by Day Star Schema].[InteractiveChannelToCalendar][Interact Model].[InteractiveChannelToCalendar].[Actual Date]  
Presentedfloat64factIF([Interactive Channel by IP by Day Star Schema].[Interactive Channel by IP Number of Times Presented by Day][Interact Model].[Interactive Channel by IP Number of Times Presented by Day].[Presented] is missing) THEN(0) ELSE([Interactive Channel by IP by Day Star Schema].[Interactive Channel by IP Number of Times Presented by Day][Interact Model].[Interactive Channel by IP Number of Times Presented by Day].[Presented]) 
Presented Model-Drivenfloat64factIF([Interactive Channel by IP by Day Star Schema].[Interactive Channel by IP Number of Times Presented by Day][Interact Model].[Interactive Channel by IP Number of Times Presented by Day].[Presented Model-Driven] is missing) THEN(0) ELSE([Interactive Channel by IP by Day Star Schema].[Interactive Channel by IP Number of Times Presented by Day][Interact Model].[Interactive Channel by IP Number of Times Presented by Day].[Presented Model-Driven]) 
Presented Randomfloat64factIF([Interactive Channel by IP by Day Star Schema].[Interactive Channel by IP Number of Times Presented by Day][Interact Model].[Interactive Channel by IP Number of Times Presented by Day].[Presented Random] is missing) THEN(0) ELSE([Interactive Channel by IP by Day Star Schema].[Interactive Channel by IP Number of Times Presented by Day][Interact Model].[Interactive Channel by IP Number of Times Presented by Day].[Presented Random]) 
Acceptedfloat64factIF([Interactive Channel by IP by Day Star Schema].[Interactive Channel by IP Response History by Day][Interact Model].[Interactive Channel by IP Response History by Day].[Accepted] is missing) THEN(0) ELSE([Interactive Channel by IP by Day Star Schema].[Interactive Channel by IP Response History by Day][Interact Model].[Interactive Channel by IP Response History by Day].[Accepted]) 
Accepted Model-Drivenfloat64factIF([Interactive Channel by IP by Day Star Schema].[Interactive Channel by IP Response History by Day][Interact Model].[Interactive Channel by IP Response History by Day].[Accepted Model-Driven] is missing) THEN(0) ELSE([Interactive Channel by IP by Day Star Schema].[Interactive Channel by IP Response History by Day][Interact Model].[Interactive Channel by IP Response History by Day].[Accepted Model-Driven]) 
Accepted Randomfloat64factIF([Interactive Channel by IP by Day Star Schema].[Interactive Channel by IP Response History by Day][Interact Model].[Interactive Channel by IP Response History by Day].[Accepted Random] is missing) THEN(0) ELSE([Interactive Channel by IP by Day Star Schema].[Interactive Channel by IP Response History by Day][Interact Model].[Interactive Channel by IP Response History by Day].[Accepted Random]) 
Rejectedfloat64factIF([Interactive Channel by IP by Day Star Schema].[Interactive Channel by IP Response History by Day][Interact Model].[Interactive Channel by IP Response History by Day].[Rejected] is missing) THEN(0) ELSE([Interactive Channel by IP by Day Star Schema].[Interactive Channel by IP Response History by Day][Interact Model].[Interactive Channel by IP Response History by Day].[Rejected]) 
Interactive Channel by Interaction Point Performance Last 24 HoursInteractive Channel IDdecimalidentifier[Interactive Channel by IP by Hour Star Schema].[Interactive Channel - Last 24 Hours Lookup][Interact Model].[Interactive Channel - Last 24 Hours Lookup].[Interactive Channel ID]  
Interactive ChannelcharacterLength16attribute[Interactive Channel by IP by Hour Star Schema].[Interactive Channel - Last 24 Hours Lookup][Interact Model].[Interactive Channel - Last 24 Hours Lookup].[Interactive Channel]  
Interaction Point IDfloat64identifier[Interactive Channel by IP by Hour Star Schema].[Interactive Channel - Last 24 Hours Lookup][Interact Model].[Interactive Channel - Last 24 Hours Lookup].[Interaction Point ID]  
Interaction PointcharacterLength16attribute[Interactive Channel by IP by Hour Star Schema].[Interactive Channel - Last 24 Hours Lookup][Interact Model].[Interactive Channel - Last 24 Hours Lookup].[Interaction Point]  
Hourfloat64identifier[Interactive Channel by IP by Hour Star Schema].[Interactive Channel - Last 24 Hours Lookup][Interact Model].[Interactive Channel - Last 24 Hours Lookup].[Hour]  
Actual DatedateTimeidentifier[Interactive Channel by IP by Hour Star Schema].[Interactive Channel - Last 24 Hours Lookup][Interact Model].[Interactive Channel - Last 24 Hours Lookup].[Actual Date]  
Presentedfloat64factIF([Interactive Channel by IP by Hour Star Schema].[Interactive Channel by IP Number of Times Presented by Hour][Interact Model].[Interactive Channel by IP Number of Times Presented by Hour].[Presented] is missing) THEN(0) ELSE([Interactive Channel by IP by Hour Star Schema].[Interactive Channel by IP Number of Times Presented by Hour][Interact Model].[Interactive Channel by IP Number of Times Presented by Hour].[Presented]) 
Presented Model-Drivenfloat64factIF([Interactive Channel by IP by Hour Star Schema].[Interactive Channel by IP Number of Times Presented by Hour][Interact Model].[Interactive Channel by IP Number of Times Presented by Hour].[Presented Model-Driven] is missing) THEN(0) ELSE([Interactive Channel by IP by Hour Star Schema].[Interactive Channel by IP Number of Times Presented by Hour][Interact Model].[Interactive Channel by IP Number of Times Presented by Hour].[Presented Model-Driven]) 
Presented Randomfloat64factIF([Interactive Channel by IP by Hour Star Schema].[Interactive Channel by IP Number of Times Presented by Hour][Interact Model].[Interactive Channel by IP Number of Times Presented by Hour].[Presented Random] is missing) THEN(0) ELSE([Interactive Channel by IP by Hour Star Schema].[Interactive Channel by IP Number of Times Presented by Hour][Interact Model].[Interactive Channel by IP Number of Times Presented by Hour].[Presented Random]) 
Acceptedfloat64factIF([Interactive Channel by IP by Hour Star Schema].[Interactive Channel by IP Response History by Hour][Interact Model].[Interactive Channel by IP Response History by Hour].[Accepted] is missing) THEN(0) ELSE([Interactive Channel by IP by Hour Star Schema].[Interactive Channel by IP Response History by Hour][Interact Model].[Interactive Channel by IP Response History by Hour].[Accepted]) 
Accepted Model-Drivenfloat64factIF([Interactive Channel by IP by Hour Star Schema].[Interactive Channel by IP Response History by Hour][Interact Model].[Interactive Channel by IP Response History by Hour].[Accepted Model-Driven] is missing) THEN(0) ELSE([Interactive Channel by IP by Hour Star Schema].[Interactive Channel by IP Response History by Hour][Interact Model].[Interactive Channel by IP Response History by Hour].[Accepted Model-Driven]) 
Accepted Randomfloat64factIF([Interactive Channel by IP by Hour Star Schema].[Interactive Channel by IP Response History by Hour][Interact Model].[Interactive Channel by IP Response History by Hour].[Accepted Random] is missing) THEN(0) ELSE([Interactive Channel by IP by Hour Star Schema].[Interactive Channel by IP Response History by Hour][Interact Model].[Interactive Channel by IP Response History by Hour].[Accepted Random]) 
Rejectedfloat64factIF([Interactive Channel by IP by Hour Star Schema].[Interactive Channel by IP Response History by Hour][Interact Model].[Interactive Channel by IP Response History by Hour].[Rejected] is missing) THEN(0) ELSE([Interactive Channel by IP by Hour Star Schema].[Interactive Channel by IP Response History by Hour][Interact Model].[Interactive Channel by IP Response History by Hour].[Rejected]) 
Namespace/FolderQuery SubjectQuery ItemTypeUsageRef Obj/Expr.
DashboardDashboard Interactive Channel by Interaction Point Performance Last 7 DaysInteractive Channel IDdecimalidentifier[Interactive Channel by IP by Day Star Schema].[InteractiveChannelToCalendar][Interact Model].[InteractiveChannelToCalendar].[Interactive Channel ID]  
Interactive ChannelcharacterLength16attribute[Interactive Channel by IP by Day Star Schema].[InteractiveChannelToCalendar][Interact Model].[InteractiveChannelToCalendar].[Interactive Channel]  
Interaction Point IDfloat64identifier[Interactive Channel by IP by Day Star Schema].[InteractiveChannelToCalendar][Interact Model].[InteractiveChannelToCalendar].[Interaction Point ID]  
Interaction PointcharacterLength16attribute[Interactive Channel by IP by Day Star Schema].[InteractiveChannelToCalendar][Interact Model].[InteractiveChannelToCalendar].[Interaction Point]  
Actual DatedateTimeidentifier[Interactive Channel by IP by Day Star Schema].[InteractiveChannelToCalendar][Interact Model].[InteractiveChannelToCalendar].[Actual Date]  
Presentedfloat64factIF([Interactive Channel by IP by Day Star Schema].[Interactive Channel by IP Number of Times Presented by Day][Interact Model].[Interactive Channel by IP Number of Times Presented by Day].[Presented] is missing) THEN(0) ELSE([Interactive Channel by IP by Day Star Schema].[Interactive Channel by IP Number of Times Presented by Day][Interact Model].[Interactive Channel by IP Number of Times Presented by Day].[Presented]) 
Presented Model-Drivenfloat64factIF([Interactive Channel by IP by Day Star Schema].[Interactive Channel by IP Number of Times Presented by Day][Interact Model].[Interactive Channel by IP Number of Times Presented by Day].[Presented Model-Driven] is missing) THEN(0) ELSE([Interactive Channel by IP by Day Star Schema].[Interactive Channel by IP Number of Times Presented by Day][Interact Model].[Interactive Channel by IP Number of Times Presented by Day].[Presented Model-Driven]) 
Presented Randomfloat64factIF([Interactive Channel by IP by Day Star Schema].[Interactive Channel by IP Number of Times Presented by Day][Interact Model].[Interactive Channel by IP Number of Times Presented by Day].[Presented Random] is missing) THEN(0) ELSE([Interactive Channel by IP by Day Star Schema].[Interactive Channel by IP Number of Times Presented by Day][Interact Model].[Interactive Channel by IP Number of Times Presented by Day].[Presented Random]) 
Acceptedfloat64factIF([Interactive Channel by IP by Day Star Schema].[Interactive Channel by IP Response History by Day][Interact Model].[Interactive Channel by IP Response History by Day].[Accepted] is missing) THEN(0) ELSE([Interactive Channel by IP by Day Star Schema].[Interactive Channel by IP Response History by Day][Interact Model].[Interactive Channel by IP Response History by Day].[Accepted]) 
Accepted Model-Drivenfloat64factIF([Interactive Channel by IP by Day Star Schema].[Interactive Channel by IP Response History by Day][Interact Model].[Interactive Channel by IP Response History by Day].[Accepted Model-Driven] is missing) THEN(0) ELSE([Interactive Channel by IP by Day Star Schema].[Interactive Channel by IP Response History by Day][Interact Model].[Interactive Channel by IP Response History by Day].[Accepted Model-Driven]) 
Accepted Randomfloat64factIF([Interactive Channel by IP by Day Star Schema].[Interactive Channel by IP Response History by Day][Interact Model].[Interactive Channel by IP Response History by Day].[Accepted Random] is missing) THEN(0) ELSE([Interactive Channel by IP by Day Star Schema].[Interactive Channel by IP Response History by Day][Interact Model].[Interactive Channel by IP Response History by Day].[Accepted Random]) 
Rejectedfloat64factIF([Interactive Channel by IP by Day Star Schema].[Interactive Channel by IP Response History by Day][Interact Model].[Interactive Channel by IP Response History by Day].[Rejected] is missing) THEN(0) ELSE([Interactive Channel by IP by Day Star Schema].[Interactive Channel by IP Response History by Day][Interact Model].[Interactive Channel by IP Response History by Day].[Rejected]) 
Campaign by Cell PerformanceCampaign Cell Performance SummaryCampaign IDdecimalidentifier[Campaign Cell Performance Summary Star Schema].[Campaign Cell Performance Elig Opps][Interact Model].[Campaign Cell Performance Elig Opps].[Campaign ID] 
Campaign NamecharacterLength16attribute[Campaign Cell Performance Summary Star Schema].[Campaign][Interact Model].[Campaign].[Campaign Name] 
Campaign CodecharacterLength16attribute[Campaign Cell Performance Summary Star Schema].[Campaign][Interact Model].[Campaign].[Campaign Code] 
Cell IDdecimalidentifier[Campaign Cell Performance Summary Star Schema].[Campaign Cell Performance Elig Opps][Interact Model].[Campaign Cell Performance Elig Opps].[Cell ID] 
Cell NamecharacterLength16attribute[Campaign Cell Performance Summary Star Schema].[Cells][Interact Model].[Cells].[Cell Name] 
Cell CodecharacterLength16attribute[Campaign Cell Performance Summary Star Schema].[Cells][Interact Model].[Cells].[Cell Code] 
Presentedfloat64factIF([Campaign Cell Performance Summary Star Schema].[Campaign Cell Performance Number of Times Presented][Interact Model].[Campaign Cell Performance Number of Times Presented].[Presented] is missing) THEN(0) ELSE([Campaign Cell Performance Summary Star Schema].[Campaign Cell Performance Number of Times Presented][Interact Model].[Campaign Cell Performance Number of Times Presented].[Presented]) 
Presented Model-Drivenfloat64factIF([Campaign Cell Performance Summary Star Schema].[Campaign Cell Performance Number of Times Presented][Interact Model].[Campaign Cell Performance Number of Times Presented].[Presented Model-Driven] is missing) THEN(0) ELSE([Campaign Cell Performance Summary Star Schema].[Campaign Cell Performance Number of Times Presented][Interact Model].[Campaign Cell Performance Number of Times Presented].[Presented Model-Driven]) 
Presented Randomfloat64factIF([Campaign Cell Performance Summary Star Schema].[Campaign Cell Performance Number of Times Presented][Interact Model].[Campaign Cell Performance Number of Times Presented].[Presented Random] is missing) THEN (0) ELSE([Campaign Cell Performance Summary Star Schema].[Campaign Cell Performance Number of Times Presented][Interact Model].[Campaign Cell Performance Number of Times Presented].[Presented Random]) 
Eligible Opportunitiesfloat64factIF([Campaign Cell Performance Summary Star Schema].[Campaign Cell Performance Elig Opps][Interact Model].[Campaign Cell Performance Elig Opps].[Eligible Opportunities] is missing) THEN(0) ELSE([Campaign Cell Performance Summary Star Schema].[Campaign Cell Performance Elig Opps][Interact Model].[Campaign Cell Performance Elig Opps].[Eligible Opportunities]) 
Acceptedfloat64factIF([Campaign Cell Performance Summary Star Schema].[Campaign Cell Performance Response History][Interact Model].[Campaign Cell Performance Response History].[Accepted] is missing) THEN(0) ELSE([Campaign Cell Performance Summary Star Schema].[Campaign Cell Performance Response History][Interact Model].[Campaign Cell Performance Response History].[Accepted]) 
Accepted Model-Drivenfloat64factIF([Campaign Cell Performance Summary Star Schema].[Campaign Cell Performance Response History][Interact Model].[Campaign Cell Performance Response History].[Accepted Model-Driven] is missing) THEN(0) ELSE([Campaign Cell Performance Summary Star Schema].[Campaign Cell Performance Response History][Interact Model].[Campaign Cell Performance Response History].[Accepted Model-Driven]) 
Accepted Randomfloat64factIF([Campaign Cell Performance Summary Star Schema].[Campaign Cell Performance Response History][Interact Model].[Campaign Cell Performance Response History].[Accepted Random] is missing) THEN(0) ELSE([Campaign Cell Performance Summary Star Schema].[Campaign Cell Performance Response History][Interact Model].[Campaign Cell Performance Response History].[Accepted Random]) 
Rejectedfloat64factIF([Campaign Cell Performance Summary Star Schema].[Campaign Cell Performance Response History][Interact Model].[Campaign Cell Performance Response History].[Rejected] is missing) THEN(0) ELSE([Campaign Cell Performance Summary Star Schema].[Campaign Cell Performance Response History][Interact Model].[Campaign Cell Performance Response History].[Rejected]) 
Campaign Cell Performance by Last 7 DaysCampaign IDdecimalidentifier[Campaign Cell Performance by Day Star Schema].[Campaign Cell Performance Elig Opps by Day][Interact Model].[Campaign Cell Performance Elig Opps by Day].[Campaign ID] 
Campaign NamecharacterLength16attribute[Campaign Cell Performance by Day Star Schema].[Campaign][Interact Model].[Campaign].[Campaign Name] 
Campaign CodecharacterLength16attribute[Campaign Cell Performance by Day Star Schema].[Campaign][Interact Model].[Campaign].[Campaign Code] 
Cell IDdecimalidentifier[Campaign Cell Performance by Day Star Schema].[CellToCalendar][Interact Model].[CellToCalendar].[Cell ID]  
Cell NamecharacterLength16attribute[Campaign Cell Performance by Day Star Schema].[CellToCalendar][Interact Model].[CellToCalendar].[Cell Name]  
Cell CodecharacterLength16attribute[Campaign Cell Performance by Day Star Schema].[CellToCalendar][Interact Model].[CellToCalendar].[Cell Code]  
Actual DatedateTimeidentifier[Campaign Cell Performance by Day Star Schema].[CellToCalendar][Interact Model].[CellToCalendar].[Actual Date]  
Presentedfloat64factIF([Campaign Cell Performance by Day Star Schema].[Campaign Cell Number of Times Presented by Day][Interact Model].[Campaign Cell Number of Times Presented by Day].[Presented] is missing) THEN(0) ELSE([Campaign Cell Performance by Day Star Schema].[Campaign Cell Number of Times Presented by Day][Interact Model].[Campaign Cell Number of Times Presented by Day].[Presented]) 
Presented Model-Drivenfloat64factIF([Campaign Cell Performance by Day Star Schema].[Campaign Cell Number of Times Presented by Day][Interact Model].[Campaign Cell Number of Times Presented by Day].[Presented Model-Driven] is missing) THEN(0) ELSE([Campaign Cell Performance by Day Star Schema].[Campaign Cell Number of Times Presented by Day][Interact Model].[Campaign Cell Number of Times Presented by Day].[Presented Model-Driven]) 
Presented Randomfloat64factIF([Campaign Cell Performance by Day Star Schema].[Campaign Cell Number of Times Presented by Day][Interact Model].[Campaign Cell Number of Times Presented by Day].[Presented Random] is missing) THEN(0) ELSE([Campaign Cell Performance by Day Star Schema].[Campaign Cell Number of Times Presented by Day][Interact Model].[Campaign Cell Number of Times Presented by Day].[Presented Random]) 
Eligible Opportunitiesfloat64factIF([Campaign Cell Performance by Day Star Schema].[Campaign Cell Performance Elig Opps by Day][Interact Model].[Campaign Cell Performance Elig Opps by Day].[Eligible Opportunities] is missing) THEN(0) ELSE([Campaign Cell Performance by Day Star Schema].[Campaign Cell Performance Elig Opps by Day][Interact Model].[Campaign Cell Performance Elig Opps by Day].[Eligible Opportunities]) 
Acceptedfloat64factIF([Campaign Cell Performance by Day Star Schema].[Campaign Cell Performance Response History by Day][Interact Model].[Campaign Cell Performance Response History by Day].[Accepted] is missing) THEN(0) ELSE([Campaign Cell Performance by Day Star Schema].[Campaign Cell Performance Response History by Day][Interact Model].[Campaign Cell Performance Response History by Day].[Accepted]) 
Accepted Model-Drivenfloat64factIF([Campaign Cell Performance by Day Star Schema].[Campaign Cell Performance Response History by Day][Interact Model].[Campaign Cell Performance Response History by Day].[Accepted Model-Driven] is missing) THEN(0) ELSE([Campaign Cell Performance by Day Star Schema].[Campaign Cell Performance Response History by Day][Interact Model].[Campaign Cell Performance Response History by Day].[Accepted Model-Driven]) 
Accepted Randomfloat64factIF([Campaign Cell Performance by Day Star Schema].[Campaign Cell Performance Response History by Day][Interact Model].[Campaign Cell Performance Response History by Day].[Accepted Random] is missing) THEN(0) ELSE([Campaign Cell Performance by Day Star Schema].[Campaign Cell Performance Response History by Day][Interact Model].[Campaign Cell Performance Response History by Day].[Accepted Random]) 
Rejectedfloat64factIF([Campaign Cell Performance by Day Star Schema].[Campaign Cell Performance Response History by Day][Interact Model].[Campaign Cell Performance Response History by Day].[Rejected] is missing) THEN(0) ELSE([Campaign Cell Performance by Day Star Schema].[Campaign Cell Performance Response History by Day][Interact Model].[Campaign Cell Performance Response History by Day].[Rejected]) 
Campaign Cell Performance by Last 24 HoursCampaign IDdecimalidentifier[Campaign Cell Performance by Hour Star Schema].[Campaign Cell Performance Elig Opps by Hour][Interact Model].[Campaign Cell Performance Elig Opps by Hour].[Campaign ID] 
Campaign NamecharacterLength16attribute[Campaign Cell Performance by Hour Star Schema].[Campaign][Interact Model].[Campaign].[Campaign Name] 
Campaign CodecharacterLength16attribute[Campaign Cell Performance by Hour Star Schema].[Campaign][Interact Model].[Campaign].[Campaign Code] 
Cell IDdecimalidentifier[Campaign Cell Performance by Hour Star Schema].[Cell - Last 24 Hours Lookup][Interact Model].[Cell - Last 24 Hours Lookup].[Cell ID]  
Cell NamecharacterLength16attribute[Campaign Cell Performance by Hour Star Schema].[Cell - Last 24 Hours Lookup][Interact Model].[Cell - Last 24 Hours Lookup].[Cell Name]  
Cell CodecharacterLength16attribute[Campaign Cell Performance by Hour Star Schema].[Cell - Last 24 Hours Lookup][Interact Model].[Cell - Last 24 Hours Lookup].[Cell Code]  
Hourfloat64identifier[Campaign Cell Performance by Hour Star Schema].[Cell - Last 24 Hours Lookup][Interact Model].[Cell - Last 24 Hours Lookup].[Hour]  
Actual DatedateTimeidentifier[Campaign Cell Performance by Hour Star Schema].[Cell - Last 24 Hours Lookup][Interact Model].[Cell - Last 24 Hours Lookup].[Actual Date]  
Presentedfloat64factIF([Campaign Cell Performance by Hour Star Schema].[Campaign Cell Number of Times Presented by Hour][Interact Model].[Campaign Cell Number of Times Presented by Hour].[Presented] is missing) THEN(0) ELSE([Campaign Cell Performance by Hour Star Schema].[Campaign Cell Number of Times Presented by Hour][Interact Model].[Campaign Cell Number of Times Presented by Hour].[Presented]) 
Presented Model-Drivenfloat64factIF([Campaign Cell Performance by Hour Star Schema].[Campaign Cell Number of Times Presented by Hour][Interact Model].[Campaign Cell Number of Times Presented by Hour].[Presented Model-Driven] is missing) THEN(0) ELSE([Campaign Cell Performance by Hour Star Schema].[Campaign Cell Number of Times Presented by Hour][Interact Model].[Campaign Cell Number of Times Presented by Hour].[Presented Model-Driven]) 
Presented Randomfloat64factIF([Campaign Cell Performance by Hour Star Schema].[Campaign Cell Number of Times Presented by Hour][Interact Model].[Campaign Cell Number of Times Presented by Hour].[Presented Random] is missing) THEN(0) ELSE([Campaign Cell Performance by Hour Star Schema].[Campaign Cell Number of Times Presented by Hour][Interact Model].[Campaign Cell Number of Times Presented by Hour].[Presented Random]) 
Eligible Opportunitiesfloat64factIF([Campaign Cell Performance by Hour Star Schema].[Campaign Cell Performance Elig Opps by Hour][Interact Model].[Campaign Cell Performance Elig Opps by Hour].[Eligible Opportunities] is missing) THEN(0) ELSE([Campaign Cell Performance by Hour Star Schema].[Campaign Cell Performance Elig Opps by Hour][Interact Model].[Campaign Cell Performance Elig Opps by Hour].[Eligible Opportunities]) 
Acceptedfloat64factIF([Campaign Cell Performance by Hour Star Schema].[Campaign Cell Performance Response History by Hour][Interact Model].[Campaign Cell Performance Response History by Hour].[Accepted] is missing) THEN(0) ELSE([Campaign Cell Performance by Hour Star Schema].[Campaign Cell Performance Response History by Hour][Interact Model].[Campaign Cell Performance Response History by Hour].[Accepted]) 
Accepted Model-Drivenfloat64factIF([Campaign Cell Performance by Hour Star Schema].[Campaign Cell Performance Response History by Hour][Interact Model].[Campaign Cell Performance Response History by Hour].[Accepted Model-Driven] is missing) THEN(0) ELSE([Campaign Cell Performance by Hour Star Schema].[Campaign Cell Performance Response History by Hour][Interact Model].[Campaign Cell Performance Response History by Hour].[Accepted Model-Driven]) 
Accepted Randomfloat64factIF([Campaign Cell Performance by Hour Star Schema].[Campaign Cell Performance Response History by Hour][Interact Model].[Campaign Cell Performance Response History by Hour].[Accepted Random] is missing) THEN(0) ELSE([Campaign Cell Performance by Hour Star Schema].[Campaign Cell Performance Response History by Hour][Interact Model].[Campaign Cell Performance Response History by Hour].[Accepted Random]) 
Rejectedfloat64factIF([Campaign Cell Performance by Hour Star Schema].[Campaign Cell Performance Response History by Hour][Interact Model].[Campaign Cell Performance Response History by Hour].[Rejected] is missing) THEN(0) ELSE([Campaign Cell Performance by Hour Star Schema].[Campaign Cell Performance Response History by Hour][Interact Model].[Campaign Cell Performance Response History by Hour].[Rejected]) 
Campaign Cell Performance by HourCampaign IDdecimalidentifier[Campaign Cell Performance by Hour Star Schema].[Campaign Cell Performance Elig Opps by Hour][Interact Model].[Campaign Cell Performance Elig Opps by Hour].[Campaign ID] 
Campaign NamecharacterLength16attribute[Campaign Cell Performance by Hour Star Schema].[Campaign][Interact Model].[Campaign].[Campaign Name] 
Campaign CodecharacterLength16attribute[Campaign Cell Performance by Hour Star Schema].[Campaign][Interact Model].[Campaign].[Campaign Code] 
Cell IDdecimalidentifier[Campaign Cell Performance by Hour Star Schema].[Campaign Cell Performance Elig Opps by Hour][Interact Model].[Campaign Cell Performance Elig Opps by Hour].[Cell ID] 
Cell NamecharacterLength16attribute[Campaign Cell Performance by Hour Star Schema].[Cells][Interact Model].[Cells].[Cell Name] 
Cell CodecharacterLength16attribute[Campaign Cell Performance by Hour Star Schema].[Cells][Interact Model].[Cells].[Cell Code] 
Actual DatedateTimeidentifier[Campaign Cell Performance by Hour Star Schema].[Campaign Cell Performance Elig Opps by Hour][Interact Model].[Campaign Cell Performance Elig Opps by Hour].[Actual Date] 
Hourint64identifier[Campaign Cell Performance by Hour Star Schema].[Campaign Cell Performance Elig Opps by Hour][Interact Model].[Campaign Cell Performance Elig Opps by Hour].[Hour] 
Presentedfloat64factIF([Campaign Cell Performance by Hour Star Schema].[Campaign Cell Number of Times Presented by Hour][Interact Model].[Campaign Cell Number of Times Presented by Hour].[Presented] is missing) THEN(0) ELSE([Campaign Cell Performance by Hour Star Schema].[Campaign Cell Number of Times Presented by Hour][Interact Model].[Campaign Cell Number of Times Presented by Hour].[Presented]) 
Presented Model-Drivenfloat64factIF([Campaign Cell Performance by Hour Star Schema].[Campaign Cell Number of Times Presented by Hour][Interact Model].[Campaign Cell Number of Times Presented by Hour].[Presented Model-Driven] is missing) THEN(0) ELSE([Campaign Cell Performance by Hour Star Schema].[Campaign Cell Number of Times Presented by Hour][Interact Model].[Campaign Cell Number of Times Presented by Hour].[Presented Model-Driven]) 
Presented Randomfloat64factIF([Campaign Cell Performance by Hour Star Schema].[Campaign Cell Number of Times Presented by Hour][Interact Model].[Campaign Cell Number of Times Presented by Hour].[Presented Random] is missing) THEN(0) ELSE([Campaign Cell Performance by Hour Star Schema].[Campaign Cell Number of Times Presented by Hour][Interact Model].[Campaign Cell Number of Times Presented by Hour].[Presented Random]) 
Eligible Opportunitiesfloat64factIF([Campaign Cell Performance by Hour Star Schema].[Campaign Cell Performance Elig Opps by Hour][Interact Model].[Campaign Cell Performance Elig Opps by Hour].[Eligible Opportunities] is missing) THEN(0) ELSE([Campaign Cell Performance by Hour Star Schema].[Campaign Cell Performance Elig Opps by Hour][Interact Model].[Campaign Cell Performance Elig Opps by Hour].[Eligible Opportunities]) 
Acceptedfloat64factIF([Campaign Cell Performance by Hour Star Schema].[Campaign Cell Performance Response History by Hour][Interact Model].[Campaign Cell Performance Response History by Hour].[Accepted] is missing) THEN(0) ELSE([Campaign Cell Performance by Hour Star Schema].[Campaign Cell Performance Response History by Hour][Interact Model].[Campaign Cell Performance Response History by Hour].[Accepted]) 
Accepted Model-Drivenfloat64factIF([Campaign Cell Performance by Hour Star Schema].[Campaign Cell Performance Response History by Hour][Interact Model].[Campaign Cell Performance Response History by Hour].[Accepted Model-Driven] is missing) THEN(0) ELSE([Campaign Cell Performance by Hour Star Schema].[Campaign Cell Performance Response History by Hour][Interact Model].[Campaign Cell Performance Response History by Hour].[Accepted Model-Driven]) 
Accepted Randomfloat64factIF([Campaign Cell Performance by Hour Star Schema].[Campaign Cell Performance Response History by Hour][Interact Model].[Campaign Cell Performance Response History by Hour].[Accepted Random] is missing) THEN(0) ELSE([Campaign Cell Performance by Hour Star Schema].[Campaign Cell Performance Response History by Hour][Interact Model].[Campaign Cell Performance Response History by Hour].[Accepted Random]) 
Rejectedfloat64factIF([Campaign Cell Performance by Hour Star Schema].[Campaign Cell Performance Response History by Hour][Interact Model].[Campaign Cell Performance Response History by Hour].[Rejected] is missing) THEN(0) ELSE([Campaign Cell Performance by Hour Star Schema].[Campaign Cell Performance Response History by Hour][Interact Model].[Campaign Cell Performance Response History by Hour].[Rejected]) 
Campaign Cell Performance by Last 14 DaysCampaign IDdecimalidentifier[Campaign Cell Performance by Day Star Schema].[Campaign Cell Performance Elig Opps by Day][Interact Model].[Campaign Cell Performance Elig Opps by Day].[Campaign ID] 
Campaign NamecharacterLength16attribute[Campaign Cell Performance by Day Star Schema].[Campaign][Interact Model].[Campaign].[Campaign Name] 
Campaign CodecharacterLength16attribute[Campaign Cell Performance by Day Star Schema].[Campaign][Interact Model].[Campaign].[Campaign Code] 
Cell IDdecimalidentifier[Campaign Cell Performance by Day Star Schema].[CellToCalendar][Interact Model].[CellToCalendar].[Cell ID]  
Cell NamecharacterLength16attribute[Campaign Cell Performance by Day Star Schema].[CellToCalendar][Interact Model].[CellToCalendar].[Cell Name]  
Cell CodecharacterLength16attribute[Campaign Cell Performance by Day Star Schema].[CellToCalendar][Interact Model].[CellToCalendar].[Cell Code]  
Actual DatedateTimeidentifier[Campaign Cell Performance by Day Star Schema].[CellToCalendar][Interact Model].[CellToCalendar].[Actual Date]  
Presentedfloat64factIF([Campaign Cell Performance by Day Star Schema].[Campaign Cell Number of Times Presented by Day][Interact Model].[Campaign Cell Number of Times Presented by Day].[Presented] is missing) THEN(0) ELSE([Campaign Cell Performance by Day Star Schema].[Campaign Cell Number of Times Presented by Day][Interact Model].[Campaign Cell Number of Times Presented by Day].[Presented]) 
Presented Model-Drivenfloat64factIF([Campaign Cell Performance by Day Star Schema].[Campaign Cell Number of Times Presented by Day][Interact Model].[Campaign Cell Number of Times Presented by Day].[Presented Model-Driven] is missing) THEN(0) ELSE([Campaign Cell Performance by Day Star Schema].[Campaign Cell Number of Times Presented by Day][Interact Model].[Campaign Cell Number of Times Presented by Day].[Presented Model-Driven]) 
Presented Randomfloat64factIF([Campaign Cell Performance by Day Star Schema].[Campaign Cell Number of Times Presented by Day][Interact Model].[Campaign Cell Number of Times Presented by Day].[Presented Random] is missing) THEN(0) ELSE([Campaign Cell Performance by Day Star Schema].[Campaign Cell Number of Times Presented by Day][Interact Model].[Campaign Cell Number of Times Presented by Day].[Presented Random]) 
Eligible Opportunitiesfloat64factIF([Campaign Cell Performance by Day Star Schema].[Campaign Cell Performance Elig Opps by Day][Interact Model].[Campaign Cell Performance Elig Opps by Day].[Eligible Opportunities] is missing) THEN(0) ELSE([Campaign Cell Performance by Day Star Schema].[Campaign Cell Performance Elig Opps by Day][Interact Model].[Campaign Cell Performance Elig Opps by Day].[Eligible Opportunities]) 
Acceptedfloat64factIF([Campaign Cell Performance by Day Star Schema].[Campaign Cell Performance Response History by Day][Interact Model].[Campaign Cell Performance Response History by Day].[Accepted] is missing) THEN(0) ELSE([Campaign Cell Performance by Day Star Schema].[Campaign Cell Performance Response History by Day][Interact Model].[Campaign Cell Performance Response History by Day].[Accepted]) 
Accepted Model-Drivenfloat64factIF([Campaign Cell Performance by Day Star Schema].[Campaign Cell Performance Response History by Day][Interact Model].[Campaign Cell Performance Response History by Day].[Accepted Model-Driven] is missing) THEN(0) ELSE([Campaign Cell Performance by Day Star Schema].[Campaign Cell Performance Response History by Day][Interact Model].[Campaign Cell Performance Response History by Day].[Accepted Model-Driven]) 
Accepted Randomfloat64factIF([Campaign Cell Performance by Day Star Schema].[Campaign Cell Performance Response History by Day][Interact Model].[Campaign Cell Performance Response History by Day].[Accepted Random] is missing) THEN(0) ELSE([Campaign Cell Performance by Day Star Schema].[Campaign Cell Performance Response History by Day][Interact Model].[Campaign Cell Performance Response History by Day].[Accepted Random]) 
Rejectedfloat64factIF([Campaign Cell Performance by Day Star Schema].[Campaign Cell Performance Response History by Day][Interact Model].[Campaign Cell Performance Response History by Day].[Rejected] is missing) THEN(0) ELSE([Campaign Cell Performance by Day Star Schema].[Campaign Cell Performance Response History by Day][Interact Model].[Campaign Cell Performance Response History by Day].[Rejected]) 
Namespace/FolderQuery SubjectQuery ItemTypeUsageRef Obj/Expr.
Cumulative Campaign Cell Performance by Day
model/Cumulative Campaign Cell Performance by Day.jpg
Campaign (shortcut) [Interact Model].[Campaign]
Cells (shortcut) [Interact Model].[Cells]
Cumulative Campaign Cell Number of Times Presented by Day (shortcut) [Interact Model].[Cumulative Campaign Cell Number of Times Presented by Day]
Cumulative Campaign Cell Performance Response History by Day (shortcut) [Interact Model].[Cumulative Campaign Cell Performance Response History by Day]
Last 14 Days Calendar (shortcut) [Interact Model].[Last 14 Days Calendar]
Campaign by Cell by Offer PerformanceCampaign by Cell by Offer Performance SummaryCampaign IDdecimalidentifier[Campaign Cell by Offer Performance Star Schema].[Campaign Cell by Offer Elig Opps][Interact Model].[Campaign Cell by Offer Elig Opps].[Campaign ID] 
Campaign NamecharacterLength16attribute[Campaign Cell by Offer Performance Star Schema].[Campaign][Interact Model].[Campaign].[Campaign Name] 
Campaign CodecharacterLength16attribute[Campaign Cell by Offer Performance Star Schema].[Campaign][Interact Model].[Campaign].[Campaign Code] 
Cell IDdecimalidentifier[Campaign Cell by Offer Performance Star Schema].[Campaign Cell by Offer Elig Opps][Interact Model].[Campaign Cell by Offer Elig Opps].[Cell ID] 
Cell NamecharacterLength16attribute[Campaign Cell by Offer Performance Star Schema].[Cells][Interact Model].[Cells].[Cell Name] 
Cell CodecharacterLength16attribute[Campaign Cell by Offer Performance Star Schema].[Cells][Interact Model].[Cells].[Cell Code] 
Offer IDdecimalidentifier[Campaign Cell by Offer Performance Star Schema].[Campaign Cell by Offer Elig Opps][Interact Model].[Campaign Cell by Offer Elig Opps].[Offer ID] 
Offer NamecharacterLength16attribute[Campaign Cell by Offer Performance Star Schema].[Offer][Interact Model].[Offer].[Offer Name] 
Offer Code 1characterLength16attribute[Campaign Cell by Offer Performance Star Schema].[Offer][Interact Model].[Offer].[Offer Code 1] 
Presentedfloat64factIF([Campaign Cell by Offer Performance Star Schema].[Campaign Cell by Offer Number of Times Presented][Interact Model].[Campaign Cell by Offer Number of Times Presented].[Presented] is missing) THEN(0) ELSE([Campaign Cell by Offer Performance Star Schema].[Campaign Cell by Offer Number of Times Presented][Interact Model].[Campaign Cell by Offer Number of Times Presented].[Presented]) 
Presented Model-Drivenfloat64factIF([Campaign Cell by Offer Performance Star Schema].[Campaign Cell by Offer Number of Times Presented][Interact Model].[Campaign Cell by Offer Number of Times Presented].[Presented Model-Driven] is missing) THEN(0) ELSE([Campaign Cell by Offer Performance Star Schema].[Campaign Cell by Offer Number of Times Presented][Interact Model].[Campaign Cell by Offer Number of Times Presented].[Presented Model-Driven]) 
Presented Randomfloat64factIF([Campaign Cell by Offer Performance Star Schema].[Campaign Cell by Offer Number of Times Presented][Interact Model].[Campaign Cell by Offer Number of Times Presented].[Presented Random] is missing) THEN(0) ELSE([Campaign Cell by Offer Performance Star Schema].[Campaign Cell by Offer Number of Times Presented][Interact Model].[Campaign Cell by Offer Number of Times Presented].[Presented Random]) 
Eligible Opportunitiesfloat64factIF([Campaign Cell by Offer Performance Star Schema].[Campaign Cell by Offer Elig Opps][Interact Model].[Campaign Cell by Offer Elig Opps].[Eligible Opportunities] is missing) THEN(0) ELSE([Campaign Cell by Offer Performance Star Schema].[Campaign Cell by Offer Elig Opps][Interact Model].[Campaign Cell by Offer Elig Opps].[Eligible Opportunities]) 
Acceptedfloat64factIF([Campaign Cell by Offer Performance Star Schema].[Campaign Cell by Offer Response History][Interact Model].[Campaign Cell by Offer Response History].[Accepted] is missing) THEN(0) ELSE([Campaign Cell by Offer Performance Star Schema].[Campaign Cell by Offer Response History][Interact Model].[Campaign Cell by Offer Response History].[Accepted]) 
Accepted Model-Drivenfloat64factIF([Campaign Cell by Offer Performance Star Schema].[Campaign Cell by Offer Response History][Interact Model].[Campaign Cell by Offer Response History].[Accepted Model-Driven] is missing) THEN(0) ELSE([Campaign Cell by Offer Performance Star Schema].[Campaign Cell by Offer Response History][Interact Model].[Campaign Cell by Offer Response History].[Accepted Model-Driven]) 
Accepted Randomfloat64factIF([Campaign Cell by Offer Performance Star Schema].[Campaign Cell by Offer Response History][Interact Model].[Campaign Cell by Offer Response History].[Accepted Random] is missing) THEN (0) ELSE([Campaign Cell by Offer Performance Star Schema].[Campaign Cell by Offer Response History][Interact Model].[Campaign Cell by Offer Response History].[Accepted Random]) 
Rejectedfloat64factIF([Campaign Cell by Offer Performance Star Schema].[Campaign Cell by Offer Response History][Interact Model].[Campaign Cell by Offer Response History].[Rejected] is missing) THEN(0) ELSE([Campaign Cell by Offer Performance Star Schema].[Campaign Cell by Offer Response History][Interact Model].[Campaign Cell by Offer Response History].[Rejected]) 
Campaign by Cell by Interaction Point PerformanceCampaign Cell by Interaction Point SummaryCampaign IDdecimalfact[Campaign Cell by IP Star Schema].[Campaign Cell by IP Elig Opps][Interact Model].[Campaign Cell by IP Elig Opps].[Campaign ID] 
Campaign NamecharacterLength16attribute[Campaign Cell by IP Star Schema].[Campaign][Interact Model].[Campaign].[Campaign Name] 
Campaign CodecharacterLength16attribute[Campaign Cell by IP Star Schema].[Campaign][Interact Model].[Campaign].[Campaign Code] 
Cell IDdecimalidentifier[Campaign Cell by IP Star Schema].[Campaign Cell by IP Elig Opps][Interact Model].[Campaign Cell by IP Elig Opps].[Cell ID] 
Cell NamecharacterLength16attribute[Campaign Cell by IP Star Schema].[Cells][Interact Model].[Cells].[Cell Name] 
Cell CodecharacterLength16attribute[Campaign Cell by IP Star Schema].[Cells][Interact Model].[Cells].[Cell Code] 
Interaction Point IDdecimalidentifier[Campaign Cell by IP Star Schema].[Campaign Cell by IP Elig Opps][Interact Model].[Campaign Cell by IP Elig Opps].[Interaction Point ID] 
Interaction PointcharacterLength16attribute[Campaign Cell by IP Star Schema].[Campaign Cell by IP Elig Opps][Interact Model].[Campaign Cell by IP Elig Opps].[Interaction Point] 
Presentedfloat64factIF([Campaign Cell by IP Star Schema].[Campaign Cell by IP Number of Times Presented][Interact Model].[Campaign Cell by IP Number of Times Presented].[Presented] is missing) THEN(0) ELSE([Campaign Cell by IP Star Schema].[Campaign Cell by IP Number of Times Presented][Interact Model].[Campaign Cell by IP Number of Times Presented].[Presented]) 
Presented Model-Drivenfloat64factIF([Campaign Cell by IP Star Schema].[Campaign Cell by IP Number of Times Presented][Interact Model].[Campaign Cell by IP Number of Times Presented].[Presented Model-Driven] is missing) THEN(0) ELSE([Campaign Cell by IP Star Schema].[Campaign Cell by IP Number of Times Presented][Interact Model].[Campaign Cell by IP Number of Times Presented].[Presented Model-Driven]) 
Presented Randomfloat64factIF([Campaign Cell by IP Star Schema].[Campaign Cell by IP Number of Times Presented][Interact Model].[Campaign Cell by IP Number of Times Presented].[Presented Random] is missing) THEN(0) ELSE([Campaign Cell by IP Star Schema].[Campaign Cell by IP Number of Times Presented][Interact Model].[Campaign Cell by IP Number of Times Presented].[Presented Random]) 
Eligible Opportunitiesfloat64factIF([Campaign Cell by IP Star Schema].[Campaign Cell by IP Elig Opps][Interact Model].[Campaign Cell by IP Elig Opps].[Eligible Opportunities] is missing) THEN(0) ELSE([Campaign Cell by IP Star Schema].[Campaign Cell by IP Elig Opps][Interact Model].[Campaign Cell by IP Elig Opps].[Eligible Opportunities]) 
Acceptedfloat64factIF([Campaign Cell by IP Star Schema].[Campaign Cell by IP Response History][Interact Model].[Campaign Cell by IP Response History].[Accepted] is missing) THEN(0) ELSE([Campaign Cell by IP Star Schema].[Campaign Cell by IP Response History][Interact Model].[Campaign Cell by IP Response History].[Accepted]) 
Accepted Model-Drivenfloat64factIF([Campaign Cell by IP Star Schema].[Campaign Cell by IP Response History][Interact Model].[Campaign Cell by IP Response History].[Accepted Model-Driven] is missing) THEN(0) ELSE([Campaign Cell by IP Star Schema].[Campaign Cell by IP Response History][Interact Model].[Campaign Cell by IP Response History].[Accepted Model-Driven]) 
Accepted Randomfloat64factIF([Campaign Cell by IP Star Schema].[Campaign Cell by IP Response History][Interact Model].[Campaign Cell by IP Response History].[Accepted Random] is missing) THEN(0) ELSE([Campaign Cell by IP Star Schema].[Campaign Cell by IP Response History][Interact Model].[Campaign Cell by IP Response History].[Accepted Random]) 
Rejectedfloat64factIF([Campaign Cell by IP Star Schema].[Campaign Cell by IP Response History][Interact Model].[Campaign Cell by IP Response History].[Rejected] is missing) THEN(0) ELSE([Campaign Cell by IP Star Schema].[Campaign Cell by IP Response History][Interact Model].[Campaign Cell by IP Response History].[Rejected]) 
Campaign by Offer PerformanceCampaign by Offer Performance SummaryCampaign IDdecimalidentifier[Campaign Offer Performance Star Schema].[Campaign Offer Elig Opps][Interact Model].[Campaign Offer Elig Opps].[Campaign ID] 
Campaign NamecharacterLength16attribute[Campaign Offer Performance Star Schema].[Campaign][Interact Model].[Campaign].[Campaign Name] 
Campaign CodecharacterLength16attribute[Campaign Offer Performance Star Schema].[Campaign][Interact Model].[Campaign].[Campaign Code] 
Offer IDdecimalidentifier[Campaign Offer Performance Star Schema].[Campaign Offer Elig Opps][Interact Model].[Campaign Offer Elig Opps].[Offer ID] 
Offer NamecharacterLength16attribute[Campaign Offer Performance Star Schema].[Offer][Interact Model].[Offer].[Offer Name] 
Offer Code 1characterLength16attribute[Campaign Offer Performance Star Schema].[Offer][Interact Model].[Offer].[Offer Code 1] 
Presentedfloat64factIF([Campaign Offer Performance Star Schema].[Campaign Offer Number of Times Presented][Interact Model].[Campaign Offer Number of Times Presented].[Presented] is missing) THEN(0) ELSE([Campaign Offer Performance Star Schema].[Campaign Offer Number of Times Presented][Interact Model].[Campaign Offer Number of Times Presented].[Presented]) 
Presented Model-Drivenfloat64factIF([Campaign Offer Performance Star Schema].[Campaign Offer Number of Times Presented][Interact Model].[Campaign Offer Number of Times Presented].[Presented Model-Driven] is missing) THEN(0) ELSE([Campaign Offer Performance Star Schema].[Campaign Offer Number of Times Presented][Interact Model].[Campaign Offer Number of Times Presented].[Presented Model-Driven]) 
Presented Randomfloat64factIF([Campaign Offer Performance Star Schema].[Campaign Offer Number of Times Presented][Interact Model].[Campaign Offer Number of Times Presented].[Presented Random] is missing) THEN(0) ELSE([Campaign Offer Performance Star Schema].[Campaign Offer Number of Times Presented][Interact Model].[Campaign Offer Number of Times Presented].[Presented Random]) 
Eligible Opportunitiesfloat64factIF([Campaign Offer Performance Star Schema].[Campaign Offer Elig Opps][Interact Model].[Campaign Offer Elig Opps].[Eligible Opportunities] is missing) THEN(0) ELSE([Campaign Offer Performance Star Schema].[Campaign Offer Elig Opps][Interact Model].[Campaign Offer Elig Opps].[Eligible Opportunities]) 
Acceptedfloat64factIF([Campaign Offer Performance Star Schema].[Campaign Offer Response History][Interact Model].[Campaign Offer Response History].[Accepted] is missing) THEN(0) ELSE([Campaign Offer Performance Star Schema].[Campaign Offer Response History][Interact Model].[Campaign Offer Response History].[Accepted]) 
Accepted Model-Drivenfloat64factIF([Campaign Offer Performance Star Schema].[Campaign Offer Response History][Interact Model].[Campaign Offer Response History].[Accepted Model-Driven] is missing) THEN(0) ELSE([Campaign Offer Performance Star Schema].[Campaign Offer Response History][Interact Model].[Campaign Offer Response History].[Accepted Model-Driven]) 
Accepted Randomfloat64factIF([Campaign Offer Performance Star Schema].[Campaign Offer Response History][Interact Model].[Campaign Offer Response History].[Accepted Random] is missing) THEN(0) ELSE([Campaign Offer Performance Star Schema].[Campaign Offer Response History][Interact Model].[Campaign Offer Response History].[Accepted Random]) 
Rejectedfloat64factIF([Campaign Offer Performance Star Schema].[Campaign Offer Response History][Interact Model].[Campaign Offer Response History].[Rejected] is missing) THEN(0) ELSE([Campaign Offer Performance Star Schema].[Campaign Offer Response History][Interact Model].[Campaign Offer Response History].[Rejected]) 
Campaign by Offer Performance by Last 7 DaysCampaign IDdecimalidentifier[Campaign Offer by Day Star Schema].[Campaign Offer Elig Opps by Day][Interact Model].[Campaign Offer Elig Opps by Day].[Campaign ID] 
Campaign NamecharacterLength16attribute[Campaign Offer by Day Star Schema].[Campaign][Interact Model].[Campaign].[Campaign Name] 
Campaign CodecharacterLength16attribute[Campaign Offer by Day Star Schema].[Campaign][Interact Model].[Campaign].[Campaign Code] 
Offer IDdecimalidentifier[Campaign Offer by Day Star Schema].[OfferToCalendar][Interact Model].[OfferToCalendar].[Offer ID]  
Offer NamecharacterLength16attribute[Campaign Offer by Day Star Schema].[OfferToCalendar][Interact Model].[OfferToCalendar].[Offer Name]  
Offer Code 1characterLength16attribute[Campaign Offer by Day Star Schema].[OfferToCalendar][Interact Model].[OfferToCalendar].[Offer Code 1]  
Actual DatedateTimeidentifier[Campaign Offer by Day Star Schema].[OfferToCalendar][Interact Model].[OfferToCalendar].[Actual Date]  
Presentedfloat64factIF([Campaign Offer by Day Star Schema].[Campaign Offer Number of Times Presented by Day][Interact Model].[Campaign Offer Number of Times Presented by Day].[Presented] is missing) THEN(0) ELSE([Campaign Offer by Day Star Schema].[Campaign Offer Number of Times Presented by Day][Interact Model].[Campaign Offer Number of Times Presented by Day].[Presented])  
Presented Model-Drivenfloat64factIF([Campaign Offer by Day Star Schema].[Campaign Offer Number of Times Presented by Day][Interact Model].[Campaign Offer Number of Times Presented by Day].[Presented Model-Driven] is missing) THEN(0) ELSE([Campaign Offer by Day Star Schema].[Campaign Offer Number of Times Presented by Day][Interact Model].[Campaign Offer Number of Times Presented by Day].[Presented Model-Driven]) 
Presented Randomfloat64factIF([Campaign Offer by Day Star Schema].[Campaign Offer Number of Times Presented by Day][Interact Model].[Campaign Offer Number of Times Presented by Day].[Presented Random] is missing) THEN(0) ELSE([Campaign Offer by Day Star Schema].[Campaign Offer Number of Times Presented by Day][Interact Model].[Campaign Offer Number of Times Presented by Day].[Presented Random]) 
Eligible Opportunitiesfloat64factIF([Campaign Offer by Day Star Schema].[Campaign Offer Elig Opps by Day][Interact Model].[Campaign Offer Elig Opps by Day].[Eligible Opportunities] is missing) THEN(0) ELSE([Campaign Offer by Day Star Schema].[Campaign Offer Elig Opps by Day][Interact Model].[Campaign Offer Elig Opps by Day].[Eligible Opportunities]) 
Acceptedfloat64factIF([Campaign Offer by Day Star Schema].[Campaign Offer Response History by Day][Interact Model].[Campaign Offer Response History by Day].[Accepted] is missing) THEN(0) ELSE([Campaign Offer by Day Star Schema].[Campaign Offer Response History by Day][Interact Model].[Campaign Offer Response History by Day].[Accepted]) 
Accepted Model-Drivenfloat64factIF([Campaign Offer by Day Star Schema].[Campaign Offer Response History by Day][Interact Model].[Campaign Offer Response History by Day].[Accepted Model-Driven] is missing) THEN(0) ELSE([Campaign Offer by Day Star Schema].[Campaign Offer Response History by Day][Interact Model].[Campaign Offer Response History by Day].[Accepted Model-Driven]) 
Accepted Randomfloat64factIF([Campaign Offer by Day Star Schema].[Campaign Offer Response History by Day][Interact Model].[Campaign Offer Response History by Day].[Accepted Random] is missing) THEN(0) ELSE([Campaign Offer by Day Star Schema].[Campaign Offer Response History by Day][Interact Model].[Campaign Offer Response History by Day].[Accepted Random]) 
Rejectedfloat64factIF([Campaign Offer by Day Star Schema].[Campaign Offer Response History by Day][Interact Model].[Campaign Offer Response History by Day].[Rejected] is missing) THEN(0) ELSE([Campaign Offer by Day Star Schema].[Campaign Offer Response History by Day][Interact Model].[Campaign Offer Response History by Day].[Rejected]) 
Campaign by Offer Performance by Last 24 HoursCampaign IDdecimalidentifier[Campaign Offer by Hour Star Schema].[Campaign Offer Elig Opps by Hour][Interact Model].[Campaign Offer Elig Opps by Hour].[Campaign ID] 
Campaign NamecharacterLength16attribute[Campaign Offer by Hour Star Schema].[Campaign][Interact Model].[Campaign].[Campaign Name] 
Campaign CodecharacterLength16attribute[Campaign Offer by Hour Star Schema].[Campaign][Interact Model].[Campaign].[Campaign Code] 
Offer IDdecimalidentifier[Campaign Offer by Hour Star Schema].[Offer-Last 24 Hours Lookup][Interact Model].[Offer-Last 24 Hours Lookup].[Offer ID]  
Offer NamecharacterLength16attribute[Campaign Offer by Hour Star Schema].[Offer-Last 24 Hours Lookup][Interact Model].[Offer-Last 24 Hours Lookup].[Offer Name]  
Offer Code 1characterLength16attribute[Campaign Offer by Hour Star Schema].[Offer-Last 24 Hours Lookup][Interact Model].[Offer-Last 24 Hours Lookup].[Offer Code 1]  
Hourfloat64identifier[Campaign Offer by Hour Star Schema].[Offer-Last 24 Hours Lookup][Interact Model].[Offer-Last 24 Hours Lookup].[Hour]  
Actual DatedateTimeidentifier[Campaign Offer by Hour Star Schema].[Offer-Last 24 Hours Lookup][Interact Model].[Offer-Last 24 Hours Lookup].[Actual Date]  
Presentedfloat64factIF([Campaign Offer by Hour Star Schema].[Campaign Offer Number of Times Presented by Hour][Interact Model].[Campaign Offer Number of Times Presented by Hour].[Presented] is missing) THEN(0) ELSE([Campaign Offer by Hour Star Schema].[Campaign Offer Number of Times Presented by Hour][Interact Model].[Campaign Offer Number of Times Presented by Hour].[Presented]) 
Presented Model-Drivenfloat64factIF([Campaign Offer by Hour Star Schema].[Campaign Offer Number of Times Presented by Hour][Interact Model].[Campaign Offer Number of Times Presented by Hour].[Presented Model-Driven] is missing) THEN(0) ELSE([Campaign Offer by Hour Star Schema].[Campaign Offer Number of Times Presented by Hour][Interact Model].[Campaign Offer Number of Times Presented by Hour].[Presented Model-Driven]) 
Presented Randomfloat64factIF([Campaign Offer by Hour Star Schema].[Campaign Offer Number of Times Presented by Hour][Interact Model].[Campaign Offer Number of Times Presented by Hour].[Presented Random] is missing) THEN(0) ELSE([Campaign Offer by Hour Star Schema].[Campaign Offer Number of Times Presented by Hour][Interact Model].[Campaign Offer Number of Times Presented by Hour].[Presented Random]) 
Eligible Opportunitiesfloat64factIF([Campaign Offer by Hour Star Schema].[Campaign Offer Elig Opps by Hour][Interact Model].[Campaign Offer Elig Opps by Hour].[Eligible Opportunities] is missing) THEN(0) ELSE([Campaign Offer by Hour Star Schema].[Campaign Offer Elig Opps by Hour][Interact Model].[Campaign Offer Elig Opps by Hour].[Eligible Opportunities]) 
Acceptedfloat64factIF([Campaign Offer by Hour Star Schema].[Campaign Offer Response History by Hour][Interact Model].[Campaign Offer Response History by Hour].[Accepted] is missing) THEN(0) ELSE([Campaign Offer by Hour Star Schema].[Campaign Offer Response History by Hour][Interact Model].[Campaign Offer Response History by Hour].[Accepted]) 
Accepted Model-Drivenfloat64factIF([Campaign Offer by Hour Star Schema].[Campaign Offer Response History by Hour][Interact Model].[Campaign Offer Response History by Hour].[Accepted Model-Driven] is missing) THEN(0) ELSE([Campaign Offer by Hour Star Schema].[Campaign Offer Response History by Hour][Interact Model].[Campaign Offer Response History by Hour].[Accepted Model-Driven]) 
Accepted Randomfloat64factIF([Campaign Offer by Hour Star Schema].[Campaign Offer Response History by Hour][Interact Model].[Campaign Offer Response History by Hour].[Accepted Random] is missing) THEN(0) ELSE([Campaign Offer by Hour Star Schema].[Campaign Offer Response History by Hour][Interact Model].[Campaign Offer Response History by Hour].[Accepted Random]) 
Rejectedfloat64factIF([Campaign Offer by Hour Star Schema].[Campaign Offer Response History by Hour][Interact Model].[Campaign Offer Response History by Hour].[Rejected] is missing) THEN(0) ELSE([Campaign Offer by Hour Star Schema].[Campaign Offer Response History by Hour][Interact Model].[Campaign Offer Response History by Hour].[Rejected]) 
Campaign by Offer Performance by HourCampaign IDdecimalidentifier[Campaign Offer by Hour Star Schema].[Campaign Offer Elig Opps by Hour][Interact Model].[Campaign Offer Elig Opps by Hour].[Campaign ID] 
Campaign NamecharacterLength16attribute[Campaign Offer by Hour Star Schema].[Campaign][Interact Model].[Campaign].[Campaign Name] 
Campaign CodecharacterLength16attribute[Campaign Offer by Hour Star Schema].[Campaign][Interact Model].[Campaign].[Campaign Code] 
Offer IDdecimalidentifier[Campaign Offer by Hour Star Schema].[Campaign Offer Elig Opps by Hour][Interact Model].[Campaign Offer Elig Opps by Hour].[Offer ID] 
Offer NamecharacterLength16attribute[Campaign Offer by Hour Star Schema].[Offer][Interact Model].[Offer].[Offer Name] 
Offer Code 1characterLength16attribute[Campaign Offer by Hour Star Schema].[Offer][Interact Model].[Offer].[Offer Code 1] 
Hourint64identifier[Campaign Offer by Hour Star Schema].[Campaign Offer Elig Opps by Hour][Interact Model].[Campaign Offer Elig Opps by Hour].[Hour] 
Actual DatedateTimeidentifier[Campaign Offer by Hour Star Schema].[Campaign Offer Elig Opps by Hour][Interact Model].[Campaign Offer Elig Opps by Hour].[Actual Date] 
Presentedfloat64factIF([Campaign Offer by Hour Star Schema].[Campaign Offer Number of Times Presented by Hour][Interact Model].[Campaign Offer Number of Times Presented by Hour].[Presented] is missing) THEN(0) ELSE([Campaign Offer by Hour Star Schema].[Campaign Offer Number of Times Presented by Hour][Interact Model].[Campaign Offer Number of Times Presented by Hour].[Presented]) 
Presented Model-Drivenfloat64factIF([Campaign Offer by Hour Star Schema].[Campaign Offer Number of Times Presented by Hour][Interact Model].[Campaign Offer Number of Times Presented by Hour].[Presented Model-Driven] is missing) THEN(0) ELSE([Campaign Offer by Hour Star Schema].[Campaign Offer Number of Times Presented by Hour][Interact Model].[Campaign Offer Number of Times Presented by Hour].[Presented Model-Driven]) 
Presented Randomfloat64factIF([Campaign Offer by Hour Star Schema].[Campaign Offer Number of Times Presented by Hour][Interact Model].[Campaign Offer Number of Times Presented by Hour].[Presented Random] is missing) THEN(0) ELSE([Campaign Offer by Hour Star Schema].[Campaign Offer Number of Times Presented by Hour][Interact Model].[Campaign Offer Number of Times Presented by Hour].[Presented Random]) 
Eligible Opportunitiesfloat64factIF([Campaign Offer by Hour Star Schema].[Campaign Offer Elig Opps by Hour][Interact Model].[Campaign Offer Elig Opps by Hour].[Eligible Opportunities] is missing) THEN(0) ELSE([Campaign Offer by Hour Star Schema].[Campaign Offer Elig Opps by Hour][Interact Model].[Campaign Offer Elig Opps by Hour].[Eligible Opportunities]) 
Acceptedfloat64factIF([Campaign Offer by Hour Star Schema].[Campaign Offer Response History by Hour][Interact Model].[Campaign Offer Response History by Hour].[Accepted] is missing) THEN(0) ELSE([Campaign Offer by Hour Star Schema].[Campaign Offer Response History by Hour][Interact Model].[Campaign Offer Response History by Hour].[Accepted]) 
Accepted Model-Drivenfloat64factIF([Campaign Offer by Hour Star Schema].[Campaign Offer Response History by Hour][Interact Model].[Campaign Offer Response History by Hour].[Accepted Model-Driven] is missing) THEN(0) ELSE([Campaign Offer by Hour Star Schema].[Campaign Offer Response History by Hour][Interact Model].[Campaign Offer Response History by Hour].[Accepted Model-Driven]) 
Accepted Randomfloat64factIF([Campaign Offer by Hour Star Schema].[Campaign Offer Response History by Hour][Interact Model].[Campaign Offer Response History by Hour].[Accepted Random] is missing) THEN(0) ELSE([Campaign Offer by Hour Star Schema].[Campaign Offer Response History by Hour][Interact Model].[Campaign Offer Response History by Hour].[Accepted Random]) 
Rejectedfloat64factIF([Campaign Offer by Hour Star Schema].[Campaign Offer Response History by Hour][Interact Model].[Campaign Offer Response History by Hour].[Rejected] is missing) THEN(0) ELSE([Campaign Offer by Hour Star Schema].[Campaign Offer Response History by Hour][Interact Model].[Campaign Offer Response History by Hour].[Rejected]) 
Campaign by Offer by Cell PerformanceCampaign by Offer by Cell Performance SummaryCampaign IDdecimalidentifier[Campaign Offer Cell Star Schema].[Campaign Offer by Cell Elig Opps][Interact Model].[Campaign Offer by Cell Elig Opps].[Campaign ID] 
Campaign NamecharacterLength16attribute[Campaign Offer Cell Star Schema].[Campaign][Interact Model].[Campaign].[Campaign Name] 
Campaign CodecharacterLength16attribute[Campaign Offer Cell Star Schema].[Campaign][Interact Model].[Campaign].[Campaign Code] 
Offer IDdecimalidentifier[Campaign Offer Cell Star Schema].[Campaign Offer by Cell Elig Opps][Interact Model].[Campaign Offer by Cell Elig Opps].[Offer ID] 
Offer NamecharacterLength16attribute[Campaign Offer Cell Star Schema].[Offer][Interact Model].[Offer].[Offer Name] 
Offer Code 1characterLength16attribute[Campaign Offer Cell Star Schema].[Offer][Interact Model].[Offer].[Offer Code 1] 
Cell IDdecimalidentifier[Campaign Offer Cell Star Schema].[Campaign Offer by Cell Elig Opps][Interact Model].[Campaign Offer by Cell Elig Opps].[Cell ID] 
Cell NamecharacterLength16attribute[Campaign Offer Cell Star Schema].[Cells][Interact Model].[Cells].[Cell Name] 
Cell CodecharacterLength16attribute[Campaign Offer Cell Star Schema].[Cells][Interact Model].[Cells].[Cell Code] 
Presentedfloat64factIF([Campaign Offer Cell Star Schema].[Campaign Offer by Cell Number of Times Presented][Interact Model].[Campaign Offer by Cell Number of Times Presented].[Presented] is missing) THEN(0) ELSE([Campaign Offer Cell Star Schema].[Campaign Offer by Cell Number of Times Presented][Interact Model].[Campaign Offer by Cell Number of Times Presented].[Presented]) 
Presented Model-Drivenfloat64factIF([Campaign Offer Cell Star Schema].[Campaign Offer by Cell Number of Times Presented][Interact Model].[Campaign Offer by Cell Number of Times Presented].[Presented Model-Driven] is missing) THEN(0) ELSE([Campaign Offer Cell Star Schema].[Campaign Offer by Cell Number of Times Presented][Interact Model].[Campaign Offer by Cell Number of Times Presented].[Presented Model-Driven]) 
Presented Randomfloat64factIF([Campaign Offer Cell Star Schema].[Campaign Offer by Cell Number of Times Presented][Interact Model].[Campaign Offer by Cell Number of Times Presented].[Presented Random] is missing) THEN(0) ELSE([Campaign Offer Cell Star Schema].[Campaign Offer by Cell Number of Times Presented][Interact Model].[Campaign Offer by Cell Number of Times Presented].[Presented Random]) 
Eligible Opportunitiesfloat64factIF([Campaign Offer Cell Star Schema].[Campaign Offer by Cell Elig Opps][Interact Model].[Campaign Offer by Cell Elig Opps].[Eligible Opportunities] is missing) THEN(0) ELSE([Campaign Offer Cell Star Schema].[Campaign Offer by Cell Elig Opps][Interact Model].[Campaign Offer by Cell Elig Opps].[Eligible Opportunities]) 
Acceptedfloat64factIF([Campaign Offer Cell Star Schema].[Campaign Offer by Cell Response History][Interact Model].[Campaign Offer by Cell Response History].[Accepted] is missing) THEN(0) ELSE([Campaign Offer Cell Star Schema].[Campaign Offer by Cell Response History][Interact Model].[Campaign Offer by Cell Response History].[Accepted]) 
Accepted Model-Drivenfloat64factIF([Campaign Offer Cell Star Schema].[Campaign Offer by Cell Response History][Interact Model].[Campaign Offer by Cell Response History].[Accepted Model-Driven] is missing) THEN(0) ELSE([Campaign Offer Cell Star Schema].[Campaign Offer by Cell Response History][Interact Model].[Campaign Offer by Cell Response History].[Accepted Model-Driven]) 
Accepted Randomfloat64factIF([Campaign Offer Cell Star Schema].[Campaign Offer by Cell Response History][Interact Model].[Campaign Offer by Cell Response History].[Accepted Random] is missing) THEN(0) ELSE([Campaign Offer Cell Star Schema].[Campaign Offer by Cell Response History][Interact Model].[Campaign Offer by Cell Response History].[Accepted Random]) 
Rejectedfloat64factIF([Campaign Offer Cell Star Schema].[Campaign Offer by Cell Response History][Interact Model].[Campaign Offer by Cell Response History].[Rejected] is missing) THEN(0) ELSE([Campaign Offer Cell Star Schema].[Campaign Offer by Cell Response History][Interact Model].[Campaign Offer by Cell Response History].[Rejected]) 
Campaign by Offer by Interaction Point PerformanceCampaign by Offer by Interaction Point SummaryCampaign IDdecimalidentifier[Campaign Offer by Interaction Point Star Schema].[Campaign Offer by IP Elig Opps][Interact Model].[Campaign Offer by IP Elig Opps].[Campaign ID] 
Campaign NamecharacterLength16attribute[Campaign Offer by Interaction Point Star Schema].[Campaign][Interact Model].[Campaign].[Campaign Name] 
Campaign CodecharacterLength16attribute[Campaign Offer by Interaction Point Star Schema].[Campaign][Interact Model].[Campaign].[Campaign Code] 
Offer IDdecimalidentifier[Campaign Offer by Interaction Point Star Schema].[Campaign Offer by IP Elig Opps][Interact Model].[Campaign Offer by IP Elig Opps].[Offer ID] 
Offer NamecharacterLength16attribute[Campaign Offer by Interaction Point Star Schema].[Offer][Interact Model].[Offer].[Offer Name] 
Offer Code 1characterLength16attribute[Campaign Offer by Interaction Point Star Schema].[Offer][Interact Model].[Offer].[Offer Code 1] 
Interaction Point IDdecimalidentifier[Campaign Offer by Interaction Point Star Schema].[Campaign Offer by IP Elig Opps][Interact Model].[Campaign Offer by IP Elig Opps].[Interaction Point ID] 
Interaction PointcharacterLength16attribute[Campaign Offer by Interaction Point Star Schema].[Campaign Offer by IP Elig Opps][Interact Model].[Campaign Offer by IP Elig Opps].[Interaction Point] 
Presentedfloat64factIF([Campaign Offer by Interaction Point Star Schema].[Campaign Offer by IP Number of Times Presented][Interact Model].[Campaign Offer by IP Number of Times Presented].[Presented] is missing) THEN(0) ELSE([Campaign Offer by Interaction Point Star Schema].[Campaign Offer by IP Number of Times Presented][Interact Model].[Campaign Offer by IP Number of Times Presented].[Presented]) 
Presented Model-Drivenfloat64factIF([Campaign Offer by Interaction Point Star Schema].[Campaign Offer by IP Number of Times Presented][Interact Model].[Campaign Offer by IP Number of Times Presented].[Presented Model-Driven] is missing) THEN(0) ELSE([Campaign Offer by Interaction Point Star Schema].[Campaign Offer by IP Number of Times Presented][Interact Model].[Campaign Offer by IP Number of Times Presented].[Presented Model-Driven]) 
Presented Randomfloat64factIF([Campaign Offer by Interaction Point Star Schema].[Campaign Offer by IP Number of Times Presented][Interact Model].[Campaign Offer by IP Number of Times Presented].[Presented Random] is missing) THEN(0) ELSE([Campaign Offer by Interaction Point Star Schema].[Campaign Offer by IP Number of Times Presented][Interact Model].[Campaign Offer by IP Number of Times Presented].[Presented Random]) 
Eligible Opportunitiesfloat64factIF([Campaign Offer by Interaction Point Star Schema].[Campaign Offer by IP Elig Opps][Interact Model].[Campaign Offer by IP Elig Opps].[Eligible Opportunities] is missing) THEN(0) ELSE([Campaign Offer by Interaction Point Star Schema].[Campaign Offer by IP Elig Opps][Interact Model].[Campaign Offer by IP Elig Opps].[Eligible Opportunities]) 
Acceptedfloat64factIF([Campaign Offer by Interaction Point Star Schema].[Campaign Offer by IP Response History][Interact Model].[Campaign Offer by IP Response History].[Accepted] is missing) THEN(0) ELSE([Campaign Offer by Interaction Point Star Schema].[Campaign Offer by IP Response History][Interact Model].[Campaign Offer by IP Response History].[Accepted]) 
Accepted Model-Drivenfloat64factIF([Campaign Offer by Interaction Point Star Schema].[Campaign Offer by IP Response History][Interact Model].[Campaign Offer by IP Response History].[Accepted Model-Driven] is missing) THEN(0) ELSE([Campaign Offer by Interaction Point Star Schema].[Campaign Offer by IP Response History][Interact Model].[Campaign Offer by IP Response History].[Accepted Model-Driven]) 
Accepted Randomfloat64factIF([Campaign Offer by Interaction Point Star Schema].[Campaign Offer by IP Response History][Interact Model].[Campaign Offer by IP Response History].[Accepted Random] is missing) THEN(0) ELSE([Campaign Offer by Interaction Point Star Schema].[Campaign Offer by IP Response History][Interact Model].[Campaign Offer by IP Response History].[Accepted Random]) 
Rejectedfloat64factIF([Campaign Offer by Interaction Point Star Schema].[Campaign Offer by IP Response History][Interact Model].[Campaign Offer by IP Response History].[Rejected] is missing) THEN(0) ELSE([Campaign Offer by Interaction Point Star Schema].[Campaign Offer by IP Response History][Interact Model].[Campaign Offer by IP Response History].[Rejected]) 
Campaign Interactive Offer Learning DetailsInteractive Offer Learning DetailsCampaign IDdecimalidentifier[Interactive Offer Learning Star Schema].[Treatment Rule Inventory Campaign to Offer][Interact Model].[Treatment Rule Inventory Campaign to Offer].[Campaign ID] 
Campaign NamecharacterLength16attribute[Interactive Offer Learning Star Schema].[Treatment Rule Inventory Campaign to Offer][Interact Model].[Treatment Rule Inventory Campaign to Offer].[Campaign Name] 
Campaign CodecharacterLength16attribute[Interactive Offer Learning Star Schema].[Treatment Rule Inventory Campaign to Offer][Interact Model].[Treatment Rule Inventory Campaign to Offer].[Campaign Code] 
Offer IDdecimalidentifier[Interactive Offer Learning Star Schema].[Interactive Offer Learning][Interact Model].[Interactive Offer Learning].[Offer ID] 
Offer NamecharacterLength16attribute[Interactive Offer Learning Star Schema].[Offer][Interact Model].[Offer].[Offer Name] 
Offer Code 1characterLength16attribute[Interactive Offer Learning Star Schema].[Offer][Interact Model].[Offer].[Offer Code 1] 
Attribute NamecharacterLength16attribute[Interactive Offer Learning Star Schema].[Interactive Offer Learning][Interact Model].[Interactive Offer Learning].[Attribute Name] 
Attribute ValuecharacterLength16attribute[Interactive Offer Learning Star Schema].[Interactive Offer Learning][Interact Model].[Interactive Offer Learning].[Attribute Value] 
Likelyhood of Responsefloat64fact[Interactive Offer Learning Star Schema].[Interactive Offer Learning][Interact Model].[Interactive Offer Learning].[Likelyhood of Response] 
Predictabilityint64attribute[Interactive Offer Learning Star Schema].[Interactive Offer Learning][Interact Model].[Interactive Offer Learning].[Predictability] 
Channel_Campaign - Interactive Channel Deployment HistoryInteractive Channel Campaign - Interactive Channel Deployment HistoryInteractive Channel IDdecimalidentifier[Interactive Channel Deployment Star Schema].[Interactive Channel Deployment History][Interact Model].[Interactive Channel Deployment History].[Interactive Channel ID] 
Campaign IDdecimalattribute[Interactive Channel Deployment Star Schema].[Interactive Channel Deployment History][Interact Model].[Interactive Channel Deployment History].[Campaign ID] 
Campaign NamecharacterLength16attribute[Interactive Channel Deployment Star Schema].[Interactive Channel Deployment History][Interact Model].[Interactive Channel Deployment History].[Campaign Name] 
Campaign CodecharacterLength16attribute[Interactive Channel Deployment Star Schema].[Campaign][Interact Model].[Campaign].[Campaign Code]  
Session IDdecimalidentifier[Interactive Channel Deployment Star Schema].[Interactive Channel Deployment History][Interact Model].[Interactive Channel Deployment History].[Session ID]  
Session NamecharacterLength16attribute[Interactive Channel Deployment Star Schema].[Interactive Channel Deployment History][Interact Model].[Interactive Channel Deployment History].[Session Name]  
Flowchart IDdecimalidentifier[Interactive Channel Deployment Star Schema].[Interactive Channel Deployment History][Interact Model].[Interactive Channel Deployment History].[Flowchart ID]  
Flowchart NamecharacterLength16attribute[Interactive Channel Deployment Star Schema].[Interactive Channel Deployment History][Interact Model].[Interactive Channel Deployment History].[Flowchart Name]  
Flowchart Deployment TypecharacterLength16attribute[Interactive Channel Deployment Star Schema].[Flowchart Deployment Type][Interact Model].[Flowchart Deployment Type].[Flowchart Deployment Type] 
Audience LevelcharacterLength16attribute[Interactive Channel Deployment Star Schema].[Interactive Channel Deployment History][Interact Model].[Interactive Channel Deployment History].[Audience Level]  
Deployment IDdecimalidentifier[Interactive Channel Deployment Star Schema].[Interactive Channel Deployment History][Interact Model].[Interactive Channel Deployment History].[Deployment ID] 
Deployment Deploy Type IDint64attribute[Interact Model].[Interactive Channel Deployment History].[Deployment Deploy Type ID] 
Deployment DestinationcharacterLength16attribute[Interactive Channel Deployment Star Schema].[Interactive Channel Deployment History][Interact Model].[Interactive Channel Deployment History].[Deployment Destination] 
Deployment Server Groupint64attribute[Interactive Channel Deployment Star Schema].[Interactive Channel Deployment History][Interact Model].[Interactive Channel Deployment History].[Deployment Server Group] 
Production GroupcharacterLength16attribute[Interactive Channel Deployment Star Schema].[isProduction][Interact Model].[isProduction].[Production Group] 
Deployment TypecharacterLength16attribute[Interactive Channel Deployment Star Schema].[Deploy Type][Interact Model].[Deployment Type].[Deployment Type] 
StrategyIDdecimalidentifier[Interactive Channel Deployment Star Schema].[Interactive Channel Deployment History][Interact Model].[Interactive Channel Deployment History].[StrategyID] 
Strategy NamecharacterLength16attribute[Interactive Channel Deployment Star Schema].[Interactive Channel Deployment History][Interact Model].[Interactive Channel Deployment History].[Strategy Name] 
Deployment OwnercharacterLength16attribute[Interactive Channel Deployment Star Schema].[Interactive Channel Deployment History][Interact Model].[Interactive Channel Deployment History].[Deployment Owner] 
Time of DeploymentdateTimeattribute[Interactive Channel Deployment Star Schema].[Interactive Channel Deployment History][Interact Model].[Interactive Channel Deployment History].[Time of Deployment] 
Strategy Tab URLcharacterLength16attribute[Interactive Channel Deployment Star Schema].[Interactive Channel Deployment History][Interact Model].[Interactive Channel Deployment History].[Strategy Tab URL] 
Flowchart Tab URLcharacterLength16attribute[Interactive Channel Deployment Star Schema].[Interactive Channel Deployment History][Interact Model].[Interactive Channel Deployment History].[Flowchart Tab URL]  
Channel Treatment Rule InventoryTreatment Rule Inventory SummaryTreatment Rule IDdecimalidentifier[Treatment Rule Inventory Star Schema].[Treatment Rule Inventory][Interact Model].[Treatment Rule Inventory].[Treatment Rule ID] 
Deployment IDdecimalidentifier[Treatment Rule Inventory Star Schema].[Treatment Rule Inventory][Interact Model].[Treatment Rule Inventory].[Deployment ID] 
Interactive Channel IDdecimalidentifier[Treatment Rule Inventory Star Schema].[Treatment Rule Inventory][Interact Model].[Treatment Rule Inventory].[Interactive Channel ID] 
Interactive ChannelcharacterLength16attribute[Treatment Rule Inventory Star Schema].[Treatment Rule Inventory][Interact Model].[Treatment Rule Inventory].[Interactive Channel] 
Cell IDdecimalidentifier[Treatment Rule Inventory Star Schema].[Treatment Rule Inventory][Interact Model].[Treatment Rule Inventory].[Cell ID] 
Cell NamecharacterLength16attribute[Treatment Rule Inventory Star Schema].[Treatment Rule Inventory][Interact Model].[Treatment Rule Inventory].[Cell Name] 
Cell CodecharacterLength16attribute[Treatment Rule Inventory Star Schema].[Cells][Interact Model].[Cells].[Cell Code] 
Zone IDdecimalidentifier[Treatment Rule Inventory Star Schema].[Treatment Rule Inventory][Interact Model].[Treatment Rule Inventory].[Zone ID] 
ZonecharacterLength16attributeIF ([Treatment Rule Inventory Star Schema].[Treatment Rule Inventory][Interact Model].[Treatment Rule Inventory].[Zone] is NULL) THEN ([Interact Model].[Treatment Rule Inventory].[All Zones] ) ELSE([Treatment Rule Inventory Star Schema].[Treatment Rule Inventory][Interact Model].[Treatment Rule Inventory].[Zone] ) 
Strategy IDdecimalidentifier[Treatment Rule Inventory Star Schema].[Treatment Rule Inventory][Interact Model].[Treatment Rule Inventory].[Strategy ID] 
Strategy NamecharacterLength16attribute[Treatment Rule Inventory Star Schema].[Treatment Rule Inventory][Interact Model].[Treatment Rule Inventory].[Strategy Name] 
Offer IDdecimalidentifier[Treatment Rule Inventory Star Schema].[Treatment Rule Inventory][Interact Model].[Treatment Rule Inventory].[Offer ID] 
Offer NamecharacterLength16attribute[Treatment Rule Inventory Star Schema].[Treatment Rule Inventory][Interact Model].[Treatment Rule Inventory].[Offer Name] 
Offer Code 1characterLength16attribute[Treatment Rule Inventory Star Schema].[Offer][Interact Model].[Offer].[Offer Code 1] 
Campaign IDdecimalidentifier[Treatment Rule Inventory Star Schema].[Treatment Rule Inventory][Interact Model].[Treatment Rule Inventory].[Campaign ID] 
Campaign NamecharacterLength16attribute[Treatment Rule Inventory Star Schema].[Treatment Rule Inventory][Interact Model].[Treatment Rule Inventory].[Campaign Name] 
Campaign CodecharacterLength16attribute[Treatment Rule Inventory Star Schema].[Treatment Rule Inventory][Interact Model].[Treatment Rule Inventory].[Campaign Code] 
Segment IDdecimalidentifier[Treatment Rule Inventory Star Schema].[Treatment Rule Inventory][Interact Model].[Treatment Rule Inventory].[Segment ID] 
SegmentcharacterLength16attribute[Treatment Rule Inventory Star Schema].[Treatment Rule Inventory][Interact Model].[Treatment Rule Inventory].[Segment] 
Marketing Scoreint64fact[Treatment Rule Inventory Star Schema].[Treatment Rule Inventory][Interact Model].[Treatment Rule Inventory].[Marketing Score] 
Enable State IDint64identifier[Treatment Rule Inventory Star Schema].[Treatment Rule Inventory][Interact Model].[Treatment Rule Inventory].[Enable State ID] 
Predicate StatecharacterLength16attribute[Treatment Rule Inventory Star Schema].[Predicate State][Interact Model].[Predicate State].[Predicate State] 
PredicatecharacterLength16attribute[Treatment Rule Inventory Star Schema].[Treatment Rule Inventory][Interact Model].[Treatment Rule Inventory].[Predicate] 
Last Update DatedateTimeattribute[Treatment Rule Inventory Star Schema].[Treatment Rule Inventory][Interact Model].[Treatment Rule Inventory].[Last Update Date] 
StrategyTab URLcharacterLength16attribute[Treatment Rule Inventory Star Schema].[Treatment Rule Inventory][Interact Model].[Treatment Rule Inventory].[StrategyTab URL] 
Interactive Channel Event ActivityEvent Activity Peak Day All (shortcut) [Peak and Slow All].[Peak Day All]
Event Activity Slow Day All (shortcut) [Peak and Slow All].[Slow Day All]
Event Activity Peak Hour All (shortcut) [Peak and Slow All].[Peak Hour All]
Event Activity Slow Hour All (shortcut) [Peak and Slow All].[Slow Hour All]
Interactive Channel Event ActivityChannel Event ListingInteractive Channel IDint32identifier[Interact Model].[Event Common].[Interactive Channel ID] 
Interactive Channel NamecharacterLength16attribute[Interact Model].[Event Common].[Interactive Channel Name]  
Category IDint32identifier[Interact Model].[Event Common].[Category ID] 
Category NamecharacterLength16attribute[Interact Model].[Event Common].[Category Name] 
Event IDint32identifier[Interact Model].[Event Common].[Event ID] 
Event NamecharacterLength16attribute[Interact Model].[Event Common].[Event Name] 
Total Occurrencesint32factIF ([Interact Model].[Event Common].[Occurrences] is missing) THEN (0) ELSE ([Interact Model].[Event Common].[Occurrences]) 
Channel Event Activity 7 DaysInteractive Channel IDint32identifier[Interact Model].[Event Common by Day].[Interactive Channel ID]  
Interactive Channel NamecharacterLength16attribute[Interact Model].[Event Common by Day].[Interactive Channel Name] 
Category IDint32identifier[Interact Model].[Event Common by Day].[Category ID] 
Category NamecharacterLength16attribute[Interact Model].[Event Common by Day].[Category Name] 
Event IDint32identifier[Interact Model].[Event Common by Day].[Event ID] 
Event NamecharacterLength16attribute[Interact Model].[Event Common by Day].[Event Name] 
Actual Datedateattribute[Interact Model].[Event Common by Day].[Actual Date]  
Occurrencesint32factIF ([Interact Model].[Event Activity Day].[Occurrences] is missing) THEN (0) ELSE ([Interact Model].[Event Activity Day].[Occurrences]) 
Peak Daydateattribute[Interact Model].[Peak Day].[Peak Day] 
Max Occurrencesint32fact[Interact Model].[Peak Day].[Max Occurrences] 
Slowest Daydateattribute[Interact Model].[Slow Day].[Slowest Day] 
Min Occurrencesint32fact[Interact Model].[Slow Day].[Min Occurrences] 
Channel Event Activity 24 HrsInteractive Channel IDdecimalidentifier[Interact Model].[Event Common by Hour].[Interactive Channel ID]  
Interactive Channel NamecharacterLength16attribute[Interact Model].[Event Common by Hour].[Interactive Channel Name] 
Category IDdecimalidentifier[Interact Model].[Event Common by Hour].[Category ID] 
Category NamecharacterLength16attribute[Interact Model].[Event Common by Hour].[Category Name] 
Event IDdecimalidentifier[Interact Model].[Event Common by Hour].[Event ID] 
Event NamecharacterLength16attribute[Interact Model].[Event Common by Hour].[Event Name] 
Actual Datedateattribute[Interact Model].[Event Common by Hour].[Actual Date]  
Hourfloat64attribute[Interact Model].[Event Common by Hour].[Hour]  
Occurrencesfloat64factIF ([Interact Model].[Event Activity HR].[Occurrences] is missing) THEN (0) ELSE ([Interact Model].[Event Activity HR].[Occurrences]) 
Peak Daydateattribute[Interact Model].[Peak Hour].[Peak Day] 
Peak Hourint64attribute[Interact Model].[Peak Hour].[Peak Hour] 
Max Occurrencesfloat64fact[Interact Model].[Peak Hour].[Max Occur] 
Slowest Daydateattribute[Interact Model].[Slow Hour].[Slowest Day] 
Slowest Hourint64attribute[Interact Model].[Slow Hour].[Slowest Hour] 
Min Occurrencesfloat64fact[Interact Model].[Slow Hour].[Min Occur] 
Common ViewsCampaign View (shortcut) [Interact Model].[Campaign]
Calendar View (shortcut) [Interact Model].[Calendar]
Time View (shortcut) [Interact Model].[Time]
Last 24 Hours View (shortcut) [Interact Model].[Last 24 Hours Lookup]
Model View
model/Model View.jpg
Namespace/FolderQuery SubjectQuery ItemTypeUsageRef Obj/Expr.
CommonCampaignCampaign IDdecimalidentifier[InteractDTDS].[UARI_CAMPAIGN].[CAMPAIGNID] 
Campaign NamecharacterLength16attribute[InteractDTDS].[UARI_CAMPAIGN].[NAME] 
DescriptioncharacterLength16attribute[InteractDTDS].[UARI_CAMPAIGN].[DESCRIPTION] 
Campaign CodecharacterLength16attribute[InteractDTDS].[UARI_CAMPAIGN].[CAMPAIGNCODE] 
ObjectivescharacterLength16attribute[InteractDTDS].[UARI_CAMPAIGN].[OBJECTIVES] 
Last Run DatedateTimeattribute[InteractDTDS].[UARI_CAMPAIGN].[LASTRUNDATE] 
InitiativecharacterLength16attribute[InteractDTDS].[UARI_CAMPAIGN].[INITIATIVE] 
Created DatedateTimeattribute[InteractDTDS].[UARI_CAMPAIGN].[CREATEDATE] 
Start DatedateTimeattribute[InteractDTDS].[UARI_CAMPAIGN].[STARTDATE] 
End DatedateTimeidentifier[InteractDTDS].[UARI_CAMPAIGN].[ENDDATE] 
OfferOffer IDdecimalidentifier[InteractDTDS].[UARI_OFFER].[OFFERID] 
Offer NamecharacterLength16attribute[InteractDTDS].[UARI_OFFER].[NAME] 
Offer DescriptioncharacterLength16attribute[InteractDTDS].[UARI_OFFER].[DESCRIPTION] 
Offer Code 1characterLength16attribute[InteractDTDS].[UARI_OFFER].[OFFERCODE1] 
Offer Code 2characterLength16attribute[InteractDTDS].[UARI_OFFER].[OFFERCODE2] 
Offer Code 3characterLength16attribute[InteractDTDS].[UARI_OFFER].[OFFERCODE3] 
Offer Code 4characterLength16attribute[InteractDTDS].[UARI_OFFER].[OFFERCODE4] 
Offer Code 5characterLength16attribute[InteractDTDS].[UARI_OFFER].[OFFERCODE5] 
CellsCell IDdecimalidentifier[InteractDTDS].[UARI_CELLS].[CELLID] 
Cell NamecharacterLength16attribute[InteractDTDS].[UARI_CELLS].[CELLNAME] 
Cell CodecharacterLength16attribute[InteractDTDS].[UARI_CELLS].[CELLCODE] 
Control Cell IDdecimalidentifier[InteractDTDS].[UARI_CELLS].[CONTROLCELLID] 
Is Controlint64attribute[InteractDTDS].[UARI_CELLS].[ISCONTROL] 
Campaign IDdecimalidentifier[InteractDTDS].[UARI_CELLS].[CAMPAIGNID] 
Eligible StatSequence Numberdecimalidentifier[InteractRTDS].[UARI_ELIGSTAT].[SEQNUM] 
Interactive Channel IDdecimalidentifier[InteractRTDS].[UARI_ELIGSTAT].[ICID] 
Interactive ChannelcharacterLength16attribute[InteractRTDS].[UARI_ELIGSTAT].[ICNAME] 
Offer IDdecimalidentifier[InteractRTDS].[UARI_ELIGSTAT].[OFFERID] 
Offer NamecharacterLength16attribute[InteractRTDS].[UARI_ELIGSTAT].[OFFERNAME] 
Time IDdecimalfact[InteractRTDS].[UARI_ELIGSTAT].[TIMEID] 
Date IDdecimalfact[InteractRTDS].[UARI_ELIGSTAT].[DATEID] 
Cell IDdecimalfact[InteractRTDS].[UARI_ELIGSTAT].[CELLID] 
Cell NamecharacterLength16attribute[InteractRTDS].[UARI_ELIGSTAT].[CELLNAME] 
Cell CodecharacterLength16attribute[InteractRTDS].[UARI_ELIGSTAT].[CELLCODE] 
Interaction Point IDdecimalfact[InteractRTDS].[UARI_ELIGSTAT].[IPID] 
Interaction PointcharacterLength16attribute[InteractRTDS].[UARI_ELIGSTAT].[IPNAME] 
Eligible Opportunitiesdecimalfact[InteractRTDS].[UARI_ELIGSTAT].[ELIGIBLEOPPS] 
Defaulted StatSequence Numberdecimalidentifier[InteractRTDS].[UARI_DEFAULTEDSTAT].[SEQNUM] 
Time IDdecimalidentifier[InteractRTDS].[UARI_DEFAULTEDSTAT].[TIMEID] 
Date IDdecimalidentifier[InteractRTDS].[UARI_DEFAULTEDSTAT].[DATEID] 
Segment IDdecimalidentifier[InteractRTDS].[UARI_DEFAULTEDSTAT].[SEGMENTID] 
SegmentcharacterLength16attribute[InteractRTDS].[UARI_DEFAULTEDSTAT].[SEGMENTNAME] 
Interaction Point IDdecimalidentifier[InteractRTDS].[UARI_DEFAULTEDSTAT].[IPID] 
Interaction PointcharacterLength16attribute[InteractRTDS].[UARI_DEFAULTEDSTAT].[IPNAME] 
Interactive Channel IDdecimalidentifier[InteractRTDS].[UARI_DEFAULTEDSTAT].[ICID] 
Defaulteddecimalfact[InteractRTDS].[UARI_DEFAULTEDSTAT].[OCCURRENCES] 
Treatment Rule Inventory Campaign to OfferOffer IDdecimalidentifier[InteractDTDS].[UARI_TRI_CAMP_OFF].[OFFERID] 
Offer NamecharacterLength16attribute[InteractDTDS].[UARI_TRI_CAMP_OFF].[OFFERNAME] 
Campaign IDdecimalidentifier[InteractDTDS].[UARI_TRI_CAMP_OFF].[CAMPAIGNID] 
Campaign NamecharacterLength16attribute[InteractDTDS].[UARI_TRI_CAMP_OFF].[CAMPAIGNNAME] 
Campaign CodecharacterLength16attribute[InteractDTDS].[UARI_TRI_CAMP_OFF].[CAMPAIGNCODE] 
Localization LookupLookup IDint64fact[InteractDTDS].[UARI_LOOKUP].[LKUP_ID] 
Lookup CodecharacterLength16attribute[InteractDTDS].[UARI_LOOKUP].[LKUP_CODE] 
Lookup TypecharacterLength16attribute[InteractDTDS].[UARI_LOOKUP].[LKUP_TYPE] 
DescriptioncharacterLength16attribute[InteractDTDS].[UARI_LOOKUP].[DESCRIPTION] 
LocalecharacterLength16attribute[InteractDTDS].[UARI_LOOKUP].[LOCALE] 
Localized StringcharacterLength16attribute[InteractDTDS].[UARI_LOOKUP].[LOCALIZED_STRING] 
CalendarDate IDdecimalidentifier[InteractDTDS].[UARI_CALENDAR].[DATEID] 
Yearint64attribute[InteractDTDS].[UARI_CALENDAR].[YEAR] 
Fiscal Yearint64attribute[InteractDTDS].[UARI_CALENDAR].[FISCALYEAR] 
Quarterint64attribute[InteractDTDS].[UARI_CALENDAR].[QUARTER] 
Fiscal Quarterint64attribute[InteractDTDS].[UARI_CALENDAR].[FISCALQUARTER] 
Monthint64attribute[InteractDTDS].[UARI_CALENDAR].[MONTH] 
Week of Yearint64attribute[InteractDTDS].[UARI_CALENDAR].[WEEKOFYEAR] 
Week of Monthint64attribute[InteractDTDS].[UARI_CALENDAR].[WEEKOFMONTH] 
Day of Yearint64attribute[InteractDTDS].[UARI_CALENDAR].[DAYOFYEAR] 
Day of Monthint64attribute[InteractDTDS].[UARI_CALENDAR].[DAYOFMONTH] 
Day of Weekint64attribute[InteractDTDS].[UARI_CALENDAR].[DAYOFWEEK] 
Actual DatedateTimeidentifier[InteractDTDS].[UARI_CALENDAR].[ACTUALDATE] 
First Day of WeekdateTimeattribute[InteractDTDS].[UARI_CALENDAR].[FIRSTDAYOFWEEK] 
Last Day of WeekdateTimeattribute[InteractDTDS].[UARI_CALENDAR].[LASTDAYOFWEEK] 
TimeTime IDdecimalidentifier[InteractDTDS].[UARI_TIME].[TIMEID] 
Hourint64identifier[InteractDTDS].[UARI_TIME].[HOUR] 
Minuteint64identifier[InteractDTDS].[UARI_TIME].[MINUTE] 
Last 14 Days CalendarDate IDdecimalidentifier[Interact Model].[Calendar].[Date ID] 
Yearint64attribute[Interact Model].[Calendar].[Year] 
Fiscal Yearint64attribute[Interact Model].[Calendar].[Fiscal Year] 
Quarterint64attribute[Interact Model].[Calendar].[Quarter] 
Fiscal Quarterint64attribute[Interact Model].[Calendar].[Fiscal Quarter] 
Monthint64attribute[Interact Model].[Calendar].[Month] 
Week of Yearint64attribute[Interact Model].[Calendar].[Week of Year] 
Week of Monthint64attribute[Interact Model].[Calendar].[Week of Month] 
Day of Yearint64attribute[Interact Model].[Calendar].[Day of Year] 
Day of Monthint64attribute[Interact Model].[Calendar].[Day of Month] 
Day of Weekint64attribute[Interact Model].[Calendar].[Day of Week] 
Actual DatedateTimeidentifier[Interact Model].[Calendar].[Actual Date] 
First Day of WeekdateTimeattribute[Interact Model].[Calendar].[First Day of Week] 
Last Day of WeekdateTimeattribute[Interact Model].[Calendar].[Last Day of Week] 
Last 24 Hours LookupHourdecimalattribute[InteractDTDS].[LAST_24_HOURS_LOOKUP].[HOUR] 
Actual DatedateTimeidentifier[InteractDTDS].[LAST_24_HOURS_LOOKUP].[ACTUALDATE] 
Namespace/FolderQuery SubjectQuery ItemTypeUsageRef Obj/Expr.
Namespace/FolderQuery SubjectQuery ItemTypeUsageRef Obj/Expr.
SummaryInteractive Channel by Offer Number of Times PresentedInteractive Channel IDdecimalidentifier[InteractDTDS].[UARI_ICP_OCH].[ICID] 
Interactive ChannelcharacterLength16attribute[InteractDTDS].[UARI_ICP_OCH].[ICNAME] 
Interaction Point IDfloat64identifier[InteractDTDS].[UARI_ICP_OCH].[IPID] 
Interaction PointcharacterLength16attribute[InteractDTDS].[UARI_ICP_OCH].[IPNAME] 
Offer IDdecimalidentifier[InteractDTDS].[UARI_ICP_OCH].[OFFERID] 
Presentedfloat64fact[InteractDTDS].[UARI_ICP_OCH].[NUM_TIMES_PRES] 
Presented Model-Drivenfloat64fact[InteractDTDS].[UARI_ICP_OCH].[NUM_PRES_MODELDRVN] 
Presented Randomfloat64fact[InteractDTDS].[UARI_ICP_OCH].[NUM_PRES_RANDOM] 
Interactive Channel by Offer Elig OppsInteractive Channel IDdecimalidentifier[InteractRTDS].[UARI_ICP_OES].[ICID] 
Interactive ChannelcharacterLength16attribute[InteractRTDS].[UARI_ICP_OES].[ICNAME] 
Interaction Point IDdecimalidentifier[InteractRTDS].[UARI_ICP_OES].[IPID] 
Interaction PointcharacterLength16attribute[InteractRTDS].[UARI_ICP_OES].[IPNAME] 
Offer IDdecimalidentifier[InteractRTDS].[UARI_ICP_OES].[OFFERID] 
Eligible Opportunitiesfloat64factIF([InteractRTDS].[UARI_ICP_OES].[ELIGIBLEOPPS] is missing) THEN(0) ELSE([InteractRTDS].[UARI_ICP_OES].[ELIGIBLEOPPS]) 
Interactive Channel by Offer Response HistoryInteractive Channel IDdecimalidentifier[InteractDTDS].[UARI_ICP_ORH].[ICID] 
Interactive ChannelcharacterLength16attribute[InteractDTDS].[UARI_ICP_ORH].[ICNAME] 
Interaction Point IDfloat64identifier[InteractDTDS].[UARI_ICP_ORH].[IPID] 
Interaction PointcharacterLength16attribute[InteractDTDS].[UARI_ICP_ORH].[IPNAME] 
Offer IDdecimalidentifier[InteractDTDS].[UARI_ICP_ORH].[OFFERID] 
Acceptedfloat64fact[InteractDTDS].[UARI_ICP_ORH].[NUM_TIMES_ACCP] 
Accepted Model-Drivenfloat64fact[InteractDTDS].[UARI_ICP_ORH].[NUM_ACCP_MODELDRVN] 
Accepted Randomfloat64fact[InteractDTDS].[UARI_ICP_ORH].[NUM_ACCP_RANDOM] 
Rejectedfloat64fact[InteractDTDS].[UARI_ICP_ORH].[NUM_TIME_REJ] 
Namespace/FolderQuery SubjectQuery ItemTypeUsageRef Obj/Expr.
Interactive Channel by Offer Performance Summary Star Schema
model/Interactive Channel by Offer Performance Summary Star Schema.jpg
Offer (shortcut) [Interact Model].[Offer]
Interactive Channel by Offer Number of Times Presented (shortcut) [Interact Model].[Interactive Channel by Offer Number of Times Presented]
Interactive Channel by Offer Elig Opps (shortcut) [Interact Model].[Interactive Channel by Offer Elig Opps]
Interactive Channel by Offer Response History (shortcut) [Interact Model].[Interactive Channel by Offer Response History]
By DayInteractive Channel by Offer Number of Times Presented by DayInteractive Channel IDdecimalidentifier[InteractDTDS].[UARI_ICP_OCH_DY].[ICID] 
Interactive ChannelcharacterLength16attribute[InteractDTDS].[UARI_ICP_OCH_DY].[ICNAME] 
Interaction Point IDfloat64identifier[InteractDTDS].[UARI_ICP_OCH_DY].[IPID] 
Interaction PointcharacterLength16attribute[InteractDTDS].[UARI_ICP_OCH_DY].[IPNAME] 
Offer IDdecimalidentifier[InteractDTDS].[UARI_ICP_OCH_DY].[OFFERID] 
Actual DatedateTimeidentifier[InteractDTDS].[UARI_ICP_OCH_DY].[ACTUALDATE] 
Presentedfloat64fact[InteractDTDS].[UARI_ICP_OCH_DY].[NUM_TIMES_PRES] 
Presented Model-Drivenfloat64fact[InteractDTDS].[UARI_ICP_OCH_DY].[NUM_PRES_MODELDRVN] 
Presented Randomfloat64fact[InteractDTDS].[UARI_ICP_OCH_DY].[NUM_PRES_RANDOM] 
Interactive Channel by Offer Elig Opps by DayInteractive Channel IDdecimalidentifier[InteractRTDS].[UARI_ICP_OES_DY].[ICID] 
Interactive ChannelcharacterLength16attribute[InteractRTDS].[UARI_ICP_OES_DY].[ICNAME] 
Interaction Point IDdecimalidentifier[InteractRTDS].[UARI_ICP_OES_DY].[IPID] 
Interaction PointcharacterLength16attribute[InteractRTDS].[UARI_ICP_OES_DY].[IPNAME] 
Offer IDdecimalidentifier[InteractRTDS].[UARI_ICP_OES_DY].[OFFERID] 
Actual DatedateTimeidentifier[InteractRTDS].[UARI_ICP_OES_DY].[ACTUALDATE] 
Eligible Opportunitiesfloat64fact[InteractRTDS].[UARI_ICP_OES_DY].[ELIGIBLEOPPS] 
Interactive Channel by Offer Response History by DayInteractive Channel IDdecimalidentifier[InteractDTDS].[UARI_ICP_ORH_DY].[ICID] 
Interactive ChannelcharacterLength16attribute[InteractDTDS].[UARI_ICP_ORH_DY].[ICNAME] 
Interaction Point IDfloat64identifier[InteractDTDS].[UARI_ICP_ORH_DY].[IPID] 
Interaction PointcharacterLength16attribute[InteractDTDS].[UARI_ICP_ORH_DY].[IPNAME] 
Offer IDdecimalidentifier[InteractDTDS].[UARI_ICP_ORH_DY].[OFFERID] 
Actual DatedateTimeidentifier[InteractDTDS].[UARI_ICP_ORH_DY].[ACTUALDATE] 
Acceptedfloat64fact[InteractDTDS].[UARI_ICP_ORH_DY].[NUM_TIMES_ACCP] 
Accepted Model-Drivenfloat64fact[InteractDTDS].[UARI_ICP_ORH_DY].[NUM_ACCP_MODELDRVN] 
Accepted Randomfloat64fact[InteractDTDS].[UARI_ICP_ORH_DY].[NUM_ACCP_RANDOM] 
Rejectedfloat64fact[InteractDTDS].[UARI_ICP_ORH_DY].[NUM_TIME_REJ] 
Namespace/FolderQuery SubjectQuery ItemTypeUsageRef Obj/Expr.
Interactive Channel by Offer Performance by Day Star Schema
model/Interactive Channel by Offer Performance by Day Star Schema.jpg
Offer (shortcut) [Interact Model].[Offer]
Interactive Channel by Offer Number of Times Presented by Day (shortcut) [Interact Model].[Interactive Channel by Offer Number of Times Presented by Day]
Interactive Channel by Offer Elig Opps by Day (shortcut) [Interact Model].[Interactive Channel by Offer Elig Opps by Day]
Interactive Channel by Offer Response History by Day (shortcut) [Interact Model].[Interactive Channel by Offer Response History by Day]
Calendar (shortcut) [Interact Model].[Calendar]
By HourInteractive Channel by Offer Number of Times Presented by HourInteractive Channel IDdecimalidentifier[InteractDTDS].[UARI_ICP_OCH_HR].[ICID] 
Interactive ChannelcharacterLength16attribute[InteractDTDS].[UARI_ICP_OCH_HR].[ICNAME] 
Interaction Point IDfloat64identifier[InteractDTDS].[UARI_ICP_OCH_HR].[IPID] 
Interaction PointcharacterLength16attribute[InteractDTDS].[UARI_ICP_OCH_HR].[IPNAME] 
Offer IDdecimalidentifier[InteractDTDS].[UARI_ICP_OCH_HR].[OFFERID] 
Hourint64identifier[InteractDTDS].[UARI_ICP_OCH_HR].[HOUR] 
Actual DatedateTimeidentifier[InteractDTDS].[UARI_ICP_OCH_HR].[ACTUALDATE] 
Presentedfloat64fact[InteractDTDS].[UARI_ICP_OCH_HR].[NUM_TIMES_PRES] 
Presented Model-Drivenfloat64fact[InteractDTDS].[UARI_ICP_OCH_HR].[NUM_PRES_MODELDRVN] 
Presented Randomfloat64fact[InteractDTDS].[UARI_ICP_OCH_HR].[NUM_PRES_RANDOM] 
Interactive Channel by Offer Respone History by HourInteractive Channel IDdecimalidentifier[InteractDTDS].[UARI_ICP_ORH_HR].[ICID] 
Interactive ChannelcharacterLength16attribute[InteractDTDS].[UARI_ICP_ORH_HR].[ICNAME] 
Interaction Point IDfloat64identifier[InteractDTDS].[UARI_ICP_ORH_HR].[IPID] 
Interaction PointcharacterLength16attribute[InteractDTDS].[UARI_ICP_ORH_HR].[IPNAME] 
Offer IDdecimalidentifier[InteractDTDS].[UARI_ICP_ORH_HR].[OFFERID] 
Hourint64identifier[InteractDTDS].[UARI_ICP_ORH_HR].[HOUR] 
Actual DatedateTimeidentifier[InteractDTDS].[UARI_ICP_ORH_HR].[ACTUALDATE] 
Acceptedfloat64fact[InteractDTDS].[UARI_ICP_ORH_HR].[NUM_TIMES_ACCP] 
Accepted Model-Drivenfloat64fact[InteractDTDS].[UARI_ICP_ORH_HR].[NUM_ACCP_MODELDRVN] 
Accepted Randomfloat64fact[InteractDTDS].[UARI_ICP_ORH_HR].[NUM_ACCP_RANDOM] 
Rejectedfloat64fact[InteractDTDS].[UARI_ICP_ORH_HR].[NUM_TIME_REJ] 
Namespace/FolderQuery SubjectQuery ItemTypeUsageRef Obj/Expr.
Interactive Channel by Offer Performance by Hour Star Schema
model/Interactive Channel by Offer Performance by Hour Star Schema.jpg
Offer (shortcut) [Interact Model].[Offer]
Interactive Channel by Offer Number of Times Presented by Hour (shortcut) [Interact Model].[Interactive Channel by Offer Number of Times Presented by Hour]
Interactive Channel by Offer Respone History by Hour (shortcut) [Interact Model].[Interactive Channel by Offer Respone History by Hour]
Namespace/FolderQuery SubjectQuery ItemTypeUsageRef Obj/Expr.
Segment SummaryInteractive Channel by Segment Number of Times PresentedInteractive Channel IDdecimalidentifier[InteractDTDS].[UARI_ICP_SEGCH].[ICID] 
Interactive ChannelcharacterLength16attribute[InteractDTDS].[UARI_ICP_SEGCH].[ICNAME] 
Interaction Point IDfloat64identifier[InteractDTDS].[UARI_ICP_SEGCH].[IPID] 
Interaction PointcharacterLength16attribute[InteractDTDS].[UARI_ICP_SEGCH].[IPNAME] 
Segment IDdecimalidentifier[InteractDTDS].[UARI_ICP_SEGCH].[SEGMENTID] 
SegmentcharacterLength16attribute[InteractDTDS].[UARI_ICP_SEGCH].[SEGMENT_NAME] 
Presentedfloat64fact[InteractDTDS].[UARI_ICP_SEGCH].[NUM_TIMES_PRES] 
Presented Model-Drivenfloat64fact[InteractDTDS].[UARI_ICP_SEGCH].[NUM_PRES_MODELDRVN] 
Presented Randomfloat64fact[InteractDTDS].[UARI_ICP_SEGCH].[NUM_PRES_RANDOM] 
Interactive Channel by Segment Times DefaultedInteractive Channel IDdecimalidentifier[InteractRTDS].[UARI_ICP_SEGDS].[ICID] 
Interaction Point IDdecimalidentifier[InteractRTDS].[UARI_ICP_SEGDS].[IPID] 
Segment IDdecimalidentifier[InteractRTDS].[UARI_ICP_SEGDS].[SEGMENTID] 
Defaultedfloat64fact[InteractRTDS].[UARI_ICP_SEGDS].[NUM_OF_OCCURRENCES] 
Interactive Channel by Segment Response HistoryInteractive Channel IDdecimalidentifier[InteractDTDS].[UARI_ICP_SEGRH].[ICID] 
Interactive ChannelcharacterLength16attribute[InteractDTDS].[UARI_ICP_SEGRH].[ICNAME] 
Interaction Point IDfloat64identifier[InteractDTDS].[UARI_ICP_SEGRH].[IPID] 
Interaction PointcharacterLength16attribute[InteractDTDS].[UARI_ICP_SEGRH].[IPNAME] 
Segment IDdecimalidentifier[InteractDTDS].[UARI_ICP_SEGRH].[SEGMENTID] 
SegmentcharacterLength16attribute[InteractDTDS].[UARI_ICP_SEGRH].[SEGMENT_NAME] 
Acceptedfloat64fact[InteractDTDS].[UARI_ICP_SEGRH].[NUM_TIMES_ACCP] 
Accepted Model-Drivenfloat64fact[InteractDTDS].[UARI_ICP_SEGRH].[NUM_ACCP_MODELDRVN] 
Accepted Randomfloat64fact[InteractDTDS].[UARI_ICP_SEGRH].[NUM_ACCP_RANDOM] 
Rejectedfloat64fact[InteractDTDS].[UARI_ICP_SEGRH].[NUM_TIME_REJ] 
Namespace/FolderQuery SubjectQuery ItemTypeUsageRef Obj/Expr.
Interactive Channel by Segment Summary Star Schema
model/Interactive Channel by Segment Summary Star Schema.jpg
Interactive Channel by Segment Number of Times Presented (shortcut) [Interact Model].[Interactive Channel by Segment Number of Times Presented]
Interactive Channel by Segment Times Defaulted (shortcut) [Interact Model].[Interactive Channel by Segment Times Defaulted]
Interactive Channel by Segment Response History (shortcut) [Interact Model].[Interactive Channel by Segment Response History]
Segment by DayInteractive Channel by Segment Number of Times Presented by DayInteractive Channel IDdecimalidentifier[InteractDTDS].[UARI_ICP_SEGCH_DY].[ICID] 
Interactive ChannelcharacterLength16attribute[InteractDTDS].[UARI_ICP_SEGCH_DY].[ICNAME] 
Interaction Point IDfloat64identifier[InteractDTDS].[UARI_ICP_SEGCH_DY].[IPID] 
Interaction PointcharacterLength16attribute[InteractDTDS].[UARI_ICP_SEGCH_DY].[IPNAME] 
Segment IDdecimalidentifier[InteractDTDS].[UARI_ICP_SEGCH_DY].[SEGMENTID] 
SegmentcharacterLength16attribute[InteractDTDS].[UARI_ICP_SEGCH_DY].[SEGMENT_NAME] 
Actual DatedateTimeidentifier[InteractDTDS].[UARI_ICP_SEGCH_DY].[ACTUALDATE] 
Presentedfloat64fact[InteractDTDS].[UARI_ICP_SEGCH_DY].[NUM_TIMES_PRES] 
Presented Model-Drivenfloat64fact[InteractDTDS].[UARI_ICP_SEGCH_DY].[NUM_PRES_MODELDRVN] 
Presented Randomfloat64fact[InteractDTDS].[UARI_ICP_SEGCH_DY].[NUM_PRES_RANDOM] 
Interactive Channel by Segment Response History by DayInteractive Channel IDdecimalidentifier[InteractDTDS].[UARI_ICP_SEGRH_DY].[ICID] 
Interactive ChannelcharacterLength16attribute[InteractDTDS].[UARI_ICP_SEGRH_DY].[ICNAME] 
Interaction Point IDfloat64identifier[InteractDTDS].[UARI_ICP_SEGRH_DY].[IPID] 
Interaction PointcharacterLength16attribute[InteractDTDS].[UARI_ICP_SEGRH_DY].[IPNAME] 
Segment IDdecimalidentifier[InteractDTDS].[UARI_ICP_SEGRH_DY].[SEGMENTID] 
SegmentcharacterLength16attribute[InteractDTDS].[UARI_ICP_SEGRH_DY].[SEGMENT_NAME] 
Actual DatedateTimeidentifier[InteractDTDS].[UARI_ICP_SEGRH_DY].[ACTUALDATE] 
Acceptedfloat64fact[InteractDTDS].[UARI_ICP_SEGRH_DY].[NUM_TIMES_ACCP] 
Accepted Model-Drivenfloat64fact[InteractDTDS].[UARI_ICP_SEGRH_DY].[NUM_ACCP_MODELDRVN] 
Accepted Randomfloat64fact[InteractDTDS].[UARI_ICP_SEGRH_DY].[NUM_ACCP_RANDOM] 
Rejectedfloat64fact[InteractDTDS].[UARI_ICP_SEGRH_DY].[NUM_TIME_REJ] 
Namespace/FolderQuery SubjectQuery ItemTypeUsageRef Obj/Expr.
Interactive Channel by Segment by Day Star Schema
model/Interactive Channel by Segment by Day Star Schema.jpg
Interactive Channel by Segment Number of Times Presented by Day (shortcut) [Interact Model].[Interactive Channel by Segment Number of Times Presented by Day]
Interactive Channel by Segment Response History by Day (shortcut) [Interact Model].[Interactive Channel by Segment Response History by Day]
Segment by HourInteractive Channel by Segment Number of Times Presented by HourInteractive Channel IDdecimalidentifier[InteractDTDS].[UARI_ICP_SEGCH_HR].[ICID] 
Interactive ChannelcharacterLength16attribute[InteractDTDS].[UARI_ICP_SEGCH_HR].[ICNAME] 
Interaction Point IDfloat64identifier[InteractDTDS].[UARI_ICP_SEGCH_HR].[IPID] 
Interaction PointcharacterLength16attribute[InteractDTDS].[UARI_ICP_SEGCH_HR].[IPNAME] 
Segment IDdecimalidentifier[InteractDTDS].[UARI_ICP_SEGCH_HR].[SEGMENTID] 
SegmentcharacterLength16attribute[InteractDTDS].[UARI_ICP_SEGCH_HR].[SEGMENT_NAME] 
Hourint64identifier[InteractDTDS].[UARI_ICP_SEGCH_HR].[HOUR] 
Actual DatedateTimeidentifier[InteractDTDS].[UARI_ICP_SEGCH_HR].[ACTUALDATE] 
Presentedfloat64fact[InteractDTDS].[UARI_ICP_SEGCH_HR].[NUM_TIMES_PRES] 
Presented Model-Drivenfloat64fact[InteractDTDS].[UARI_ICP_SEGCH_HR].[NUM_PRES_MODELDRVN] 
Presented Randomfloat64fact[InteractDTDS].[UARI_ICP_SEGCH_HR].[NUM_PRES_RANDOM] 
Interactive Channel by Segment Response History by HourInteractive Channel IDdecimalidentifier[InteractDTDS].[UARI_ICP_SEGRH_HR].[ICID] 
Interactive ChannelcharacterLength16attribute[InteractDTDS].[UARI_ICP_SEGRH_HR].[ICNAME] 
Interaction Point IDfloat64identifier[InteractDTDS].[UARI_ICP_SEGRH_HR].[IPID] 
Interaction PointcharacterLength16attribute[InteractDTDS].[UARI_ICP_SEGRH_HR].[IPNAME] 
Segment IDdecimalidentifier[InteractDTDS].[UARI_ICP_SEGRH_HR].[SEGMENTID] 
SegmentcharacterLength16attribute[InteractDTDS].[UARI_ICP_SEGRH_HR].[SEGMENT_NAME] 
Hourint64identifier[InteractDTDS].[UARI_ICP_SEGRH_HR].[HOUR] 
Actual DatedateTimeidentifier[InteractDTDS].[UARI_ICP_SEGRH_HR].[ACTUALDATE] 
Acceptedfloat64fact[InteractDTDS].[UARI_ICP_SEGRH_HR].[NUM_TIMES_ACCP] 
Accepted Model-Drivenfloat64fact[InteractDTDS].[UARI_ICP_SEGRH_HR].[NUM_ACCP_MODELDRVN] 
Accepted Randomfloat64fact[InteractDTDS].[UARI_ICP_SEGRH_HR].[NUM_ACCP_RANDOM] 
Rejectedfloat64fact[InteractDTDS].[UARI_ICP_SEGRH_HR].[NUM_TIME_REJ] 
Namespace/FolderQuery SubjectQuery ItemTypeUsageRef Obj/Expr.
Interactive Channel by Segment by Hour Star Schema
model/Interactive Channel by Segment by Hour Star Schema.jpg
Interactive Channel by Segment Number of Times Presented by Hour (shortcut) [Interact Model].[Interactive Channel by Segment Number of Times Presented by Hour]
Interactive Channel by Segment Response History by Hour (shortcut) [Interact Model].[Interactive Channel by Segment Response History by Hour]
Cumulative Segment by DayCumulative Interactive Channel by Segment Number of Times Presented by DayInteractive Channel IDdecimalidentifier[InteractDTDS].[UARI_ICP_SEGCH_DY].[ICID] 
Interactive ChannelcharacterLength16attribute[InteractDTDS].[UARI_ICP_SEGCH_DY].[ICNAME] 
Interaction Point IDfloat64identifier[InteractDTDS].[UARI_ICP_SEGCH_DY].[IPID] 
Interaction PointcharacterLength16attribute[InteractDTDS].[UARI_ICP_SEGCH_DY].[IPNAME] 
Segment IDdecimalidentifier[InteractDTDS].[UARI_ICP_SEGCH_DY].[SEGMENTID] 
SegmentcharacterLength16attribute[InteractDTDS].[UARI_ICP_SEGCH_DY].[SEGMENT_NAME] 
Actual DatedateTimeidentifier[InteractDTDS].[UARI_ICP_SEGCH_DY].[ACTUALDATE] 
Presentedfloat64factIF([InteractDTDS].[UARI_ICP_SEGCH_DY].[NUM_TIMES_PRES] is missing) THEN(0) ELSE([InteractDTDS].[UARI_ICP_SEGCH_DY].[NUM_TIMES_PRES]) 
Presented Model-Drivenfloat64factIF([InteractDTDS].[UARI_ICP_SEGCH_DY].[NUM_PRES_MODELDRVN] is missing) THEN(0) ELSE([InteractDTDS].[UARI_ICP_SEGCH_DY].[NUM_PRES_MODELDRVN]) 
Presented Randomfloat64factIF([InteractDTDS].[UARI_ICP_SEGCH_DY].[NUM_PRES_RANDOM] is missing) THEN(0) ELSE([InteractDTDS].[UARI_ICP_SEGCH_DY].[NUM_PRES_RANDOM]) 
Cumulative Presentedfloat64factrunning-total([Interact Model].[Cumulative Interactive Channel by Segment Number of Times Presented by Day].[Presented] AT [Interact Model].[Cumulative Interactive Channel by Segment Number of Times Presented by Day].[Interactive Channel ID] ,[Interact Model].[Cumulative Interactive Channel by Segment Number of Times Presented by Day].[Interaction Point ID] ,[Interact Model].[Cumulative Interactive Channel by Segment Number of Times Presented by Day].[Segment ID] ,[Interact Model].[Cumulative Interactive Channel by Segment Number of Times Presented by Day].[Actual Date] FOR [Interact Model].[Cumulative Interactive Channel by Segment Number of Times Presented by Day].[Segment ID] ,[Interact Model].[Cumulative Interactive Channel by Segment Number of Times Presented by Day].[Interaction Point ID] ,[Interact Model].[Cumulative Interactive Channel by Segment Number of Times Presented by Day].[Interactive Channel ID] ) 
Cumulative Presented Model-Drivenfloat64factrunning-total([Interact Model].[Cumulative Interactive Channel by Segment Number of Times Presented by Day].[Presented Model-Driven] AT [Interact Model].[Cumulative Interactive Channel by Segment Number of Times Presented by Day].[Interactive Channel ID] ,[Interact Model].[Cumulative Interactive Channel by Segment Number of Times Presented by Day].[Interaction Point ID] ,[Interact Model].[Cumulative Interactive Channel by Segment Number of Times Presented by Day].[Segment ID] ,[Interact Model].[Cumulative Interactive Channel by Segment Number of Times Presented by Day].[Actual Date] FOR [Interact Model].[Cumulative Interactive Channel by Segment Number of Times Presented by Day].[Segment ID] ,[Interact Model].[Cumulative Interactive Channel by Segment Number of Times Presented by Day].[Interaction Point ID] ,[Interact Model].[Cumulative Interactive Channel by Segment Number of Times Presented by Day].[Interactive Channel ID] ) 
Cumulative Presented Randomfloat64factrunning-total([Interact Model].[Cumulative Interactive Channel by Segment Number of Times Presented by Day].[Presented Random] AT [Interact Model].[Cumulative Interactive Channel by Segment Number of Times Presented by Day].[Interactive Channel ID] ,[Interact Model].[Cumulative Interactive Channel by Segment Number of Times Presented by Day].[Interaction Point ID] ,[Interact Model].[Cumulative Interactive Channel by Segment Number of Times Presented by Day].[Segment ID] ,[Interact Model].[Cumulative Interactive Channel by Segment Number of Times Presented by Day].[Actual Date] FOR [Interact Model].[Cumulative Interactive Channel by Segment Number of Times Presented by Day].[Segment ID] ,[Interact Model].[Cumulative Interactive Channel by Segment Number of Times Presented by Day].[Interaction Point ID] ,[Interact Model].[Cumulative Interactive Channel by Segment Number of Times Presented by Day].[Interactive Channel ID] ) 
Cumulative Interactive Channel by Segment Response History by DayInteractive Channel IDdecimalidentifier[InteractDTDS].[UARI_ICP_SEGRH_DY].[ICID] 
Interactive ChannelcharacterLength16attribute[InteractDTDS].[UARI_ICP_SEGRH_DY].[ICNAME] 
Interaction Point IDfloat64identifier[InteractDTDS].[UARI_ICP_SEGRH_DY].[IPID] 
Interaction PointcharacterLength16attribute[InteractDTDS].[UARI_ICP_SEGRH_DY].[IPNAME] 
Segment IDdecimalidentifier[InteractDTDS].[UARI_ICP_SEGRH_DY].[SEGMENTID] 
SegmentcharacterLength16attribute[InteractDTDS].[UARI_ICP_SEGRH_DY].[SEGMENT_NAME] 
Actual DatedateTimeidentifier[InteractDTDS].[UARI_ICP_SEGRH_DY].[ACTUALDATE] 
Acceptedfloat64factIF([InteractDTDS].[UARI_ICP_SEGRH_DY].[NUM_TIMES_ACCP] is missing) THEN(0) ELSE([InteractDTDS].[UARI_ICP_SEGRH_DY].[NUM_TIMES_ACCP]) 
Accepted Model-Drivenfloat64factIF([InteractDTDS].[UARI_ICP_SEGRH_DY].[NUM_ACCP_MODELDRVN] is missing) THEN(0) ELSE([InteractDTDS].[UARI_ICP_SEGRH_DY].[NUM_ACCP_MODELDRVN]) 
Accepted Randomfloat64factIF([InteractDTDS].[UARI_ICP_SEGRH_DY].[NUM_ACCP_RANDOM] is missing) THEN(0) ELSE([InteractDTDS].[UARI_ICP_SEGRH_DY].[NUM_ACCP_RANDOM]) 
Rejectedfloat64factIF([InteractDTDS].[UARI_ICP_SEGRH_DY].[NUM_TIME_REJ] is missing) THEN(0) ELSE([InteractDTDS].[UARI_ICP_SEGRH_DY].[NUM_TIME_REJ]) 
Cumulative Acceptedfloat64factrunning-total([Interact Model].[Cumulative Interactive Channel by Segment Response History by Day].[Accepted] AT [Interact Model].[Cumulative Interactive Channel by Segment Response History by Day].[Interactive Channel ID] ,[Interact Model].[Cumulative Interactive Channel by Segment Response History by Day].[Interaction Point ID] ,[Interact Model].[Cumulative Interactive Channel by Segment Response History by Day].[Segment ID] ,[Interact Model].[Cumulative Interactive Channel by Segment Response History by Day].[Actual Date] FOR [Interact Model].[Cumulative Interactive Channel by Segment Response History by Day].[Segment ID] ,[Interact Model].[Cumulative Interactive Channel by Segment Response History by Day].[Interaction Point ID] ,[Interact Model].[Cumulative Interactive Channel by Segment Response History by Day].[Interactive Channel ID] ) 
Cumulative Accepted Model-Drivenfloat64factrunning-total([Interact Model].[Cumulative Interactive Channel by Segment Response History by Day].[Accepted Model-Driven] AT [Interact Model].[Cumulative Interactive Channel by Segment Response History by Day].[Interactive Channel ID] ,[Interact Model].[Cumulative Interactive Channel by Segment Response History by Day].[Interaction Point ID] ,[Interact Model].[Cumulative Interactive Channel by Segment Response History by Day].[Segment ID] ,[Interact Model].[Cumulative Interactive Channel by Segment Response History by Day].[Actual Date] FOR [Interact Model].[Cumulative Interactive Channel by Segment Response History by Day].[Segment ID] ,[Interact Model].[Cumulative Interactive Channel by Segment Response History by Day].[Interaction Point ID] ,[Interact Model].[Cumulative Interactive Channel by Segment Response History by Day].[Interactive Channel ID] ) 
Cumulative Accepted Randomfloat64factrunning-total([Interact Model].[Cumulative Interactive Channel by Segment Response History by Day].[Accepted Random] AT [Interact Model].[Cumulative Interactive Channel by Segment Response History by Day].[Interactive Channel ID] ,[Interact Model].[Cumulative Interactive Channel by Segment Response History by Day].[Interaction Point ID] ,[Interact Model].[Cumulative Interactive Channel by Segment Response History by Day].[Segment ID] ,[Interact Model].[Cumulative Interactive Channel by Segment Response History by Day].[Actual Date] FOR [Interact Model].[Cumulative Interactive Channel by Segment Response History by Day].[Segment ID] ,[Interact Model].[Cumulative Interactive Channel by Segment Response History by Day].[Interaction Point ID] ,[Interact Model].[Cumulative Interactive Channel by Segment Response History by Day].[Interactive Channel ID] ) 
Cumulative Rejectedfloat64factrunning-total([Interact Model].[Cumulative Interactive Channel by Segment Response History by Day].[Rejected] AT [Interact Model].[Cumulative Interactive Channel by Segment Response History by Day].[Interactive Channel ID] ,[Interact Model].[Cumulative Interactive Channel by Segment Response History by Day].[Interaction Point ID] ,[Interact Model].[Cumulative Interactive Channel by Segment Response History by Day].[Segment ID] ,[Interact Model].[Cumulative Interactive Channel by Segment Response History by Day].[Actual Date] FOR [Interact Model].[Cumulative Interactive Channel by Segment Response History by Day].[Segment ID] ,[Interact Model].[Cumulative Interactive Channel by Segment Response History by Day].[Interaction Point ID] ,[Interact Model].[Cumulative Interactive Channel by Segment Response History by Day].[Interactive Channel ID] ) 
Namespace/FolderQuery SubjectQuery ItemTypeUsageRef Obj/Expr.
Cumulative Interactive Channel by Segment by Day Star Schema
model/Cumulative Interactive Channel by Segment by Day Star Schema.jpg
Cumulative Interactive Channel by Segment Number of Times Presented by Day (shortcut) [Interact Model].[Cumulative Interactive Channel by Segment Number of Times Presented by Day]
Cumulative Interactive Channel by Segment Response History by Day (shortcut) [Interact Model].[Cumulative Interactive Channel by Segment Response History by Day]
Last 14 Days Calendar (shortcut) [Interact Model].[Last 14 Days Calendar]
Namespace/FolderQuery SubjectQuery ItemTypeUsageRef Obj/Expr.
Interaction Point SummaryInteractive Channel by IP Number of Times PresentedInteractive Channel IDdecimalidentifier[InteractDTDS].[UARI_ICP_IPCH].[ICID] 
Interactive ChannelcharacterLength16attribute[InteractDTDS].[UARI_ICP_IPCH].[ICNAME] 
Interaction Point IDfloat64identifier[InteractDTDS].[UARI_ICP_IPCH].[IPID] 
Interaction PointcharacterLength16attribute[InteractDTDS].[UARI_ICP_IPCH].[IPNAME] 
Presentedfloat64fact[InteractDTDS].[UARI_ICP_IPCH].[NUM_TIMES_PRES] 
Presented Model-Drivenfloat64fact[InteractDTDS].[UARI_ICP_IPCH].[NUM_PRES_MODELDRVN] 
Presented Randomfloat64fact[InteractDTDS].[UARI_ICP_IPCH].[NUM_PRES_RANDOM] 
Interactive Channel by IP Times DefaultedInteractive Channel IDdecimalidentifier[InteractRTDS].[UARI_ICP_IPDS].[ICID] 
Interaction Point IDdecimalidentifier[InteractRTDS].[UARI_ICP_IPDS].[IPID] 
Defaultedfloat64fact[InteractRTDS].[UARI_ICP_IPDS].[NUM_OF_OCCURRENCES] 
Interactive Channel by IP Response HistoryInteractive Channel IDdecimalidentifier[InteractDTDS].[UARI_ICP_IPRH].[ICID] 
Interactive ChannelcharacterLength16attribute[InteractDTDS].[UARI_ICP_IPRH].[ICNAME] 
Interaction Point IDfloat64identifier[InteractDTDS].[UARI_ICP_IPRH].[IPID] 
Interaction PointcharacterLength16attribute[InteractDTDS].[UARI_ICP_IPRH].[IPNAME] 
Acceptedfloat64fact[InteractDTDS].[UARI_ICP_IPRH].[NUM_TIMES_ACCP] 
Accepted Model-Drivenfloat64fact[InteractDTDS].[UARI_ICP_IPRH].[NUM_ACCP_MODELDRVN] 
Accepted Randomfloat64fact[InteractDTDS].[UARI_ICP_IPRH].[NUM_ACCP_RANDOM] 
Rejectedfloat64fact[InteractDTDS].[UARI_ICP_IPRH].[NUM_TIME_REJ] 
Namespace/FolderQuery SubjectQuery ItemTypeUsageRef Obj/Expr.
Interactive Channel by IP Summary Star Schema
model/Interactive Channel by IP Summary Star Schema.jpg
Interactive Channel by IP Number of Times Presented (shortcut) [Interact Model].[Interactive Channel by IP Number of Times Presented]
Interactive Channel by IP Times Defaulted (shortcut) [Interact Model].[Interactive Channel by IP Times Defaulted]
Interactive Channel by IP Response History (shortcut) [Interact Model].[Interactive Channel by IP Response History]
Interaction Point by DayInteractive Channel by IP Number of Times Presented by DayInteractive Channel IDdecimalidentifier[InteractDTDS].[UARI_ICP_IPCH_DY].[ICID] 
Interactive ChannelcharacterLength16attribute[InteractDTDS].[UARI_ICP_IPCH_DY].[ICNAME] 
Interaction Point IDfloat64identifier[InteractDTDS].[UARI_ICP_IPCH_DY].[IPID] 
Interaction PointcharacterLength16attribute[InteractDTDS].[UARI_ICP_IPCH_DY].[IPNAME] 
Actual DatedateTimeidentifier[InteractDTDS].[UARI_ICP_IPCH_DY].[ACTUALDATE] 
Presentedfloat64fact[InteractDTDS].[UARI_ICP_IPCH_DY].[NUM_TIMES_PRES] 
Presented Model-Drivenfloat64fact[InteractDTDS].[UARI_ICP_IPCH_DY].[NUM_PRES_MODELDRVN] 
Presented Randomfloat64fact[InteractDTDS].[UARI_ICP_IPCH_DY].[NUM_PRES_RANDOM] 
Interactive Channel by IP Response History by DayInteractive Channel IDdecimalidentifier[InteractDTDS].[UARI_ICP_IPRH_DY].[ICID] 
Interactive ChannelcharacterLength16attribute[InteractDTDS].[UARI_ICP_IPRH_DY].[ICNAME] 
Interaction Point IDfloat64identifier[InteractDTDS].[UARI_ICP_IPRH_DY].[IPID] 
Interaction PointcharacterLength16attribute[InteractDTDS].[UARI_ICP_IPRH_DY].[IPNAME] 
Actual DatedateTimeidentifier[InteractDTDS].[UARI_ICP_IPRH_DY].[ACTUALDATE] 
Acceptedfloat64fact[InteractDTDS].[UARI_ICP_IPRH_DY].[NUM_TIMES_ACCP] 
Accepted Model-Drivenfloat64fact[InteractDTDS].[UARI_ICP_IPRH_DY].[NUM_ACCP_MODELDRVN] 
Accepted Randomfloat64fact[InteractDTDS].[UARI_ICP_IPRH_DY].[NUM_ACCP_RANDOM] 
Rejectedfloat64fact[InteractDTDS].[UARI_ICP_IPRH_DY].[NUM_TIME_REJ] 
InteractiveChannelToCalendarDate IDdecimalidentifier[InteractDTDS].[UARI_CALENDAR].[DATEID] 
Actual DatedateTimeidentifier[InteractDTDS].[UARI_CALENDAR].[ACTUALDATE] 
Interactive Channel IDdecimalidentifier[Interact Model].[Interactive Channel by IP Number of Times Presented].[Interactive Channel ID] 
Interactive ChannelcharacterLength16attribute[Interact Model].[Interactive Channel by IP Number of Times Presented].[Interactive Channel] 
Interaction Point IDfloat64identifier[Interact Model].[Interactive Channel by IP Number of Times Presented].[Interaction Point ID] 
Interaction PointcharacterLength16attribute[Interact Model].[Interactive Channel by IP Number of Times Presented].[Interaction Point] 
Namespace/FolderQuery SubjectQuery ItemTypeUsageRef Obj/Expr.
Interactive Channel by IP by Day Star Schema
model/Interactive Channel by IP by Day Star Schema.jpg
Interactive Channel by IP Number of Times Presented by Day (shortcut) [Interact Model].[Interactive Channel by IP Number of Times Presented by Day]
Interactive Channel by IP Response History by Day (shortcut) [Interact Model].[Interactive Channel by IP Response History by Day]
InteractiveChannelToCalendar (shortcut) [Interact Model].[InteractiveChannelToCalendar]
Interaction Point by HourInteractive Channel by IP Number of Times Presented by HourInteractive Channel IDdecimalidentifier[InteractDTDS].[UARI_ICP_IPCH_HR].[ICID] 
Interactive ChannelcharacterLength16attribute[InteractDTDS].[UARI_ICP_IPCH_HR].[ICNAME] 
Interaction Point IDfloat64identifier[InteractDTDS].[UARI_ICP_IPCH_HR].[IPID] 
Interaction PointcharacterLength16attribute[InteractDTDS].[UARI_ICP_IPCH_HR].[IPNAME] 
Hourint64identifier[InteractDTDS].[UARI_ICP_IPCH_HR].[HOUR] 
Actual DatedateTimeidentifier[InteractDTDS].[UARI_ICP_IPCH_HR].[ACTUALDATE] 
Presentedfloat64fact[InteractDTDS].[UARI_ICP_IPCH_HR].[NUM_TIMES_PRES] 
Presented Model-Drivenfloat64fact[InteractDTDS].[UARI_ICP_IPCH_HR].[NUM_PRES_MODELDRVN] 
Presented Randomfloat64fact[InteractDTDS].[UARI_ICP_IPCH_HR].[NUM_PRES_RANDOM] 
Interactive Channel by IP Response History by HourInteractive Channel IDdecimalidentifier[InteractDTDS].[UARI_ICP_IPRH_HR].[ICID] 
Interactive ChannelcharacterLength16attribute[InteractDTDS].[UARI_ICP_IPRH_HR].[ICNAME] 
Interaction Point IDfloat64identifier[InteractDTDS].[UARI_ICP_IPRH_HR].[IPID] 
Interaction PointcharacterLength16attribute[InteractDTDS].[UARI_ICP_IPRH_HR].[IPNAME] 
Hourint64identifier[InteractDTDS].[UARI_ICP_IPRH_HR].[HOUR] 
Actual DatedateTimeidentifier[InteractDTDS].[UARI_ICP_IPRH_HR].[ACTUALDATE] 
Acceptedfloat64fact[InteractDTDS].[UARI_ICP_IPRH_HR].[NUM_TIMES_ACCP] 
Accepted Model-Drivenfloat64fact[InteractDTDS].[UARI_ICP_IPRH_HR].[NUM_ACCP_MODELDRVN] 
Accepted Randomfloat64fact[InteractDTDS].[UARI_ICP_IPRH_HR].[NUM_ACCP_RANDOM] 
Rejectedfloat64fact[InteractDTDS].[UARI_ICP_IPRH_HR].[NUM_TIME_REJ] 
Interactive Channel - Last 24 Hours LookupHourfloat64attribute[InteractDTDS].[LAST_24_HOURS_LOOKUP].[HOUR] 
Actual DatedateTimeidentifier[InteractDTDS].[LAST_24_HOURS_LOOKUP].[ACTUALDATE] 
Interactive Channel IDdecimalidentifier[Interact Model].[Interactive Channel by IP Number of Times Presented].[Interactive Channel ID] 
Interactive ChannelcharacterLength16attribute[Interact Model].[Interactive Channel by IP Number of Times Presented].[Interactive Channel] 
Interaction Point IDfloat64identifier[Interact Model].[Interactive Channel by IP Number of Times Presented].[Interaction Point ID] 
Interaction PointcharacterLength16attribute[Interact Model].[Interactive Channel by IP Number of Times Presented].[Interaction Point] 
Namespace/FolderQuery SubjectQuery ItemTypeUsageRef Obj/Expr.
Interactive Channel by IP by Hour Star Schema
model/Interactive Channel by IP by Hour Star Schema.jpg
Interactive Channel by IP Number of Times Presented by Hour (shortcut) [Interact Model].[Interactive Channel by IP Number of Times Presented by Hour]
Interactive Channel by IP Response History by Hour (shortcut) [Interact Model].[Interactive Channel by IP Response History by Hour]
Last 24 Hours (shortcut) [Interact Model].[Last 24 Hours Lookup]
Interactive Channel - Last 24 Hours Lookup (shortcut) [Interact Model].[Interactive Channel - Last 24 Hours Lookup]
Namespace/FolderQuery SubjectQuery ItemTypeUsageRef Obj/Expr.
Campaign Cell SummaryCampaign Cell Performance Number of Times PresentedCampaign IDdecimalidentifier[InteractDTDS].[UARI_CCP_CH].[CAMPAIGNID] 
Cell IDdecimalidentifier[InteractDTDS].[UARI_CCP_CH].[CELLID] 
Presentedfloat64fact[InteractDTDS].[UARI_CCP_CH].[NUM_TIMES_PRES] 
Presented Model-Drivenfloat64fact[InteractDTDS].[UARI_CCP_CH].[NUM_PRES_MODELDRVN] 
Presented Randomfloat64fact[InteractDTDS].[UARI_CCP_CH].[NUM_PRES_RANDOM] 
Campaign Cell Performance Elig OppsCampaign IDint64identifier[InteractRTDS].[UARI_CCP_ES].[CAMPAIGNID] 
Cell IDdecimalidentifier[InteractRTDS].[UARI_CCP_ES].[CELLID] 
Eligible Opportunitiesfloat64fact[InteractRTDS].[UARI_CCP_ES].[ELIGIBLEOPPS] 
Campaign Cell Performance Response HistoryCampaign IDdecimalidentifier[InteractDTDS].[UARI_CCP_RH].[CAMPAIGNID] 
Cell IDdecimalidentifier[InteractDTDS].[UARI_CCP_RH].[CELLID] 
Acceptedfloat64fact[InteractDTDS].[UARI_CCP_RH].[NUM_TIMES_ACCP] 
Accepted Model-Drivenfloat64fact[InteractDTDS].[UARI_CCP_RH].[NUM_ACCP_MODELDRVN] 
Accepted Randomfloat64fact[InteractDTDS].[UARI_CCP_RH].[NUM_ACCP_RANDOM] 
Rejectedfloat64fact[InteractDTDS].[UARI_CCP_RH].[NUM_TIME_REJ] 
Namespace/FolderQuery SubjectQuery ItemTypeUsageRef Obj/Expr.
Campaign Cell Performance Summary Star Schema
model/Campaign Cell Performance Summary Star Schema.jpg
Campaign (shortcut) [Interact Model].[Campaign]
Cells (shortcut) [Interact Model].[Cells]
Campaign Cell Performance Number of Times Presented (shortcut) [Interact Model].[Campaign Cell Performance Number of Times Presented]
Campaign Cell Performance Elig Opps (shortcut) [Interact Model].[Campaign Cell Performance Elig Opps]
Campaign Cell Performance Response History (shortcut) [Interact Model].[Campaign Cell Performance Response History]
Campaign Cell by DayCampaign Cell Number of Times Presented by DayCampaign IDdecimalidentifier[InteractDTDS].[UARI_CCP_CH_DY].[CAMPAIGNID] 
Cell IDdecimalidentifier[InteractDTDS].[UARI_CCP_CH_DY].[CELLID] 
Actual DatedateTimeidentifier[InteractDTDS].[UARI_CCP_CH_DY].[ACTUALDATE] 
Presentedfloat64fact[InteractDTDS].[UARI_CCP_CH_DY].[NUM_TIMES_PRES] 
Presented Model-Drivenfloat64fact[InteractDTDS].[UARI_CCP_CH_DY].[NUM_PRES_MODELDRVN] 
Presented Randomfloat64fact[InteractDTDS].[UARI_CCP_CH_DY].[NUM_PRES_RANDOM] 
Campaign Cell Performance Elig Opps by DayCampaign IDint64identifier[InteractRTDS].[UARI_CCP_ES_DY].[CAMPAIGNID] 
Cell IDdecimalidentifier[InteractRTDS].[UARI_CCP_ES_DY].[CELLID] 
Actual DatedateTimeidentifier[InteractRTDS].[UARI_CCP_ES_DY].[ACTUALDATE] 
Eligible Opportunitiesfloat64fact[InteractRTDS].[UARI_CCP_ES_DY].[ELIGIBLEOPPS] 
Campaign Cell Performance Response History by DayCampaign IDdecimalidentifier[InteractDTDS].[UARI_CCP_RH_DY].[CAMPAIGNID] 
Cell IDdecimalidentifier[InteractDTDS].[UARI_CCP_RH_DY].[CELLID] 
Actual DatedateTimeidentifier[InteractDTDS].[UARI_CCP_RH_DY].[ACTUALDATE] 
Acceptedfloat64fact[InteractDTDS].[UARI_CCP_RH_DY].[NUM_TIMES_ACCP] 
Accepted Model-Drivenfloat64fact[InteractDTDS].[UARI_CCP_RH_DY].[NUM_ACCP_MODELDRVN] 
Accepted Randomfloat64fact[InteractDTDS].[UARI_CCP_RH_DY].[NUM_ACCP_RANDOM] 
Rejectedfloat64fact[InteractDTDS].[UARI_CCP_RH_DY].[NUM_TIME_REJ] 
CellToCalendarDate IDdecimalidentifier[InteractDTDS].[UARI_CALENDAR].[DATEID] 
Actual DatedateTimeidentifier[InteractDTDS].[UARI_CALENDAR].[ACTUALDATE] 
Cell IDdecimalidentifier[Interact Model].[Cells].[Cell ID] 
Cell NamecharacterLength16attribute[Interact Model].[Cells].[Cell Name] 
Cell CodecharacterLength16attribute[Interact Model].[Cells].[Cell Code] 
Control Cell IDdecimalidentifier[Interact Model].[Cells].[Control Cell ID] 
Is Controlint64attribute[Interact Model].[Cells].[Is Control] 
Campaign IDdecimalidentifier[Interact Model].[Cells].[Campaign ID] 
Namespace/FolderQuery SubjectQuery ItemTypeUsageRef Obj/Expr.
Campaign Cell Performance by Day Star Schema
model/Campaign Cell Performance by Day Star Schema.jpg
Campaign (shortcut) [Interact Model].[Campaign]
Campaign Cell Number of Times Presented by Day (shortcut) [Interact Model].[Campaign Cell Number of Times Presented by Day]
Campaign Cell Performance Elig Opps by Day (shortcut) [Interact Model].[Campaign Cell Performance Elig Opps by Day]
Campaign Cell Performance Response History by Day (shortcut) [Interact Model].[Campaign Cell Performance Response History by Day]
CellToCalendar (shortcut) [Interact Model].[CellToCalendar]
Campaign Cell by HourCampaign Cell Number of Times Presented by HourCampaign IDdecimalidentifier[InteractDTDS].[UARI_CCP_CH_HR].[CAMPAIGNID] 
Cell IDdecimalidentifier[InteractDTDS].[UARI_CCP_CH_HR].[CELLID] 
Hourint64identifier[InteractDTDS].[UARI_CCP_CH_HR].[HOUR] 
Actual DatedateTimeidentifier[InteractDTDS].[UARI_CCP_CH_HR].[ACTUALDATE] 
Presentedfloat64fact[InteractDTDS].[UARI_CCP_CH_HR].[NUM_TIMES_PRES] 
Presented Model-Drivenfloat64fact[InteractDTDS].[UARI_CCP_CH_HR].[NUM_PRES_MODELDRVN] 
Presented Randomfloat64fact[InteractDTDS].[UARI_CCP_CH_HR].[NUM_PRES_RANDOM] 
Campaign Cell Performance Elig Opps by HourCampaign IDint64identifier[InteractRTDS].[UARI_CCP_ES_HR].[CAMPAIGNID] 
Cell IDdecimalidentifier[InteractRTDS].[UARI_CCP_ES_HR].[CELLID] 
Hourint64identifier[InteractRTDS].[UARI_CCP_ES_HR].[HOUR] 
Actual DatedateTimeidentifier[InteractRTDS].[UARI_CCP_ES_HR].[ACTUALDATE] 
Eligible Opportunitiesfloat64fact[InteractRTDS].[UARI_CCP_ES_HR].[ELIGIBLEOPPS] 
Campaign Cell Performance Response History by HourCampaign IDdecimalidentifier[InteractDTDS].[UARI_CCP_RH_HR].[CAMPAIGNID] 
Cell IDdecimalidentifier[InteractDTDS].[UARI_CCP_RH_HR].[CELLID] 
Hourint64identifier[InteractDTDS].[UARI_CCP_RH_HR].[HOUR] 
Actual DatedateTimeidentifier[InteractDTDS].[UARI_CCP_RH_HR].[ACTUALDATE] 
Acceptedfloat64fact[InteractDTDS].[UARI_CCP_RH_HR].[NUM_TIMES_ACCP] 
Accepted Model-Drivenfloat64fact[InteractDTDS].[UARI_CCP_RH_HR].[NUM_ACCP_MODELDRVN] 
Accepted Randomfloat64fact[InteractDTDS].[UARI_CCP_RH_HR].[NUM_ACCP_RANDOM] 
Rejectedfloat64fact[InteractDTDS].[UARI_CCP_RH_HR].[NUM_TIME_REJ] 
Cell - Last 24 Hours LookupHourfloat64attribute[InteractDTDS].[LAST_24_HOURS_LOOKUP].[HOUR] 
Actual DatedateTimeidentifier[InteractDTDS].[LAST_24_HOURS_LOOKUP].[ACTUALDATE] 
Cell IDdecimalidentifier[Interact Model].[Cells].[Cell ID] 
Cell NamecharacterLength16attribute[Interact Model].[Cells].[Cell Name] 
Cell CodecharacterLength16attribute[Interact Model].[Cells].[Cell Code] 
Control Cell IDdecimalidentifier[Interact Model].[Cells].[Control Cell ID] 
Is Controlint64attribute[Interact Model].[Cells].[Is Control] 
Campaign IDdecimalidentifier[Interact Model].[Cells].[Campaign ID] 
Namespace/FolderQuery SubjectQuery ItemTypeUsageRef Obj/Expr.
Campaign Cell Performance by Hour Star Schema
model/Campaign Cell Performance by Hour Star Schema.jpg
Campaign (shortcut) [Interact Model].[Campaign]
Cells (shortcut) [Interact Model].[Cells]
Campaign Cell Number of Times Presented by Hour (shortcut) [Interact Model].[Campaign Cell Number of Times Presented by Hour]
Campaign Cell Performance Elig Opps by Hour (shortcut) [Interact Model].[Campaign Cell Performance Elig Opps by Hour]
Campaign Cell Performance Response History by Hour (shortcut) [Interact Model].[Campaign Cell Performance Response History by Hour]
Cell - Last 24 Hours Lookup (shortcut) [Interact Model].[Cell - Last 24 Hours Lookup]
Cumulative Campaign Cell by DayCumulative Campaign Cell Number of Times Presented by DayCampaign IDdecimalidentifier[InteractDTDS].[UARI_CCP_CH_DY].[CAMPAIGNID] 
Cell IDdecimalidentifier[InteractDTDS].[UARI_CCP_CH_DY].[CELLID] 
Actual DatedateTimeidentifier[InteractDTDS].[UARI_CCP_CH_DY].[ACTUALDATE] 
Presentedfloat64factIF([InteractDTDS].[UARI_CCP_CH_DY].[NUM_TIMES_PRES] is missing) THEN(0) ELSE([InteractDTDS].[UARI_CCP_CH_DY].[NUM_TIMES_PRES]) 
Presented Model-Drivenfloat64factIF([InteractDTDS].[UARI_CCP_CH_DY].[NUM_PRES_MODELDRVN] is missing) THEN(0) ELSE([InteractDTDS].[UARI_CCP_CH_DY].[NUM_PRES_MODELDRVN]) 
Presented Randomfloat64factIF([InteractDTDS].[UARI_CCP_CH_DY].[NUM_PRES_RANDOM] is missing) THEN(0) ELSE([InteractDTDS].[UARI_CCP_CH_DY].[NUM_PRES_RANDOM]) 
Cumulative Presentedfloat64factrunning-total([Interact Model].[Cumulative Campaign Cell Number of Times Presented by Day].[Presented] AT [Interact Model].[Cumulative Campaign Cell Number of Times Presented by Day].[Campaign ID] ,[Interact Model].[Cumulative Campaign Cell Number of Times Presented by Day].[Cell ID] ,[Interact Model].[Cumulative Campaign Cell Number of Times Presented by Day].[Actual Date] FOR [Interact Model].[Cumulative Campaign Cell Number of Times Presented by Day].[Cell ID] ,[Interact Model].[Cumulative Campaign Cell Number of Times Presented by Day].[Campaign ID] ) 
Cumulative Presented Model-Drivenfloat64factrunning-total([Interact Model].[Cumulative Campaign Cell Number of Times Presented by Day].[Presented Model-Driven] AT [Interact Model].[Cumulative Campaign Cell Number of Times Presented by Day].[Campaign ID] ,[Interact Model].[Cumulative Campaign Cell Number of Times Presented by Day].[Cell ID] ,[Interact Model].[Cumulative Campaign Cell Number of Times Presented by Day].[Actual Date] FOR [Interact Model].[Cumulative Campaign Cell Number of Times Presented by Day].[Cell ID] ,[Interact Model].[Cumulative Campaign Cell Number of Times Presented by Day].[Campaign ID] ) 
Cumulative Presented Randomfloat64factrunning-total([Interact Model].[Cumulative Campaign Cell Number of Times Presented by Day].[Presented Random] AT [Interact Model].[Cumulative Campaign Cell Number of Times Presented by Day].[Campaign ID] ,[Interact Model].[Cumulative Campaign Cell Number of Times Presented by Day].[Cell ID] ,[Interact Model].[Cumulative Campaign Cell Number of Times Presented by Day].[Actual Date] FOR [Interact Model].[Cumulative Campaign Cell Number of Times Presented by Day].[Campaign ID] ,[Interact Model].[Cumulative Campaign Cell Number of Times Presented by Day].[Cell ID] ) 
Cumulative Campaign Cell Performance Elig Opps by DayCampaign IDdecimalidentifier[InteractRTDS].[UARI_CCP_ES_DY].[CAMPAIGNID] 
Cell IDdecimalidentifier[InteractRTDS].[UARI_CCP_ES_DY].[CELLID] 
Actual DatedateTimeidentifier[InteractRTDS].[UARI_CCP_ES_DY].[ACTUALDATE] 
Eligible Opportunitiesfloat64factIF([InteractRTDS].[UARI_CCP_ES_DY].[ELIGIBLEOPPS] is missing) THEN(0) ELSE([InteractRTDS].[UARI_CCP_ES_DY].[ELIGIBLEOPPS]) 
Cumulative Eligible Opportunitiesfloat64factrunning-total([Interact Model].[Cumulative Campaign Cell Performance Elig Opps by Day].[Eligible Opportunities] AT [Interact Model].[Cumulative Campaign Cell Performance Elig Opps by Day].[Campaign ID] ,[Interact Model].[Cumulative Campaign Cell Performance Elig Opps by Day].[Cell ID] ,[Interact Model].[Cumulative Campaign Cell Performance Elig Opps by Day].[Actual Date] FOR [Interact Model].[Cumulative Campaign Cell Performance Elig Opps by Day].[Campaign ID] ,[Interact Model].[Cumulative Campaign Cell Performance Elig Opps by Day].[Cell ID] ) 
Cumulative Campaign Cell Performance Response History by DayCampaign IDdecimalidentifier[InteractDTDS].[UARI_CCP_RH_DY].[CAMPAIGNID] 
Cell IDdecimalidentifier[InteractDTDS].[UARI_CCP_RH_DY].[CELLID] 
Actual DatedateTimeidentifier[InteractDTDS].[UARI_CCP_RH_DY].[ACTUALDATE] 
Acceptedfloat64factIF([InteractDTDS].[UARI_CCP_RH_DY].[NUM_TIMES_ACCP] is missing) THEN(0) ELSE([InteractDTDS].[UARI_CCP_RH_DY].[NUM_TIMES_ACCP]) 
Accepted Model-Drivenfloat64factIF([InteractDTDS].[UARI_CCP_RH_DY].[NUM_ACCP_MODELDRVN] is missing) THEN(0) ELSE([InteractDTDS].[UARI_CCP_RH_DY].[NUM_ACCP_MODELDRVN]) 
Accepted Randomfloat64factIF([InteractDTDS].[UARI_CCP_RH_DY].[NUM_ACCP_RANDOM] is missing) THEN(0) ELSE([InteractDTDS].[UARI_CCP_RH_DY].[NUM_ACCP_RANDOM]) 
Rejectedfloat64factIF([InteractDTDS].[UARI_CCP_RH_DY].[NUM_TIME_REJ] is missing) THEN(0) ELSE([InteractDTDS].[UARI_CCP_RH_DY].[NUM_TIME_REJ]) 
Cumulative Acceptedfloat64factrunning-total([Interact Model].[Cumulative Campaign Cell Performance Response History by Day].[Accepted] AT [Interact Model].[Cumulative Campaign Cell Performance Response History by Day].[Campaign ID] ,[Interact Model].[Cumulative Campaign Cell Performance Response History by Day].[Cell ID] ,[Interact Model].[Cumulative Campaign Cell Performance Response History by Day].[Actual Date] FOR [Interact Model].[Cumulative Campaign Cell Performance Response History by Day].[Cell ID] ,[Interact Model].[Cumulative Campaign Cell Performance Response History by Day].[Campaign ID] ) 
Cumulative Accepted Model-Drivenfloat64factrunning-total([Interact Model].[Cumulative Campaign Cell Performance Response History by Day].[Accepted Model-Driven] AT [Interact Model].[Cumulative Campaign Cell Performance Response History by Day].[Campaign ID] ,[Interact Model].[Cumulative Campaign Cell Performance Response History by Day].[Cell ID] ,[Interact Model].[Cumulative Campaign Cell Performance Response History by Day].[Actual Date] FOR [Interact Model].[Cumulative Campaign Cell Performance Response History by Day].[Cell ID] ,[Interact Model].[Cumulative Campaign Cell Performance Response History by Day].[Campaign ID] ) 
Cumulative Accepted Randomfloat64factrunning-total([Interact Model].[Cumulative Campaign Cell Performance Response History by Day].[Accepted Random] AT [Interact Model].[Cumulative Campaign Cell Performance Response History by Day].[Campaign ID] ,[Interact Model].[Cumulative Campaign Cell Performance Response History by Day].[Cell ID] ,[Interact Model].[Cumulative Campaign Cell Performance Response History by Day].[Actual Date] FOR [Interact Model].[Cumulative Campaign Cell Performance Response History by Day].[Cell ID] ,[Interact Model].[Cumulative Campaign Cell Performance Response History by Day].[Campaign ID] ) 
Cumulative Rejectedfloat64factrunning-total([Interact Model].[Cumulative Campaign Cell Performance Response History by Day].[Rejected] AT [Interact Model].[Cumulative Campaign Cell Performance Response History by Day].[Campaign ID] ,[Interact Model].[Cumulative Campaign Cell Performance Response History by Day].[Cell ID] ,[Interact Model].[Cumulative Campaign Cell Performance Response History by Day].[Actual Date] FOR [Interact Model].[Cumulative Campaign Cell Performance Response History by Day].[Campaign ID] ,[Interact Model].[Cumulative Campaign Cell Performance Response History by Day].[Cell ID] ) 
Namespace/FolderQuery SubjectQuery ItemTypeUsageRef Obj/Expr.
Cumulative Campaign Cell Performance by Day Star Schema
model/Cumulative Campaign Cell Performance by Day Star Schema.jpg
Campaign (shortcut) [Interact Model].[Campaign]
Cells (shortcut) [Interact Model].[Cells]
Cumulative Campaign Cell Number of Times Presented by Day (shortcut) [Interact Model].[Cumulative Campaign Cell Number of Times Presented by Day]
Cumulative Campaign Cell Performance Response History by Day (shortcut) [Interact Model].[Cumulative Campaign Cell Performance Response History by Day]
Last 14 Days Calendar (shortcut) [Interact Model].[Last 14 Days Calendar]
Namespace/FolderQuery SubjectQuery ItemTypeUsageRef Obj/Expr.
Campaign Cell by Offer SummaryCampaign Cell by Offer Number of Times PresentedCampaign IDdecimalidentifier[InteractDTDS].[UARI_CCP_OCH].[CAMPAIGNID] 
Cell IDdecimalidentifier[InteractDTDS].[UARI_CCP_OCH].[CELLID] 
Offer IDdecimalidentifier[InteractDTDS].[UARI_CCP_OCH].[OFFERID] 
Presentedfloat64fact[InteractDTDS].[UARI_CCP_OCH].[NUM_TIMES_PRES] 
Presented Model-Drivenfloat64fact[InteractDTDS].[UARI_CCP_OCH].[NUM_PRES_MODELDRVN] 
Presented Randomfloat64fact[InteractDTDS].[UARI_CCP_OCH].[NUM_PRES_RANDOM] 
Campaign Cell by Offer Elig OppsCampaign IDint64identifier[InteractRTDS].[UARI_CCP_OES].[CAMPAIGNID] 
Cell IDdecimalidentifier[InteractRTDS].[UARI_CCP_OES].[CELLID] 
Offer IDdecimalidentifier[InteractRTDS].[UARI_CCP_OES].[OFFERID] 
Eligible Opportunitiesfloat64fact[InteractRTDS].[UARI_CCP_OES].[ELIGIBLEOPPS] 
Campaign Cell by Offer Response HistoryCampaign IDdecimalidentifier[InteractDTDS].[UARI_CCP_ORH].[CAMPAIGNID] 
Cell IDdecimalidentifier[InteractDTDS].[UARI_CCP_ORH].[CELLID] 
Offer IDdecimalidentifier[InteractDTDS].[UARI_CCP_ORH].[OFFERID] 
Acceptedfloat64fact[InteractDTDS].[UARI_CCP_ORH].[NUM_TIMES_ACCP] 
Accepted Model-Drivenfloat64fact[InteractDTDS].[UARI_CCP_ORH].[NUM_ACCP_MODELDRVN] 
Accepted Randomfloat64fact[InteractDTDS].[UARI_CCP_ORH].[NUM_ACCP_RANDOM] 
Rejectedfloat64fact[InteractDTDS].[UARI_CCP_ORH].[NUM_TIME_REJ] 
Namespace/FolderQuery SubjectQuery ItemTypeUsageRef Obj/Expr.
Campaign Cell by Offer Performance Star Schema
model/Campaign Cell by Offer Performance Star Schema.jpg
Campaign (shortcut) [Interact Model].[Campaign]
Offer (shortcut) [Interact Model].[Offer]
Cells (shortcut) [Interact Model].[Cells]
Campaign Cell by Offer Number of Times Presented (shortcut) [Interact Model].[Campaign Cell by Offer Number of Times Presented]
Campaign Cell by Offer Elig Opps (shortcut) [Interact Model].[Campaign Cell by Offer Elig Opps]
Campaign Cell by Offer Response History (shortcut) [Interact Model].[Campaign Cell by Offer Response History]
Namespace/FolderQuery SubjectQuery ItemTypeUsageRef Obj/Expr.
Campaign Cell by Interaction Point SummariesCampaign Cell by IP Number of Times PresentedCampaign IDdecimalidentifier[InteractDTDS].[UARI_CCP_IPCH].[CAMPAIGNID] 
Cell IDdecimalidentifier[InteractDTDS].[UARI_CCP_IPCH].[CELLID] 
Interaction Point IDfloat64identifier[InteractDTDS].[UARI_CCP_IPCH].[IPID] 
Interaction PointcharacterLength16attribute[InteractDTDS].[UARI_CCP_IPCH].[IPNAME] 
Presentedfloat64fact[InteractDTDS].[UARI_CCP_IPCH].[NUM_TIMES_PRES] 
Presented Model-Drivenfloat64fact[InteractDTDS].[UARI_CCP_IPCH].[NUM_PRES_MODELDRVN] 
Presented Randomfloat64fact[InteractDTDS].[UARI_CCP_IPCH].[NUM_PRES_RANDOM] 
Campaign Cell by IP Elig OppsCampaign IDint64fact[InteractRTDS].[UARI_CCP_IPES].[CAMPAIGNID] 
Cell IDdecimalidentifier[InteractRTDS].[UARI_CCP_IPES].[CELLID] 
Interaction Point IDdecimalidentifier[InteractRTDS].[UARI_CCP_IPES].[IPID] 
Interaction PointcharacterLength16attribute[InteractRTDS].[UARI_CCP_IPES].[IPNAME] 
Eligible Opportunitiesfloat64fact[InteractRTDS].[UARI_CCP_IPES].[ELIGIBLEOPPS] 
Campaign Cell by IP Response HistoryCampaign IDdecimalidentifier[InteractDTDS].[UARI_CCP_IPRH].[CAMPAIGNID] 
Cell IDdecimalidentifier[InteractDTDS].[UARI_CCP_IPRH].[CELLID] 
Interaction Point IDfloat64identifier[InteractDTDS].[UARI_CCP_IPRH].[IPID] 
Interaction PointcharacterLength16attribute[InteractDTDS].[UARI_CCP_IPRH].[IPNAME] 
Acceptedfloat64fact[InteractDTDS].[UARI_CCP_IPRH].[NUM_TIMES_ACCP] 
Accepted Model-Drivenfloat64fact[InteractDTDS].[UARI_CCP_IPRH].[NUM_ACCP_MODELDRVN] 
Accepted Randomfloat64fact[InteractDTDS].[UARI_CCP_IPRH].[NUM_ACCP_RANDOM] 
Rejectedfloat64fact[InteractDTDS].[UARI_CCP_IPRH].[NUM_TIME_REJ] 
Namespace/FolderQuery SubjectQuery ItemTypeUsageRef Obj/Expr.
Campaign Cell by IP Star Schema
model/Campaign Cell by IP Star Schema.jpg
Campaign (shortcut) [Interact Model].[Campaign]
Cells (shortcut) [Interact Model].[Cells]
Campaign Cell by IP Number of Times Presented (shortcut) [Interact Model].[Campaign Cell by IP Number of Times Presented]
Campaign Cell by IP Elig Opps (shortcut) [Interact Model].[Campaign Cell by IP Elig Opps]
Campaign Cell by IP Response History (shortcut) [Interact Model].[Campaign Cell by IP Response History]
Namespace/FolderQuery SubjectQuery ItemTypeUsageRef Obj/Expr.
Campaign Offer SummaryCampaign Offer Number of Times PresentedCampaign IDdecimalidentifier[InteractDTDS].[UARI_COP_CH].[CAMPAIGNID] 
Offer IDdecimalidentifier[InteractDTDS].[UARI_COP_CH].[OFFERID] 
Presentedfloat64fact[InteractDTDS].[UARI_COP_CH].[NUM_TIMES_PRES] 
Presented Model-Drivenfloat64fact[InteractDTDS].[UARI_COP_CH].[NUM_PRES_MODELDRVN] 
Presented Randomfloat64fact[InteractDTDS].[UARI_COP_CH].[NUM_PRES_RANDOM] 
Campaign Offer Elig OppsCampaign IDfloat64identifier[InteractRTDS].[UARI_COP_ES].[CAMPAIGNID]  
Offer IDdecimalidentifier[InteractRTDS].[UARI_COP_ES].[OFFERID]  
Eligible Opportunitiesfloat64fact[InteractRTDS].[UARI_COP_ES].[ELIGIBLEOPPS]  
Campaign Offer Response HistoryCampaign IDdecimalidentifier[InteractDTDS].[UARI_COP_RH].[CAMPAIGNID] 
Offer IDdecimalidentifier[InteractDTDS].[UARI_COP_RH].[OFFERID] 
Acceptedfloat64fact[InteractDTDS].[UARI_COP_RH].[NUM_TIMES_ACCP] 
Accepted Model-Drivenfloat64fact[InteractDTDS].[UARI_COP_RH].[NUM_ACCP_MODELDRVN] 
Accepted Randomfloat64fact[InteractDTDS].[UARI_COP_RH].[NUM_ACCP_RANDOM] 
Rejectedfloat64fact[InteractDTDS].[UARI_COP_RH].[NUM_TIME_REJ] 
Namespace/FolderQuery SubjectQuery ItemTypeUsageRef Obj/Expr.
Campaign Offer Performance Star Schema
model/Campaign Offer Performance Star Schema.jpg
Campaign (shortcut) [Interact Model].[Campaign]
Offer (shortcut) [Interact Model].[Offer]
Campaign Offer Number of Times Presented (shortcut) [Interact Model].[Campaign Offer Number of Times Presented]
Campaign Offer Elig Opps (shortcut) [Interact Model].[Campaign Offer Elig Opps]
Campaign Offer Response History (shortcut) [Interact Model].[Campaign Offer Response History]
Campaign Offer by DayCampaign Offer Number of Times Presented by DayCampaign IDdecimalidentifier[InteractDTDS].[UARI_COP_CH_DY].[CAMPAIGNID] 
Offer IDdecimalidentifier[InteractDTDS].[UARI_COP_CH_DY].[OFFERID] 
Actual DatedateTimeidentifier[InteractDTDS].[UARI_COP_CH_DY].[ACTUALDATE] 
Presentedfloat64fact[InteractDTDS].[UARI_COP_CH_DY].[NUM_TIMES_PRES] 
Presented Model-Drivenfloat64fact[InteractDTDS].[UARI_COP_CH_DY].[NUM_PRES_MODELDRVN] 
Presented Randomfloat64fact[InteractDTDS].[UARI_COP_CH_DY].[NUM_PRES_RANDOM] 
Campaign Offer Elig Opps by DayCampaign IDfloat64identifier[InteractRTDS].[UARI_COP_ES_DY].[CAMPAIGNID]  
Offer IDdecimalidentifier[InteractRTDS].[UARI_COP_ES_DY].[OFFERID]  
Actual DatedateTimeidentifier[InteractRTDS].[UARI_COP_ES_DY].[ACTUALDATE]  
Eligible Opportunitiesfloat64fact[InteractRTDS].[UARI_COP_ES_DY].[ELIGIBLEOPPS]  
Campaign Offer Response History by DayCampaign IDdecimalidentifier[InteractDTDS].[UARI_COP_RH_DY].[CAMPAIGNID] 
Offer IDdecimalidentifier[InteractDTDS].[UARI_COP_RH_DY].[OFFERID] 
Actual DatedateTimeidentifier[InteractDTDS].[UARI_COP_RH_DY].[ACTUALDATE] 
Acceptedfloat64fact[InteractDTDS].[UARI_COP_RH_DY].[NUM_TIMES_ACCP] 
Accepted Model-Drivenfloat64fact[InteractDTDS].[UARI_COP_RH_DY].[NUM_ACCP_MODELDRVN] 
Accepted Randomfloat64fact[InteractDTDS].[UARI_COP_RH_DY].[NUM_ACCP_RANDOM] 
Rejectedfloat64fact[InteractDTDS].[UARI_COP_RH_DY].[NUM_TIME_REJ] 
OfferToCalendarDate IDdecimalidentifier[InteractDTDS].[UARI_CALENDAR].[DATEID] 
Actual DatedateTimeidentifier[InteractDTDS].[UARI_CALENDAR].[ACTUALDATE] 
Offer IDdecimalidentifier[Interact Model].[Offer].[Offer ID] 
Offer NamecharacterLength16attribute[Interact Model].[Offer].[Offer Name] 
Offer DescriptioncharacterLength16attribute[Interact Model].[Offer].[Offer Description] 
Offer Code 1characterLength16attribute[Interact Model].[Offer].[Offer Code 1] 
Offer Code 2characterLength16attribute[Interact Model].[Offer].[Offer Code 2] 
Offer Code 3characterLength16attribute[Interact Model].[Offer].[Offer Code 3] 
Offer Code 4characterLength16attribute[Interact Model].[Offer].[Offer Code 4] 
Offer Code 5characterLength16attribute[Interact Model].[Offer].[Offer Code 5] 
Namespace/FolderQuery SubjectQuery ItemTypeUsageRef Obj/Expr.
Campaign Offer by Day Star Schema
model/Campaign Offer by Day Star Schema.jpg
Campaign (shortcut) [Interact Model].[Campaign]
Campaign Offer Number of Times Presented by Day (shortcut) [Interact Model].[Campaign Offer Number of Times Presented by Day]
Campaign Offer Elig Opps by Day (shortcut) [Interact Model].[Campaign Offer Elig Opps by Day]
Campaign Offer Response History by Day (shortcut) [Interact Model].[Campaign Offer Response History by Day]
OfferToCalendar (shortcut) [Interact Model].[OfferToCalendar]
Campaign Offer by HourCampaign Offer Number of Times Presented by HourCampaign IDdecimalidentifier[InteractDTDS].[UARI_COP_CH_HR].[CAMPAIGNID] 
Offer IDdecimalidentifier[InteractDTDS].[UARI_COP_CH_HR].[OFFERID] 
Hourint64identifier[InteractDTDS].[UARI_COP_CH_HR].[HOUR] 
Actual DatedateTimeidentifier[InteractDTDS].[UARI_COP_CH_HR].[ACTUALDATE] 
Presentedfloat64fact[InteractDTDS].[UARI_COP_CH_HR].[NUM_TIMES_PRES] 
Presented Model-Drivenfloat64fact[InteractDTDS].[UARI_COP_CH_HR].[NUM_PRES_MODELDRVN] 
Presented Randomfloat64fact[InteractDTDS].[UARI_COP_CH_HR].[NUM_PRES_RANDOM] 
Campaign Offer Elig Opps by HourCampaign IDfloat64identifier[InteractRTDS].[UARI_COP_ES_HR].[CAMPAIGNID]  
Offer IDdecimalidentifier[InteractRTDS].[UARI_COP_ES_HR].[OFFERID]  
Hourint64identifier[InteractRTDS].[UARI_COP_ES_HR].[HOUR]  
Actual DatedateTimeidentifier[InteractRTDS].[UARI_COP_ES_HR].[ACTUALDATE]  
Eligible Opportunitiesfloat64fact[InteractRTDS].[UARI_COP_ES_HR].[ELIGIBLEOPPS]  
Campaign Offer Response History by HourCampaign IDdecimalidentifier[InteractDTDS].[UARI_COP_RH_HR].[CAMPAIGNID] 
Offer IDdecimalidentifier[InteractDTDS].[UARI_COP_RH_HR].[OFFERID] 
Hourint64identifier[InteractDTDS].[UARI_COP_RH_HR].[HOUR] 
Actual DatedateTimeidentifier[InteractDTDS].[UARI_COP_RH_HR].[ACTUALDATE] 
Acceptedfloat64fact[InteractDTDS].[UARI_COP_RH_HR].[NUM_TIMES_ACCP] 
Accepted Model-Drivenfloat64fact[InteractDTDS].[UARI_COP_RH_HR].[NUM_ACCP_MODELDRVN] 
Accepted Randomfloat64fact[InteractDTDS].[UARI_COP_RH_HR].[NUM_ACCP_RANDOM] 
Rejectedfloat64fact[InteractDTDS].[UARI_COP_RH_HR].[NUM_TIME_REJ] 
Offer-Last 24 Hours LookupHourfloat64attribute[InteractDTDS].[LAST_24_HOURS_LOOKUP].[HOUR] 
Actual DatedateTimeidentifier[InteractDTDS].[LAST_24_HOURS_LOOKUP].[ACTUALDATE] 
Offer IDdecimalidentifier[Interact Model].[Offer].[Offer ID] 
Offer NamecharacterLength16attribute[Interact Model].[Offer].[Offer Name] 
Offer DescriptioncharacterLength16attribute[Interact Model].[Offer].[Offer Description] 
Offer Code 1characterLength16attribute[Interact Model].[Offer].[Offer Code 1] 
Offer Code 2characterLength16attribute[Interact Model].[Offer].[Offer Code 2] 
Offer Code 3characterLength16attribute[Interact Model].[Offer].[Offer Code 3] 
Offer Code 4characterLength16attribute[Interact Model].[Offer].[Offer Code 4] 
Offer Code 5characterLength16attribute[Interact Model].[Offer].[Offer Code 5] 
Namespace/FolderQuery SubjectQuery ItemTypeUsageRef Obj/Expr.
Campaign Offer by Hour Star Schema
model/Campaign Offer by Hour Star Schema.jpg
Campaign (shortcut) [Interact Model].[Campaign]
Offer (shortcut) [Interact Model].[Offer]
Campaign Offer Number of Times Presented by Hour (shortcut) [Interact Model].[Campaign Offer Number of Times Presented by Hour]
Campaign Offer Elig Opps by Hour (shortcut) [Interact Model].[Campaign Offer Elig Opps by Hour]
Campaign Offer Response History by Hour (shortcut) [Interact Model].[Campaign Offer Response History by Hour]
Offer-Last 24 Hours Lookup (shortcut) [Interact Model].[Offer-Last 24 Hours Lookup]
Namespace/FolderQuery SubjectQuery ItemTypeUsageRef Obj/Expr.
Campaign Offer by Cell SummaryCampaign Offer by Cell Number of Times PresentedCampaign IDdecimalidentifier[InteractDTDS].[UARI_COP_CCH].[CAMPAIGNID] 
Offer IDdecimalidentifier[InteractDTDS].[UARI_COP_CCH].[OFFERID] 
Cell IDdecimalidentifier[InteractDTDS].[UARI_COP_CCH].[CELLID] 
Presentedfloat64fact[InteractDTDS].[UARI_COP_CCH].[NUM_TIMES_PRES] 
Presented Model-Drivenfloat64fact[InteractDTDS].[UARI_COP_CCH].[NUM_PRES_MODELDRVN] 
Presented Randomfloat64fact[InteractDTDS].[UARI_COP_CCH].[NUM_PRES_RANDOM] 
Campaign Offer by Cell Elig OppsCampaign IDint64identifier[InteractRTDS].[UARI_COP_CES].[CAMPAIGNID] 
Offer IDdecimalidentifier[InteractRTDS].[UARI_COP_CES].[OFFERID] 
Cell IDdecimalidentifier[InteractRTDS].[UARI_COP_CES].[CELLID] 
Eligible Opportunitiesfloat64fact[InteractRTDS].[UARI_COP_CES].[ELIGIBLEOPPS] 
Campaign Offer by Cell Response HistoryCampaign IDdecimalidentifier[InteractDTDS].[UARI_COP_CRH].[CAMPAIGNID] 
Offer IDdecimalidentifier[InteractDTDS].[UARI_COP_CRH].[OFFERID] 
Cell IDdecimalidentifier[InteractDTDS].[UARI_COP_CRH].[CELLID] 
Acceptedfloat64fact[InteractDTDS].[UARI_COP_CRH].[NUM_TIMES_ACCP] 
Accepted Model-Drivenfloat64fact[InteractDTDS].[UARI_COP_CRH].[NUM_ACCP_MODELDRVN] 
Accepted Randomfloat64fact[InteractDTDS].[UARI_COP_CRH].[NUM_ACCP_RANDOM] 
Rejectedfloat64fact[InteractDTDS].[UARI_COP_CRH].[NUM_TIME_REJ] 
Namespace/FolderQuery SubjectQuery ItemTypeUsageRef Obj/Expr.
Campaign Offer Cell Star Schema
model/Campaign Offer Cell Star Schema.jpg
Campaign (shortcut) [Interact Model].[Campaign]
Offer (shortcut) [Interact Model].[Offer]
Cells (shortcut) [Interact Model].[Cells]
Campaign Offer by Cell Number of Times Presented (shortcut) [Interact Model].[Campaign Offer by Cell Number of Times Presented]
Campaign Offer by Cell Elig Opps (shortcut) [Interact Model].[Campaign Offer by Cell Elig Opps]
Campaign Offer by Cell Response History (shortcut) [Interact Model].[Campaign Offer by Cell Response History]
Namespace/FolderQuery SubjectQuery ItemTypeUsageRef Obj/Expr.
Campaign Offer by Interaction Point SummaryCampaign Offer by IP Number of Times PresentedCampaign IDdecimalidentifier[InteractDTDS].[UARI_COP_IPCH].[CAMPAIGNID] 
Offer IDdecimalidentifier[InteractDTDS].[UARI_COP_IPCH].[OFFERID] 
Interaction Point IDfloat64identifier[InteractDTDS].[UARI_COP_IPCH].[IPID] 
Interaction PointcharacterLength16attribute[InteractDTDS].[UARI_COP_IPCH].[IPNAME] 
Presentedfloat64fact[InteractDTDS].[UARI_COP_IPCH].[NUM_TIMES_PRES] 
Presented Model-Drivenfloat64fact[InteractDTDS].[UARI_COP_IPCH].[NUM_PRES_MODELDRVN] 
Presented Randomfloat64fact[InteractDTDS].[UARI_COP_IPCH].[NUM_PRES_RANDOM] 
Campaign Offer by IP Elig OppsCampaign IDint64identifier[InteractRTDS].[UARI_COP_IPES].[CAMPAIGNID] 
Offer IDdecimalidentifier[InteractRTDS].[UARI_COP_IPES].[OFFERID] 
Interaction Point IDdecimalidentifier[InteractRTDS].[UARI_COP_IPES].[IPID] 
Interaction PointcharacterLength16attribute[InteractRTDS].[UARI_COP_IPES].[IPNAME] 
Eligible Opportunitiesfloat64fact[InteractRTDS].[UARI_COP_IPES].[ELIGIBLEOPPS] 
Campaign Offer by IP Response HistoryCampaign IDdecimalidentifier[InteractDTDS].[UARI_COP_IPRH].[CAMPAIGNID] 
Offer IDdecimalidentifier[InteractDTDS].[UARI_COP_IPRH].[OFFERID] 
Interaction Point IDfloat64identifier[InteractDTDS].[UARI_COP_IPRH].[IPID] 
Interaction PointcharacterLength16attribute[InteractDTDS].[UARI_COP_IPRH].[IPNAME] 
Acceptedfloat64fact[InteractDTDS].[UARI_COP_IPRH].[NUM_TIMES_ACCP] 
Accepted Model-Drivenfloat64fact[InteractDTDS].[UARI_COP_IPRH].[NUM_ACCP_MODELDRVN] 
Accepted Randomfloat64fact[InteractDTDS].[UARI_COP_IPRH].[NUM_ACCP_RANDOM] 
Rejectedfloat64fact[InteractDTDS].[UARI_COP_IPRH].[NUM_TIME_REJ] 
Namespace/FolderQuery SubjectQuery ItemTypeUsageRef Obj/Expr.
Campaign Offer by Interaction Point Star Schema
model/Campaign Offer by Interaction Point Star Schema.jpg
Campaign (shortcut) [Interact Model].[Campaign]
Offer (shortcut) [Interact Model].[Offer]
Campaign Offer by IP Number of Times Presented (shortcut) [Interact Model].[Campaign Offer by IP Number of Times Presented]
Campaign Offer by IP Elig Opps (shortcut) [Interact Model].[Campaign Offer by IP Elig Opps]
Campaign Offer by IP Response History (shortcut) [Interact Model].[Campaign Offer by IP Response History]
Interactive Channel DeploymentInteractive Channel Deployment HistoryDeployment IDdecimalidentifier[InteractDTDS].[UARI_DEPLOYMENT].[DEPLOYMENTID] 
Deployment Deploy Type IDint64attribute[InteractDTDS].[UARI_DEPLOYMENT].[DEPLOYDEPTYPEID] 
Interactive Channel IDdecimalidentifier[InteractDTDS].[UARI_DEPLOYMENT].[ICID] 
Campaign IDdecimalattribute[InteractDTDS].[UARI_DEPLOYMENT].[CAMPAIGNID] 
Campaign NamecharacterLength16attribute[InteractDTDS].[UARI_DEPLOYMENT].[CAMPAIGNNAME] 
StrategyIDdecimalidentifier[InteractDTDS].[UARI_DEPLOYMENT].[STRATEGYID] 
Strategy NamecharacterLength16attribute[InteractDTDS].[UARI_DEPLOYMENT].[STRATEGYNAME] 
Deployment Type IDint64attribute[InteractDTDS].[UARI_DEPLOYMENT].[DEPLOYTYPEID] 
Deployment TypecharacterLength16attribute[InteractDTDS].[UARI_DEPLOYMENT].[DEPLOYTYPE] 
Session IDdecimalidentifier[InteractDTDS].[UARI_DEPLOYMENT].[SESSIONID] 
Session NamecharacterLength16attribute[InteractDTDS].[UARI_DEPLOYMENT].[SESSIONNAME] 
Flowchart IDdecimalidentifier[InteractDTDS].[UARI_DEPLOYMENT].[FLOWCHARTID] 
Flowchart NamecharacterLength16attribute[InteractDTDS].[UARI_DEPLOYMENT].[FLOWCHARTNAME] 
Flowchart Type IDint64identifier[InteractDTDS].[UARI_DEPLOYMENT].[FLOWCHDEPLOYTYPEID] 
Flowchart TypecharacterLength16attribute[InteractDTDS].[UARI_DEPLOYMENT].[FLOWCHDEPLOYTYPE] 
Audience LevelcharacterLength16attribute[InteractDTDS].[UARI_DEPLOYMENT].[AUDIENCELEVEL] 
Deployment DestinationcharacterLength16attribute[InteractDTDS].[UARI_DEPLOYMENT].[DEPLMNTDEST] 
Deployment Server Groupint64attribute[InteractDTDS].[UARI_DEPLOYMENT].[DEPLMNTSVRGRP] 
Deployment OwnercharacterLength16attribute[InteractDTDS].[UARI_DEPLOYMENT].[DEPLMNTOWNER] 
Time of DeploymentdateTimeattribute[InteractDTDS].[UARI_DEPLOYMENT].[TIMEDEPLMNT] 
Strategy Tab URLcharacterLength16attribute#sq($Environment{'Redirect URL'})# + 'strategy&id=' + cast(cast([Interact Model].[Interactive Channel Deployment History].[StrategyID] , integer), varchar(10)) + '&campaignID=' + cast(cast([Interact Model].[Interactive Channel Deployment History].[Campaign ID] , integer), varchar(10)) 
Flowchart Tab URLcharacterLength16attribute#sq($Environment{'Redirect URL'})# + 'flowchart&id=' + cast(cast([Interact Model].[Interactive Channel Deployment History].[Flowchart ID] , integer), varchar(10)) + '&sessionID=' + cast(cast([Interact Model].[Interactive Channel Deployment History].[Session ID] , integer), varchar(10)) 
isProductionLookup IDint64fact[Interact Model].[Localization Lookup].[Lookup ID] 
Lookup TypecharacterLength16attribute[Interact Model].[Localization Lookup].[Lookup Type] 
DescriptioncharacterLength16attribute[Interact Model].[Localization Lookup].[Description] 
Production GroupcharacterLength16attribute[Interact Model].[Localization Lookup].[Localized String] 
Deployment TypeLookup IDint64fact[Interact Model].[Localization Lookup].[Lookup ID] 
Lookup TypecharacterLength16attribute[Interact Model].[Localization Lookup].[Lookup Type] 
DescriptioncharacterLength16attribute[Interact Model].[Localization Lookup].[Description] 
Deployment TypecharacterLength16attribute[Interact Model].[Localization Lookup].[Localized String] 
Flowchart Deployment TypeLookup IDint64fact[Interact Model].[Localization Lookup].[Lookup ID] 
Lookup TypecharacterLength16attribute[Interact Model].[Localization Lookup].[Lookup Type] 
DescriptioncharacterLength16attribute[Interact Model].[Localization Lookup].[Description] 
Flowchart Deployment TypecharacterLength16attribute[Interact Model].[Localization Lookup].[Localized String] 
Namespace/FolderQuery SubjectQuery ItemTypeUsageRef Obj/Expr.
Interactive Channel Deployment Star Schema
model/Interactive Channel Deployment Star Schema.jpg
Interactive Channel Deployment History (shortcut) [Interact Model].[Interactive Channel Deployment History]
isProduction (shortcut) [Interact Model].[isProduction]
Deploy Type (shortcut) [Interact Model].[Deployment Type]
Flowchart Deployment Type (shortcut) [Interact Model].[Flowchart Deployment Type]
Campaign (shortcut) [Interact Model].[Campaign]
Campaign Interactive Offer LearningInteractive Offer LearningOffer IDdecimalidentifier[InteractLearningDS].[UARI_LEARNING].[OFFERID] 
Attribute NamecharacterLength16attribute[InteractLearningDS].[UARI_LEARNING].[ATTRIBUTENAME] 
Attribute ValuecharacterLength16attribute[InteractLearningDS].[UARI_LEARNING].[ATTRIBUTEVALUE] 
Likelyhood of Responsefloat64fact[InteractLearningDS].[UARI_LEARNING].[ACCEPTPERCENTAGE] 
Predictabilityint64attribute[InteractLearningDS].[UARI_LEARNING].[PREDICTABILITY] 
Namespace/FolderQuery SubjectQuery ItemTypeUsageRef Obj/Expr.
Interactive Offer Learning Star Schema
model/Interactive Offer Learning Star Schema.jpg
Interactive Offer Learning (shortcut) [Interact Model].[Interactive Offer Learning]
Offer (shortcut) [Interact Model].[Offer]
Treatment Rule Inventory Campaign to Offer (shortcut) [Interact Model].[Treatment Rule Inventory Campaign to Offer]
Treatment Rule Inventory FolderTreatment Rule InventoryTreatment Rule IDdecimalidentifier[InteractDTDS].[UARI_TRMTRULEINV].[TREATMENTRULEID] 
Deployment IDdecimalidentifier[InteractDTDS].[UARI_TRMTRULEINV].[DEPLOYMENTID] 
Interactive Channel IDdecimalidentifier[InteractDTDS].[UARI_TRMTRULEINV].[ICID] 
Interactive ChannelcharacterLength16attribute[InteractDTDS].[UARI_TRMTRULEINV].[ICNAME] 
Cell IDdecimalidentifier[InteractDTDS].[UARI_TRMTRULEINV].[CELLID] 
Cell NamecharacterLength16attribute[InteractDTDS].[UARI_TRMTRULEINV].[CELLNAME] 
Zone IDdecimalidentifier[InteractDTDS].[UARI_TRMTRULEINV].[ZONEID] 
ZonecharacterLength16attribute[InteractDTDS].[UARI_TRMTRULEINV].[ZONENAME] 
Strategy IDdecimalidentifier[InteractDTDS].[UARI_TRMTRULEINV].[STRATEGYID] 
Strategy NamecharacterLength16attribute[InteractDTDS].[UARI_TRMTRULEINV].[STRATEGYNAME] 
Offer IDdecimalidentifier[InteractDTDS].[UARI_TRMTRULEINV].[OFFERID] 
Offer NamecharacterLength16attribute[InteractDTDS].[UARI_TRMTRULEINV].[OFFERNAME] 
Campaign IDdecimalidentifier[InteractDTDS].[UARI_TRMTRULEINV].[CAMPAIGNID] 
Campaign NamecharacterLength16attribute[InteractDTDS].[UARI_TRMTRULEINV].[CAMPAIGNNAME] 
Campaign CodecharacterLength16attribute[InteractDTDS].[UARI_TRMTRULEINV].[CAMPAIGNCODE] 
Segment IDdecimalidentifier[InteractDTDS].[UARI_TRMTRULEINV].[SEGMENTID] 
SegmentcharacterLength16attribute[InteractDTDS].[UARI_TRMTRULEINV].[SEGMENTNAME] 
Marketing Scoreint64fact[InteractDTDS].[UARI_TRMTRULEINV].[MARKETINGSCORE]  
Enable State IDint64identifier[InteractDTDS].[UARI_TRMTRULEINV].[ENABLESTATEID] 
Predicate StatecharacterLength16attribute[InteractDTDS].[UARI_TRMTRULEINV].[PREDICATESTATE] 
PredicatecharacterLength16attribute[InteractDTDS].[UARI_TRMTRULEINV].[PREDICATE] 
Last Update DatedateTimeattribute[InteractDTDS].[UARI_TRMTRULEINV].[LASTUPDATE] 
StrategyTab URLcharacterLength16attribute#sq($Environment{'Redirect URL'})# + 'strategy&id=' + cast(cast([Interact Model].[Treatment Rule Inventory].[Strategy ID] , integer), varchar(10)) + '&campaignID=' + cast(cast([Interact Model].[Treatment Rule Inventory].[Campaign ID] , integer), varchar(10)) 
All ZonescharacterLength16attribute[Interact Model].[All Zones].[All Zones] 
All ZonesLookup IDint64fact[Interact Model].[Localization Lookup].[Lookup ID] 
Lookup CodecharacterLength16attribute[Interact Model].[Localization Lookup].[Lookup Code] 
Lookup TypecharacterLength16attribute[Interact Model].[Localization Lookup].[Lookup Type] 
DescriptioncharacterLength16attribute[Interact Model].[Localization Lookup].[Description] 
LocalecharacterLength16attribute[Interact Model].[Localization Lookup].[Locale] 
All ZonescharacterLength16attribute[Interact Model].[Localization Lookup].[Localized String] 
Predicate StateLookup IDint64fact[InteractDTDS].[UARI_LOOKUP].[LKUP_ID] 
Lookup CodecharacterLength16attribute[InteractDTDS].[UARI_LOOKUP].[LKUP_CODE] 
Lookup TypecharacterLength16attribute[InteractDTDS].[UARI_LOOKUP].[LKUP_TYPE] 
DescriptioncharacterLength16attribute[InteractDTDS].[UARI_LOOKUP].[DESCRIPTION] 
LocalecharacterLength16attribute[InteractDTDS].[UARI_LOOKUP].[LOCALE] 
Predicate StatecharacterLength16attribute[InteractDTDS].[UARI_LOOKUP].[LOCALIZED_STRING] 
Namespace/FolderQuery SubjectQuery ItemTypeUsageRef Obj/Expr.
Treatment Rule Inventory Star Schema
model/Treatment Rule Inventory Star Schema.jpg
Treatment Rule Inventory (shortcut) [Interact Model].[Treatment Rule Inventory]
Offer (shortcut) [Interact Model].[Offer]
Cells (shortcut) [Interact Model].[Cells]
Predicate State (shortcut) [Interact Model].[Predicate State]
Channel Event ActivityLast 24 Hours (shortcut) [Interact Model].[Last 24 Hours Lookup]
Channel Event ActivityEvent CommonInteractive Channel IDdecimalidentifier[InteractRTDS].[UARI_EV_ACT].[ICID] 
Interactive Channel NamecharacterLength16attribute[InteractRTDS].[UARI_EV_ACT].[ICNAME] 
Category IDdecimalidentifier[InteractRTDS].[UARI_EV_ACT].[CATEGORYID] 
Category NamecharacterLength16attribute[InteractRTDS].[UARI_EV_ACT].[CATEGORYNAME] 
Event IDdecimalidentifier[InteractRTDS].[UARI_EV_ACT].[EVENTID] 
Event NamecharacterLength16attribute[InteractRTDS].[UARI_EV_ACT].[EVENTNAME] 
Occurrencesfloat64fact[InteractRTDS].[UARI_EV_ACT].[NUM_OCCURRENCES] 
Event Common by DayInteractive Channel IDint32identifier[Interact Model].[Event Common].[Interactive Channel ID] 
Interactive Channel NamecharacterLength16attribute[Interact Model].[Event Common].[Interactive Channel Name] 
Category IDint32identifier[Interact Model].[Event Common].[Category ID] 
Category NamecharacterLength16attribute[Interact Model].[Event Common].[Category Name] 
Event IDint32identifier[Interact Model].[Event Common].[Event ID] 
Event NamecharacterLength16attribute[Interact Model].[Event Common].[Event Name] 
Actual DatedateTimeidentifier[Interact Model].[Last 7 Days Calendar].[Actual Date] 
Event Activity DayInteractive Channel IDint32identifier[InteractRTDS].[UARI_EV_ACT_DY].[ICID] 
Interactive Channel NamecharacterLength16attribute[InteractRTDS].[UARI_EV_ACT_DY].[ICNAME] 
Category IDint32identifier[InteractRTDS].[UARI_EV_ACT_DY].[CATEGORYID] 
Category NamecharacterLength16attribute[InteractRTDS].[UARI_EV_ACT_DY].[CATEGORYNAME] 
Event IDint32identifier[InteractRTDS].[UARI_EV_ACT_DY].[EVENTID] 
Event NamecharacterLength16attribute[InteractRTDS].[UARI_EV_ACT_DY].[EVENTNAME] 
Occurrencesint32fact[InteractRTDS].[UARI_EV_ACT_DY].[NUM_OCCURRENCES] 
Actual Datedateattributecast([InteractRTDS].[UARI_EV_ACT_DY].[ACTUALDATE], date) 
Last 7 Days CalendarDate IDint32identifier[InteractDTDS].[UARI_CALENDAR].[DATEID] 
Yearint32attribute[InteractDTDS].[UARI_CALENDAR].[YEAR] 
Fiscal Yearint32attribute[InteractDTDS].[UARI_CALENDAR].[FISCALYEAR] 
Quarterint32attribute[InteractDTDS].[UARI_CALENDAR].[QUARTER] 
Fiscal Quarterint32attribute[InteractDTDS].[UARI_CALENDAR].[FISCALQUARTER] 
Monthint32attribute[InteractDTDS].[UARI_CALENDAR].[MONTH] 
Week of Yearint32attribute[InteractDTDS].[UARI_CALENDAR].[WEEKOFYEAR] 
Week of Monthint32attribute[InteractDTDS].[UARI_CALENDAR].[WEEKOFMONTH] 
Day of Yearint32attribute[InteractDTDS].[UARI_CALENDAR].[DAYOFYEAR] 
Day of Monthint32attribute[InteractDTDS].[UARI_CALENDAR].[DAYOFMONTH] 
Day of Weekint32attribute[InteractDTDS].[UARI_CALENDAR].[DAYOFWEEK] 
Actual Datedateidentifiercast([InteractDTDS].[UARI_CALENDAR].[ACTUALDATE], date) 
First Day of WeekdateTimeattribute[InteractDTDS].[UARI_CALENDAR].[FIRSTDAYOFWEEK] 
Last Day of WeekdateTimeattribute[InteractDTDS].[UARI_CALENDAR].[LASTDAYOFWEEK] 
Event Common by HourInteractive Channel IDdecimalidentifier[Interact Model].[Event Common].[Interactive Channel ID] 
Interactive Channel NamecharacterLength16attribute[Interact Model].[Event Common].[Interactive Channel Name] 
Category IDdecimalidentifier[Interact Model].[Event Common].[Category ID] 
Category NamecharacterLength16attribute[Interact Model].[Event Common].[Category Name] 
Event IDdecimalidentifier[Interact Model].[Event Common].[Event ID] 
Event NamecharacterLength16attribute[Interact Model].[Event Common].[Event Name] 
Actual Datedateidentifiercast([Interact Model].[Last 24 Hours][Interact Model].[Last 24 Hours Lookup].[Actual Date], date) 
Hourfloat64attribute[Interact Model].[Last 24 Hours][Interact Model].[Last 24 Hours Lookup].[Hour] 
Event Activity HRInteractive Channel IDdecimalidentifier[InteractRTDS].[UARI_EV_ACT_HR].[ICID] 
Interactive Channel NamecharacterLength16attribute[InteractRTDS].[UARI_EV_ACT_HR].[ICNAME] 
Category IDdecimalidentifier[InteractRTDS].[UARI_EV_ACT_HR].[CATEGORYID] 
Cat NamecharacterLength16attribute[InteractRTDS].[UARI_EV_ACT_HR].[CATEGORYNAME] 
Event IDdecimalidentifier[InteractRTDS].[UARI_EV_ACT_HR].[EVENTID] 
Event NamecharacterLength16attribute[InteractRTDS].[UARI_EV_ACT_HR].[EVENTNAME] 
Occurrencesfloat64fact[InteractRTDS].[UARI_EV_ACT_HR].[NUM_OCCURRENCES] 
Actual Datedateattributecast([InteractRTDS].[UARI_EV_ACT_HR].[ACTUALDATE], date) 
Hourint64attribute[InteractRTDS].[UARI_EV_ACT_HR].[HR] 
Peak DayInteractive Channel IDdecimalidentifier[Interact Model].[Event Activity Day].[Interactive Channel ID] 
Category IDdecimalidentifier[Interact Model].[Event Activity Day].[Category ID] 
Event IDdecimalidentifier[Interact Model].[Event Activity Day].[Event ID] 
Peak DaydateTimeattribute[Interact Model].[Event Activity Day].[Actual Date] 
Max Occurrencesfloat64factmaximum ([Interact Model].[Event Activity Day].[Occurrences] for [Interact Model].[Peak Day].[Interactive Channel ID], [Interact Model].[Peak Day].[Category ID],[Interact Model].[Peak Day].[Event ID] ) 
Slow DayInteractive Channel IDdecimalidentifier[Interact Model].[Event Activity Day].[Interactive Channel ID] 
Category IDdecimalidentifier[Interact Model].[Event Activity Day].[Category ID] 
Event IDdecimalidentifier[Interact Model].[Event Activity Day].[Event ID] 
Slowest DaydateTimeattribute[Interact Model].[Event Activity Day].[Actual Date] 
Min Occurrencesfloat64factminimum ([Interact Model].[Event Activity Day].[Occurrences] for [Interact Model].[Slow Day].[Interactive Channel ID], [Interact Model].[Slow Day].[Category ID],[Interact Model].[Slow Day].[Event ID] ) 
Peak HourInt Channel IDdecimalidentifier[Interact Model].[Event Activity HR].[Interactive Channel ID] 
Cat IDdecimalidentifier[Interact Model].[Event Activity HR].[Category ID] 
Event IDdecimalidentifier[Interact Model].[Event Activity HR].[Event ID] 
Peak DaydateTimeattribute[Interact Model].[Event Activity HR].[Actual Date] 
Peak Hourint64attribute[Interact Model].[Event Activity HR].[Hour] 
Max Occurfloat64factmaximum ([Interact Model].[Event Activity HR].[Occurrences] for [Interact Model].[Peak Hour].[Int Channel ID] , [Interact Model].[Peak Hour].[Cat ID] , [Interact Model].[Peak Hour].[Event ID] ) 
Slow HourInt Channel IDdecimalidentifier[Interact Model].[Event Activity HR].[Interactive Channel ID] 
Cat IDdecimalidentifier[Interact Model].[Event Activity HR].[Category ID] 
Event IDdecimalidentifier[Interact Model].[Event Activity HR].[Event ID] 
Slowest DaydateTimeattribute[Interact Model].[Event Activity HR].[Actual Date] 
Slowest Hourint64attribute[Interact Model].[Event Activity HR].[Hour] 
Min Occurfloat64factminimum ([Interact Model].[Event Activity HR].[Occurrences] for [Interact Model].[Slow Hour].[Int Channel ID], [Interact Model].[Slow Hour].[Cat ID] ,[Interact Model].[Slow Hour].[Event ID] ) 
Namespace/FolderQuery SubjectQuery ItemTypeUsageRef Obj/Expr.
Peak and Slow AllPeak Day AllInteractive Channel IDdecimalidentifier[Peak and Slow All].[Channel Event Activity Day at IC Level].[Interactive Channel ID] 
Max Occurrencesfloat64factmaximum ([Peak and Slow All].[Channel Event Activity Day at IC Level].[Occurrences] for [Peak and Slow All].[Peak Day All].[Interactive Channel ID] ) 
Peak Day AlldateTimeattribute[Peak and Slow All].[Channel Event Activity Day at IC Level].[Actual Date] 
Slow Day AllInteractive Channel IDdecimalidentifier[Peak and Slow All].[Channel Event Activity Day at IC Level].[Interactive Channel ID] 
Min Occurrencesfloat64factminimum ([Peak and Slow All].[Channel Event Activity Day at IC Level].[Occurrences] for [Peak and Slow All].[Slow Day All].[Interactive Channel ID]) 
Slowest Day AlldateTimeattribute[Peak and Slow All].[Channel Event Activity Day at IC Level].[Actual Date] 
Peak Hour AllInteractive Channel IDdecimalidentifier[Peak and Slow All].[Channel Event Activity HR at IC Level].[Interactive Channel ID] 
Max Occurrencesfloat64factmaximum ([Peak and Slow All].[Channel Event Activity HR at IC Level].[Occurrences] for [Peak and Slow All].[Peak Hour All].[Interactive Channel ID] ) 
Peak Day AlldateTimeattribute[Peak and Slow All].[Channel Event Activity HR at IC Level].[Actual Date] 
Peak Hour Allint64attribute[Peak and Slow All].[Channel Event Activity HR at IC Level].[Hour] 
Slow Hour AllInteractive Channel IDdecimalidentifier[Peak and Slow All].[Channel Event Activity HR at IC Level].[Interactive Channel ID] 
Min Occurrencesfloat64factminimum ([Peak and Slow All].[Channel Event Activity HR at IC Level].[Occurrences] for [Peak and Slow All].[Slow Hour All].[Interactive Channel ID] ) 
Slowest Day AlldateTimeattribute[Peak and Slow All].[Channel Event Activity HR at IC Level].[Actual Date] 
Slowest Hour Allint64attribute[Peak and Slow All].[Channel Event Activity HR at IC Level].[Hour] 
Channel Event Activity HR at IC LevelInteractive Channel IDint64identifier[InteractRTDS].[UARI_EV_ACT_IC_HR].[ICID] 
Occurrencesint64fact[InteractRTDS].[UARI_EV_ACT_IC_HR].[NUM_OCCURRENCES] 
Actual DatedateTimeattribute[InteractRTDS].[UARI_EV_ACT_IC_HR].[ACTUALDATE] 
Hourint32attribute[InteractRTDS].[UARI_EV_ACT_IC_HR].[HR] 
Channel Event Activity Day at IC LevelInteractive Channel IDint64identifier[InteractRTDS].[UARI_EV_ACT_IC_DY].[ICID] 
Occurrencesint64fact[InteractRTDS].[UARI_EV_ACT_IC_DY].[NUM_OCCURRENCES] 
Actual DatedateTimeattribute[InteractRTDS].[UARI_EV_ACT_IC_DY].[ACTUALDATE] 
Import View
model/Import View.jpg
Namespace/FolderQuery SubjectQuery ItemTypeUsageRef Obj/Expr.
Namespace/FolderQuery SubjectQuery ItemTypeUsageRef Obj/Expr.
CommonUARI_OFFEROFFERIDdecimalfact 
NAMEcharacterLength16attribute 
DESCRIPTIONcharacterLength16attribute 
OFFERCODE1characterLength16attribute 
OFFERCODE2characterLength16attribute 
OFFERCODE3characterLength16attribute 
OFFERCODE4characterLength16attribute 
OFFERCODE5characterLength16attribute 
UARI_TRMTRULEINVTREATMENTRULEIDdecimalfact 
DEPLOYMENTIDdecimalfact 
ICIDdecimalfact 
ICNAMEcharacterLength16attribute 
CELLIDdecimalfact 
CELLNAMEcharacterLength16attribute 
ZONEIDdecimalfact 
ZONENAMEcharacterLength16attribute 
STRATEGYIDdecimalfact 
STRATEGYNAMEcharacterLength16attribute 
OFFERIDdecimalfact 
OFFERNAMEcharacterLength16attribute 
CAMPAIGNIDdecimalfact 
CAMPAIGNNAMEcharacterLength16attribute 
CAMPAIGNCODEcharacterLength16attribute 
SEGMENTIDdecimalfact 
SEGMENTNAMEcharacterLength16attribute 
MARKETINGSCOREint64fact 
LASTUPDATEdateTimeidentifier 
PREDICATEcharacterLength16attribute 
ENABLESTATEIDint64fact 
PREDICATESTATEcharacterLength16attribute 
UARI_CAMPAIGNCAMPAIGNIDdecimalfact 
NAMEcharacterLength16attribute 
DESCRIPTIONcharacterLength16attribute 
CAMPAIGNCODEcharacterLength16attribute 
OBJECTIVEScharacterLength16attribute 
LASTRUNDATEdateTimeidentifier 
INITIATIVEcharacterLength16attribute 
CREATEDATEdateTimeidentifier 
STARTDATEdateTimeidentifier 
ENDDATEdateTimeidentifier 
UARI_CELLSCELLIDdecimalfact 
CELLNAMEcharacterLength16attribute 
CELLCODEcharacterLength16attribute 
CONTROLCELLIDdecimalfact 
ISCONTROLint64fact 
CAMPAIGNIDdecimalfact 
UARI_TRI_CAMP_OFFOFFERIDdecimalfact 
OFFERNAMEcharacterLength16attribute 
CAMPAIGNIDdecimalfact 
CAMPAIGNNAMEcharacterLength16attribute 
CAMPAIGNCODEcharacterLength16attribute 
UARI_LOOKUPLKUP_IDint64fact 
LKUP_CODEcharacterLength16attribute 
LKUP_TYPEcharacterLength16attribute 
DESCRIPTIONcharacterLength16attribute 
LOCALEcharacterLength16attribute 
LOCALIZED_STRINGcharacterLength16attribute 
UARI_CALENDARDATEIDdecimalfact 
YEARint64fact 
FISCALYEARint64fact 
QUARTERint64fact 
FISCALQUARTERint64fact 
MONTHint64fact 
WEEKOFYEARint64fact 
WEEKOFMONTHint64fact 
DAYOFYEARint64fact 
DAYOFMONTHint64fact 
DAYOFWEEKint64fact 
ACTUALDATEdateTimeidentifier 
FIRSTDAYOFWEEKdateTimeidentifier 
LASTDAYOFWEEKdateTimeidentifier 
UARI_TIMETIMEIDdecimalfact 
HOURint64fact 
MINUTEint64fact 
LAST_24_HOURS_LOOKUPHOURfloat64fact 
DATEIDdecimalfact 
ACTUALDATEdateTimeidentifier 
DeploymentUARI_DEPLOYMENTDEPLOYMENTIDdecimalfact 
DEPLOYDEPTYPEIDint64fact 
ICIDdecimalfact 
CAMPAIGNIDdecimalfact 
CAMPAIGNNAMEcharacterLength16attribute 
STRATEGYIDdecimalfact 
STRATEGYNAMEcharacterLength16attribute 
DEPLOYTYPEIDint64fact 
DEPLOYTYPEcharacterLength16attribute 
SESSIONIDdecimalfact 
SESSIONNAMEcharacterLength16attribute 
FLOWCHARTIDdecimalfact 
FLOWCHARTNAMEcharacterLength16attribute 
FLOWCHDEPLOYTYPEIDint64fact 
FLOWCHDEPLOYTYPEcharacterLength16attribute 
AUDIENCELEVELcharacterLength16attribute 
DEPLMNTDESTcharacterLength16attribute 
DEPLMNTSVRGRPint64fact 
DEPLMNTOWNERcharacterLength16attribute 
TIMEDEPLMNTdateTimeidentifier 
Namespace/FolderQuery SubjectQuery ItemTypeUsageRef Obj/Expr.
Interactive Channel by OfferUARI_ICP_OCHICIDdecimalfact 
ICNAMEcharacterLength16attribute 
IPIDfloat64fact 
IPNAMEcharacterLength16attribute 
OFFERIDdecimalfact 
NUM_TIMES_PRESfloat64fact 
NUM_PRES_MODELDRVNfloat64fact 
NUM_PRES_RANDOMfloat64fact 
UARI_ICP_OCH_DYICIDdecimalfact 
ICNAMEcharacterLength16attribute 
IPIDfloat64fact 
IPNAMEcharacterLength16attribute 
OFFERIDdecimalfact 
ACTUALDATEdateTimeidentifier 
NUM_TIMES_PRESfloat64fact 
NUM_PRES_MODELDRVNfloat64fact 
NUM_PRES_RANDOMfloat64fact 
UARI_ICP_OCH_HRICIDdecimalfact 
ICNAMEcharacterLength16attribute 
IPIDfloat64fact 
IPNAMEcharacterLength16attribute 
OFFERIDdecimalfact 
HOURint64fact 
ACTUALDATEdateTimeidentifier 
NUM_TIMES_PRESfloat64fact 
NUM_PRES_MODELDRVNfloat64fact 
NUM_PRES_RANDOMfloat64fact 
UARI_ICP_ORHICIDdecimalfact 
ICNAMEcharacterLength16attribute 
IPIDfloat64fact 
IPNAMEcharacterLength16attribute 
OFFERIDdecimalfact 
NUM_TIMES_ACCPfloat64fact 
NUM_TIME_REJfloat64fact 
NUM_ACCP_MODELDRVNfloat64fact 
NUM_ACCP_RANDOMfloat64fact 
UARI_ICP_ORH_DYICIDdecimalfact 
ICNAMEcharacterLength16attribute 
IPIDfloat64fact 
IPNAMEcharacterLength16attribute 
OFFERIDdecimalfact 
ACTUALDATEdateTimeidentifier 
NUM_TIMES_ACCPfloat64fact 
NUM_TIME_REJfloat64fact 
NUM_ACCP_MODELDRVNfloat64fact 
NUM_ACCP_RANDOMfloat64fact 
UARI_ICP_ORH_HRICIDdecimalfact 
ICNAMEcharacterLength16attribute 
IPIDfloat64fact 
IPNAMEcharacterLength16attribute 
OFFERIDdecimalfact 
HOURint64fact 
ACTUALDATEdateTimeidentifier 
NUM_TIMES_ACCPfloat64fact 
NUM_TIME_REJfloat64fact 
NUM_ACCP_MODELDRVNfloat64fact 
NUM_ACCP_RANDOMfloat64fact 
Interactive Channel by SegmentUARI_ICP_SEGCHICIDdecimalfact 
ICNAMEcharacterLength16attribute 
IPIDfloat64fact 
IPNAMEcharacterLength16attribute 
SEGMENTIDdecimalfact 
SEGMENT_NAMEcharacterLength16attribute 
NUM_TIMES_PRESfloat64fact 
NUM_PRES_MODELDRVNfloat64fact 
NUM_PRES_RANDOMfloat64fact 
UARI_ICP_SEGCH_DYICIDdecimalfact 
ICNAMEcharacterLength16attribute 
IPIDfloat64fact 
IPNAMEcharacterLength16attribute 
SEGMENTIDdecimalfact 
SEGMENT_NAMEcharacterLength16attribute 
ACTUALDATEdateTimeidentifier 
NUM_TIMES_PRESfloat64fact 
NUM_PRES_MODELDRVNfloat64fact 
NUM_PRES_RANDOMfloat64fact 
UARI_ICP_SEGCH_HRICIDdecimalfact 
ICNAMEcharacterLength16attribute 
IPIDfloat64fact 
IPNAMEcharacterLength16attribute 
SEGMENTIDdecimalfact 
SEGMENT_NAMEcharacterLength16attribute 
HOURint64fact 
ACTUALDATEdateTimeidentifier 
NUM_TIMES_PRESfloat64fact 
NUM_PRES_MODELDRVNfloat64fact 
NUM_PRES_RANDOMfloat64fact 
UARI_ICP_SEGRHICIDdecimalfact 
ICNAMEcharacterLength16attribute 
IPIDfloat64fact 
IPNAMEcharacterLength16attribute 
SEGMENTIDdecimalfact 
SEGMENT_NAMEcharacterLength16attribute 
NUM_TIMES_ACCPfloat64fact 
NUM_TIME_REJfloat64fact 
NUM_ACCP_MODELDRVNfloat64fact 
NUM_ACCP_RANDOMfloat64fact 
UARI_ICP_SEGRH_DYICIDdecimalfact 
ICNAMEcharacterLength16attribute 
IPIDfloat64fact 
IPNAMEcharacterLength16attribute 
SEGMENTIDdecimalfact 
SEGMENT_NAMEcharacterLength16attribute 
ACTUALDATEdateTimeidentifier 
NUM_TIMES_ACCPfloat64fact 
NUM_TIME_REJfloat64fact 
NUM_ACCP_MODELDRVNfloat64fact 
NUM_ACCP_RANDOMfloat64fact 
UARI_ICP_SEGRH_HRICIDdecimalfact 
ICNAMEcharacterLength16attribute 
IPIDfloat64fact 
IPNAMEcharacterLength16attribute 
SEGMENTIDdecimalfact 
SEGMENT_NAMEcharacterLength16attribute 
HOURint64fact 
ACTUALDATEdateTimeidentifier 
NUM_TIMES_ACCPfloat64fact 
NUM_TIME_REJfloat64fact 
NUM_ACCP_MODELDRVNfloat64fact 
NUM_ACCP_RANDOMfloat64fact 
Interactive Channel by Interaction PointUARI_ICP_IPCHICIDdecimalfact 
ICNAMEcharacterLength16attribute 
IPIDfloat64fact 
IPNAMEcharacterLength16attribute 
NUM_TIMES_PRESfloat64fact 
NUM_PRES_MODELDRVNfloat64fact 
NUM_PRES_RANDOMfloat64fact 
UARI_ICP_IPCH_DYICIDdecimalfact 
ICNAMEcharacterLength16attribute 
IPIDfloat64fact 
IPNAMEcharacterLength16attribute 
ACTUALDATEdateTimeidentifier 
NUM_TIMES_PRESfloat64fact 
NUM_PRES_MODELDRVNfloat64fact 
NUM_PRES_RANDOMfloat64fact 
UARI_ICP_IPCH_HRICIDdecimalfact 
ICNAMEcharacterLength16attribute 
IPIDfloat64fact 
IPNAMEcharacterLength16attribute 
HOURint64fact 
ACTUALDATEdateTimeidentifier 
NUM_TIMES_PRESfloat64fact 
NUM_PRES_MODELDRVNfloat64fact 
NUM_PRES_RANDOMfloat64fact 
UARI_ICP_IPRHICIDdecimalfact 
ICNAMEcharacterLength16attribute 
IPIDfloat64fact 
IPNAMEcharacterLength16attribute 
NUM_TIMES_ACCPfloat64fact 
NUM_TIME_REJfloat64fact 
NUM_ACCP_MODELDRVNfloat64fact 
NUM_ACCP_RANDOMfloat64fact 
UARI_ICP_IPRH_DYICIDdecimalfact 
ICNAMEcharacterLength16attribute 
IPIDfloat64fact 
IPNAMEcharacterLength16attribute 
ACTUALDATEdateTimeidentifier 
NUM_TIMES_ACCPfloat64fact 
NUM_TIME_REJfloat64fact 
NUM_ACCP_MODELDRVNfloat64fact 
NUM_ACCP_RANDOMfloat64fact 
UARI_ICP_IPRH_HRICIDdecimalfact 
ICNAMEcharacterLength16attribute 
IPIDfloat64fact 
IPNAMEcharacterLength16attribute 
HOURint64fact 
ACTUALDATEdateTimeidentifier 
NUM_TIMES_ACCPfloat64fact 
NUM_TIME_REJfloat64fact 
NUM_ACCP_MODELDRVNfloat64fact 
NUM_ACCP_RANDOMfloat64fact 
Campaign Cell PerformanceUARI_CCP_CHCAMPAIGNIDdecimalfact 
CELLIDdecimalfact 
NUM_TIMES_PRESfloat64fact 
NUM_PRES_MODELDRVNfloat64fact 
NUM_PRES_RANDOMfloat64fact 
UARI_CCP_CH_DYCAMPAIGNIDdecimalfact 
CELLIDdecimalfact 
ACTUALDATEdateTimeidentifier 
NUM_TIMES_PRESfloat64fact 
NUM_PRES_MODELDRVNfloat64fact 
NUM_PRES_RANDOMfloat64fact 
UARI_CCP_CH_HRCAMPAIGNIDdecimalfact 
CELLIDdecimalfact 
HOURint64fact 
ACTUALDATEdateTimeidentifier 
NUM_TIMES_PRESfloat64fact 
NUM_PRES_MODELDRVNfloat64fact 
NUM_PRES_RANDOMfloat64fact 
UARI_CCP_RHCAMPAIGNIDdecimalfact 
CELLIDdecimalfact 
NUM_TIMES_ACCPfloat64fact 
NUM_TIME_REJfloat64fact 
NUM_ACCP_MODELDRVNfloat64fact 
NUM_ACCP_RANDOMfloat64fact 
UARI_CCP_RH_DYCAMPAIGNIDdecimalfact 
CELLIDdecimalfact 
ACTUALDATEdateTimeidentifier 
NUM_TIMES_ACCPfloat64fact 
NUM_TIME_REJfloat64fact 
NUM_ACCP_MODELDRVNfloat64fact 
NUM_ACCP_RANDOMfloat64fact 
UARI_CCP_RH_HRCAMPAIGNIDdecimalfact 
CELLIDdecimalfact 
HOURint64fact 
ACTUALDATEdateTimeidentifier 
NUM_TIMES_ACCPfloat64fact 
NUM_TIME_REJfloat64fact 
NUM_ACCP_MODELDRVNfloat64fact 
NUM_ACCP_RANDOMfloat64fact 
Campaign Cell by OfferUARI_CCP_OCHCAMPAIGNIDdecimalfact 
CELLIDdecimalfact 
OFFERIDdecimalfact 
NUM_TIMES_PRESfloat64fact 
NUM_PRES_MODELDRVNfloat64fact 
NUM_PRES_RANDOMfloat64fact 
UARI_CCP_ORHCAMPAIGNIDdecimalfact 
CELLIDdecimalfact 
OFFERIDdecimalfact 
NUM_TIMES_ACCPfloat64fact 
NUM_TIME_REJfloat64fact 
NUM_ACCP_MODELDRVNfloat64fact 
NUM_ACCP_RANDOMfloat64fact 
Campaign Cell by Interaction PointUARI_CCP_IPCHCAMPAIGNIDdecimalfact 
CELLIDdecimalfact 
IPIDfloat64fact 
IPNAMEcharacterLength16attribute 
NUM_TIMES_PRESfloat64fact 
NUM_PRES_MODELDRVNfloat64fact 
NUM_PRES_RANDOMfloat64fact 
UARI_CCP_IPRHCAMPAIGNIDdecimalfact 
CELLIDdecimalfact 
IPIDfloat64fact 
IPNAMEcharacterLength16attribute 
NUM_TIMES_ACCPfloat64fact 
NUM_TIME_REJfloat64fact 
NUM_ACCP_MODELDRVNfloat64fact 
NUM_ACCP_RANDOMfloat64fact 
Campaign Offer PerformanceUARI_COP_CHCAMPAIGNIDdecimalfact 
OFFERIDdecimalfact 
NUM_TIMES_PRESfloat64fact 
NUM_PRES_MODELDRVNfloat64fact 
NUM_PRES_RANDOMfloat64fact 
UARI_COP_CH_DYCAMPAIGNIDdecimalfact 
OFFERIDdecimalfact 
ACTUALDATEdateTimeidentifier 
NUM_TIMES_PRESfloat64fact 
NUM_PRES_MODELDRVNfloat64fact 
NUM_PRES_RANDOMfloat64fact 
UARI_COP_CH_HRCAMPAIGNIDdecimalfact 
OFFERIDdecimalfact 
HOURint64fact 
ACTUALDATEdateTimeidentifier 
NUM_TIMES_PRESfloat64fact 
NUM_PRES_MODELDRVNfloat64fact 
NUM_PRES_RANDOMfloat64fact 
UARI_COP_RHCAMPAIGNIDdecimalfact 
OFFERIDdecimalfact 
NUM_TIMES_ACCPfloat64fact 
NUM_TIME_REJfloat64fact 
NUM_ACCP_MODELDRVNfloat64fact 
NUM_ACCP_RANDOMfloat64fact 
UARI_COP_RH_DYCAMPAIGNIDdecimalfact 
OFFERIDdecimalfact 
ACTUALDATEdateTimeidentifier 
NUM_TIMES_ACCPfloat64fact 
NUM_TIME_REJfloat64fact 
NUM_ACCP_MODELDRVNfloat64fact 
NUM_ACCP_RANDOMfloat64fact 
UARI_COP_RH_HRCAMPAIGNIDdecimalfact 
OFFERIDdecimalfact 
HOURint64fact 
ACTUALDATEdateTimeidentifier 
NUM_TIMES_ACCPfloat64fact 
NUM_TIME_REJfloat64fact 
NUM_ACCP_MODELDRVNfloat64fact 
NUM_ACCP_RANDOMfloat64fact 
Campaign Offer by CellUARI_COP_CCHCAMPAIGNIDdecimalfact 
OFFERIDdecimalfact 
CELLIDdecimalfact 
NUM_TIMES_PRESfloat64fact 
NUM_PRES_MODELDRVNfloat64fact 
NUM_PRES_RANDOMfloat64fact 
UARI_COP_CRHCAMPAIGNIDdecimalfact 
OFFERIDdecimalfact 
CELLIDdecimalfact 
NUM_TIMES_ACCPfloat64fact 
NUM_TIME_REJfloat64fact 
NUM_ACCP_MODELDRVNfloat64fact 
NUM_ACCP_RANDOMfloat64fact 
Campaign Offer by Interaction PointUARI_COP_IPCHCAMPAIGNIDdecimalfact 
OFFERIDdecimalfact 
IPIDfloat64fact 
IPNAMEcharacterLength16attribute 
NUM_TIMES_PRESfloat64fact 
NUM_PRES_MODELDRVNfloat64fact 
NUM_PRES_RANDOMfloat64fact 
UARI_COP_IPRHCAMPAIGNIDdecimalfact 
OFFERIDdecimalfact 
IPIDfloat64fact 
IPNAMEcharacterLength16attribute 
NUM_TIMES_ACCPfloat64fact 
NUM_TIME_REJfloat64fact 
NUM_ACCP_MODELDRVNfloat64fact 
NUM_ACCP_RANDOMfloat64fact 
Namespace/FolderQuery SubjectQuery ItemTypeUsageRef Obj/Expr.
Run Time CommonUARI_ELIGSTATSEQNUMdecimalfact 
ICIDdecimalfact 
ICNAMEcharacterLength16attribute 
OFFERIDdecimalfact 
OFFERNAMEcharacterLength16attribute 
TIMEIDdecimalfact 
DATEIDdecimalfact 
CELLIDdecimalfact 
CELLNAMEcharacterLength16attribute 
CELLCODEcharacterLength16attribute 
IPIDdecimalfact 
IPNAMEcharacterLength16attribute 
ELIGIBLEOPPSdecimalfact 
UARI_DEFAULTEDSTATSEQNUMdecimalfact 
TIMEIDdecimalfact 
DATEIDdecimalfact 
SEGMENTIDdecimalfact 
SEGMENTNAMEcharacterLength16attribute 
IPIDdecimalfact 
IPNAMEcharacterLength16attribute 
ICIDdecimalfact 
OCCURRENCESdecimalfact 
Namespace/FolderQuery SubjectQuery ItemTypeUsageRef Obj/Expr.
Interactive Channel by OfferUARI_ICP_OESICIDdecimalfact 
ICNAMEcharacterLength16attribute 
IPIDdecimalfact 
IPNAMEcharacterLength16attribute 
OFFERIDdecimalfact 
ELIGIBLEOPPSfloat64fact 
UARI_ICP_OES_DYICIDdecimalfact 
ICNAMEcharacterLength16attribute 
IPIDdecimalfact 
IPNAMEcharacterLength16attribute 
OFFERIDdecimalfact 
ACTUALDATEdateTimeidentifier 
ELIGIBLEOPPSfloat64fact 
UARI_ICP_OES_HRICIDdecimalfact 
ICNAMEcharacterLength16attribute 
IPIDdecimalfact 
IPNAMEcharacterLength16attribute 
OFFERIDdecimalfact 
HOURint64fact 
ACTUALDATEdateTimeidentifier 
ELIGIBLEOPPSfloat64fact 
Interactive Channel by SegmentUARI_ICP_SEGDSICIDdecimalfact 
IPIDdecimalfact 
SEGMENTIDdecimalfact 
NUM_OF_OCCURRENCESfloat64fact 
Interactive Channel by Interaction PointUARI_ICP_IPDSICIDdecimalfact 
IPIDdecimalfact 
NUM_OF_OCCURRENCESfloat64fact 
Campaign Cell PerformanceUARI_CCP_ESCAMPAIGNIDint64fact 
CELLIDdecimalfact 
ELIGIBLEOPPSfloat64fact 
UARI_CCP_ES_DYCAMPAIGNIDint64fact 
CELLIDdecimalfact 
ACTUALDATEdateTimeidentifier 
ELIGIBLEOPPSfloat64fact 
UARI_CCP_ES_HRCAMPAIGNIDint64fact 
CELLIDdecimalfact 
HOURint64fact 
ACTUALDATEdateTimeidentifier 
ELIGIBLEOPPSfloat64fact 
UARI_CCP_IPESCAMPAIGNIDint64fact 
CELLIDdecimalfact 
IPIDdecimalfact 
IPNAMEcharacterLength16attribute 
ELIGIBLEOPPSfloat64fact 
UARI_CCP_OESCAMPAIGNIDint64fact 
CELLIDdecimalfact 
OFFERIDdecimalfact 
ELIGIBLEOPPSfloat64fact 
Campaign Offer PerformacneUARI_COP_ESCAMPAIGNIDfloat64fact 
OFFERIDdecimalfact 
ELIGIBLEOPPSfloat64fact 
UARI_COP_ES_DYCAMPAIGNIDfloat64fact 
OFFERIDdecimalfact 
ACTUALDATEdateTimeidentifier 
ELIGIBLEOPPSfloat64fact 
UARI_COP_ES_HRCAMPAIGNIDfloat64fact 
OFFERIDdecimalfact 
HOURint64fact 
ACTUALDATEdateTimeidentifier 
ELIGIBLEOPPSfloat64fact 
UARI_COP_CESCAMPAIGNIDint64fact 
OFFERIDdecimalfact 
CELLIDdecimalfact 
ELIGIBLEOPPSfloat64fact 
UARI_COP_IPESCAMPAIGNIDint64fact 
OFFERIDdecimalfact 
IPIDdecimalfact 
IPNAMEcharacterLength16attribute 
ELIGIBLEOPPSfloat64fact 
Event ActivityUARI_EV_ACTICIDdecimalidentifier 
ICNAMEcharacterLength16attribute 
CATEGORYIDdecimalidentifier 
CATEGORYNAMEcharacterLength16attribute 
EVENTIDdecimalidentifier 
EVENTNAMEcharacterLength16attribute 
NUM_OCCURRENCESfloat64fact 
UARI_EV_ACT_DYICIDdecimalidentifier 
ICNAMEcharacterLength16attribute 
CATEGORYIDdecimalidentifier 
CATEGORYNAMEcharacterLength16attribute 
EVENTIDdecimalidentifier 
EVENTNAMEcharacterLength16attribute 
NUM_OCCURRENCESfloat64fact 
ACTUALDATEdateTimeattribute 
UARI_EV_ACT_HRICIDdecimalidentifier 
ICNAMEcharacterLength16attribute 
CATEGORYIDdecimalidentifier 
CATEGORYNAMEcharacterLength16attribute 
EVENTIDdecimalidentifier 
EVENTNAMEcharacterLength16attribute 
NUM_OCCURRENCESfloat64fact 
ACTUALDATEdateTimeattribute 
HRint64attribute 
UARI_EV_ACT_IC_DYICIDdecimalfact 
NUM_OCCURRENCESfloat64fact 
ACTUALDATEdateTimeidentifier 
UARI_EV_ACT_IC_HRICIDdecimalfact 
NUM_OCCURRENCESfloat64fact 
ACTUALDATEdateTimeidentifier 
HRint64fact 
Namespace/FolderQuery SubjectQuery ItemTypeUsageRef Obj/Expr.
LearningUARI_LEARNINGOFFERIDdecimalfact 
ATTRIBUTENAMEcharacterLength16attribute 
ATTRIBUTEVALUEcharacterLength16attribute 
ACCEPTPERCENTAGEfloat64fact 
PREDICTABILITYint64fact 
Namespace/FolderQuery SubjectQuery ItemTypeUsageRef Obj/Expr.
CommonUARI_OFFEROFFERIDdecimalfact 
NAMEcharacterLength16attribute 
DESCRIPTIONcharacterLength16attribute 
OFFERCODE1characterLength16attribute 
OFFERCODE2characterLength16attribute 
OFFERCODE3characterLength16attribute 
OFFERCODE4characterLength16attribute 
OFFERCODE5characterLength16attribute 
UARI_TRMTRULEINVTREATMENTRULEIDdecimalfact 
DEPLOYMENTIDdecimalfact 
ICIDdecimalfact 
ICNAMEcharacterLength16attribute 
CELLIDdecimalfact 
CELLNAMEcharacterLength16attribute 
ZONEIDdecimalfact 
ZONENAMEcharacterLength16attribute 
STRATEGYIDdecimalfact 
STRATEGYNAMEcharacterLength16attribute 
OFFERIDdecimalfact 
OFFERNAMEcharacterLength16attribute 
CAMPAIGNIDdecimalfact 
CAMPAIGNNAMEcharacterLength16attribute 
CAMPAIGNCODEcharacterLength16attribute 
SEGMENTIDdecimalfact 
SEGMENTNAMEcharacterLength16attribute 
MARKETINGSCOREint64fact 
LASTUPDATEdateTimeidentifier 
PREDICATEcharacterLength16attribute 
ENABLESTATEIDint64fact 
PREDICATESTATEcharacterLength16attribute 
UARI_CAMPAIGNCAMPAIGNIDdecimalfact 
NAMEcharacterLength16attribute 
DESCRIPTIONcharacterLength16attribute 
CAMPAIGNCODEcharacterLength16attribute 
OBJECTIVEScharacterLength16attribute 
LASTRUNDATEdateTimeidentifier 
INITIATIVEcharacterLength16attribute 
CREATEDATEdateTimeidentifier 
STARTDATEdateTimeidentifier 
ENDDATEdateTimeidentifier 
UARI_CELLSCELLIDdecimalfact 
CELLNAMEcharacterLength16attribute 
CELLCODEcharacterLength16attribute 
CONTROLCELLIDdecimalfact 
ISCONTROLint64fact 
CAMPAIGNIDdecimalfact 
UARI_TRI_CAMP_OFFOFFERIDdecimalfact 
OFFERNAMEcharacterLength16attribute 
CAMPAIGNIDdecimalfact 
CAMPAIGNNAMEcharacterLength16attribute 
CAMPAIGNCODEcharacterLength16attribute 
UARI_LOOKUPLKUP_IDint64fact 
LKUP_CODEcharacterLength16attribute 
LKUP_TYPEcharacterLength16attribute 
DESCRIPTIONcharacterLength16attribute 
LOCALEcharacterLength16attribute 
LOCALIZED_STRINGcharacterLength16attribute 
UARI_CALENDARDATEIDdecimalfact 
YEARint64fact 
FISCALYEARint64fact 
QUARTERint64fact 
FISCALQUARTERint64fact 
MONTHint64fact 
WEEKOFYEARint64fact 
WEEKOFMONTHint64fact 
DAYOFYEARint64fact 
DAYOFMONTHint64fact 
DAYOFWEEKint64fact 
ACTUALDATEdateTimeidentifier 
FIRSTDAYOFWEEKdateTimeidentifier 
LASTDAYOFWEEKdateTimeidentifier 
UARI_TIMETIMEIDdecimalfact 
HOURint64fact 
MINUTEint64fact 
LAST_24_HOURS_LOOKUPHOURfloat64fact 
DATEIDdecimalfact 
ACTUALDATEdateTimeidentifier 
DeploymentUARI_DEPLOYMENTDEPLOYMENTIDdecimalfact 
DEPLOYDEPTYPEIDint64fact 
ICIDdecimalfact 
CAMPAIGNIDdecimalfact 
CAMPAIGNNAMEcharacterLength16attribute 
STRATEGYIDdecimalfact 
STRATEGYNAMEcharacterLength16attribute 
DEPLOYTYPEIDint64fact 
DEPLOYTYPEcharacterLength16attribute 
SESSIONIDdecimalfact 
SESSIONNAMEcharacterLength16attribute 
FLOWCHARTIDdecimalfact 
FLOWCHARTNAMEcharacterLength16attribute 
FLOWCHDEPLOYTYPEIDint64fact 
FLOWCHDEPLOYTYPEcharacterLength16attribute 
AUDIENCELEVELcharacterLength16attribute 
DEPLMNTDESTcharacterLength16attribute 
DEPLMNTSVRGRPint64fact 
DEPLMNTOWNERcharacterLength16attribute 
TIMEDEPLMNTdateTimeidentifier 
Namespace/FolderQuery SubjectQuery ItemTypeUsageRef Obj/Expr.
Interactive Channel by OfferUARI_ICP_OCHICIDdecimalfact 
ICNAMEcharacterLength16attribute 
IPIDfloat64fact 
IPNAMEcharacterLength16attribute 
OFFERIDdecimalfact 
NUM_TIMES_PRESfloat64fact 
NUM_PRES_MODELDRVNfloat64fact 
NUM_PRES_RANDOMfloat64fact 
UARI_ICP_OCH_DYICIDdecimalfact 
ICNAMEcharacterLength16attribute 
IPIDfloat64fact 
IPNAMEcharacterLength16attribute 
OFFERIDdecimalfact 
ACTUALDATEdateTimeidentifier 
NUM_TIMES_PRESfloat64fact 
NUM_PRES_MODELDRVNfloat64fact 
NUM_PRES_RANDOMfloat64fact 
UARI_ICP_OCH_HRICIDdecimalfact 
ICNAMEcharacterLength16attribute 
IPIDfloat64fact 
IPNAMEcharacterLength16attribute 
OFFERIDdecimalfact 
HOURint64fact 
ACTUALDATEdateTimeidentifier 
NUM_TIMES_PRESfloat64fact 
NUM_PRES_MODELDRVNfloat64fact 
NUM_PRES_RANDOMfloat64fact 
UARI_ICP_ORHICIDdecimalfact 
ICNAMEcharacterLength16attribute 
IPIDfloat64fact 
IPNAMEcharacterLength16attribute 
OFFERIDdecimalfact 
NUM_TIMES_ACCPfloat64fact 
NUM_TIME_REJfloat64fact 
NUM_ACCP_MODELDRVNfloat64fact 
NUM_ACCP_RANDOMfloat64fact 
UARI_ICP_ORH_DYICIDdecimalfact 
ICNAMEcharacterLength16attribute 
IPIDfloat64fact 
IPNAMEcharacterLength16attribute 
OFFERIDdecimalfact 
ACTUALDATEdateTimeidentifier 
NUM_TIMES_ACCPfloat64fact 
NUM_TIME_REJfloat64fact 
NUM_ACCP_MODELDRVNfloat64fact 
NUM_ACCP_RANDOMfloat64fact 
UARI_ICP_ORH_HRICIDdecimalfact 
ICNAMEcharacterLength16attribute 
IPIDfloat64fact 
IPNAMEcharacterLength16attribute 
OFFERIDdecimalfact 
HOURint64fact 
ACTUALDATEdateTimeidentifier 
NUM_TIMES_ACCPfloat64fact 
NUM_TIME_REJfloat64fact 
NUM_ACCP_MODELDRVNfloat64fact 
NUM_ACCP_RANDOMfloat64fact 
Interactive Channel by SegmentUARI_ICP_SEGCHICIDdecimalfact 
ICNAMEcharacterLength16attribute 
IPIDfloat64fact 
IPNAMEcharacterLength16attribute 
SEGMENTIDdecimalfact 
SEGMENT_NAMEcharacterLength16attribute 
NUM_TIMES_PRESfloat64fact 
NUM_PRES_MODELDRVNfloat64fact 
NUM_PRES_RANDOMfloat64fact 
UARI_ICP_SEGCH_DYICIDdecimalfact 
ICNAMEcharacterLength16attribute 
IPIDfloat64fact 
IPNAMEcharacterLength16attribute 
SEGMENTIDdecimalfact 
SEGMENT_NAMEcharacterLength16attribute 
ACTUALDATEdateTimeidentifier 
NUM_TIMES_PRESfloat64fact 
NUM_PRES_MODELDRVNfloat64fact 
NUM_PRES_RANDOMfloat64fact 
UARI_ICP_SEGCH_HRICIDdecimalfact 
ICNAMEcharacterLength16attribute 
IPIDfloat64fact 
IPNAMEcharacterLength16attribute 
SEGMENTIDdecimalfact 
SEGMENT_NAMEcharacterLength16attribute 
HOURint64fact 
ACTUALDATEdateTimeidentifier 
NUM_TIMES_PRESfloat64fact 
NUM_PRES_MODELDRVNfloat64fact 
NUM_PRES_RANDOMfloat64fact 
UARI_ICP_SEGRHICIDdecimalfact 
ICNAMEcharacterLength16attribute 
IPIDfloat64fact 
IPNAMEcharacterLength16attribute 
SEGMENTIDdecimalfact 
SEGMENT_NAMEcharacterLength16attribute 
NUM_TIMES_ACCPfloat64fact 
NUM_TIME_REJfloat64fact 
NUM_ACCP_MODELDRVNfloat64fact 
NUM_ACCP_RANDOMfloat64fact 
UARI_ICP_SEGRH_DYICIDdecimalfact 
ICNAMEcharacterLength16attribute 
IPIDfloat64fact 
IPNAMEcharacterLength16attribute 
SEGMENTIDdecimalfact 
SEGMENT_NAMEcharacterLength16attribute 
ACTUALDATEdateTimeidentifier 
NUM_TIMES_ACCPfloat64fact 
NUM_TIME_REJfloat64fact 
NUM_ACCP_MODELDRVNfloat64fact 
NUM_ACCP_RANDOMfloat64fact 
UARI_ICP_SEGRH_HRICIDdecimalfact 
ICNAMEcharacterLength16attribute 
IPIDfloat64fact 
IPNAMEcharacterLength16attribute 
SEGMENTIDdecimalfact 
SEGMENT_NAMEcharacterLength16attribute 
HOURint64fact 
ACTUALDATEdateTimeidentifier 
NUM_TIMES_ACCPfloat64fact 
NUM_TIME_REJfloat64fact 
NUM_ACCP_MODELDRVNfloat64fact 
NUM_ACCP_RANDOMfloat64fact 
Interactive Channel by Interaction PointUARI_ICP_IPCHICIDdecimalfact 
ICNAMEcharacterLength16attribute 
IPIDfloat64fact 
IPNAMEcharacterLength16attribute 
NUM_TIMES_PRESfloat64fact 
NUM_PRES_MODELDRVNfloat64fact 
NUM_PRES_RANDOMfloat64fact 
UARI_ICP_IPCH_DYICIDdecimalfact 
ICNAMEcharacterLength16attribute 
IPIDfloat64fact 
IPNAMEcharacterLength16attribute 
ACTUALDATEdateTimeidentifier 
NUM_TIMES_PRESfloat64fact 
NUM_PRES_MODELDRVNfloat64fact 
NUM_PRES_RANDOMfloat64fact 
UARI_ICP_IPCH_HRICIDdecimalfact 
ICNAMEcharacterLength16attribute 
IPIDfloat64fact 
IPNAMEcharacterLength16attribute 
HOURint64fact 
ACTUALDATEdateTimeidentifier 
NUM_TIMES_PRESfloat64fact 
NUM_PRES_MODELDRVNfloat64fact 
NUM_PRES_RANDOMfloat64fact 
UARI_ICP_IPRHICIDdecimalfact 
ICNAMEcharacterLength16attribute 
IPIDfloat64fact 
IPNAMEcharacterLength16attribute 
NUM_TIMES_ACCPfloat64fact 
NUM_TIME_REJfloat64fact 
NUM_ACCP_MODELDRVNfloat64fact 
NUM_ACCP_RANDOMfloat64fact 
UARI_ICP_IPRH_DYICIDdecimalfact 
ICNAMEcharacterLength16attribute 
IPIDfloat64fact 
IPNAMEcharacterLength16attribute 
ACTUALDATEdateTimeidentifier 
NUM_TIMES_ACCPfloat64fact 
NUM_TIME_REJfloat64fact 
NUM_ACCP_MODELDRVNfloat64fact 
NUM_ACCP_RANDOMfloat64fact 
UARI_ICP_IPRH_HRICIDdecimalfact 
ICNAMEcharacterLength16attribute 
IPIDfloat64fact 
IPNAMEcharacterLength16attribute 
HOURint64fact 
ACTUALDATEdateTimeidentifier 
NUM_TIMES_ACCPfloat64fact 
NUM_TIME_REJfloat64fact 
NUM_ACCP_MODELDRVNfloat64fact 
NUM_ACCP_RANDOMfloat64fact 
Campaign Cell PerformanceUARI_CCP_CHCAMPAIGNIDdecimalfact 
CELLIDdecimalfact 
NUM_TIMES_PRESfloat64fact 
NUM_PRES_MODELDRVNfloat64fact 
NUM_PRES_RANDOMfloat64fact 
UARI_CCP_CH_DYCAMPAIGNIDdecimalfact 
CELLIDdecimalfact 
ACTUALDATEdateTimeidentifier 
NUM_TIMES_PRESfloat64fact 
NUM_PRES_MODELDRVNfloat64fact 
NUM_PRES_RANDOMfloat64fact 
UARI_CCP_CH_HRCAMPAIGNIDdecimalfact 
CELLIDdecimalfact 
HOURint64fact 
ACTUALDATEdateTimeidentifier 
NUM_TIMES_PRESfloat64fact 
NUM_PRES_MODELDRVNfloat64fact 
NUM_PRES_RANDOMfloat64fact 
UARI_CCP_RHCAMPAIGNIDdecimalfact 
CELLIDdecimalfact 
NUM_TIMES_ACCPfloat64fact 
NUM_TIME_REJfloat64fact 
NUM_ACCP_MODELDRVNfloat64fact 
NUM_ACCP_RANDOMfloat64fact 
UARI_CCP_RH_DYCAMPAIGNIDdecimalfact 
CELLIDdecimalfact 
ACTUALDATEdateTimeidentifier 
NUM_TIMES_ACCPfloat64fact 
NUM_TIME_REJfloat64fact 
NUM_ACCP_MODELDRVNfloat64fact 
NUM_ACCP_RANDOMfloat64fact 
UARI_CCP_RH_HRCAMPAIGNIDdecimalfact 
CELLIDdecimalfact 
HOURint64fact 
ACTUALDATEdateTimeidentifier 
NUM_TIMES_ACCPfloat64fact 
NUM_TIME_REJfloat64fact 
NUM_ACCP_MODELDRVNfloat64fact 
NUM_ACCP_RANDOMfloat64fact 
Campaign Cell by OfferUARI_CCP_OCHCAMPAIGNIDdecimalfact 
CELLIDdecimalfact 
OFFERIDdecimalfact 
NUM_TIMES_PRESfloat64fact 
NUM_PRES_MODELDRVNfloat64fact 
NUM_PRES_RANDOMfloat64fact 
UARI_CCP_ORHCAMPAIGNIDdecimalfact 
CELLIDdecimalfact 
OFFERIDdecimalfact 
NUM_TIMES_ACCPfloat64fact 
NUM_TIME_REJfloat64fact 
NUM_ACCP_MODELDRVNfloat64fact 
NUM_ACCP_RANDOMfloat64fact 
Campaign Cell by Interaction PointUARI_CCP_IPCHCAMPAIGNIDdecimalfact 
CELLIDdecimalfact 
IPIDfloat64fact 
IPNAMEcharacterLength16attribute 
NUM_TIMES_PRESfloat64fact 
NUM_PRES_MODELDRVNfloat64fact 
NUM_PRES_RANDOMfloat64fact 
UARI_CCP_IPRHCAMPAIGNIDdecimalfact 
CELLIDdecimalfact 
IPIDfloat64fact 
IPNAMEcharacterLength16attribute 
NUM_TIMES_ACCPfloat64fact 
NUM_TIME_REJfloat64fact 
NUM_ACCP_MODELDRVNfloat64fact 
NUM_ACCP_RANDOMfloat64fact 
Campaign Offer PerformanceUARI_COP_CHCAMPAIGNIDdecimalfact 
OFFERIDdecimalfact 
NUM_TIMES_PRESfloat64fact 
NUM_PRES_MODELDRVNfloat64fact 
NUM_PRES_RANDOMfloat64fact 
UARI_COP_CH_DYCAMPAIGNIDdecimalfact 
OFFERIDdecimalfact 
ACTUALDATEdateTimeidentifier 
NUM_TIMES_PRESfloat64fact 
NUM_PRES_MODELDRVNfloat64fact 
NUM_PRES_RANDOMfloat64fact 
UARI_COP_CH_HRCAMPAIGNIDdecimalfact 
OFFERIDdecimalfact 
HOURint64fact 
ACTUALDATEdateTimeidentifier 
NUM_TIMES_PRESfloat64fact 
NUM_PRES_MODELDRVNfloat64fact 
NUM_PRES_RANDOMfloat64fact 
UARI_COP_RHCAMPAIGNIDdecimalfact 
OFFERIDdecimalfact 
NUM_TIMES_ACCPfloat64fact 
NUM_TIME_REJfloat64fact 
NUM_ACCP_MODELDRVNfloat64fact 
NUM_ACCP_RANDOMfloat64fact 
UARI_COP_RH_DYCAMPAIGNIDdecimalfact 
OFFERIDdecimalfact 
ACTUALDATEdateTimeidentifier 
NUM_TIMES_ACCPfloat64fact 
NUM_TIME_REJfloat64fact 
NUM_ACCP_MODELDRVNfloat64fact 
NUM_ACCP_RANDOMfloat64fact 
UARI_COP_RH_HRCAMPAIGNIDdecimalfact 
OFFERIDdecimalfact 
HOURint64fact 
ACTUALDATEdateTimeidentifier 
NUM_TIMES_ACCPfloat64fact 
NUM_TIME_REJfloat64fact 
NUM_ACCP_MODELDRVNfloat64fact 
NUM_ACCP_RANDOMfloat64fact 
Campaign Offer by CellUARI_COP_CCHCAMPAIGNIDdecimalfact 
OFFERIDdecimalfact 
CELLIDdecimalfact 
NUM_TIMES_PRESfloat64fact 
NUM_PRES_MODELDRVNfloat64fact 
NUM_PRES_RANDOMfloat64fact 
UARI_COP_CRHCAMPAIGNIDdecimalfact 
OFFERIDdecimalfact 
CELLIDdecimalfact 
NUM_TIMES_ACCPfloat64fact 
NUM_TIME_REJfloat64fact 
NUM_ACCP_MODELDRVNfloat64fact 
NUM_ACCP_RANDOMfloat64fact 
Campaign Offer by Interaction PointUARI_COP_IPCHCAMPAIGNIDdecimalfact 
OFFERIDdecimalfact 
IPIDfloat64fact 
IPNAMEcharacterLength16attribute 
NUM_TIMES_PRESfloat64fact 
NUM_PRES_MODELDRVNfloat64fact 
NUM_PRES_RANDOMfloat64fact 
UARI_COP_IPRHCAMPAIGNIDdecimalfact 
OFFERIDdecimalfact 
IPIDfloat64fact 
IPNAMEcharacterLength16attribute 
NUM_TIMES_ACCPfloat64fact 
NUM_TIME_REJfloat64fact 
NUM_ACCP_MODELDRVNfloat64fact 
NUM_ACCP_RANDOMfloat64fact 
Run Time CommonUARI_ELIGSTATSEQNUMdecimalfact 
ICIDdecimalfact 
ICNAMEcharacterLength16attribute 
OFFERIDdecimalfact 
OFFERNAMEcharacterLength16attribute 
TIMEIDdecimalfact 
DATEIDdecimalfact 
CELLIDdecimalfact 
CELLNAMEcharacterLength16attribute 
CELLCODEcharacterLength16attribute 
IPIDdecimalfact 
IPNAMEcharacterLength16attribute 
ELIGIBLEOPPSdecimalfact 
UARI_DEFAULTEDSTATSEQNUMdecimalfact 
TIMEIDdecimalfact 
DATEIDdecimalfact 
SEGMENTIDdecimalfact 
SEGMENTNAMEcharacterLength16attribute 
IPIDdecimalfact 
IPNAMEcharacterLength16attribute 
ICIDdecimalfact 
OCCURRENCESdecimalfact 
Namespace/FolderQuery SubjectQuery ItemTypeUsageRef Obj/Expr.
Interactive Channel by OfferUARI_ICP_OESICIDdecimalfact 
ICNAMEcharacterLength16attribute 
IPIDdecimalfact 
IPNAMEcharacterLength16attribute 
OFFERIDdecimalfact 
ELIGIBLEOPPSfloat64fact 
UARI_ICP_OES_DYICIDdecimalfact 
ICNAMEcharacterLength16attribute 
IPIDdecimalfact 
IPNAMEcharacterLength16attribute 
OFFERIDdecimalfact 
ACTUALDATEdateTimeidentifier 
ELIGIBLEOPPSfloat64fact 
UARI_ICP_OES_HRICIDdecimalfact 
ICNAMEcharacterLength16attribute 
IPIDdecimalfact 
IPNAMEcharacterLength16attribute 
OFFERIDdecimalfact 
HOURint64fact 
ACTUALDATEdateTimeidentifier 
ELIGIBLEOPPSfloat64fact 
Interactive Channel by SegmentUARI_ICP_SEGDSICIDdecimalfact 
IPIDdecimalfact 
SEGMENTIDdecimalfact 
NUM_OF_OCCURRENCESfloat64fact 
Interactive Channel by Interaction PointUARI_ICP_IPDSICIDdecimalfact 
IPIDdecimalfact 
NUM_OF_OCCURRENCESfloat64fact 
Campaign Cell PerformanceUARI_CCP_ESCAMPAIGNIDint64fact 
CELLIDdecimalfact 
ELIGIBLEOPPSfloat64fact 
UARI_CCP_ES_DYCAMPAIGNIDint64fact 
CELLIDdecimalfact 
ACTUALDATEdateTimeidentifier 
ELIGIBLEOPPSfloat64fact 
UARI_CCP_ES_HRCAMPAIGNIDint64fact 
CELLIDdecimalfact 
HOURint64fact 
ACTUALDATEdateTimeidentifier 
ELIGIBLEOPPSfloat64fact 
UARI_CCP_IPESCAMPAIGNIDint64fact 
CELLIDdecimalfact 
IPIDdecimalfact 
IPNAMEcharacterLength16attribute 
ELIGIBLEOPPSfloat64fact 
UARI_CCP_OESCAMPAIGNIDint64fact 
CELLIDdecimalfact 
OFFERIDdecimalfact 
ELIGIBLEOPPSfloat64fact 
Campaign Offer PerformacneUARI_COP_ESCAMPAIGNIDfloat64fact 
OFFERIDdecimalfact 
ELIGIBLEOPPSfloat64fact 
UARI_COP_ES_DYCAMPAIGNIDfloat64fact 
OFFERIDdecimalfact 
ACTUALDATEdateTimeidentifier 
ELIGIBLEOPPSfloat64fact 
UARI_COP_ES_HRCAMPAIGNIDfloat64fact 
OFFERIDdecimalfact 
HOURint64fact 
ACTUALDATEdateTimeidentifier 
ELIGIBLEOPPSfloat64fact 
UARI_COP_CESCAMPAIGNIDint64fact 
OFFERIDdecimalfact 
CELLIDdecimalfact 
ELIGIBLEOPPSfloat64fact 
UARI_COP_IPESCAMPAIGNIDint64fact 
OFFERIDdecimalfact 
IPIDdecimalfact 
IPNAMEcharacterLength16attribute 
ELIGIBLEOPPSfloat64fact 
Event ActivityUARI_EV_ACTICIDdecimalidentifier 
ICNAMEcharacterLength16attribute 
CATEGORYIDdecimalidentifier 
CATEGORYNAMEcharacterLength16attribute 
EVENTIDdecimalidentifier 
EVENTNAMEcharacterLength16attribute 
NUM_OCCURRENCESfloat64fact 
UARI_EV_ACT_DYICIDdecimalidentifier 
ICNAMEcharacterLength16attribute 
CATEGORYIDdecimalidentifier 
CATEGORYNAMEcharacterLength16attribute 
EVENTIDdecimalidentifier 
EVENTNAMEcharacterLength16attribute 
NUM_OCCURRENCESfloat64fact 
ACTUALDATEdateTimeattribute 
UARI_EV_ACT_HRICIDdecimalidentifier 
ICNAMEcharacterLength16attribute 
CATEGORYIDdecimalidentifier 
CATEGORYNAMEcharacterLength16attribute 
EVENTIDdecimalidentifier 
EVENTNAMEcharacterLength16attribute 
NUM_OCCURRENCESfloat64fact 
ACTUALDATEdateTimeattribute 
HRint64attribute 
UARI_EV_ACT_IC_DYICIDdecimalfact 
NUM_OCCURRENCESfloat64fact 
ACTUALDATEdateTimeidentifier 
UARI_EV_ACT_IC_HRICIDdecimalfact 
NUM_OCCURRENCESfloat64fact 
ACTUALDATEdateTimeidentifier 
HRint64fact 
LearningUARI_LEARNINGOFFERIDdecimalfact 
ATTRIBUTENAMEcharacterLength16attribute 
ATTRIBUTEVALUEcharacterLength16attribute 
ACCEPTPERCENTAGEfloat64fact 
PREDICTABILITYint64fact 
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.