📄 时间.dim

📁 SQL SERVER 2005数据挖掘与商务智能完全解决方案随书光盘,作者：朱德利,出版日期：2007-10-01 页　数： 383 出版社：电子工业
💻 DIM
字号:
<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="ee8e5251-8379-4250-8099-6d98f708ad18" 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>
      <Value>
        <dds xmlns="">
          <diagram fontclsid="{0BE35203-8F91-11CE-9DE3-00AA004BB851}" mouseiconclsid="{0BE35204-8F91-11CE-9DE3-00AA004BB851}" defaultlayout="MSDDS.Rectilinear" defaultlineroute="MSDDS.Rectilinear" version="7" nextobject="3" scale="100" pagebreakanchorx="0" pagebreakanchory="0" pagebreaksizex="0" pagebreaksizey="0" scrollleft="-588" scrolltop="-5000" gridx="150" gridy="150" marginx="5000" marginy="5000" zoom="100" x="7805" y="14870" backcolor="15334399" defaultpersistence="2" PrintPageNumbersMode="3" PrintMarginTop="0" PrintMarginBottom="635" PrintMarginLeft="0" PrintMarginRight="0" marqueeselectionmode="0" mousepointer="0" snaptogrid="0" autotypeannotation="1" showscrollbars="0" viewpagebreaks="0" donotforceconnectorsbehindshapes="1" backpictureclsid="{00000000-0000-0000-0000-000000000000}">
            <font>
              <ddsxmlobjectstreamwrapper binary="018600009001905f010004cbcecce5" />
            </font>
            <mouseicon>
              <ddsxmlobjectstreamwrapper binary="6c74000000000000" />
            </mouseicon>
          </diagram>
          <layoutmanager>
            <ddsxmlobj />
          </layoutmanager>
          <ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.1" tooltip="DimTime (dbo.DimTime)" left="20" top="-4286" logicalid="2" controlid="1" masterid="0" hint1="0" hint2="0" width="4524" height="9286" noresize="0" nomove="0" nodefaultattachpoints="0" autodrag="1" usedefaultiddshape="1" selectable="1" showselectionhandles="1" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0">
            <control>
              <ddsxmlobjectstreaminitwrapper binary="00080000ac11000046240000" />
            </control>
            <layoutobject>
              <ddsxmlobj>
                <property name="LogicalObject" value="dbo_DimTime" vartype="8" />
              </ddsxmlobj>
            </layoutobject>
            <shape groupshapeid="0" groupnode="0" />
          </ddscontrol>
        </dds>
      </Value>
    </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>-588</Value>
    </Annotation>
    <Annotation>
      <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramViewPortTop</Name>
      <Value>-5000</Value>
    </Annotation>
    <Annotation>
      <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramBoundingLeft</Name>
      <Value>20</Value>
    </Annotation>
    <Annotation>
      <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramBoundingTop</Name>
      <Value>-4286</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="8837b88c-71f2-43e2-87c9-a27e51dd3641">
    <DataSourceViewID>Adventure Works DW</DataSourceViewID>
  </Source>
  <Type>Time</Type>
  <CurrentStorageMode>Molap</CurrentStorageMode>
  <Attributes>
    <Attribute dwd:design-time-name="e8824a76-ecaf-4a90-94f0-866ab65270f8">
      <ID>年</ID>
      <Name>CalendarYear</Name>
      <Type>Years</Type>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="0c5588ef-90c8-4672-a5dc-b18c7abc0879">
          <DataType>WChar</DataType>
          <DataSize>4</DataSize>
          <Source xsi:type="ColumnBinding" dwd:design-time-name="8973f486-258a-49fa-b332-a1c4fb97ea7b">
            <TableID>dbo_DimTime</TableID>
            <ColumnID>CalendarYear</ColumnID>
          </Source>
        </KeyColumn>
      </KeyColumns>
      <NameColumn dwd:design-time-name="9530c18a-ebb8-4496-b7e6-b4245ed72338">
        <DataType>WChar</DataType>
        <DataSize>4</DataSize>
        <Source xsi:type="ColumnBinding" dwd:design-time-name="bd0a29ba-de3e-4586-bade-ae50a818d9ec">
          <TableID>dbo_DimTime</TableID>
          <ColumnID>CalendarYear</ColumnID>
        </Source>
      </NameColumn>
      <Translations>
        <Translation dwd:design-time-name="0147bc57-2718-4a14-af3b-bc40eda63b33">
          <Language>2052</Language>
          <Caption>年</Caption>
        </Translation>
      </Translations>
      <OrderBy>Key</OrderBy>
    </Attribute>
    <Attribute dwd:design-time-name="b81f0763-1073-44b4-ab5d-d9282f3d78da">
      <ID>半年</ID>
      <Name>CalendarSemester</Name>
      <Type>HalfYears</Type>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="820d89f9-bd5e-41bc-8e82-9d5c80fea90f">
          <DataType>UnsignedTinyInt</DataType>
          <DataSize>-1</DataSize>
          <Source xsi:type="ColumnBinding" dwd:design-time-name="09935dac-6ef0-4ec3-89e8-6085d5c1bf12">
            <TableID>dbo_DimTime</TableID>
            <ColumnID>CalendarSemester</ColumnID>
          </Source>
        </KeyColumn>
      </KeyColumns>
      <NameColumn dwd:design-time-name="4594b2a3-66d7-42a8-86bd-5c3a17ec70fc">
        <DataType>WChar</DataType>
        <DataSize>-1</DataSize>
        <Source xsi:type="ColumnBinding" dwd:design-time-name="ba09dfe1-6973-4aef-9b46-e60a40e9aa1b">
          <TableID>dbo_DimTime</TableID>
          <ColumnID>CalendarSemester</ColumnID>
        </Source>
      </NameColumn>
      <Translations>
        <Translation dwd:design-time-name="cf3b48db-f3ad-4166-ae75-1a9e18a47a20">
          <Language>2052</Language>
          <Caption>半年</Caption>
        </Translation>
      </Translations>
      <OrderBy>Key</OrderBy>
    </Attribute>
    <Attribute dwd:design-time-name="58d6a32a-9a1c-45f2-a825-bb83531618b5">
      <ID>季度</ID>
      <Name>CalendarQuarter</Name>
      <Type>Quarters</Type>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="21f081a4-f9a2-42ab-901d-ce4cb43c70c9">
          <DataType>UnsignedTinyInt</DataType>
          <DataSize>-1</DataSize>
          <Source xsi:type="ColumnBinding" dwd:design-time-name="55bbc118-c3ce-4755-9c47-d29f6e71a228">
            <TableID>dbo_DimTime</TableID>
            <ColumnID>CalendarQuarter</ColumnID>
          </Source>
        </KeyColumn>
      </KeyColumns>
      <NameColumn dwd:design-time-name="af09833e-0b7c-47ba-95e5-9061d7e28fc8">
        <DataType>WChar</DataType>
        <DataSize>-1</DataSize>
        <Source xsi:type="ColumnBinding" dwd:design-time-name="e14f9b51-a91b-4f2c-9f1f-5032c9bd283d">
          <TableID>dbo_DimTime</TableID>
          <ColumnID>CalendarQuarter</ColumnID>
        </Source>
      </NameColumn>
      <Translations>
        <Translation dwd:design-time-name="0a4b7e63-95f2-41fc-a75f-048014b47883">
          <Language>2052</Language>
          <Caption>季度</Caption>
        </Translation>
      </Translations>
      <OrderBy>Key</OrderBy>
    </Attribute>
    <Attribute dwd:design-time-name="78768efe-a4e9-4ba4-b8d1-fda96ac0a7f7">
      <ID>月份</ID>
      <Name>EnglishMonthName</Name>
      <Type>Months</Type>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="72007fad-ba81-42e7-b881-68d3db406084">
          <DataType>WChar</DataType>
          <DataSize>10</DataSize>
          <Source xsi:type="ColumnBinding" dwd:design-time-name="792981f4-5087-4c42-8135-a0ad86db8f6f">
            <TableID>dbo_DimTime</TableID>
            <ColumnID>EnglishMonthName</ColumnID>
          </Source>
        </KeyColumn>
      </KeyColumns>
      <NameColumn dwd:design-time-name="ad28bf29-803b-4371-87df-3c060bff75be">
        <DataType>WChar</DataType>
        <DataSize>10</DataSize>
        <Source xsi:type="ColumnBinding" dwd:design-time-name="3bfa2dd2-9c9b-467e-a454-4ebe64f769ce">
          <TableID>dbo_DimTime</TableID>
          <ColumnID>EnglishMonthName</ColumnID>
        </Source>
      </NameColumn>
      <Translations>
        <Translation dwd:design-time-name="56b1cf5c-862c-46b6-b387-70b9280b5bee">
          <Language>2052</Language>
          <Caption>中文月</Caption>
          <CaptionColumn dwd:design-time-name="3f5e70fb-3e30-4e35-948b-80662d1054a8">
            <DataType>WChar</DataType>
            <DataSize>50</DataSize>
            <Collation>Chinese_PRC_CI_AS</Collation>
            <Source xsi:type="ColumnBinding" dwd:design-time-name="44046ef2-9e2e-4b53-9be4-3029a1693c65">
              <TableID>dbo_DimTime</TableID>
              <ColumnID>ChineseMonthName</ColumnID>
            </Source>
          </CaptionColumn>
        </Translation>
      </Translations>
      <OrderBy>Key</OrderBy>
    </Attribute>
    <Attribute dwd:design-time-name="c5092a03-29e6-4afc-b1e9-9c65504ae475">
      <ID>TimeKey</ID>
      <Name>TimeKey</Name>
      <Usage>Key</Usage>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="5e3d7795-bd48-454b-8070-4b5622c5977d">
          <DataType>Integer</DataType>
          <DataSize>-1</DataSize>
          <Source xsi:type="ColumnBinding" dwd:design-time-name="c29dd0c0-164f-486b-b558-1a365787fe2a">
            <TableID>dbo_DimTime</TableID>
            <ColumnID>TimeKey</ColumnID>
          </Source>
        </KeyColumn>
      </KeyColumns>
      <NameColumn dwd:design-time-name="faf8e8e8-9877-4730-b8d1-2f43292e9851">
        <DataType>WChar</DataType>
        <DataSize>96</DataSize>
        <Source xsi:type="ColumnBinding" dwd:design-time-name="522724e4-1d71-4477-87d3-218ad9ba6984">
          <TableID>dbo_DimTime</TableID>
          <ColumnID>chinadate</ColumnID>
        </Source>
      </NameColumn>
      <Translations>
        <Translation dwd:design-time-name="3bdb419c-f9ee-439b-8e93-14c55fcdf87b">
          <Language>2052</Language>
          <Caption>时间键</Caption>
        </Translation>
      </Translations>
      <AttributeRelationships>
        <AttributeRelationship dwd:design-time-name="a0f5942d-2ab7-4a41-a5a0-33946cf51a63">
          <AttributeID>年</AttributeID>
          <Name>CalendarYear</Name>
        </AttributeRelationship>
        <AttributeRelationship dwd:design-time-name="47a3c72b-29e4-401c-992a-9b98892fdb7b">
          <AttributeID>半年</AttributeID>
          <Name>CalendarSemester</Name>
        </AttributeRelationship>
        <AttributeRelationship dwd:design-time-name="686646b9-fd8a-4af8-bad9-032afc31df62">
          <AttributeID>季度</AttributeID>
          <Name>CalendarQuarter</Name>
        </AttributeRelationship>
        <AttributeRelationship dwd:design-time-name="efcbe190-c375-41f9-b4b6-241ee1a9da55">
          <AttributeID>月份</AttributeID>
          <Name>EnglishMonthName</Name>
        </AttributeRelationship>
      </AttributeRelationships>
      <OrderBy>Key</OrderBy>
    </Attribute>
  </Attributes>
  <Hierarchies>
    <Hierarchy dwd:design-time-name="6842c21d-c9bb-43ce-b3fe-ef9dc00b4740">
      <ID>CalendarYear -  CalendarSemester -  CalendarQuarter -  EnglishMonthName -  FullDateAlternateKey</ID>
      <Name>日历时间</Name>
      <Translations>
        <Translation dwd:design-time-name="115ef761-4a17-404f-b3f6-0c7e769d5087">
          <Language>2052</Language>
          <Caption>年</Caption>
        </Translation>
      </Translations>
      <Levels>
        <Level dwd:design-time-name="5b4010f4-d5dc-47c7-8cc6-1f2019da4844">
          <ID>CalendarYear</ID>
          <Name>日历年</Name>
          <SourceAttributeID>年</SourceAttributeID>
          <Translations>
            <Translation dwd:design-time-name="c111d62d-c177-4283-ac50-82fc1ac77779">
              <Language>2052</Language>
              <Caption>年</Caption>
            </Translation>
          </Translations>
        </Level>
        <Level dwd:design-time-name="b8c17b6c-869e-4006-aff3-f6a1bd0b5392">
          <ID>CalendarSemester</ID>
          <Name>日历半年</Name>
          <SourceAttributeID>半年</SourceAttributeID>
          <Translations>
            <Translation dwd:design-time-name="09beee06-6067-419a-b562-2106918723c9">
              <Language>2052</Language>
              <Caption>半年</Caption>
            </Translation>
          </Translations>
        </Level>
        <Level dwd:design-time-name="2ee8e40e-40f6-4750-8017-53984869b147">
          <ID>CalendarQuarter</ID>
          <Name>日历季度</Name>
          <SourceAttributeID>季度</SourceAttributeID>
          <Translations>
            <Translation dwd:design-time-name="0f5663b9-281c-47aa-be94-09e7184cc04e">
              <Language>2052</Language>
              <Caption>季度</Caption>
            </Translation>
          </Translations>
        </Level>
        <Level dwd:design-time-name="46f25871-270f-4426-8e68-5764e9d5d527">
          <ID>EnglishMonthName</ID>
          <Name>日历月</Name>
          <SourceAttributeID>月份</SourceAttributeID>
          <Translations>
            <Translation dwd:design-time-name="f862ac2b-e4c8-4075-9561-b28668c382c4">
              <Language>2052</Language>
              <Caption>英文月</Caption>
            </Translation>
          </Translations>
        </Level>
        <Level dwd:design-time-name="7d4e3964-3400-4061-99c1-c934ae353760">
          <ID>FullDateAlternateKey</ID>
          <Name>日期</Name>
          <SourceAttributeID>TimeKey</SourceAttributeID>
          <Translations>
            <Translation dwd:design-time-name="8b0ce6c6-f2ec-4923-8ec3-cadfe86d48f3">
              <Language>2052</Language>
              <Caption>完整日期键</Caption>
            </Translation>
          </Translations>
        </Level>
      </Levels>
    </Hierarchy>
  </Hierarchies>
</Dimension>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -