📄 时间.dim

📁 SQL SERVER 2005数据挖掘与商务智能完全解决方案随书光盘,作者：朱德利,出版日期：2007-10-01 页　数： 383 出版社：电子工业
💻 DIM
📖 第 1 页 / 共 2 页
字号:
上一页 12
      </NameColumn>
      <AttributeRelationships>
        <AttributeRelationship dwd:design-time-name="dda04c64-435e-4f7c-bd14-0ef17d1ac66b">
          <AttributeID>Fiscal Quarter</AttributeID>
          <Name>Fiscal Quarter</Name>
        </AttributeRelationship>
        <AttributeRelationship dwd:design-time-name="12db1dba-3a86-4414-867e-2498ec3b5912">
          <AttributeID>Calendar Quarter</AttributeID>
          <Name>Calendar Quarter</Name>
        </AttributeRelationship>
      </AttributeRelationships>
      <OrderBy>Key</OrderBy>
    </Attribute>
    <Attribute dwd:design-time-name="6462920e-9fce-4563-a724-6c0de2c9d665">
      <ID>TimeKey</ID>
      <Name>Date</Name>
      <Usage>Key</Usage>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="91d82014-845c-454f-b9d0-081e14837bf9">
          <DataType>Integer</DataType>
          <DataSize>-1</DataSize>
          <Source xsi:type="ColumnBinding" dwd:design-time-name="ff40784b-6deb-4af5-8e8d-657f53038d63">
            <TableID>dbo_DimTime</TableID>
            <ColumnID>TimeKey</ColumnID>
          </Source>
        </KeyColumn>
      </KeyColumns>
      <NameColumn dwd:design-time-name="2a7088ea-967a-4762-a0c3-0084b4f9e181">
        <DataType>WChar</DataType>
        <DataSize>93</DataSize>
        <Source xsi:type="ColumnBinding" dwd:design-time-name="2fe8fdf1-2250-4b4a-b19e-ce78d1d130aa">
          <TableID>dbo_DimTime</TableID>
          <ColumnID>SimpleDate</ColumnID>
        </Source>
      </NameColumn>
      <AttributeRelationships>
        <AttributeRelationship dwd:design-time-name="00cb9526-edba-4196-b903-2f7234f567fb">
          <AttributeID>English Month Name</AttributeID>
          <Name>Month Name</Name>
        </AttributeRelationship>
      </AttributeRelationships>
      <OrderBy>Key</OrderBy>
    </Attribute>
    <Attribute dwd:design-time-name="64432666-d75d-494e-9037-a8db4b684bb1">
      <ID>Fiscal Quarter</ID>
      <Name>Fiscal Quarter</Name>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="d928d441-5602-4c53-a075-a4b1a4b3855f">
          <DataType>WChar</DataType>
          <DataSize>4</DataSize>
          <Source xsi:type="ColumnBinding" dwd:design-time-name="9bc0e8ec-461c-4e9d-b193-96491bbdc147">
            <TableID>dbo_DimTime</TableID>
            <ColumnID>FiscalYear</ColumnID>
          </Source>
        </KeyColumn>
        <KeyColumn dwd:design-time-name="8c1d2f0c-003c-44b8-b341-7cab77757ef8">
          <DataType>UnsignedTinyInt</DataType>
          <Source xsi:type="ColumnBinding" dwd:design-time-name="b1342aeb-f731-46b5-a812-644542b4074b">
            <TableID>dbo_DimTime</TableID>
            <ColumnID>FiscalQuarter</ColumnID>
          </Source>
        </KeyColumn>
      </KeyColumns>
      <NameColumn dwd:design-time-name="248e6407-06bd-444d-9501-206ab8c3d609">
        <DataType>WChar</DataType>
        <DataSize>10</DataSize>
        <Source xsi:type="ColumnBinding" dwd:design-time-name="961db911-df41-4101-9045-7577d3a0a3ba">
          <TableID>dbo_DimTime</TableID>
          <ColumnID>FiscalQuarterDesc</ColumnID>
        </Source>
      </NameColumn>
      <AttributeRelationships>
        <AttributeRelationship dwd:design-time-name="b2a4c075-07fc-40c3-b0f0-781f5c2953a7">
          <AttributeID>Fiscal Semester</AttributeID>
          <Name>Fiscal Semester</Name>
        </AttributeRelationship>
      </AttributeRelationships>
      <AttributeHierarchyDisplayFolder>Fiscal</AttributeHierarchyDisplayFolder>
    </Attribute>
    <Attribute dwd:design-time-name="133cc676-5a6d-44df-b29e-435a39aa677b">
      <ID>Fiscal Semester</ID>
      <Name>Fiscal Semester</Name>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="2e24eaf8-1857-4b65-a274-13924aae6738">
          <DataType>WChar</DataType>
          <DataSize>4</DataSize>
          <Source xsi:type="ColumnBinding" dwd:design-time-name="daa0e4af-f69c-4b82-9b38-2efa028e2cde">
            <TableID>dbo_DimTime</TableID>
            <ColumnID>FiscalYear</ColumnID>
          </Source>
        </KeyColumn>
        <KeyColumn dwd:design-time-name="7724a2c8-8e4e-4b19-ba3f-3071c3a8ad91">
          <DataType>UnsignedTinyInt</DataType>
          <Source xsi:type="ColumnBinding" dwd:design-time-name="cb9e19b6-683d-4eec-8f63-1f7973a7850c">
            <TableID>dbo_DimTime</TableID>
            <ColumnID>FiscalSemester</ColumnID>
          </Source>
        </KeyColumn>
      </KeyColumns>
      <NameColumn dwd:design-time-name="9b1033ea-d11e-4dc1-baa0-46c87163432c">
        <DataType>WChar</DataType>
        <DataSize>10</DataSize>
        <Source xsi:type="ColumnBinding" dwd:design-time-name="3bf60312-2926-46cf-9627-5936856c5568">
          <TableID>dbo_DimTime</TableID>
          <ColumnID>FiscalSemesterDesc</ColumnID>
        </Source>
      </NameColumn>
      <AttributeRelationships>
        <AttributeRelationship dwd:design-time-name="55601758-0d37-41a8-ae27-77aa1e44b14a">
          <AttributeID>Fiscal Year</AttributeID>
          <Name>Fiscal Year</Name>
        </AttributeRelationship>
      </AttributeRelationships>
      <AttributeHierarchyDisplayFolder>Fiscal</AttributeHierarchyDisplayFolder>
    </Attribute>
    <Attribute dwd:design-time-name="bd874c7b-32db-4e05-b885-1fe14ac66af7">
      <ID>Fiscal Year</ID>
      <Name>Fiscal Year</Name>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="45ca0a38-ece5-4a51-b910-82684c7814fa">
          <DataType>WChar</DataType>
          <DataSize>4</DataSize>
          <Source xsi:type="ColumnBinding" dwd:design-time-name="fa05b6be-5520-44e2-a6f5-8cae02ea93d8">
            <TableID>dbo_DimTime</TableID>
            <ColumnID>FiscalYear</ColumnID>
          </Source>
        </KeyColumn>
      </KeyColumns>
      <NameColumn dwd:design-time-name="8658fbf0-87a4-4734-a927-a903de817f1f">
        <DataType>WChar</DataType>
        <DataSize>7</DataSize>
        <Source xsi:type="ColumnBinding" dwd:design-time-name="97b0f5c6-4398-4765-8364-ba9f189e2654">
          <TableID>dbo_DimTime</TableID>
          <ColumnID>FiscalYearDesc</ColumnID>
        </Source>
      </NameColumn>
      <AttributeHierarchyDisplayFolder>Fiscal</AttributeHierarchyDisplayFolder>
    </Attribute>
  </Attributes>
  <AttributeAllMemberName>All Periods</AttributeAllMemberName>
  <Hierarchies>
    <Hierarchy dwd:design-time-name="89bd79cc-6cb7-49ae-be9d-cbb84db669c3">
      <ID>Calendar Year -  Calendar Semester -  Calendar Quarter -  English Month Name -  Full Date Alternate</ID>
      <Name>Calendar Time</Name>
      <DisplayFolder>Calendar</DisplayFolder>
      <AllMemberName>All Periods</AllMemberName>
      <Levels>
        <Level dwd:design-time-name="c3dcbb11-edbd-4522-b8d1-065322658ad1">
          <ID>Calendar Year</ID>
          <Name>Calendar Year</Name>
          <SourceAttributeID>Calendar Year</SourceAttributeID>
        </Level>
        <Level dwd:design-time-name="0eb40b36-a0ae-4d12-a294-2bb18369bec8">
          <ID>Calendar Semester</ID>
          <Name>Calendar Semester</Name>
          <SourceAttributeID>Calendar Semester</SourceAttributeID>
        </Level>
        <Level dwd:design-time-name="b0f3b309-acf2-473d-8dd0-cffed5ad7fcb">
          <ID>Calendar Quarter</ID>
          <Name>Calendar Quarter</Name>
          <SourceAttributeID>Calendar Quarter</SourceAttributeID>
        </Level>
        <Level dwd:design-time-name="09fa7efe-ff05-44c1-a785-c3ff54397687">
          <ID>English Month Name</ID>
          <Name>Calendar Month</Name>
          <SourceAttributeID>English Month Name</SourceAttributeID>
        </Level>
        <Level dwd:design-time-name="2f99e4dd-aaba-44e1-bcd9-167515afa568">
          <ID>Full Date Alternate Key</ID>
          <Name>Date</Name>
          <SourceAttributeID>TimeKey</SourceAttributeID>
        </Level>
      </Levels>
    </Hierarchy>
    <Hierarchy dwd:design-time-name="2ccd617a-b38a-477a-8bb7-788893ff851a">
      <ID>Hierarchy</ID>
      <Name>Fiscal Time</Name>
      <DisplayFolder>Fiscal</DisplayFolder>
      <AllMemberName>All Periods</AllMemberName>
      <Levels>
        <Level dwd:design-time-name="9a1bf10e-4959-4f66-908e-b002337864bb">
          <ID>Fiscal Year</ID>
          <Name>Fiscal Year</Name>
          <SourceAttributeID>Fiscal Year</SourceAttributeID>
        </Level>
        <Level dwd:design-time-name="54a6e1ab-d9e1-4e24-a921-83a92668d271">
          <ID>Fiscal Semester</ID>
          <Name>Fiscal Semester</Name>
          <SourceAttributeID>Fiscal Semester</SourceAttributeID>
        </Level>
        <Level dwd:design-time-name="4311f394-378b-4e8c-bd39-29d2fe4f4f8d">
          <ID>Fiscal Quarter</ID>
          <Name>Fiscal Quarter</Name>
          <SourceAttributeID>Fiscal Quarter</SourceAttributeID>
        </Level>
        <Level dwd:design-time-name="2531aa51-a95d-42a4-a1b8-3b1ef22b2fea">
          <ID>Month Name</ID>
          <Name>Fiscal Month</Name>
          <SourceAttributeID>English Month Name</SourceAttributeID>
        </Level>
        <Level dwd:design-time-name="f75a3278-55d6-452f-be10-307bed5d1c2c">
          <ID>Date</ID>
          <Name>Date</Name>
          <SourceAttributeID>TimeKey</SourceAttributeID>
        </Level>
      </Levels>
    </Hierarchy>
  </Hierarchies>
</Dimension>
上一页 12
⌨️ 快捷键说明

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