customer.dim

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

      <ID>State Province</ID>
      <Name>State Province</Name>
      <EstimatedCount>13</EstimatedCount>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="d7f4fbb6-3845-40d6-9da4-72e30fe564aa">
          <DataType>WChar</DataType>
          <DataSize>50</DataSize>
          <Source xsi:type="ColumnBinding" dwd:design-time-name="a98e9494-ef2a-49cb-a6b4-e811394d115c">
            <TableID>dbo_customer</TableID>
            <ColumnID>state_province</ColumnID>
          </Source>
        </KeyColumn>
      </KeyColumns>
      <OrderBy>Key</OrderBy>
      <InstanceSelection>DropDown</InstanceSelection>
    </Attribute>
    <Attribute dwd:design-time-name="649a9282-f648-4d8a-91e2-88b6baa0cdfa">
      <ID>Postal Code</ID>
      <Name>Postal Code</Name>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="9222c2c8-022d-4663-820e-07b759a5a39f">
          <DataType>WChar</DataType>
          <DataSize>50</DataSize>
          <Source xsi:type="ColumnBinding" dwd:design-time-name="bcce4f55-d174-4067-b1e6-1d6975b2eb84">
            <TableID>dbo_customer</TableID>
            <ColumnID>postal_code</ColumnID>
          </Source>
        </KeyColumn>
      </KeyColumns>
      <OrderBy>Key</OrderBy>
      <InstanceSelection>MandatoryFilter</InstanceSelection>
    </Attribute>
    <Attribute dwd:design-time-name="c4942172-81ae-4f73-a6a6-b026f7ff0ef7">
      <ID>Country</ID>
      <Name>Country</Name>
      <EstimatedCount>3</EstimatedCount>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="a9438949-4191-45ab-ac84-6ef974212af7">
          <DataType>WChar</DataType>
          <DataSize>50</DataSize>
          <Source xsi:type="ColumnBinding" dwd:design-time-name="b8d77159-de7e-40df-ac6b-d742bb700da9">
            <TableID>dbo_customer</TableID>
            <ColumnID>country</ColumnID>
          </Source>
        </KeyColumn>
      </KeyColumns>
      <OrderBy>Key</OrderBy>
      <InstanceSelection>DropDown</InstanceSelection>
    </Attribute>
    <Attribute dwd:design-time-name="09e085f4-d404-4ba7-b085-8505c21542c4">
      <ID>Customer Region Id</ID>
      <Name>Customer Region Id</Name>
      <EstimatedCount>109</EstimatedCount>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="6ac0974e-b0f0-4346-bffa-2ef27f0f0c5b">
          <DataType>Integer</DataType>
          <Source xsi:type="ColumnBinding" dwd:design-time-name="9fab319f-f772-4b87-b83c-31116ada005e">
            <TableID>dbo_customer</TableID>
            <ColumnID>customer_region_id</ColumnID>
          </Source>
        </KeyColumn>
      </KeyColumns>
      <OrderBy>Key</OrderBy>
      <InstanceSelection>List</InstanceSelection>
    </Attribute>
    <Attribute dwd:design-time-name="37e6fa0c-8f64-4733-8645-bce14eb3a43b">
      <ID>Phone1</ID>
      <Name>Phone1</Name>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="8b7c0f5a-4c9b-4c04-93d8-ce44be3f3911">
          <DataType>WChar</DataType>
          <DataSize>50</DataSize>
          <Source xsi:type="ColumnBinding" dwd:design-time-name="fe9b1dfc-aa55-42fe-af3e-eedf74f4c0d3">
            <TableID>dbo_customer</TableID>
            <ColumnID>phone1</ColumnID>
          </Source>
        </KeyColumn>
      </KeyColumns>
      <OrderBy>Key</OrderBy>
      <InstanceSelection>MandatoryFilter</InstanceSelection>
    </Attribute>
    <Attribute dwd:design-time-name="5ed00909-e22b-4b6e-b1cb-3e0cbb14c031">
      <ID>Phone2</ID>
      <Name>Phone2</Name>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="eee6049b-78d1-4c64-a0cf-6e27462e6d72">
          <DataType>WChar</DataType>
          <DataSize>50</DataSize>
          <Source xsi:type="ColumnBinding" dwd:design-time-name="8fe22f06-1c8d-4749-ba55-4ea8e1c45217">
            <TableID>dbo_customer</TableID>
            <ColumnID>phone2</ColumnID>
          </Source>
        </KeyColumn>
      </KeyColumns>
      <OrderBy>Key</OrderBy>
      <InstanceSelection>MandatoryFilter</InstanceSelection>
    </Attribute>
    <Attribute dwd:design-time-name="454758f1-6397-4f04-ba91-84169916fde6">
      <ID>Birthdate</ID>
      <Name>Birthdate</Name>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="c29a6074-3864-4c11-866f-9ed81be4d03c">
          <DataType>Date</DataType>
          <Source xsi:type="ColumnBinding" dwd:design-time-name="63984e75-72d2-4a54-83da-5809690de0a5">
            <TableID>dbo_customer</TableID>
            <ColumnID>birthdate</ColumnID>
          </Source>
        </KeyColumn>
      </KeyColumns>
      <OrderBy>Key</OrderBy>
      <InstanceSelection>MandatoryFilter</InstanceSelection>
    </Attribute>
    <Attribute dwd:design-time-name="d3675edc-97dc-45a2-a2dc-d6ee2e0d8f50">
      <ID>Marital Status</ID>
      <Name>Marital Status</Name>
      <EstimatedCount>2</EstimatedCount>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="6a3ff9f2-85cc-40db-ac2f-58c5d4616df8">
          <DataType>WChar</DataType>
          <DataSize>1</DataSize>
          <Source xsi:type="ColumnBinding" dwd:design-time-name="35de3996-53e9-472e-8b35-aae6b49b843b">
            <TableID>dbo_customer</TableID>
            <ColumnID>marital_status</ColumnID>
          </Source>
        </KeyColumn>
      </KeyColumns>
      <OrderBy>Key</OrderBy>
      <InstanceSelection>DropDown</InstanceSelection>
    </Attribute>
    <Attribute dwd:design-time-name="f5f20708-1579-400c-9a28-5e00fee1c646">
      <ID>Yearly Income</ID>
      <Name>Yearly Income</Name>
      <EstimatedCount>8</EstimatedCount>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="43658c40-21cf-4111-8291-20f3cc4e9165">
          <DataType>WChar</DataType>
          <DataSize>50</DataSize>
          <Source xsi:type="ColumnBinding" dwd:design-time-name="c4ada35e-d61b-413e-b0f5-a6ef0c5cdb94">
            <TableID>dbo_customer</TableID>
            <ColumnID>yearly_income</ColumnID>
          </Source>
        </KeyColumn>
      </KeyColumns>
      <OrderBy>Key</OrderBy>
      <InstanceSelection>DropDown</InstanceSelection>
    </Attribute>
    <Attribute dwd:design-time-name="72a9dcb1-4075-4034-9746-4cce090c268b">
      <ID>Gender</ID>
      <Name>Gender</Name>
      <EstimatedCount>2</EstimatedCount>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="c2dcc6a1-3343-47b7-ad32-e948dbecc641">
          <DataType>WChar</DataType>
          <DataSize>1</DataSize>
          <Source xsi:type="ColumnBinding" dwd:design-time-name="0dfb2e23-730a-4641-82d7-0382bdcbefa2">
            <TableID>dbo_customer</TableID>
            <ColumnID>gender</ColumnID>
          </Source>
        </KeyColumn>
      </KeyColumns>
      <OrderBy>Key</OrderBy>
      <InstanceSelection>DropDown</InstanceSelection>
    </Attribute>
    <Attribute dwd:design-time-name="f6b20c03-06a6-48d4-a9e6-31901f347fb1">
      <ID>Total Children</ID>
      <Name>Total Children</Name>
      <EstimatedCount>6</EstimatedCount>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="5ef3df89-92fc-410c-bdf3-10ca0a0ba9e5">
          <DataType>SmallInt</DataType>
          <Source xsi:type="ColumnBinding" dwd:design-time-name="b6cae17c-3219-4000-9230-1a6fef988c84">
            <TableID>dbo_customer</TableID>
            <ColumnID>total_children</ColumnID>
          </Source>
        </KeyColumn>
      </KeyColumns>
      <OrderBy>Key</OrderBy>
      <InstanceSelection>DropDown</InstanceSelection>
    </Attribute>
    <Attribute dwd:design-time-name="996bc83a-2b61-4fa4-80b5-3f852ad7d766">
      <ID>Num Children At Home</ID>
      <Name>Num Children At Home</Name>
      <EstimatedCount>6</EstimatedCount>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="830771e2-a25d-4995-8ce7-841108ac90e5">
          <DataType>SmallInt</DataType>
          <Source xsi:type="ColumnBinding" dwd:design-time-name="e576d8b1-6786-4020-8c37-b9e953c438a7">
            <TableID>dbo_customer</TableID>
            <ColumnID>num_children_at_home</ColumnID>
          </Source>
        </KeyColumn>
      </KeyColumns>
      <OrderBy>Key</OrderBy>
      <InstanceSelection>DropDown</InstanceSelection>
    </Attribute>
    <Attribute dwd:design-time-name="40a409af-2286-4ea4-8e2e-a1c1d69cd17b">
      <ID>Education</ID>
      <Name>Education</Name>
      <EstimatedCount>5</EstimatedCount>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="e94154df-cc26-45c7-941c-2437c0abf5ea">
          <DataType>WChar</DataType>
          <DataSize>30</DataSize>
          <Source xsi:type="ColumnBinding" dwd:design-time-name="626d18f7-871e-4fe3-82f1-6c939ee58587">
            <TableID>dbo_customer</TableID>
            <ColumnID>education</ColumnID>
          </Source>
        </KeyColumn>
      </KeyColumns>
      <OrderBy>Key</OrderBy>
      <InstanceSelection>DropDown</InstanceSelection>
    </Attribute>
    <Attribute dwd:design-time-name="0d19d1fd-42c0-43ce-955f-6e08040dc70f">
      <ID>Date Accnt Opened</ID>
      <Name>Date Accnt Opened</Name>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="de841bad-09bd-4e74-991a-dad25bf6b3a6">
          <DataType>Date</DataType>
          <Source xsi:type="ColumnBinding" dwd:design-time-name="40cb0339-3bf8-41bf-9e18-4cada297f9b5">
            <TableID>dbo_customer</TableID>
            <ColumnID>date_accnt_opened</ColumnID>
          </Source>
        </KeyColumn>
      </KeyColumns>
      <OrderBy>Key</OrderBy>
      <InstanceSelection>MandatoryFilter</InstanceSelection>
    </Attribute>
    <Attribute dwd:design-time-name="1182c4dc-307f-40eb-85c3-6f44a695e102">
      <ID>Member Card</ID>
      <Name>Member Card</Name>
      <EstimatedCount>4</EstimatedCount>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="ee24f42d-8bd5-492f-afbc-6733a8f1302d">
          <DataType>WChar</DataType>
          <DataSize>50</DataSize>
          <Source xsi:type="ColumnBinding" dwd:design-time-name="0aead9ef-815c-46e8-b218-5aaf3255c7d9">
            <TableID>dbo_customer</TableID>
            <ColumnID>member_card</ColumnID>
          </Source>
        </KeyColumn>
      </KeyColumns>
      <OrderBy>Key</OrderBy>
      <InstanceSelection>DropDown</InstanceSelection>
    </Attribute>
    <Attribute dwd:design-time-name="731a43bb-0194-4c09-8a23-be03d9238735">
      <ID>Occupation</ID>
      <Name>Occupation</Name>
      <EstimatedCount>5</EstimatedCount>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="6513e35d-7114-4b2a-8086-1fa8619f9837">
          <DataType>WChar</DataType>
          <DataSize>50</DataSize>
          <Source xsi:type="ColumnBinding" dwd:design-time-name="46386b18-7d8a-4078-a75d-28999f67e16c">
            <TableID>dbo_customer</TableID>
            <ColumnID>occupation</ColumnID>
          </Source>
        </KeyColumn>
      </KeyColumns>
      <OrderBy>Key</OrderBy>
      <InstanceSelection>DropDown</InstanceSelection>
    </Attribute>
    <Attribute dwd:design-time-name="bb6d7cd1-e7b1-4c37-a33a-3c0fae50962a">
      <ID>Houseowner</ID>
      <Name>Houseowner</Name>
      <EstimatedCount>2</EstimatedCount>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="90e4e6e3-6f41-4069-bacc-6f953f289c14">
          <DataType>WChar</DataType>
          <DataSize>1</DataSize>
          <Source xsi:type="ColumnBinding" dwd:design-time-name="8501bc20-69b9-42c2-a4cd-9d53363803c4">
            <TableID>dbo_customer</TableID>
            <ColumnID>houseowner</ColumnID>
          </Source>
        </KeyColumn>
      </KeyColumns>
      <OrderBy>Key</OrderBy>
      <InstanceSelection>DropDown</InstanceSelection>
    </Attribute>
    <Attribute dwd:design-time-name="0a4acdca-0907-472a-9c01-73fcc714cfb4">
      <ID>Num Cars Owned</ID>
      <Name>Num Cars Owned</Name>
      <EstimatedCount>5</EstimatedCount>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="f6073f5f-ea3f-4146-ae74-68f63c508aca">
          <DataType>SmallInt</DataType>
          <Source xsi:type="ColumnBinding" dwd:design-time-name="ba345803-0cd9-4019-9e05-92ab401cae27">
            <TableID>dbo_customer</TableID>
            <ColumnID>num_cars_owned</ColumnID>
          </Source>
        </KeyColumn>
      </KeyColumns>
      <OrderBy>Key</OrderBy>
      <InstanceSelection>DropDown</InstanceSelection>
    </Attribute>
  </Attributes>
  <Hierarchies>
    <Hierarchy dwd:design-time-name="024960c9-d1cf-4ec0-8814-7617d6bbe73c">
      <ID>Country - State Province - Customer Region Id</ID>
      <Name>Country - State Province - Customer Region Id</Name>
      <Levels>
        <Level dwd:design-time-name="a73dd281-b263-4c26-9389-8e1d9a552d28">
          <ID>Country</ID>
          <Name>Country</Name>
          <SourceAttributeID>Country</SourceAttributeID>
        </Level>
        <Level dwd:design-time-name="5e6bed5a-46eb-486b-9bda-4f1cb2888c54">
          <ID>State Province</ID>
          <Name>State Province</Name>
          <SourceAttributeID>State Province</SourceAttributeID>
        </Level>
        <Level dwd:design-time-name="4c1bc773-a28f-4a9a-8f01-9d2fb56689f0">
          <ID>Customer Region Id</ID>
          <Name>Customer Region Id</Name>
          <SourceAttributeID>Customer Region Id</SourceAttributeID>
        </Level>
        <Level dwd:design-time-name="59aac0dd-f1db-4e4d-bf18-00172a06362a">
          <ID>Customer</ID>
          <Name>Customer</Name>
          <SourceAttributeID>Customer</SourceAttributeID>
        </Level>
      </Levels>
    </Hierarchy>
  </Hierarchies>
</Dimension>