promotion.dim

来自「SQL SERVER 2005数据挖掘与商务智能完全解决方案随书光盘,作者：朱德」· DIM 代码 · 共 194 行

<Dimension xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:dwd="http://schemas.microsoft.com/DataWarehouse/Designer/1.0" dwd:design-time-name="f32d8f5a-84f4-4112-b504-76fbe027a61d" xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
  <ID>Promotion</ID>
  <Name>Promotion</Name>
  <CreatedTimestamp>0001-01-01T00:00:00Z</CreatedTimestamp>
  <LastSchemaUpdate>0001-01-01T00:00:00Z</LastSchemaUpdate>
  <Annotations>
    <Annotation>
      <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramLayout</Name>
    </Annotation>
    <Annotation>
      <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:ShowFriendlyNames</Name>
      <Value>true</Value>
    </Annotation>
    <Annotation>
      <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:ShowRelationshipNames</Name>
      <Value>false</Value>
    </Annotation>
    <Annotation>
      <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:UseDiagramDefaultLayout</Name>
      <Value>true</Value>
    </Annotation>
    <Annotation>
      <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramViewPortLeft</Name>
      <Value>0</Value>
    </Annotation>
    <Annotation>
      <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramViewPortTop</Name>
      <Value>0</Value>
    </Annotation>
    <Annotation>
      <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramBoundingLeft</Name>
      <Value>0</Value>
    </Annotation>
    <Annotation>
      <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramBoundingTop</Name>
      <Value>0</Value>
    </Annotation>
    <Annotation>
      <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramZoom</Name>
      <Value>100</Value>
    </Annotation>
  </Annotations>
  <LastProcessed>0001-01-01T00:00:00Z</LastProcessed>
  <State>Unprocessed</State>
  <Source xsi:type="DataSourceViewBinding" dwd:design-time-name="d2c395c7-b98f-4f08-8d81-988fdf788938">
    <DataSourceViewID>Foodmartsale DW</DataSourceViewID>
  </Source>
  <UnknownMember>Visible</UnknownMember>
  <CurrentStorageMode>Molap</CurrentStorageMode>
  <Attributes>
    <Attribute dwd:design-time-name="b0c655d5-7ba8-4876-9bcf-fa1a17b0e626">
      <ID>Promotion</ID>
      <Name>Promotion</Name>
      <Usage>Key</Usage>
      <EstimatedCount>1864</EstimatedCount>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="cfcd47db-a0e6-42dc-a698-1af3fbf881b6">
          <DataType>Integer</DataType>
          <NullProcessing>UnknownMember</NullProcessing>
          <Source xsi:type="ColumnBinding" dwd:design-time-name="0cc293e0-98ca-4a2f-b869-a6972240f0ee">
            <TableID>dbo_promotion</TableID>
            <ColumnID>promotion_id</ColumnID>
          </Source>
        </KeyColumn>
      </KeyColumns>
      <AttributeRelationships>
        <AttributeRelationship dwd:design-time-name="f50772a7-2684-466b-a6c2-d1ec2f7145e9">
          <AttributeID>Promotion District Id</AttributeID>
          <Name>Promotion District Id</Name>
        </AttributeRelationship>
        <AttributeRelationship dwd:design-time-name="63bd6047-27f3-4259-9ab7-d37904d2a256">
          <AttributeID>Promotion Name</AttributeID>
          <Name>Promotion Name</Name>
        </AttributeRelationship>
        <AttributeRelationship dwd:design-time-name="21ccb71c-ee84-431b-a5f8-d43f84879872">
          <AttributeID>Media Type</AttributeID>
          <Name>Media Type</Name>
        </AttributeRelationship>
        <AttributeRelationship dwd:design-time-name="ff729d7f-c866-4782-85be-9de16608bacf">
          <AttributeID>Cost</AttributeID>
          <Name>Cost</Name>
        </AttributeRelationship>
        <AttributeRelationship dwd:design-time-name="dc4525c3-7a41-46e1-a55e-daa9f38c0764">
          <AttributeID>Start Date</AttributeID>
          <Name>Start Date</Name>
        </AttributeRelationship>
        <AttributeRelationship dwd:design-time-name="734c2bbb-3e53-4978-b9a8-fb01415ce7dc">
          <AttributeID>End Date</AttributeID>
          <Name>End Date</Name>
        </AttributeRelationship>
      </AttributeRelationships>
      <OrderBy>Key</OrderBy>
      <InstanceSelection>FilteredList</InstanceSelection>
    </Attribute>
    <Attribute dwd:design-time-name="462b1359-c471-4033-9087-dea95ddc11ad">
      <ID>Promotion District Id</ID>
      <Name>Promotion District Id</Name>
      <EstimatedCount>25</EstimatedCount>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="845a83a2-8bf8-480e-b881-3244d407524f">
          <DataType>Integer</DataType>
          <Source xsi:type="ColumnBinding" dwd:design-time-name="4ac62d48-1510-4283-bc21-127792004b37">
            <TableID>dbo_promotion</TableID>
            <ColumnID>promotion_district_id</ColumnID>
          </Source>
        </KeyColumn>
      </KeyColumns>
      <OrderBy>Key</OrderBy>
      <InstanceSelection>DropDown</InstanceSelection>
    </Attribute>
    <Attribute dwd:design-time-name="8ddbbbdd-07b6-4536-bf2c-3592ed1a4f05">
      <ID>Promotion Name</ID>
      <Name>Promotion Name</Name>
      <EstimatedCount>51</EstimatedCount>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="f164eecb-339f-4e97-bf2d-45984edbe216">
          <DataType>WChar</DataType>
          <DataSize>255</DataSize>
          <Source xsi:type="ColumnBinding" dwd:design-time-name="9e819dca-1425-4b6a-9c70-af236e4fa10c">
            <TableID>dbo_promotion</TableID>
            <ColumnID>promotion_name</ColumnID>
          </Source>
        </KeyColumn>
      </KeyColumns>
      <OrderBy>Key</OrderBy>
      <InstanceSelection>DropDown</InstanceSelection>
    </Attribute>
    <Attribute dwd:design-time-name="02b440d8-436d-4e4a-93dd-9bf8a04f3276">
      <ID>Media Type</ID>
      <Name>Media Type</Name>
      <EstimatedCount>14</EstimatedCount>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="ab8af6ab-f618-469c-81d9-7cbd4efabaaf">
          <DataType>WChar</DataType>
          <DataSize>255</DataSize>
          <Source xsi:type="ColumnBinding" dwd:design-time-name="9ef8b661-cba7-42a4-94d4-6b2a668f40c4">
            <TableID>dbo_promotion</TableID>
            <ColumnID>media_type</ColumnID>
          </Source>
        </KeyColumn>
      </KeyColumns>
      <OrderBy>Key</OrderBy>
      <InstanceSelection>DropDown</InstanceSelection>
    </Attribute>
    <Attribute dwd:design-time-name="f94e804f-798b-42b8-a130-0899e84538ad">
      <ID>Cost</ID>
      <Name>Cost</Name>
      <EstimatedCount>1711</EstimatedCount>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="87c09517-fe7b-421e-bf41-4ef4fb96203d">
          <DataType>Double</DataType>
          <Source xsi:type="ColumnBinding" dwd:design-time-name="2e476956-a6cf-4024-99f5-63eff661d745">
            <TableID>dbo_promotion</TableID>
            <ColumnID>cost</ColumnID>
          </Source>
        </KeyColumn>
      </KeyColumns>
      <OrderBy>Key</OrderBy>
      <InstanceSelection>FilteredList</InstanceSelection>
    </Attribute>
    <Attribute dwd:design-time-name="29d76d3c-cf2f-4780-85db-c1b887a3ddb8">
      <ID>Start Date</ID>
      <Name>Start Date</Name>
      <EstimatedCount>313</EstimatedCount>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="a3c1851a-b74a-4038-b71f-faaa3b9d2e40">
          <DataType>Date</DataType>
          <Source xsi:type="ColumnBinding" dwd:design-time-name="8d20c493-14e7-4518-9be3-c413c528f1cf">
            <TableID>dbo_promotion</TableID>
            <ColumnID>start_date</ColumnID>
          </Source>
        </KeyColumn>
      </KeyColumns>
      <OrderBy>Key</OrderBy>
      <InstanceSelection>List</InstanceSelection>
    </Attribute>
    <Attribute dwd:design-time-name="e7f3bdd0-55f6-4aa2-bc1c-5ba62d78ffc4">
      <ID>End Date</ID>
      <Name>End Date</Name>
      <EstimatedCount>469</EstimatedCount>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="4c35984c-b1f6-4dfa-b01b-0abfdd80bf2a">
          <DataType>Date</DataType>
          <Source xsi:type="ColumnBinding" dwd:design-time-name="12abcf5a-b073-4d48-aea8-2ee0f2fe654f">
            <TableID>dbo_promotion</TableID>
            <ColumnID>end_date</ColumnID>
          </Source>
        </KeyColumn>
      </KeyColumns>
      <OrderBy>Key</OrderBy>
      <InstanceSelection>List</InstanceSelection>
    </Attribute>
  </Attributes>
</Dimension>