📄 时间.dim

📁 SQL SERVER 2005数据挖掘与商务智能完全解决方案随书光盘,作者：朱德利,出版日期：2007-10-01 页　数： 383 出版社：电子工业
💻 DIM
📖 第 1 页 / 共 2 页
字号:
上一页 12
      <KeyColumns>
        <KeyColumn dwd:design-time-name="23fc80cc-fc86-4796-ba2f-85a29bb2674c">
          <DataType>Integer</DataType>
        </KeyColumn>
      </KeyColumns>
      <NameColumn dwd:design-time-name="e96f6592-d5fe-4477-99b6-ebe23158e5d2">
        <DataType>WChar</DataType>
      </NameColumn>
      <OrderBy>Key</OrderBy>
    </Attribute>
    <Attribute dwd:design-time-name="12d7064f-e481-447e-904d-5ce1f939cfa3">
      <ID>每半年的某一日</ID>
      <Name>每半年的某一日</Name>
      <Type>DayOfHalfYear</Type>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="a497ecd4-ef9d-4789-b5fc-75ca59a41dd8">
          <DataType>Integer</DataType>
        </KeyColumn>
      </KeyColumns>
      <NameColumn dwd:design-time-name="bc73487e-f043-42bc-a4b5-be13146099bb">
        <DataType>WChar</DataType>
      </NameColumn>
      <OrderBy>Key</OrderBy>
    </Attribute>
    <Attribute dwd:design-time-name="51739f1e-df26-4168-8a60-042a112bcdd0">
      <ID>每个季度的某一日</ID>
      <Name>每个季度的某一日</Name>
      <Type>DayOfQuarter</Type>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="1d3fb9b6-3116-46ec-bb66-8afddbd8f0d5">
          <DataType>Integer</DataType>
        </KeyColumn>
      </KeyColumns>
      <NameColumn dwd:design-time-name="7819aa5f-8fcd-4fcd-90c7-ced653fa3c0f">
        <DataType>WChar</DataType>
      </NameColumn>
      <OrderBy>Key</OrderBy>
    </Attribute>
    <Attribute dwd:design-time-name="a6b5e80f-2448-439a-9f4f-232c469cd4ca">
      <ID>每月的某一日</ID>
      <Name>每月的某一日</Name>
      <Type>DayOfMonth</Type>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="82eb7ad3-0012-418b-a861-79a2c61eab9a">
          <DataType>Integer</DataType>
        </KeyColumn>
      </KeyColumns>
      <NameColumn dwd:design-time-name="b43ffa23-cef6-407f-b32b-167e4c11210a">
        <DataType>WChar</DataType>
      </NameColumn>
      <OrderBy>Key</OrderBy>
    </Attribute>
    <Attribute dwd:design-time-name="175cfe3e-2bed-4c94-979e-781a2e30b7e0">
      <ID>每十天的某一日</ID>
      <Name>每十天的某一日</Name>
      <Type>DayOfTenDays</Type>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="905882bf-4488-4f59-88dd-57fa47784a6f">
          <DataType>Integer</DataType>
        </KeyColumn>
      </KeyColumns>
      <NameColumn dwd:design-time-name="2fc4caae-3ca8-429e-b2b5-002c0656e461">
        <DataType>WChar</DataType>
      </NameColumn>
      <OrderBy>Key</OrderBy>
    </Attribute>
    <Attribute dwd:design-time-name="a8571eb2-c71a-46c3-9872-4adb15849fc2">
      <ID>每周的某一日</ID>
      <Name>每周的某一日</Name>
      <Type>DayOfWeek</Type>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="bc3164f0-6743-4e47-bd13-8c9ef3130216">
          <DataType>Integer</DataType>
        </KeyColumn>
      </KeyColumns>
      <NameColumn dwd:design-time-name="5621c4b9-b2ba-4adf-b5b9-5b6ac536e697">
        <DataType>WChar</DataType>
      </NameColumn>
      <OrderBy>Key</OrderBy>
    </Attribute>
    <Attribute dwd:design-time-name="e316df42-6210-448a-8a80-7e0edff2318b">
      <ID>每年的某一周</ID>
      <Name>每年的某一周</Name>
      <Type>WeekOfYear</Type>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="04650d2f-3c41-472a-915d-62a3e25f22e8">
          <DataType>Integer</DataType>
        </KeyColumn>
      </KeyColumns>
      <NameColumn dwd:design-time-name="3ef3c371-b84d-4224-8b61-c0c183464d37">
        <DataType>WChar</DataType>
      </NameColumn>
      <OrderBy>Key</OrderBy>
    </Attribute>
    <Attribute dwd:design-time-name="72e52e7c-94e3-415b-b81a-d5c008bdbb15">
      <ID>每年的某十天</ID>
      <Name>每年的某十天</Name>
      <Type>TenDayOfYear</Type>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="907323e0-69b9-41c0-8f89-4f2ff3fa9f7c">
          <DataType>Integer</DataType>
        </KeyColumn>
      </KeyColumns>
      <NameColumn dwd:design-time-name="f838f15e-1cb5-42d0-9616-fd68087d1991">
        <DataType>WChar</DataType>
      </NameColumn>
      <OrderBy>Key</OrderBy>
    </Attribute>
    <Attribute dwd:design-time-name="2b48547e-67cf-4d59-8407-bee94fb4283b">
      <ID>每半年的某十天</ID>
      <Name>每半年的某十天</Name>
      <Type>TenDayOfHalfYear</Type>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="c40cd48f-ae9b-4e82-9545-39f05a3e07bf">
          <DataType>Integer</DataType>
        </KeyColumn>
      </KeyColumns>
      <NameColumn dwd:design-time-name="ee512932-e209-4a4a-9422-29a977cd7293">
        <DataType>WChar</DataType>
      </NameColumn>
      <OrderBy>Key</OrderBy>
    </Attribute>
    <Attribute dwd:design-time-name="d246f755-a159-45ae-82bf-4016b095e312">
      <ID>每个季度的某十天</ID>
      <Name>每个季度的某十天</Name>
      <Type>TenDayOfQuarter</Type>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="5220391e-547d-4930-a276-09529b15bad9">
          <DataType>Integer</DataType>
        </KeyColumn>
      </KeyColumns>
      <NameColumn dwd:design-time-name="1cded2ab-8407-42a0-93e3-7cde37d7c3aa">
        <DataType>WChar</DataType>
      </NameColumn>
      <OrderBy>Key</OrderBy>
    </Attribute>
    <Attribute dwd:design-time-name="7b8df302-c70a-420b-a1c7-0d037c1e99af">
      <ID>每月的某十天</ID>
      <Name>每月的某十天</Name>
      <Type>TenDayOfMonth</Type>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="2d97abfe-07f7-4ce1-9e00-dc2099bee5b4">
          <DataType>Integer</DataType>
        </KeyColumn>
      </KeyColumns>
      <NameColumn dwd:design-time-name="47d68656-3057-44ab-8d16-7109d74eacac">
        <DataType>WChar</DataType>
      </NameColumn>
      <OrderBy>Key</OrderBy>
    </Attribute>
    <Attribute dwd:design-time-name="368d5488-5b61-4cad-86e8-86325b0a3312">
      <ID>每年的某一月</ID>
      <Name>每年的某一月</Name>
      <Type>MonthOfYear</Type>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="198a1ddd-4d9c-4ad5-ac16-2c021ea20442">
          <DataType>Integer</DataType>
        </KeyColumn>
      </KeyColumns>
      <NameColumn dwd:design-time-name="9ad1ca50-48d3-42d9-a118-5ddae468dc7f">
        <DataType>WChar</DataType>
      </NameColumn>
      <OrderBy>Key</OrderBy>
    </Attribute>
    <Attribute dwd:design-time-name="d5b7c2fb-3b5a-4b90-a24a-3dbfee1a106b">
      <ID>每半年的某一月</ID>
      <Name>每半年的某一月</Name>
      <Type>MonthOfHalfYear</Type>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="3a152182-9981-452e-84ba-f4a898d45c85">
          <DataType>Integer</DataType>
        </KeyColumn>
      </KeyColumns>
      <NameColumn dwd:design-time-name="212cbcc1-a6b9-43dc-ad1d-a221092f06bc">
        <DataType>WChar</DataType>
      </NameColumn>
      <OrderBy>Key</OrderBy>
    </Attribute>
    <Attribute dwd:design-time-name="78dced5a-1da9-48c5-9170-69cc374f3a81">
      <ID>每个季度的某一月</ID>
      <Name>每个季度的某一月</Name>
      <Type>MonthOfQuarter</Type>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="bdc78c11-f89c-4575-961d-95cc7ad12efe">
          <DataType>Integer</DataType>
        </KeyColumn>
      </KeyColumns>
      <NameColumn dwd:design-time-name="2a461fa0-b89a-42f3-9acf-fb4da9cd7703">
        <DataType>WChar</DataType>
      </NameColumn>
      <OrderBy>Key</OrderBy>
    </Attribute>
    <Attribute dwd:design-time-name="a4c45047-4bb8-448f-b732-2e6ce434e212">
      <ID>每年的某一季度</ID>
      <Name>每年的某一季度</Name>
      <Type>QuarterOfYear</Type>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="bb0dd34a-a5ad-4a76-9433-4e5a7de66515">
          <DataType>Integer</DataType>
        </KeyColumn>
      </KeyColumns>
      <NameColumn dwd:design-time-name="62810893-8670-496d-a682-975c7cf0b0ad">
        <DataType>WChar</DataType>
      </NameColumn>
      <OrderBy>Key</OrderBy>
    </Attribute>
    <Attribute dwd:design-time-name="dd3b84ee-8e2b-4135-80d6-165f86309708">
      <ID>每半年的某一季度</ID>
      <Name>每半年的某一季度</Name>
      <Type>QuarterOfHalfYear</Type>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="522cf46f-3f5c-4e3b-ac9a-d6a50080e947">
          <DataType>Integer</DataType>
        </KeyColumn>
      </KeyColumns>
      <NameColumn dwd:design-time-name="ecd095a9-6d7c-4b51-a984-16e4e70868cc">
        <DataType>WChar</DataType>
      </NameColumn>
      <OrderBy>Key</OrderBy>
    </Attribute>
    <Attribute dwd:design-time-name="f0364ed7-0d86-4cf5-b075-4992edd5c5e8">
      <ID>每年的某一半年</ID>
      <Name>每年的某一半年</Name>
      <Type>HalfYearOfYear</Type>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="9d0e5b69-4c94-4954-8d48-5a1521d1c772">
          <DataType>Integer</DataType>
        </KeyColumn>
      </KeyColumns>
      <NameColumn dwd:design-time-name="2e5534d5-b8c1-49ec-bd57-c69a94b0b62b">
        <DataType>WChar</DataType>
      </NameColumn>
      <OrderBy>Key</OrderBy>
    </Attribute>
  </Attributes>
  <Hierarchies>
    <Hierarchy dwd:design-time-name="66921472-adc5-4884-ab34-47a5d0161f02">
      <ID>年 -  半年 -  季度 -  月份 -  十天 -  日期</ID>
      <Name>年 -  半年 -  季度 -  月份 -  十天 -  日期</Name>
      <Levels>
        <Level dwd:design-time-name="9e607813-1b27-4b10-8476-84a6ccf56362">
          <ID>年</ID>
          <Name>年</Name>
          <SourceAttributeID>年</SourceAttributeID>
        </Level>
        <Level dwd:design-time-name="f4d475f2-a3e4-4008-ab09-2c93ca16fc15">
          <ID>半年</ID>
          <Name>半年</Name>
          <SourceAttributeID>半年</SourceAttributeID>
        </Level>
        <Level dwd:design-time-name="7c9e3fbc-7775-4e3f-ad85-37078874bfd1">
          <ID>季度</ID>
          <Name>季度</Name>
          <SourceAttributeID>季度</SourceAttributeID>
        </Level>
        <Level dwd:design-time-name="35168c9b-5855-4336-bbc9-3c5d573d6003">
          <ID>月份</ID>
          <Name>月份</Name>
          <SourceAttributeID>月份</SourceAttributeID>
        </Level>
        <Level dwd:design-time-name="a2d5b060-0f48-4d96-b63b-d085e350938d">
          <ID>十天</ID>
          <Name>十天</Name>
          <SourceAttributeID>十天</SourceAttributeID>
        </Level>
        <Level dwd:design-time-name="303e0cca-3b27-464a-be7b-d11eab12e0d7">
          <ID>日期</ID>
          <Name>日期</Name>
          <SourceAttributeID>日期</SourceAttributeID>
        </Level>
      </Levels>
    </Hierarchy>
    <Hierarchy dwd:design-time-name="d8a5260d-a4ac-431b-b3d1-dce744135650">
      <ID>年 -  周 -  日期</ID>
      <Name>年 -  周 -  日期</Name>
      <Levels>
        <Level dwd:design-time-name="2a2464a4-c7a9-492a-b829-9260a84b2eb1">
          <ID>年</ID>
          <Name>年</Name>
          <SourceAttributeID>年</SourceAttributeID>
        </Level>
        <Level dwd:design-time-name="2b7a59a3-87ac-4d63-9976-0a871f0db212">
          <ID>周</ID>
          <Name>周</Name>
          <SourceAttributeID>周</SourceAttributeID>
        </Level>
        <Level dwd:design-time-name="d5dbc7de-ce1a-40cf-8c23-b96195a1bc65">
          <ID>日期</ID>
          <Name>日期</Name>
          <SourceAttributeID>日期</SourceAttributeID>
        </Level>
      </Levels>
    </Hierarchy>
  </Hierarchies>
</Dimension>
上一页 12
⌨️ 快捷键说明

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