time by day.dim

来自「SQL SERVER 2005数据挖掘与商务智能完全解决方案随书光盘,作者：朱德」· DIM 代码 · 共 218 行

<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="bdda54ba-0500-4a59-b4d6-9b6e0c462e22" xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
  <ID>Time By Day</ID>
  <Name>Time By Day</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>
    </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>0</Value>
    </Annotation>
    <Annotation>
      <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramViewPortTop</Name>
      <Value>0</Value>
    </Annotation>
    <Annotation>
      <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramBoundingLeft</Name>
      <Value>0</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>100</Value>
    </Annotation>
  </Annotations>
  <LastProcessed>0001-01-01T00:00:00Z</LastProcessed>
  <State>Unprocessed</State>
  <Source xsi:type="DataSourceViewBinding" dwd:design-time-name="8f2430c7-ddc7-4d48-89ac-42aab0e0a019">
    <DataSourceViewID>Foodmartsale DW</DataSourceViewID>
  </Source>
  <Type>Time</Type>
  <CurrentStorageMode>Molap</CurrentStorageMode>
  <Attributes>
    <Attribute dwd:design-time-name="512b5b7a-68b4-49a0-ae8c-b2db14ce5191">
      <ID>年</ID>
      <Name>the_year</Name>
      <Type>Years</Type>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="df1a16aa-cf70-4a94-95d3-fb1cc2056dc3">
          <DataType>SmallInt</DataType>
          <DataSize>-1</DataSize>
          <Source xsi:type="ColumnBinding" dwd:design-time-name="1bf7b856-f5ff-4ca5-85d5-dbd33509e7e9">
            <TableID>dbo_time_by_day</TableID>
            <ColumnID>the_year</ColumnID>
          </Source>
        </KeyColumn>
      </KeyColumns>
      <NameColumn dwd:design-time-name="b47701d0-8fc4-42ff-99b9-f78a677776b1">
        <DataType>WChar</DataType>
        <DataSize>-1</DataSize>
        <Source xsi:type="ColumnBinding" dwd:design-time-name="0f56d9d2-1fd8-414c-8de6-5bf7a9742df4">
          <TableID>dbo_time_by_day</TableID>
          <ColumnID>the_year</ColumnID>
        </Source>
      </NameColumn>
      <OrderBy>Key</OrderBy>
    </Attribute>
    <Attribute dwd:design-time-name="4d8e6f0b-05b9-4699-bbac-7e3eba00eac4">
      <ID>季度</ID>
      <Name>quarter</Name>
      <Type>Quarters</Type>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="c9371f58-e139-4567-9341-4a4d80097fbe">
          <DataType>WChar</DataType>
          <DataSize>2</DataSize>
          <Source xsi:type="ColumnBinding" dwd:design-time-name="97593471-f1dd-4e51-8e43-ff90b0a5f067">
            <TableID>dbo_time_by_day</TableID>
            <ColumnID>quarter</ColumnID>
          </Source>
        </KeyColumn>
      </KeyColumns>
      <NameColumn dwd:design-time-name="670a1cda-9722-4603-a528-7921b17c5300">
        <DataType>WChar</DataType>
        <DataSize>2</DataSize>
        <Source xsi:type="ColumnBinding" dwd:design-time-name="6dacfbd3-1589-4ba0-b166-85549136f3ea">
          <TableID>dbo_time_by_day</TableID>
          <ColumnID>quarter</ColumnID>
        </Source>
      </NameColumn>
      <OrderBy>Key</OrderBy>
    </Attribute>
    <Attribute dwd:design-time-name="bffc1e1e-b457-4212-a5e4-18a86fa4826c">
      <ID>月份</ID>
      <Name>the_month</Name>
      <Type>Months</Type>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="53e1e7ad-75fd-4ded-a3b4-67dde917650b">
          <DataType>WChar</DataType>
          <DataSize>15</DataSize>
          <Source xsi:type="ColumnBinding" dwd:design-time-name="425ba98e-1ddb-476f-a8ba-d1d3dde962df">
            <TableID>dbo_time_by_day</TableID>
            <ColumnID>the_month</ColumnID>
          </Source>
        </KeyColumn>
      </KeyColumns>
      <NameColumn dwd:design-time-name="88e2de2d-1e39-4413-99a9-a018a164b53e">
        <DataType>WChar</DataType>
        <DataSize>15</DataSize>
        <Source xsi:type="ColumnBinding" dwd:design-time-name="db630b99-438d-4a46-9abb-7930cb242d75">
          <TableID>dbo_time_by_day</TableID>
          <ColumnID>the_month</ColumnID>
        </Source>
      </NameColumn>
      <OrderBy>Key</OrderBy>
    </Attribute>
    <Attribute dwd:design-time-name="5460869b-0fc2-4fad-bc39-be9d933f4a74">
      <ID>日期</ID>
      <Name>the_day</Name>
      <Type>Days</Type>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="c97ec5ea-650d-4c28-b1ba-5e0df7bc57ca">
          <DataType>WChar</DataType>
          <DataSize>15</DataSize>
          <Source xsi:type="ColumnBinding" dwd:design-time-name="1955dbca-ef06-458d-9ae9-84a26824def8">
            <TableID>dbo_time_by_day</TableID>
            <ColumnID>the_day</ColumnID>
          </Source>
        </KeyColumn>
      </KeyColumns>
      <NameColumn dwd:design-time-name="71d862f8-06aa-4803-af11-8ce13bf2ae81">
        <DataType>WChar</DataType>
        <DataSize>15</DataSize>
        <Source xsi:type="ColumnBinding" dwd:design-time-name="f73423c7-24cc-4f23-aafb-f6516a908c00">
          <TableID>dbo_time_by_day</TableID>
          <ColumnID>the_day</ColumnID>
        </Source>
      </NameColumn>
      <OrderBy>Key</OrderBy>
    </Attribute>
    <Attribute dwd:design-time-name="e98db5ba-8023-4ade-a463-5a0aacb5661c">
      <ID>time_id</ID>
      <Name>time_id</Name>
      <Usage>Key</Usage>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="572153f9-ed84-4e53-916c-30cc6425b892">
          <DataType>Integer</DataType>
          <DataSize>-1</DataSize>
          <Source xsi:type="ColumnBinding" dwd:design-time-name="f0195ac3-81be-46a4-bdfe-04e74ef78e65">
            <TableID>dbo_time_by_day</TableID>
            <ColumnID>time_id</ColumnID>
          </Source>
        </KeyColumn>
      </KeyColumns>
      <NameColumn dwd:design-time-name="42a3c728-50c5-48c4-af7c-d03dc1c93e5a">
        <DataType>WChar</DataType>
        <DataSize>-1</DataSize>
        <Source xsi:type="ColumnBinding" dwd:design-time-name="63282895-0088-4dd0-af98-9d3137a0670b">
          <TableID>dbo_time_by_day</TableID>
          <ColumnID>time_id</ColumnID>
        </Source>
      </NameColumn>
      <AttributeRelationships>
        <AttributeRelationship dwd:design-time-name="312e0118-2383-4095-a082-9b7a3ef54a3e">
          <AttributeID>年</AttributeID>
          <Name>the_year</Name>
        </AttributeRelationship>
        <AttributeRelationship dwd:design-time-name="911cef9f-ce20-497d-8efa-520bd584c398">
          <AttributeID>季度</AttributeID>
          <Name>quarter</Name>
        </AttributeRelationship>
        <AttributeRelationship dwd:design-time-name="cf2699a6-2a7e-4343-8995-8f71a6361d3d">
          <AttributeID>月份</AttributeID>
          <Name>the_month</Name>
        </AttributeRelationship>
        <AttributeRelationship dwd:design-time-name="aad0f00c-1062-4124-b582-06dcf525d647">
          <AttributeID>日期</AttributeID>
          <Name>the_day</Name>
        </AttributeRelationship>
      </AttributeRelationships>
      <OrderBy>Key</OrderBy>
    </Attribute>
  </Attributes>
  <Hierarchies>
    <Hierarchy dwd:design-time-name="740debfe-7a5b-4965-95bb-211eecbbe98c">
      <ID>the_year -  quarter -  the_month -  the_day</ID>
      <Name>the_year -  quarter -  the_month -  the_day</Name>
      <Levels>
        <Level dwd:design-time-name="a02a618a-8739-4d75-a054-714356626da6">
          <ID>the_year</ID>
          <Name>the_year</Name>
          <SourceAttributeID>年</SourceAttributeID>
        </Level>
        <Level dwd:design-time-name="7c81b334-0cfa-4ea9-a1bd-ef997845ac60">
          <ID>quarter</ID>
          <Name>quarter</Name>
          <SourceAttributeID>季度</SourceAttributeID>
        </Level>
        <Level dwd:design-time-name="5de562be-3af8-4883-907e-d108faed306d">
          <ID>the_month</ID>
          <Name>the_month</Name>
          <SourceAttributeID>月份</SourceAttributeID>
        </Level>
        <Level dwd:design-time-name="7497f019-2054-43f7-8d54-5e23ee3b85ec">
          <ID>the_day</ID>
          <Name>the_day</Name>
          <SourceAttributeID>日期</SourceAttributeID>
        </Level>
      </Levels>
    </Hierarchy>
  </Hierarchies>
</Dimension>