customer.dim

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

<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="eadfaec6-f756-4ac3-ab58-dbafd92e433a" xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
  <ID>Customer</ID>
  <Name>Customer</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="0ffab8d2-2bfb-4d7f-be34-6a319bd428d0">
    <DataSourceViewID>Foodmartsale DW</DataSourceViewID>
  </Source>
  <UnknownMember>Visible</UnknownMember>
  <CurrentStorageMode>Molap</CurrentStorageMode>
  <Attributes>
    <Attribute dwd:design-time-name="cd385811-390a-4437-b38a-476173fde877">
      <ID>Customer</ID>
      <Name>Customer</Name>
      <Usage>Key</Usage>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="c9dc1973-478a-41e6-986c-25eb6af2f53a">
          <DataType>Integer</DataType>
          <NullProcessing>UnknownMember</NullProcessing>
          <Source xsi:type="ColumnBinding" dwd:design-time-name="abaafa1f-81ed-4a18-ade3-f163f8df5c2b">
            <TableID>dbo_customer</TableID>
            <ColumnID>customer_id</ColumnID>
          </Source>
        </KeyColumn>
      </KeyColumns>
      <AttributeRelationships>
        <AttributeRelationship dwd:design-time-name="58ddc060-4f51-4f19-89c7-aacbff3b108f">
          <AttributeID>Account Num</AttributeID>
          <Name>Account Num</Name>
        </AttributeRelationship>
        <AttributeRelationship dwd:design-time-name="b1301788-504c-494e-b32c-fecd4708db66">
          <AttributeID>Lname</AttributeID>
          <Name>Lname</Name>
        </AttributeRelationship>
        <AttributeRelationship dwd:design-time-name="2f175ac5-b55a-4868-a3dd-07dc2fdf92f8">
          <AttributeID>Fname</AttributeID>
          <Name>Fname</Name>
        </AttributeRelationship>
        <AttributeRelationship dwd:design-time-name="4b770fab-a89a-4e1e-ae2c-7eb51765eca1">
          <AttributeID>Mi</AttributeID>
          <Name>Mi</Name>
        </AttributeRelationship>
        <AttributeRelationship dwd:design-time-name="0cb73b47-9ad5-49d3-9ea7-4c784aaf50a8">
          <AttributeID>Address1</AttributeID>
          <Name>Address1</Name>
        </AttributeRelationship>
        <AttributeRelationship dwd:design-time-name="d0a7d0b4-d79c-4a63-b469-d54141ca79d3">
          <AttributeID>Address2</AttributeID>
          <Name>Address2</Name>
        </AttributeRelationship>
        <AttributeRelationship dwd:design-time-name="8d43cdf6-174a-41c6-b286-5979317a2b35">
          <AttributeID>Address3</AttributeID>
          <Name>Address3</Name>
        </AttributeRelationship>
        <AttributeRelationship dwd:design-time-name="14361a5a-f2dc-4171-bb22-f978258d483d">
          <AttributeID>Address4</AttributeID>
          <Name>Address4</Name>
        </AttributeRelationship>
        <AttributeRelationship dwd:design-time-name="92c90f42-3e7f-477e-ab83-c71ae1f90606">
          <AttributeID>City</AttributeID>
          <Name>City</Name>
        </AttributeRelationship>
        <AttributeRelationship dwd:design-time-name="8288f02b-f4bf-442d-9a37-e412eafe1935">
          <AttributeID>State Province</AttributeID>
          <Name>State Province</Name>
        </AttributeRelationship>
        <AttributeRelationship dwd:design-time-name="3327f041-b120-4570-95ef-ef5aba92a697">
          <AttributeID>Postal Code</AttributeID>
          <Name>Postal Code</Name>
        </AttributeRelationship>
        <AttributeRelationship dwd:design-time-name="4a0cc968-c385-4253-8522-c62ce5d02af9">
          <AttributeID>Country</AttributeID>
          <Name>Country</Name>
        </AttributeRelationship>
        <AttributeRelationship dwd:design-time-name="0cbef0a3-9d35-4997-815f-772a94c47d82">
          <AttributeID>Customer Region Id</AttributeID>
          <Name>Customer Region Id</Name>
        </AttributeRelationship>
        <AttributeRelationship dwd:design-time-name="0627c20c-d684-4869-9fdc-6a663414d72e">
          <AttributeID>Phone1</AttributeID>
          <Name>Phone1</Name>
        </AttributeRelationship>
        <AttributeRelationship dwd:design-time-name="0e4e6b44-05d1-436f-8132-584ef15cd49f">
          <AttributeID>Phone2</AttributeID>
          <Name>Phone2</Name>
        </AttributeRelationship>
        <AttributeRelationship dwd:design-time-name="2052711b-efca-4c98-98d9-76504fc5d4ae">
          <AttributeID>Birthdate</AttributeID>
          <Name>Birthdate</Name>
        </AttributeRelationship>
        <AttributeRelationship dwd:design-time-name="7f693a35-8d26-4e45-8ec7-e403fdbe1371">
          <AttributeID>Marital Status</AttributeID>
          <Name>Marital Status</Name>
        </AttributeRelationship>
        <AttributeRelationship dwd:design-time-name="5707afb8-2c69-4016-b658-3a068aa68dfd">
          <AttributeID>Yearly Income</AttributeID>
          <Name>Yearly Income</Name>
        </AttributeRelationship>
        <AttributeRelationship dwd:design-time-name="14b1f368-30d9-4b88-ab44-62dc7ba4a4a1">
          <AttributeID>Gender</AttributeID>
          <Name>Gender</Name>
        </AttributeRelationship>
        <AttributeRelationship dwd:design-time-name="ced4ea43-abb9-4c4c-9c11-bae9944327b5">
          <AttributeID>Total Children</AttributeID>
          <Name>Total Children</Name>
        </AttributeRelationship>
        <AttributeRelationship dwd:design-time-name="842775a3-7f02-40db-ab9a-421b3a8b5658">
          <AttributeID>Num Children At Home</AttributeID>
          <Name>Num Children At Home</Name>
        </AttributeRelationship>
        <AttributeRelationship dwd:design-time-name="926c812d-232d-426d-bda5-919d16e32ccc">
          <AttributeID>Education</AttributeID>
          <Name>Education</Name>
        </AttributeRelationship>
        <AttributeRelationship dwd:design-time-name="e01be687-ea18-4474-881e-6cdde8ed9f3c">
          <AttributeID>Date Accnt Opened</AttributeID>
          <Name>Date Accnt Opened</Name>
        </AttributeRelationship>
        <AttributeRelationship dwd:design-time-name="a42c7b48-ff07-4796-b752-ce0ad8aaf9ca">
          <AttributeID>Member Card</AttributeID>
          <Name>Member Card</Name>
        </AttributeRelationship>
        <AttributeRelationship dwd:design-time-name="3bf5078c-b2f5-4542-89f6-7b6284132f05">
          <AttributeID>Occupation</AttributeID>
          <Name>Occupation</Name>
        </AttributeRelationship>
        <AttributeRelationship dwd:design-time-name="0141f3b5-591f-4425-9243-205610c52fa5">
          <AttributeID>Houseowner</AttributeID>
          <Name>Houseowner</Name>
        </AttributeRelationship>
        <AttributeRelationship dwd:design-time-name="657653f4-a75e-4b54-9f3d-9a60cf0a23af">
          <AttributeID>Num Cars Owned</AttributeID>
          <Name>Num Cars Owned</Name>
        </AttributeRelationship>
      </AttributeRelationships>
      <OrderBy>Key</OrderBy>
      <InstanceSelection>MandatoryFilter</InstanceSelection>
    </Attribute>
    <Attribute dwd:design-time-name="dc277850-bf81-400e-8fbd-39a1b469b074">
      <ID>Account Num</ID>
      <Name>Account Num</Name>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="d88d6531-4811-4928-986c-57ac6260b4ef">
          <DataType>Double</DataType>
          <Source xsi:type="ColumnBinding" dwd:design-time-name="b08f537a-60fc-4787-8354-59c71befd768">
            <TableID>dbo_customer</TableID>
            <ColumnID>account_num</ColumnID>
          </Source>
        </KeyColumn>
      </KeyColumns>
      <OrderBy>Key</OrderBy>
      <InstanceSelection>MandatoryFilter</InstanceSelection>
    </Attribute>
    <Attribute dwd:design-time-name="a686f823-91f2-4340-a27d-068aa0664800">
      <ID>Lname</ID>
      <Name>Lname</Name>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="4f1f1a43-261b-448a-824e-b7e54d3d6c96">
          <DataType>WChar</DataType>
          <DataSize>100</DataSize>
          <Source xsi:type="ColumnBinding" dwd:design-time-name="aa39323b-3386-461c-82c8-6de2404c8aa9">
            <TableID>dbo_customer</TableID>
            <ColumnID>lname</ColumnID>
          </Source>
        </KeyColumn>
      </KeyColumns>
      <OrderBy>Key</OrderBy>
      <InstanceSelection>MandatoryFilter</InstanceSelection>
    </Attribute>
    <Attribute dwd:design-time-name="a4ab55d2-694f-4f15-b470-14c1a0681934">
      <ID>Fname</ID>
      <Name>Fname</Name>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="cf4d25ca-7b15-4b62-a2f2-21266b62e842">
          <DataType>WChar</DataType>
          <DataSize>50</DataSize>
          <Source xsi:type="ColumnBinding" dwd:design-time-name="352736cb-e925-4b74-972b-ca390d42f2c9">
            <TableID>dbo_customer</TableID>
            <ColumnID>fname</ColumnID>
          </Source>
        </KeyColumn>
      </KeyColumns>
      <OrderBy>Key</OrderBy>
      <InstanceSelection>MandatoryFilter</InstanceSelection>
    </Attribute>
    <Attribute dwd:design-time-name="c0906669-1082-4d65-9011-9744a44171d2">
      <ID>Mi</ID>
      <Name>Mi</Name>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="14c01aad-8240-4af7-89d2-3ec697f72951">
          <DataType>WChar</DataType>
          <DataSize>20</DataSize>
          <Source xsi:type="ColumnBinding" dwd:design-time-name="ca2f5365-3de6-4870-a179-3e5609a9ae95">
            <TableID>dbo_customer</TableID>
            <ColumnID>mi</ColumnID>
          </Source>
        </KeyColumn>
      </KeyColumns>
      <OrderBy>Key</OrderBy>
      <InstanceSelection>FilteredList</InstanceSelection>
    </Attribute>
    <Attribute dwd:design-time-name="4893cca3-1bec-45e4-8f52-d367bba1b9bc">
      <ID>Address1</ID>
      <Name>Address1</Name>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="458c0f59-dd23-405c-abd1-0c870205b756">
          <DataType>WChar</DataType>
          <DataSize>100</DataSize>
          <Source xsi:type="ColumnBinding" dwd:design-time-name="a9a1fcba-c994-495d-b51e-799d207d6321">
            <TableID>dbo_customer</TableID>
            <ColumnID>address1</ColumnID>
          </Source>
        </KeyColumn>
      </KeyColumns>
      <OrderBy>Key</OrderBy>
      <InstanceSelection>MandatoryFilter</InstanceSelection>
    </Attribute>
    <Attribute dwd:design-time-name="92a75482-6f75-4120-94d1-71e23016a5cc">
      <ID>Address2</ID>
      <Name>Address2</Name>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="5c4e9eee-ca05-45ff-b948-b88bad735127">
          <DataType>WChar</DataType>
          <DataSize>100</DataSize>
          <Source xsi:type="ColumnBinding" dwd:design-time-name="3b5c6e4a-8e14-4f0a-a1d8-6809e5804c33">
            <TableID>dbo_customer</TableID>
            <ColumnID>address2</ColumnID>
          </Source>
        </KeyColumn>
      </KeyColumns>
      <OrderBy>Key</OrderBy>
      <InstanceSelection>MandatoryFilter</InstanceSelection>
    </Attribute>
    <Attribute dwd:design-time-name="3efe6ba7-37a9-41dc-a35c-96c3b54fcf59">
      <ID>Address3</ID>
      <Name>Address3</Name>
      <EstimatedCount>1</EstimatedCount>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="d541a032-16ed-4e50-acdf-20c29f9fa6aa">
          <DataType>WChar</DataType>
          <DataSize>100</DataSize>
          <Source xsi:type="ColumnBinding" dwd:design-time-name="fa70ea85-b284-4de1-b4c9-00ce3ce9b021">
            <TableID>dbo_customer</TableID>
            <ColumnID>address3</ColumnID>
          </Source>
        </KeyColumn>
      </KeyColumns>
      <OrderBy>Key</OrderBy>
      <InstanceSelection>DropDown</InstanceSelection>
    </Attribute>
    <Attribute dwd:design-time-name="4d20ff98-c99a-498f-926b-72516c2f0332">
      <ID>Address4</ID>
      <Name>Address4</Name>
      <EstimatedCount>1</EstimatedCount>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="4672943c-76f2-42ef-aaca-4fd4dc7cf6e9">
          <DataType>WChar</DataType>
          <DataSize>100</DataSize>
          <Source xsi:type="ColumnBinding" dwd:design-time-name="06049ab8-3a13-414c-99f5-09e315aa2a2f">
            <TableID>dbo_customer</TableID>
            <ColumnID>address4</ColumnID>
          </Source>
        </KeyColumn>
      </KeyColumns>
      <OrderBy>Key</OrderBy>
      <InstanceSelection>DropDown</InstanceSelection>
    </Attribute>
    <Attribute dwd:design-time-name="fada6841-0151-41be-8a1b-337d895c9a99">
      <ID>City</ID>
      <Name>City</Name>
      <EstimatedCount>108</EstimatedCount>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="8eea30cf-58ae-489c-bbad-625e9acef7d5">
          <DataType>WChar</DataType>
          <DataSize>50</DataSize>
          <Source xsi:type="ColumnBinding" dwd:design-time-name="aaecd90d-44b7-4112-b403-bdc7056f7ac7">
            <TableID>dbo_customer</TableID>
            <ColumnID>city</ColumnID>
          </Source>
        </KeyColumn>
      </KeyColumns>
      <OrderBy>Key</OrderBy>
      <InstanceSelection>List</InstanceSelection>
    </Attribute>
    <Attribute dwd:design-time-name="4345b2fe-b7d4-4886-bb91-5d74f312ca81">