⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 时间 1.dim

📁 SQL SERVER 2005数据挖掘与商务智能完全解决方案随书光盘,作者：朱德利,出版日期：2007-10-01 页　数： 383 出 版 社： 电子工业
💻 DIM
📖 第 1 页 / 共 3 页
字号:
🔍
123 
<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="5d339732-1c79-498d-a688-94666afad947" 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="2" scale="100" pagebreakanchorx="0" pagebreakanchory="0" pagebreaksizex="0" pagebreaksizey="0" scrollleft="1008" scrolltop="-4273" gridx="150" gridy="150" marginx="5000" marginy="5000" zoom="75" x="1931" y="10160" backcolor="15334399" defaultpersistence="2" PrintPageNumbersMode="3" PrintMarginTop="0" PrintMarginBottom="635" PrintMarginLeft="0" PrintMarginRight="0" marqueeselectionmode="0" mousepointer="0" snaptogrid="0" autotypeannotation="1" showscrollbars="1" 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="时间 (自上而下创建的cube.时间)" left="20" top="0" logicalid="1" controlid="1" masterid="0" hint1="0" hint2="0" width="4551" height="5000" 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="00080000c711000088130000" />
            </control>
            <layoutobject>
              <ddsxmlobj>
                <property name="LogicalObject" value="时间" 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>1008</Value>
    </Annotation>
    <Annotation>
      <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramViewPortTop</Name>
      <Value>-4273</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>0</Value>
    </Annotation>
    <Annotation>
      <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramZoom</Name>
      <Value>75</Value>
    </Annotation>
    <Annotation>
      <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:Microsoft.DataWarehouse.TimeBinding</Name>
      <Value>
        <Microsoft.AnalysisServices.TimeBinding xmlns="">
          <CalendarStartDate>2003-1-1 0:00:00</CalendarStartDate>
          <CalendarEndDate>2006-12-31 0:00:00</CalendarEndDate>
          <FirstDayOfWeek>1</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>
  <Source xsi:type="DataSourceViewBinding" dwd:design-time-name="4db0b523-3767-4827-b30b-4381f5ea60c5">
    <DataSourceViewID>自上而下创建的cube</DataSourceViewID>
  </Source>
  <Type>Time</Type>
  <CurrentStorageMode>Molap</CurrentStorageMode>
  <Attributes>
    <Attribute dwd:design-time-name="8f7f54ca-b683-40f3-8fdd-9101b33b3755">
      <ID>年</ID>
      <Name>年</Name>
      <Type>Years</Type>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="dcb737e5-609b-403a-a408-6fd189228474">
          <DataType>Date</DataType>
          <Source xsi:type="ColumnBinding" dwd:design-time-name="fb56fdc7-8566-4f24-98b4-28bbca1c1832">
            <TableID>时间</TableID>
            <ColumnID>年</ColumnID>
          </Source>
        </KeyColumn>
      </KeyColumns>
      <NameColumn dwd:design-time-name="afb5f1a4-5d3c-4957-8b67-186c110d4579">
        <DataType>WChar</DataType>
        <Source xsi:type="ColumnBinding" dwd:design-time-name="2c3cf246-2fe4-4a4c-aad7-cb5fd723670b">
          <TableID>时间</TableID>
          <ColumnID>年_名称</ColumnID>
        </Source>
      </NameColumn>
      <OrderBy>Key</OrderBy>
      <ValueColumn dwd:design-time-name="ccea7db5-fc61-49d3-b148-a3c66db1908a">
        <DataType>Date</DataType>
        <Source xsi:type="ColumnBinding" dwd:design-time-name="216c175f-0b3a-4d6e-a2b9-b21b67594ea4">
          <TableID>时间</TableID>
          <ColumnID>年</ColumnID>
        </Source>
      </ValueColumn>
    </Attribute>
    <Attribute dwd:design-time-name="4bdca6c1-8494-4743-ae9f-13a3906fbac9">
      <ID>半年</ID>
      <Name>半年</Name>
      <Type>HalfYears</Type>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="1867d851-648a-4192-a70d-15f821565939">
          <DataType>Date</DataType>
          <Source xsi:type="ColumnBinding" dwd:design-time-name="21d3551d-20d3-4939-88c4-df7628080727">
            <TableID>时间</TableID>
            <ColumnID>半年</ColumnID>
          </Source>
        </KeyColumn>
      </KeyColumns>
      <NameColumn dwd:design-time-name="49b6a23a-fa12-4fb2-83d8-b05b7201322a">
        <DataType>WChar</DataType>
        <Source xsi:type="ColumnBinding" dwd:design-time-name="2839ec71-1d8a-499b-ad07-bb0979080ec0">
          <TableID>时间</TableID>
          <ColumnID>半年_名称</ColumnID>
        </Source>
      </NameColumn>
      <AttributeRelationships>
        <AttributeRelationship dwd:design-time-name="1f7146c9-d024-4898-bd18-48043c12a13a">
          <AttributeID>年</AttributeID>
          <RelationshipType>Rigid</RelationshipType>
          <Name>年</Name>
        </AttributeRelationship>
      </AttributeRelationships>
      <OrderBy>Key</OrderBy>
      <ValueColumn dwd:design-time-name="ca93a4d2-e81b-46bd-bd9a-11d629165304">
        <DataType>Date</DataType>
        <Source xsi:type="ColumnBinding" dwd:design-time-name="33df01c6-220f-4d28-83b6-8e4f11e805b0">
          <TableID>时间</TableID>
          <ColumnID>半年</ColumnID>
        </Source>
      </ValueColumn>
    </Attribute>
    <Attribute dwd:design-time-name="a5d1ca14-ede3-4567-9df3-407ba3e3247c">
      <ID>季度</ID>
      <Name>季度</Name>
      <Type>Quarters</Type>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="0b542334-4638-4c21-bf6e-5f86342e881f">
          <DataType>Date</DataType>
          <Source xsi:type="ColumnBinding" dwd:design-time-name="611f5eaf-ed98-4dba-9147-e5d119479f37">
            <TableID>时间</TableID>
            <ColumnID>季度</ColumnID>
          </Source>
        </KeyColumn>
      </KeyColumns>
      <NameColumn dwd:design-time-name="c0d0fb62-7ecf-49e0-ae35-ffdd7c4a75a6">
        <DataType>WChar</DataType>
        <Source xsi:type="ColumnBinding" dwd:design-time-name="9cc3df50-bf83-46d2-8f9c-542c06a7d115">
          <TableID>时间</TableID>
          <ColumnID>季度_名称</ColumnID>
        </Source>
      </NameColumn>
      <AttributeRelationships>
        <AttributeRelationship dwd:design-time-name="1c6a0ae8-f073-4d45-9e6e-2ecfde0776bf">
          <AttributeID>半年</AttributeID>
          <RelationshipType>Rigid</RelationshipType>
          <Name>半年</Name>
        </AttributeRelationship>
        <AttributeRelationship dwd:design-time-name="cc05ba03-5fb6-4b1b-99d6-d51cd8ab49d7">
          <AttributeID>每年的某一半年</AttributeID>
          <RelationshipType>Rigid</RelationshipType>
          <Name>每年的某一半年</Name>
        </AttributeRelationship>
      </AttributeRelationships>
      <OrderBy>Key</OrderBy>
      <ValueColumn dwd:design-time-name="9f3b5020-38a0-4fb0-b0d0-ae31761a3676">
        <DataType>Date</DataType>
        <Source xsi:type="ColumnBinding" dwd:design-time-name="131b3086-4e0c-4e1c-a48f-4534019a3d3a">
          <TableID>时间</TableID>
          <ColumnID>季度</ColumnID>
        </Source>
      </ValueColumn>
    </Attribute>
    <Attribute dwd:design-time-name="cd00c845-ea70-4d9d-9e3a-f66a88594d12">
      <ID>月份</ID>
      <Name>月份</Name>
      <Type>Months</Type>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="17e0ab48-d783-483f-9a36-aaa63fc0cff7">
          <DataType>Date</DataType>
          <Source xsi:type="ColumnBinding" dwd:design-time-name="a45730c6-0a44-4474-908f-31e9b6ea13ae">
            <TableID>时间</TableID>
            <ColumnID>月份</ColumnID>
          </Source>
        </KeyColumn>
      </KeyColumns>
      <NameColumn dwd:design-time-name="b7aefc28-46ec-414b-983c-bea7800b2604">
        <DataType>WChar</DataType>
        <Source xsi:type="ColumnBinding" dwd:design-time-name="b820674f-9cba-4539-b56b-016fdf2dc2fb">
          <TableID>时间</TableID>
          <ColumnID>月份_名称</ColumnID>
        </Source>
      </NameColumn>
      <AttributeRelationships>
        <AttributeRelationship dwd:design-time-name="4f38acf0-7e62-4024-8204-93fca019387d">
          <AttributeID>季度</AttributeID>
          <RelationshipType>Rigid</RelationshipType>
          <Name>季度</Name>
        </AttributeRelationship>
        <AttributeRelationship dwd:design-time-name="e629fe0f-7790-48b3-a50a-1fd67e2829ca">
          <AttributeID>每年的某一季度</AttributeID>
          <RelationshipType>Rigid</RelationshipType>
          <Name>每年的某一季度</Name>
        </AttributeRelationship>
        <AttributeRelationship dwd:design-time-name="30f107d3-9e60-42b7-a714-a2413373bf5c">
          <AttributeID>每半年的某一季度</AttributeID>
          <RelationshipType>Rigid</RelationshipType>
          <Name>每半年的某一季度</Name>
        </AttributeRelationship>
      </AttributeRelationships>
      <OrderBy>Key</OrderBy>
      <ValueColumn dwd:design-time-name="5c7753f0-695f-4498-b5eb-2ec89a039208">
        <DataType>Date</DataType>
        <Source xsi:type="ColumnBinding" dwd:design-time-name="b6fc6e6a-d06b-4278-a94d-c5fcc58d46aa">
          <TableID>时间</TableID>
          <ColumnID>月份</ColumnID>
        </Source>
      </ValueColumn>
    </Attribute>
    <Attribute dwd:design-time-name="2cade1f2-978e-4ae0-b9ce-c9a1d0d7e9a7">
      <ID>周</ID>
      <Name>周</Name>
      <Type>Weeks</Type>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="57ab2714-3660-486d-9d8e-8606c0ae23b6">
          <DataType>Date</DataType>
          <Source xsi:type="ColumnBinding" dwd:design-time-name="7594f98f-a759-4b88-8172-b054d029c8e0">
            <TableID>时间</TableID>
123

⌨️ 快捷键说明

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