时间.dim

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

<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="10113a55-315e-456a-a82d-d156caac67cc" xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
  <ID>时间</ID>
  <Name>时间</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>
    <Annotation>
      <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:Microsoft.DataWarehouse.TimeBinding</Name>
      <Value>
        <Microsoft.AnalysisServices.TimeBinding xmlns="">
          <CalendarStartDate>2004-1-1 0:00:00</CalendarStartDate>
          <CalendarEndDate>2007-12-31 0:00:00</CalendarEndDate>
          <FirstDayOfWeek>2</FirstDayOfWeek>
          <CalendarLanguage>1033</CalendarLanguage>
          <FiscalFirstDayOfMonth>1</FiscalFirstDayOfMonth>
          <FiscalFirstMonth>1</FiscalFirstMonth>
          <FiscalYearName>NextCalendarYearName</FiscalYearName>
          <ReportingFirstWeekOfMonth>1</ReportingFirstWeekOfMonth>
          <ReportingFirstMonth>1</ReportingFirstMonth>
          <ReportingWeekToMonthPattern>Weeks445</ReportingWeekToMonthPattern>
          <ManufacturingFirstWeekOfMonth>1</ManufacturingFirstWeekOfMonth>
          <ManufacturingFirstMonth>1</ManufacturingFirstMonth>
          <ManufacturingExtraMonthQuarter>4</ManufacturingExtraMonthQuarter>
        </Microsoft.AnalysisServices.TimeBinding>
      </Value>
    </Annotation>
  </Annotations>
  <LastProcessed>0001-01-01T00:00:00Z</LastProcessed>
  <State>Unprocessed</State>
  <Type>Time</Type>
  <CurrentStorageMode>Molap</CurrentStorageMode>
  <Attributes>
    <Attribute dwd:design-time-name="cc742f9e-78ba-4e32-bcc6-06814b0791cb">
      <ID>年</ID>
      <Name>年</Name>
      <Type>Years</Type>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="c82cf4e2-fbc2-455b-b411-bf2ca11bace0">
          <DataType>Date</DataType>
        </KeyColumn>
      </KeyColumns>
      <NameColumn dwd:design-time-name="dad7f8d4-e520-44b8-a1ed-3f93682b677b">
        <DataType>WChar</DataType>
      </NameColumn>
      <OrderBy>Key</OrderBy>
    </Attribute>
    <Attribute dwd:design-time-name="db72286e-b1c4-43b9-be78-04b184e190f8">
      <ID>半年</ID>
      <Name>半年</Name>
      <Type>HalfYears</Type>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="bccf4660-6a3e-4a55-8ae1-cabbbb3e7b3b">
          <DataType>Date</DataType>
        </KeyColumn>
      </KeyColumns>
      <NameColumn dwd:design-time-name="e3951606-fc58-45de-b7be-d9f5534ec537">
        <DataType>WChar</DataType>
      </NameColumn>
      <AttributeRelationships>
        <AttributeRelationship dwd:design-time-name="06a07334-a1b5-4280-bbc3-569014c193e8">
          <AttributeID>年</AttributeID>
          <RelationshipType>Rigid</RelationshipType>
          <Name>年</Name>
        </AttributeRelationship>
      </AttributeRelationships>
      <OrderBy>Key</OrderBy>
    </Attribute>
    <Attribute dwd:design-time-name="37749fe8-b26a-4b6e-8c92-a4af3680a1df">
      <ID>季度</ID>
      <Name>季度</Name>
      <Type>Quarters</Type>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="d9534b8e-3e13-426b-a173-2dc195383b08">
          <DataType>Date</DataType>
        </KeyColumn>
      </KeyColumns>
      <NameColumn dwd:design-time-name="ef15f158-e89f-4d42-a24d-ff841ea9e3d9">
        <DataType>WChar</DataType>
      </NameColumn>
      <AttributeRelationships>
        <AttributeRelationship dwd:design-time-name="158c045d-cd40-403b-a357-9e885141c247">
          <AttributeID>半年</AttributeID>
          <RelationshipType>Rigid</RelationshipType>
          <Name>半年</Name>
        </AttributeRelationship>
        <AttributeRelationship dwd:design-time-name="8f471b01-d503-4b55-8c00-4242c4400a1b">
          <AttributeID>每年的某一半年</AttributeID>
          <RelationshipType>Rigid</RelationshipType>
          <Name>每年的某一半年</Name>
        </AttributeRelationship>
      </AttributeRelationships>
      <OrderBy>Key</OrderBy>
    </Attribute>
    <Attribute dwd:design-time-name="9839e5cb-496a-4d6c-bf02-fa8443f85769">
      <ID>月份</ID>
      <Name>月份</Name>
      <Type>Months</Type>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="eb7880a8-acc8-40c3-a548-8cd3794de605">
          <DataType>Date</DataType>
        </KeyColumn>
      </KeyColumns>
      <NameColumn dwd:design-time-name="fadc4a5b-2046-429b-a0c4-78926f5eb98c">
        <DataType>WChar</DataType>
      </NameColumn>
      <AttributeRelationships>
        <AttributeRelationship dwd:design-time-name="00fddfcf-aec2-4039-bcf4-da5c3b391b3b">
          <AttributeID>季度</AttributeID>
          <RelationshipType>Rigid</RelationshipType>
          <Name>季度</Name>
        </AttributeRelationship>
        <AttributeRelationship dwd:design-time-name="bb5acb40-6e61-4866-a63d-1d989768d8f3">
          <AttributeID>每年的某一季度</AttributeID>
          <RelationshipType>Rigid</RelationshipType>
          <Name>每年的某一季度</Name>
        </AttributeRelationship>
        <AttributeRelationship dwd:design-time-name="4bc1a04e-3b90-41cf-93d9-2dbbc180c369">
          <AttributeID>每半年的某一季度</AttributeID>
          <RelationshipType>Rigid</RelationshipType>
          <Name>每半年的某一季度</Name>
        </AttributeRelationship>
      </AttributeRelationships>
      <OrderBy>Key</OrderBy>
    </Attribute>
    <Attribute dwd:design-time-name="4700b764-48e8-4224-b62b-258318f1d4cb">
      <ID>十天</ID>
      <Name>十天</Name>
      <Type>TenDays</Type>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="8b9f24a8-501c-4a6b-a728-e6eeaebc920b">
          <DataType>Date</DataType>
        </KeyColumn>
      </KeyColumns>
      <NameColumn dwd:design-time-name="d84672bb-d715-4392-8257-57afd7eb8175">
        <DataType>WChar</DataType>
      </NameColumn>
      <AttributeRelationships>
        <AttributeRelationship dwd:design-time-name="3980338a-b7bd-449c-9dfe-68d7b7fb6685">
          <AttributeID>月份</AttributeID>
          <RelationshipType>Rigid</RelationshipType>
          <Name>月份</Name>
        </AttributeRelationship>
        <AttributeRelationship dwd:design-time-name="e816e27b-f2ac-459a-b8e0-1dabb361deff">
          <AttributeID>每年的某一月</AttributeID>
          <RelationshipType>Rigid</RelationshipType>
          <Name>每年的某一月</Name>
        </AttributeRelationship>
        <AttributeRelationship dwd:design-time-name="f5914f7d-238a-4d46-aa3c-439736a2e72f">
          <AttributeID>每半年的某一月</AttributeID>
          <RelationshipType>Rigid</RelationshipType>
          <Name>每半年的某一月</Name>
        </AttributeRelationship>
        <AttributeRelationship dwd:design-time-name="af075b05-36b6-458b-9547-8c0d34b15649">
          <AttributeID>每个季度的某一月</AttributeID>
          <RelationshipType>Rigid</RelationshipType>
          <Name>每个季度的某一月</Name>
        </AttributeRelationship>
      </AttributeRelationships>
      <OrderBy>Key</OrderBy>
    </Attribute>
    <Attribute dwd:design-time-name="a455385b-8962-49a1-835c-7a10ef58b1ba">
      <ID>周</ID>
      <Name>周</Name>
      <Type>Weeks</Type>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="2d62d8c9-2a95-4893-adc1-c46e3c6419af">
          <DataType>Date</DataType>
        </KeyColumn>
      </KeyColumns>
      <NameColumn dwd:design-time-name="4e7fd7b0-8ad1-447f-97eb-b3b9952372d2">
        <DataType>WChar</DataType>
      </NameColumn>
      <AttributeRelationships>
        <AttributeRelationship dwd:design-time-name="7633e298-abbe-4c13-9df1-7a2fdd51d42d">
          <AttributeID>年</AttributeID>
          <RelationshipType>Rigid</RelationshipType>
          <Name>年</Name>
        </AttributeRelationship>
      </AttributeRelationships>
      <OrderBy>Key</OrderBy>
    </Attribute>
    <Attribute dwd:design-time-name="d6034d62-4ea8-4e50-8657-9bdb414ab09d">
      <ID>日期</ID>
      <Name>日期</Name>
      <Type>Days</Type>
      <Usage>Key</Usage>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="ecc5e03b-60dc-4f30-8c46-8a1ab7c7e641">
          <DataType>Date</DataType>
        </KeyColumn>
      </KeyColumns>
      <NameColumn dwd:design-time-name="e825cce9-0a49-411a-ac6a-0bbb282aefc1">
        <DataType>WChar</DataType>
      </NameColumn>
      <AttributeRelationships>
        <AttributeRelationship dwd:design-time-name="99f85811-ec18-47c0-b665-de57256b7401">
          <AttributeID>十天</AttributeID>
          <RelationshipType>Rigid</RelationshipType>
          <Name>十天</Name>
        </AttributeRelationship>
        <AttributeRelationship dwd:design-time-name="d5ea9c37-2357-437f-9370-0d5ba76fdf28">
          <AttributeID>每年的某十天</AttributeID>
          <RelationshipType>Rigid</RelationshipType>
          <Name>每年的某十天</Name>
        </AttributeRelationship>
        <AttributeRelationship dwd:design-time-name="accd8bdd-4281-488b-a987-dcbe9ad70974">
          <AttributeID>每半年的某十天</AttributeID>
          <RelationshipType>Rigid</RelationshipType>
          <Name>每半年的某十天</Name>
        </AttributeRelationship>
        <AttributeRelationship dwd:design-time-name="604a5cad-1fd3-4f74-9118-779a5f22f99c">
          <AttributeID>每个季度的某十天</AttributeID>
          <RelationshipType>Rigid</RelationshipType>
          <Name>每个季度的某十天</Name>
        </AttributeRelationship>
        <AttributeRelationship dwd:design-time-name="c6b45b0f-75b6-4aaf-aff4-621ef77c55da">
          <AttributeID>每月的某十天</AttributeID>
          <RelationshipType>Rigid</RelationshipType>
          <Name>每月的某十天</Name>
        </AttributeRelationship>
        <AttributeRelationship dwd:design-time-name="e11236ed-f6c2-4ff2-801b-1d5665076435">
          <AttributeID>周</AttributeID>
          <RelationshipType>Rigid</RelationshipType>
          <Name>周</Name>
        </AttributeRelationship>
        <AttributeRelationship dwd:design-time-name="e006324c-d4a5-40f3-b7e8-fd0f6bd20b98">
          <AttributeID>每年的某一周</AttributeID>
          <RelationshipType>Rigid</RelationshipType>
          <Name>每年的某一周</Name>
        </AttributeRelationship>
        <AttributeRelationship dwd:design-time-name="811db841-9ab4-45bc-ac8a-a70bdbae42d3">
          <AttributeID>每年的某一日</AttributeID>
          <Name>每年的某一日</Name>
        </AttributeRelationship>
        <AttributeRelationship dwd:design-time-name="84fb5cdb-c6ee-454d-9fed-abe8ca1333e4">
          <AttributeID>每半年的某一日</AttributeID>
          <Name>每半年的某一日</Name>
        </AttributeRelationship>
        <AttributeRelationship dwd:design-time-name="bdcbf0c4-3caf-4088-aa37-482028035ed0">
          <AttributeID>每个季度的某一日</AttributeID>
          <Name>每个季度的某一日</Name>
        </AttributeRelationship>
        <AttributeRelationship dwd:design-time-name="0b89e748-3274-4115-bf20-5bee94c5dbcb">
          <AttributeID>每月的某一日</AttributeID>
          <Name>每月的某一日</Name>
        </AttributeRelationship>
        <AttributeRelationship dwd:design-time-name="71e26855-dc48-40c3-b66a-887327c6e09d">
          <AttributeID>每十天的某一日</AttributeID>
          <Name>每十天的某一日</Name>
        </AttributeRelationship>
        <AttributeRelationship dwd:design-time-name="e13e14c6-41f4-4d83-9bae-f872394186b2">
          <AttributeID>每周的某一日</AttributeID>
          <Name>每周的某一日</Name>
        </AttributeRelationship>
      </AttributeRelationships>
      <OrderBy>Key</OrderBy>
    </Attribute>
    <Attribute dwd:design-time-name="f0697934-2962-432b-9fbd-74ed54a1bff3">
      <ID>每年的某一日</ID>
      <Name>每年的某一日</Name>
      <Type>DayOfYear</Type>