📄 时间 1.dim

📁 SQL SERVER 2005数据挖掘与商务智能完全解决方案随书光盘,作者：朱德利,出版日期：2007-10-01 页　数： 383 出版社：电子工业
💻 DIM
📖 第 1 页 / 共 3 页
字号:
上一页 1 23
      <Type>WeekOfYear</Type>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="8653c565-4162-4bf4-b19f-48cd4cca32a9">
          <DataType>Integer</DataType>
          <Source xsi:type="ColumnBinding" dwd:design-time-name="e3dd1a54-48f7-4ae6-8521-6d36baacbe6c">
            <TableID>时间</TableID>
            <ColumnID>每年的某一周</ColumnID>
          </Source>
        </KeyColumn>
      </KeyColumns>
      <NameColumn dwd:design-time-name="f12e87ea-10f0-4ef0-b7b3-23a5f00e9e00">
        <DataType>WChar</DataType>
        <Source xsi:type="ColumnBinding" dwd:design-time-name="37251ac6-c6c5-4d9a-a3b7-7396aeda773d">
          <TableID>时间</TableID>
          <ColumnID>每年的某一周_名称</ColumnID>
        </Source>
      </NameColumn>
      <OrderBy>Key</OrderBy>
      <ValueColumn dwd:design-time-name="16990f10-f280-466e-8c12-fe7d92a75e83">
        <DataType>Integer</DataType>
        <Source xsi:type="ColumnBinding" dwd:design-time-name="5fa482a0-56f9-40e3-939e-ab049ba14cf7">
          <TableID>时间</TableID>
          <ColumnID>每年的某一周</ColumnID>
        </Source>
      </ValueColumn>
    </Attribute>
    <Attribute dwd:design-time-name="5edffaf2-3cec-47b4-9db2-3c304573dc01">
      <ID>每年的某一月</ID>
      <Name>每年的某一月</Name>
      <Type>MonthOfYear</Type>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="477dbbab-77b7-4f63-8f41-1d67dfe4525a">
          <DataType>Integer</DataType>
          <Source xsi:type="ColumnBinding" dwd:design-time-name="15f76565-a362-47d2-beb4-d8efe12e95eb">
            <TableID>时间</TableID>
            <ColumnID>每年的某一月</ColumnID>
          </Source>
        </KeyColumn>
      </KeyColumns>
      <NameColumn dwd:design-time-name="d69f0dd6-2f96-48e2-8628-88ba36b6d0ce">
        <DataType>WChar</DataType>
        <Source xsi:type="ColumnBinding" dwd:design-time-name="bf13ac87-7322-4a22-96f8-2887b1f20bc5">
          <TableID>时间</TableID>
          <ColumnID>每年的某一月_名称</ColumnID>
        </Source>
      </NameColumn>
      <OrderBy>Key</OrderBy>
      <ValueColumn dwd:design-time-name="d2d8c939-5cdb-4c60-9ebe-210d4f23c123">
        <DataType>Integer</DataType>
        <Source xsi:type="ColumnBinding" dwd:design-time-name="9f60d566-6cd6-4f9e-ab27-3eb2402804b9">
          <TableID>时间</TableID>
          <ColumnID>每年的某一月</ColumnID>
        </Source>
      </ValueColumn>
    </Attribute>
    <Attribute dwd:design-time-name="de255bb2-f41f-4181-b4c6-618df16f0d92">
      <ID>每半年的某一月</ID>
      <Name>每半年的某一月</Name>
      <Type>MonthOfHalfYear</Type>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="74957e98-5c12-4471-8ede-2cff86bf75bc">
          <DataType>Integer</DataType>
          <Source xsi:type="ColumnBinding" dwd:design-time-name="6280fe1d-9faa-4bf1-b6e0-a3ee26db08f8">
            <TableID>时间</TableID>
            <ColumnID>每半年的某一月</ColumnID>
          </Source>
        </KeyColumn>
      </KeyColumns>
      <NameColumn dwd:design-time-name="61a8454d-4cc8-40af-a433-49679f3fabea">
        <DataType>WChar</DataType>
        <Source xsi:type="ColumnBinding" dwd:design-time-name="9ec2dd17-752e-41d8-87d4-d072b2fa1347">
          <TableID>时间</TableID>
          <ColumnID>每半年的某一月_名称</ColumnID>
        </Source>
      </NameColumn>
      <OrderBy>Key</OrderBy>
      <ValueColumn dwd:design-time-name="efc2b398-793a-462a-987b-3521782d45a2">
        <DataType>Integer</DataType>
        <Source xsi:type="ColumnBinding" dwd:design-time-name="ca77c46a-efbc-4fb0-9975-cebda28cb17e">
          <TableID>时间</TableID>
          <ColumnID>每半年的某一月</ColumnID>
        </Source>
      </ValueColumn>
    </Attribute>
    <Attribute dwd:design-time-name="dd129f48-13df-4d61-b2f9-bc9f538e6d78">
      <ID>每个季度的某一月</ID>
      <Name>每个季度的某一月</Name>
      <Type>MonthOfQuarter</Type>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="e74990ee-852a-4738-98c8-ee6e53a48d75">
          <DataType>Integer</DataType>
          <Source xsi:type="ColumnBinding" dwd:design-time-name="8668cd15-9b72-4132-bc7f-db7d98993d50">
            <TableID>时间</TableID>
            <ColumnID>每个季度的某一月</ColumnID>
          </Source>
        </KeyColumn>
      </KeyColumns>
      <NameColumn dwd:design-time-name="f1aeafb7-1f91-467c-95b7-3ce3a248a4eb">
        <DataType>WChar</DataType>
        <Source xsi:type="ColumnBinding" dwd:design-time-name="36b4e9c6-b2d6-429d-8bfe-14e57761b0ae">
          <TableID>时间</TableID>
          <ColumnID>每个季度的某一月_名称</ColumnID>
        </Source>
      </NameColumn>
      <OrderBy>Key</OrderBy>
      <ValueColumn dwd:design-time-name="99d3402b-1dba-4fb8-a820-94bd81845cfd">
        <DataType>Integer</DataType>
        <Source xsi:type="ColumnBinding" dwd:design-time-name="53cfdede-ece9-433c-bd6e-cd0daec0c542">
          <TableID>时间</TableID>
          <ColumnID>每个季度的某一月</ColumnID>
        </Source>
      </ValueColumn>
    </Attribute>
    <Attribute dwd:design-time-name="7ddd53b0-1dc0-4e50-9f1c-31ff7f0b528e">
      <ID>每年的某一季度</ID>
      <Name>每年的某一季度</Name>
      <Type>QuarterOfYear</Type>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="9976d653-859b-4444-8309-7d3222e63bdf">
          <DataType>Integer</DataType>
          <Source xsi:type="ColumnBinding" dwd:design-time-name="5826b06e-1690-4ba7-be39-ef7c4b93fd0a">
            <TableID>时间</TableID>
            <ColumnID>每年的某一季度</ColumnID>
          </Source>
        </KeyColumn>
      </KeyColumns>
      <NameColumn dwd:design-time-name="331471ed-02cf-4049-a127-92c828ed9c88">
        <DataType>WChar</DataType>
        <Source xsi:type="ColumnBinding" dwd:design-time-name="ee3310a7-dce8-4e4d-9f78-18af42cb7587">
          <TableID>时间</TableID>
          <ColumnID>每年的某一季度_名称</ColumnID>
        </Source>
      </NameColumn>
      <OrderBy>Key</OrderBy>
      <ValueColumn dwd:design-time-name="0f8607cf-7734-4bcf-81cc-c52782d5b182">
        <DataType>Integer</DataType>
        <Source xsi:type="ColumnBinding" dwd:design-time-name="8b548957-47da-4646-a7c7-febbcbba0871">
          <TableID>时间</TableID>
          <ColumnID>每年的某一季度</ColumnID>
        </Source>
      </ValueColumn>
    </Attribute>
    <Attribute dwd:design-time-name="5c88a87b-58d3-460d-8678-18f5dc447940">
      <ID>每半年的某一季度</ID>
      <Name>每半年的某一季度</Name>
      <Type>QuarterOfHalfYear</Type>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="e749e8d9-2244-4b67-a954-a1386483aa26">
          <DataType>Integer</DataType>
          <Source xsi:type="ColumnBinding" dwd:design-time-name="32267063-96aa-42d4-b9cd-e1d74cb52083">
            <TableID>时间</TableID>
            <ColumnID>每半年的某一季度</ColumnID>
          </Source>
        </KeyColumn>
      </KeyColumns>
      <NameColumn dwd:design-time-name="ed1967b2-071c-46e6-b9d4-92857808117e">
        <DataType>WChar</DataType>
        <Source xsi:type="ColumnBinding" dwd:design-time-name="87148ddc-7bf8-4e8f-8a0b-3e569c891e09">
          <TableID>时间</TableID>
          <ColumnID>每半年的某一季度_名称</ColumnID>
        </Source>
      </NameColumn>
      <OrderBy>Key</OrderBy>
      <ValueColumn dwd:design-time-name="6bd7858a-7f9b-44e4-9cec-f0853f5e5999">
        <DataType>Integer</DataType>
        <Source xsi:type="ColumnBinding" dwd:design-time-name="476ad9d5-d3e3-4587-866e-571af0c702d3">
          <TableID>时间</TableID>
          <ColumnID>每半年的某一季度</ColumnID>
        </Source>
      </ValueColumn>
    </Attribute>
    <Attribute dwd:design-time-name="45f1d2b6-3ffb-45d0-84a3-5d3ca92f28fb">
      <ID>每年的某一半年</ID>
      <Name>每年的某一半年</Name>
      <Type>HalfYearOfYear</Type>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="9dc94e31-56c1-43e5-a756-388c5cc68e0c">
          <DataType>Integer</DataType>
          <Source xsi:type="ColumnBinding" dwd:design-time-name="1c51e422-6ed2-4fd2-ad84-833458854fcd">
            <TableID>时间</TableID>
            <ColumnID>每年的某一半年</ColumnID>
          </Source>
        </KeyColumn>
      </KeyColumns>
      <NameColumn dwd:design-time-name="58914430-a8f3-4b13-bfa8-a2e95046820e">
        <DataType>WChar</DataType>
        <Source xsi:type="ColumnBinding" dwd:design-time-name="db042561-78e3-446b-82c0-ed0c922561ca">
          <TableID>时间</TableID>
          <ColumnID>每年的某一半年_名称</ColumnID>
        </Source>
      </NameColumn>
      <OrderBy>Key</OrderBy>
      <ValueColumn dwd:design-time-name="b8279c18-5046-4443-aca8-fd8759b8867c">
        <DataType>Integer</DataType>
        <Source xsi:type="ColumnBinding" dwd:design-time-name="c4748993-80f4-4dfb-86ee-a975b8acfe65">
          <TableID>时间</TableID>
          <ColumnID>每年的某一半年</ColumnID>
        </Source>
      </ValueColumn>
    </Attribute>
  </Attributes>
  <Hierarchies>
    <Hierarchy dwd:design-time-name="040853b2-472f-4c99-8ab0-157cfe7b3657">
      <ID>年 -  半年 -  季度 -  月份 -  日期</ID>
      <Name>年 -  半年 -  季度 -  月份 -  日期</Name>
      <Levels>
        <Level dwd:design-time-name="3502d215-34be-4282-bdac-2a59fac44df8">
          <ID>年</ID>
          <Name>年</Name>
          <SourceAttributeID>年</SourceAttributeID>
        </Level>
        <Level dwd:design-time-name="eeaeb7ce-394a-4157-b9b2-a6fbcf1711c2">
          <ID>半年</ID>
          <Name>半年</Name>
          <SourceAttributeID>半年</SourceAttributeID>
        </Level>
        <Level dwd:design-time-name="3127c5ec-8b8e-4c60-a479-f5c779f52398">
          <ID>季度</ID>
          <Name>季度</Name>
          <SourceAttributeID>季度</SourceAttributeID>
        </Level>
        <Level dwd:design-time-name="f7234ffe-2a6d-4cf0-8e28-fb26e833d53d">
          <ID>月份</ID>
          <Name>月份</Name>
          <SourceAttributeID>月份</SourceAttributeID>
        </Level>
        <Level dwd:design-time-name="12a968c1-7a8f-4b5b-974c-d6651a8b570b">
          <ID>日期</ID>
          <Name>日期</Name>
          <SourceAttributeID>日期</SourceAttributeID>
        </Level>
      </Levels>
    </Hierarchy>
    <Hierarchy dwd:design-time-name="43faa674-2f8e-48e8-9e34-cef9a2c114e8">
      <ID>年 -  周 -  日期</ID>
      <Name>年 -  周 -  日期</Name>
      <Levels>
        <Level dwd:design-time-name="2455c9cf-122a-4f68-b514-dba78bbf3c94">
          <ID>年</ID>
          <Name>年</Name>
          <SourceAttributeID>年</SourceAttributeID>
        </Level>
        <Level dwd:design-time-name="d762128c-f9ce-4239-bb86-f99c365ef3ff">
          <ID>周</ID>
          <Name>周</Name>
          <SourceAttributeID>周</SourceAttributeID>
        </Level>
        <Level dwd:design-time-name="f163bcac-4bde-432a-87ac-51a4f54c6952">
          <ID>日期</ID>
          <Name>日期</Name>
          <SourceAttributeID>日期</SourceAttributeID>
        </Level>
      </Levels>
    </Hierarchy>
  </Hierarchies>
</Dimension>
上一页 1 23
⌨️ 快捷键说明

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