Marketing Segment Dimension
| Name | ID | Usage | * | ** | Key Columns | Name Column |
|---|---|---|---|---|---|---|
| Segment | MARKETINGSEGMENTDIMID | false |
BBDW_DIM_MARKETINGSEGMENT.SEGMENTNAME (WChar) |
|||
| Marketing Effort Code | SEGMENTATIONCODE | false |
BBDW_DIM_MARKETINGSEGMENT.SEGMENTATIONCODE (WChar) |
|||
| Marketing Effort Description | SEGMENTATIONDESCRIPTION | false |
BBDW_DIM_MARKETINGSEGMENT.SEGMENTATIONDESCRIPTION (WChar) |
|||
| Marketing Effort Is Active | SEGMENTATIONACTIVE |
BBDW_DIM_MARKETINGSEGMENT.SEGMENTATIONACTIVE (Boolean) |
||||
| Marketing Effort Budget Amount | SEGMENTATIONBUDGETAMOUNT | false |
BBDW_DIM_MARKETINGSEGMENT.SEGMENTATIONBUDGETAMOUNT (Double) |
|||
| Marketing Effort Type | SEGMENTATIONTYPE |
BBDW_DIM_MARKETINGSEGMENT.SEGMENTATIONTYPE (WChar) |
||||
| Marketing Effort Date | SEGMENTATIONDATE | false |
BBDW_DIM_MARKETINGSEGMENT.SEGMENTATIONDATE (Date) |
|||
| Marketing Effort Householding Type | HOUSEHOLDINGTYPE |
BBDW_DIM_MARKETINGSEGMENT.HOUSEHOLDINGTYPE (WChar) |
||||
| Segment Description | SEGMENTDESCRIPTION | false |
BBDW_DIM_MARKETINGSEGMENT.SEGMENTDESCRIPTION (WChar) |
|||
| Segment Code | SEGMENTCODE | false |
BBDW_DIM_MARKETINGSEGMENT.SEGMENTCODE (WChar) |
|||
| Segment Type | SEGMENTTYPE |
BBDW_DIM_MARKETINGSEGMENT.SEGMENTTYPE (WChar) |
||||
| Marketing Segment Usage | SEGMENTUSAGE | false |
BBDW_DIM_MARKETINGSEGMENT.SEGMENTUSAGE (WChar) |
|||
| Marketing Segment | TESTSEGMENTNAME | Key | false |
BBDW_DIM_MARKETINGSEGMENT.MARKETINGSEGMENTDIMID (Integer) |
BBDW_DIM_MARKETINGSEGMENT.SEGMENTATIONSEGMENTNAME (WChar) |
|
| Package Code | PACKAGECODE | false |
BBDW_DIM_MARKETINGSEGMENT.PACKAGECODE (WChar) |
|||
| Package | PACKAGENAME | false |
BBDW_DIM_MARKETINGSEGMENT.PACKAGENAME (WChar) |
|||
| Package Description | PACKAGEDESCRIPTION | false |
BBDW_DIM_MARKETINGSEGMENT.PACKAGEDESCRIPTION (WChar) |
|||
| Package Unit Cost | PACKAGEUNITCOST | false | false |
BBDW_DIM_MARKETINGSEGMENT.PACKAGEUNITCOST (Double) |
||
| Package Channel | PACKAGECHANNEL |
BBDW_DIM_MARKETINGSEGMENT.PACKAGECHANNEL (WChar) |
||||
| Marketing Segment Is Test | ISTESTSEGMENT |
BBDW_DIM_MARKETINGSEGMENT.ISTESTSEGMENT (Boolean) |
||||
| Marketing Effort | SEGMENTATIONNAME | false |
BBDW_DIM_MARKETINGSEGMENT.SEGMENTATIONNAME (WChar) |
|||
| Marketing Segment Description | SEGMENTATIONSEGMENTDESCRIPTION | false |
BBDW_DIM_MARKETINGSEGMENT.SEGMENTATIONSEGMENTDESCRIPTION (WChar) |
|||
| Marketing Segment Code | SEGMENTATIONSEGMENTCODE | false |
BBDW_DIM_MARKETINGSEGMENT.SEGMENTATIONSEGMENTCODE (WChar) |
|||
| Marketing Package Code | SEGMENTATIONPACKAGECODE | false |
BBDW_DIM_MARKETINGSEGMENT.SEGMENTATIONPACKAGECODE (WChar) |
|||
| Marketing Package Unit Cost | SEGMENTATIONPACKAGEUNITCOST | false |
BBDW_DIM_MARKETINGSEGMENT.SEGMENTATIONPACKAGEUNITCOST (Double) |
|||
| Marketing Package Letter Code | LETTERCODE | false |
BBDW_DIM_MARKETINGSEGMENT.LETTERCODE (WChar) |
|||
| Marketing Package Description | LETTERCODEDESCRIPTION | false |
BBDW_DIM_MARKETINGSEGMENT.LETTERCODEDESCRIPTION (WChar) |
|||
| Marketing Package Letter Includes Receipt | LETTERINCLUDESRECEIPT | false |
BBDW_DIM_MARKETINGSEGMENT.LETTERINCLUDESRECEIPT (Boolean) |
|||
| Package Category | PACAKGECATEGORY |
BBDW_DIM_MARKETINGSEGMENT.PACKAGECATEGORY (WChar) |
||||
| Segment Category | SEGMENTCATEGORY |
BBDW_DIM_MARKETINGSEGMENT.SEGMENTCATEGORY (WChar) |
||||
| Marketing Segment Quantity | SEGMENTATIONSEGMENTQUANTITY | false |
BBDW_DIM_MARKETINGSEGMENT.SEGMENTATIONSEGMENTQUANTITY (Integer) |
|||
| Marketing Effort Communication Type | SEGMENTATIONCOMMUNICATIONTYPE |
BBDW_DIM_MARKETINGSEGMENT.SEGMENTATIONCOMMUNICATIONTYPE (WChar) |
*AttributeHierarchyVisible
**AttributeHierarchyEnabled
| Name | ID | Levels |
|---|---|---|
| Marketing Effort-Segment-Marketing Segment-Package | Hierarchy |
Marketing Effort, Marketing Effort, SEGMENTATIONNAME Segment, Segment, MARKETINGSEGMENTDIMID Marketing Segment, Marketing Segment, TESTSEGMENTNAME Package, Package, PACKAGENAME |
| Package-Segment-Marketing Segment-Marketing Effort | Hierarchy 2 1 |
Package, Package, PACKAGENAME Segment, Segment, MARKETINGSEGMENTDIMID Marketing Segment, Marketing Segment, TESTSEGMENTNAME Marketing Effort, Marketing Effort, SEGMENTATIONNAME |
| Segment-Marketing Segment-Package-Marketing Effort | Hierarchy 3 |
Segment, Segment, MARKETINGSEGMENTDIMID Marketing Segment, Marketing Segment, TESTSEGMENTNAME Package, Package, PACKAGENAME Marketing Effort, Marketing Effort, SEGMENTATIONNAME |