时间 1.dim

SQL SERVER 2005数据挖掘与商务智能完全解决方案随书光盘,作者：朱德利,出版日期：2007-10-01 页 数： 383 出 版 社： 电子工业

            <ColumnID>周</ColumnID>
          </Source>
        </KeyColumn>
      </KeyColumns>
      <NameColumn dwd:design-time-name="7c35cfe5-393b-4752-8c8f-fb504432ad33">
        <DataType>WChar</DataType>
        <Source xsi:type="ColumnBinding" dwd:design-time-name="1c4886a6-2dba-4833-b1c7-6f342c4776c6">
          <TableID>时间</TableID>
          <ColumnID>周_名称</ColumnID>
        </Source>
      </NameColumn>
      <AttributeRelationships>
        <AttributeRelationship dwd:design-time-name="cbfe3f39-e205-4afd-85b7-7523b8bfdfba">
          <AttributeID>年</AttributeID>
          <RelationshipType>Rigid</RelationshipType>
          <Name>年</Name>
        </AttributeRelationship>
      </AttributeRelationships>
      <OrderBy>Key</OrderBy>
      <ValueColumn dwd:design-time-name="07aff5e4-d20d-4a98-bdc8-7d2e6b21f49c">
        <DataType>Date</DataType>
        <Source xsi:type="ColumnBinding" dwd:design-time-name="a89ed0d0-b89a-4ae4-a2b8-0985511a253c">
          <TableID>时间</TableID>
          <ColumnID>周</ColumnID>
        </Source>
      </ValueColumn>
    </Attribute>
    <Attribute dwd:design-time-name="5c8a3120-6f20-4c91-a4b1-3ac67d1a6580">
      <ID>日期</ID>
      <Name>日期</Name>
      <Type>Days</Type>
      <Usage>Key</Usage>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="7afb5eae-0195-4009-9bb4-8e8ea2bd389b">
          <DataType>Date</DataType>
          <Source xsi:type="ColumnBinding" dwd:design-time-name="cc43dc4a-583f-4c34-818e-22f7df2c7a71">
            <TableID>时间</TableID>
            <ColumnID>日期</ColumnID>
          </Source>
        </KeyColumn>
      </KeyColumns>
      <NameColumn dwd:design-time-name="8d824990-4e25-4d0a-8dfd-cfc511291a1d">
        <DataType>WChar</DataType>
        <Source xsi:type="ColumnBinding" dwd:design-time-name="e0b769b7-a0d8-4caf-861f-21c658128f2b">
          <TableID>时间</TableID>
          <ColumnID>日期_名称</ColumnID>
        </Source>
      </NameColumn>
      <AttributeRelationships>
        <AttributeRelationship dwd:design-time-name="62b50315-d131-4945-99ef-a6f172b1504b">
          <AttributeID>月份</AttributeID>
          <RelationshipType>Rigid</RelationshipType>
          <Name>月份</Name>
        </AttributeRelationship>
        <AttributeRelationship dwd:design-time-name="58d3f567-061b-4ce6-b6d2-617591cc0966">
          <AttributeID>每年的某一月</AttributeID>
          <RelationshipType>Rigid</RelationshipType>
          <Name>每年的某一月</Name>
        </AttributeRelationship>
        <AttributeRelationship dwd:design-time-name="61c78915-3c46-4ed1-a8ed-0ea5a50b12ea">
          <AttributeID>每半年的某一月</AttributeID>
          <RelationshipType>Rigid</RelationshipType>
          <Name>每半年的某一月</Name>
        </AttributeRelationship>
        <AttributeRelationship dwd:design-time-name="7e65543d-c5c4-4ead-bcb0-228bedfd7c89">
          <AttributeID>每个季度的某一月</AttributeID>
          <RelationshipType>Rigid</RelationshipType>
          <Name>每个季度的某一月</Name>
        </AttributeRelationship>
        <AttributeRelationship dwd:design-time-name="13c40796-c378-4e4a-89c0-b00249f502ab">
          <AttributeID>周</AttributeID>
          <RelationshipType>Rigid</RelationshipType>
          <Name>周</Name>
        </AttributeRelationship>
        <AttributeRelationship dwd:design-time-name="c599d01d-ad5d-4a4d-98b1-70536ce3f823">
          <AttributeID>每年的某一周</AttributeID>
          <RelationshipType>Rigid</RelationshipType>
          <Name>每年的某一周</Name>
        </AttributeRelationship>
        <AttributeRelationship dwd:design-time-name="5fe6c69e-2a8f-4c9c-a147-caf8159f7ca0">
          <AttributeID>每年的某一日</AttributeID>
          <Name>每年的某一日</Name>
        </AttributeRelationship>
        <AttributeRelationship dwd:design-time-name="28d27e2a-f77b-4bef-a641-b937132822b9">
          <AttributeID>每半年的某一日</AttributeID>
          <Name>每半年的某一日</Name>
        </AttributeRelationship>
        <AttributeRelationship dwd:design-time-name="908a7a05-db10-4d4f-9a37-9d1fb0a4fd6f">
          <AttributeID>每个季度的某一日</AttributeID>
          <Name>每个季度的某一日</Name>
        </AttributeRelationship>
        <AttributeRelationship dwd:design-time-name="d2d28dbb-cf02-42e0-9e48-99d6e04d86b0">
          <AttributeID>每月的某一日</AttributeID>
          <Name>每月的某一日</Name>
        </AttributeRelationship>
        <AttributeRelationship dwd:design-time-name="c18b2413-8ef9-48c0-9c61-c695710dbf02">
          <AttributeID>每周的某一日</AttributeID>
          <Name>每周的某一日</Name>
        </AttributeRelationship>
      </AttributeRelationships>
      <OrderBy>Key</OrderBy>
      <ValueColumn dwd:design-time-name="d9dcc802-b59b-4b24-b419-d0b42f69c4bb">
        <DataType>Date</DataType>
        <Source xsi:type="ColumnBinding" dwd:design-time-name="75632eda-fafd-436a-99f3-66a2fdb42919">
          <TableID>时间</TableID>
          <ColumnID>日期</ColumnID>
        </Source>
      </ValueColumn>
    </Attribute>
    <Attribute dwd:design-time-name="6d6cf6ea-d263-4e47-9294-5431656872d4">
      <ID>每年的某一日</ID>
      <Name>每年的某一日</Name>
      <Type>DayOfYear</Type>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="e9bbe1c5-5c21-40f3-bd51-39c8cdffb27a">
          <DataType>Integer</DataType>
          <Source xsi:type="ColumnBinding" dwd:design-time-name="0061d743-2ad9-43ef-a61a-1dfa1643f0d6">
            <TableID>时间</TableID>
            <ColumnID>每年的某一日</ColumnID>
          </Source>
        </KeyColumn>
      </KeyColumns>
      <NameColumn dwd:design-time-name="a079d16e-b947-4e6d-9c77-a7629a6564b8">
        <DataType>WChar</DataType>
        <Source xsi:type="ColumnBinding" dwd:design-time-name="0099e584-c4cf-4737-8b59-9bd35c1261ac">
          <TableID>时间</TableID>
          <ColumnID>每年的某一日_名称</ColumnID>
        </Source>
      </NameColumn>
      <OrderBy>Key</OrderBy>
      <ValueColumn dwd:design-time-name="427fc726-1569-4e7b-b2ad-bd5db48d3066">
        <DataType>Integer</DataType>
        <Source xsi:type="ColumnBinding" dwd:design-time-name="34483329-4577-4c82-a440-fe0dee88d3cb">
          <TableID>时间</TableID>
          <ColumnID>每年的某一日</ColumnID>
        </Source>
      </ValueColumn>
    </Attribute>
    <Attribute dwd:design-time-name="62e4dbcd-d67c-4dcc-ab92-ca9e1718eb59">
      <ID>每半年的某一日</ID>
      <Name>每半年的某一日</Name>
      <Type>DayOfHalfYear</Type>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="980ed303-e55b-46b2-ab9f-2096aaa40a0e">
          <DataType>Integer</DataType>
          <Source xsi:type="ColumnBinding" dwd:design-time-name="9a888a5a-08a3-4db7-ac81-30053d1ea089">
            <TableID>时间</TableID>
            <ColumnID>每半年的某一日</ColumnID>
          </Source>
        </KeyColumn>
      </KeyColumns>
      <NameColumn dwd:design-time-name="15cb3648-2afc-4ab8-880e-1453eb0c39c1">
        <DataType>WChar</DataType>
        <Source xsi:type="ColumnBinding" dwd:design-time-name="5f9257c7-fe5c-42d1-9ff7-1ff53fc954eb">
          <TableID>时间</TableID>
          <ColumnID>每半年的某一日_名称</ColumnID>
        </Source>
      </NameColumn>
      <OrderBy>Key</OrderBy>
      <ValueColumn dwd:design-time-name="75fb7146-57a3-436b-ae06-4abfcffc6dcd">
        <DataType>Integer</DataType>
        <Source xsi:type="ColumnBinding" dwd:design-time-name="9c3832d6-1868-493e-b45e-24e67dc04b6b">
          <TableID>时间</TableID>
          <ColumnID>每半年的某一日</ColumnID>
        </Source>
      </ValueColumn>
    </Attribute>
    <Attribute dwd:design-time-name="8bdf7236-8d32-4ad9-9fbe-cc9bf771597a">
      <ID>每个季度的某一日</ID>
      <Name>每个季度的某一日</Name>
      <Type>DayOfQuarter</Type>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="b9ba47d0-1631-4fb0-9935-94cfc823fc85">
          <DataType>Integer</DataType>
          <Source xsi:type="ColumnBinding" dwd:design-time-name="65e68b41-9a4a-4830-af45-d47e3665b02c">
            <TableID>时间</TableID>
            <ColumnID>每个季度的某一日</ColumnID>
          </Source>
        </KeyColumn>
      </KeyColumns>
      <NameColumn dwd:design-time-name="7c64cc8c-47c1-430d-a983-dbcb17b2dcda">
        <DataType>WChar</DataType>
        <Source xsi:type="ColumnBinding" dwd:design-time-name="ee980f68-a285-4e7f-b7ae-610721167b3c">
          <TableID>时间</TableID>
          <ColumnID>每个季度的某一日_名称</ColumnID>
        </Source>
      </NameColumn>
      <OrderBy>Key</OrderBy>
      <ValueColumn dwd:design-time-name="2624e215-9d64-4696-90ed-11fa1a0e04ba">
        <DataType>Integer</DataType>
        <Source xsi:type="ColumnBinding" dwd:design-time-name="164d336a-8000-44bb-8dc8-0d9545f28d9e">
          <TableID>时间</TableID>
          <ColumnID>每个季度的某一日</ColumnID>
        </Source>
      </ValueColumn>
    </Attribute>
    <Attribute dwd:design-time-name="127c5201-e4e8-485f-bcc6-316fa6a835e0">
      <ID>每月的某一日</ID>
      <Name>每月的某一日</Name>
      <Type>DayOfMonth</Type>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="5c87a086-84fc-4dff-99c4-16f6e690267f">
          <DataType>Integer</DataType>
          <Source xsi:type="ColumnBinding" dwd:design-time-name="7036a737-36bc-4484-a8e0-4a2b839fdff2">
            <TableID>时间</TableID>
            <ColumnID>每月的某一日</ColumnID>
          </Source>
        </KeyColumn>
      </KeyColumns>
      <NameColumn dwd:design-time-name="e7fbb89c-2492-49f2-9dee-58f4f059a2be">
        <DataType>WChar</DataType>
        <Source xsi:type="ColumnBinding" dwd:design-time-name="fd576726-fdd4-4c79-9027-a54ba8254944">
          <TableID>时间</TableID>
          <ColumnID>每月的某一日_名称</ColumnID>
        </Source>
      </NameColumn>
      <OrderBy>Key</OrderBy>
      <ValueColumn dwd:design-time-name="56dc58d6-5f95-4126-8c6d-7a8beffef9df">
        <DataType>Integer</DataType>
        <Source xsi:type="ColumnBinding" dwd:design-time-name="c6396903-d5ea-4469-bd59-3d29e000bf88">
          <TableID>时间</TableID>
          <ColumnID>每月的某一日</ColumnID>
        </Source>
      </ValueColumn>
    </Attribute>
    <Attribute dwd:design-time-name="704547e8-66ed-4b4b-a8bb-2cb0f0b8a9e5">
      <ID>每周的某一日</ID>
      <Name>每周的某一日</Name>
      <Type>DayOfWeek</Type>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="8c018b3d-f856-4a49-98eb-454c2302a237">
          <DataType>Integer</DataType>
          <Source xsi:type="ColumnBinding" dwd:design-time-name="81898100-b02b-4ce2-bad6-28121b4c829b">
            <TableID>时间</TableID>
            <ColumnID>每周的某一日</ColumnID>
          </Source>
        </KeyColumn>
      </KeyColumns>
      <NameColumn dwd:design-time-name="08d3a712-42b1-4812-80b1-10f0b29f3fb6">
        <DataType>WChar</DataType>
        <Source xsi:type="ColumnBinding" dwd:design-time-name="6ef3f97c-6625-4e3f-ace3-8fc75323e2c7">
          <TableID>时间</TableID>
          <ColumnID>每周的某一日_名称</ColumnID>
        </Source>
      </NameColumn>
      <OrderBy>Key</OrderBy>
      <ValueColumn dwd:design-time-name="b120c9a2-a269-4141-b18a-ba751d7fad47">
        <DataType>Integer</DataType>
        <Source xsi:type="ColumnBinding" dwd:design-time-name="af411191-1626-4eab-888c-5487db3d5003">
          <TableID>时间</TableID>
          <ColumnID>每周的某一日</ColumnID>
        </Source>
      </ValueColumn>
    </Attribute>
    <Attribute dwd:design-time-name="af0e3525-3bee-4a92-8fff-99bf50f6b25e">
      <ID>每年的某一周</ID>
      <Name>每年的某一周</Name>