servertime.dim

< SQL Server2005程序设计>

<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="458e8b02-95f4-418d-8b54-0fe36154e778" xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
  <ID>Time 1</ID>
  <Name>ServerTime</Name>
  <CreatedTimestamp>0001-01-01T05:00:00Z</CreatedTimestamp>
  <LastSchemaUpdate>0001-01-01T05: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-01T05:00:00Z</LastProcessed>
  <State>Unprocessed</State>
  <Source xsi:type="TimeBinding" dwd:design-time-name="90404fef-68db-40a5-be15-7bdb08454944">
    <CalendarStartDate>1996-01-01T00:00:00Z</CalendarStartDate>
    <CalendarEndDate>1998-06-30T00:00:00Z</CalendarEndDate>
  </Source>
  <Type>Time</Type>
  <CurrentStorageMode>Molap</CurrentStorageMode>
  <Attributes>
    <Attribute dwd:design-time-name="bc2f5164-811e-43b5-afa1-85f65e3eeaf8">
      <ID>Year</ID>
      <Name>Year</Name>
      <Type>Years</Type>
      <EstimatedCount>912</EstimatedCount>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="224aef72-fc08-4c15-9cbf-622ebf8be303">
          <DataType>Date</DataType>
          <Source xsi:type="TimeAttributeBinding" dwd:design-time-name="3ae5b578-5dc9-4761-a701-5e77ff30a1c9" />
        </KeyColumn>
      </KeyColumns>
      <NameColumn dwd:design-time-name="654f4541-8cd8-4609-aa37-21d823ef244c">
        <DataType>WChar</DataType>
      </NameColumn>
      <OrderBy>Key</OrderBy>
    </Attribute>
    <Attribute dwd:design-time-name="b2097322-8e5d-4b4f-9ed3-2a8ca6606c0f">
      <ID>Quarter</ID>
      <Name>Quarter</Name>
      <Type>Quarters</Type>
      <EstimatedCount>912</EstimatedCount>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="fd098306-aa2b-4128-b213-f7bf53f81be3">
          <DataType>Date</DataType>
          <Source xsi:type="TimeAttributeBinding" dwd:design-time-name="ff66373b-f40a-4e4f-8ca1-242af80950e7" />
        </KeyColumn>
      </KeyColumns>
      <NameColumn dwd:design-time-name="d1e27e92-ea65-4122-8b11-9ab5b99034c4">
        <DataType>WChar</DataType>
      </NameColumn>
      <AttributeRelationships>
        <AttributeRelationship dwd:design-time-name="45969a2b-4d2f-49d9-8f69-0d144db2c351">
          <AttributeID>Year</AttributeID>
          <RelationshipType>Rigid</RelationshipType>
          <Name>Year</Name>
        </AttributeRelationship>
      </AttributeRelationships>
      <OrderBy>Key</OrderBy>
    </Attribute>
    <Attribute dwd:design-time-name="4345cb3f-c857-4450-b101-323f091ddb76">
      <ID>Month</ID>
      <Name>Month</Name>
      <Type>Months</Type>
      <EstimatedCount>912</EstimatedCount>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="5134111e-558f-41bf-afcc-6ebb370cb31b">
          <DataType>Date</DataType>
          <Source xsi:type="TimeAttributeBinding" dwd:design-time-name="08f4946f-b69b-4db5-b665-7e3dc4e136bc" />
        </KeyColumn>
      </KeyColumns>
      <NameColumn dwd:design-time-name="ef7f4d09-591e-4ef9-95ec-f9af17d6daef">
        <DataType>WChar</DataType>
      </NameColumn>
      <AttributeRelationships>
        <AttributeRelationship dwd:design-time-name="e8ca6fa2-d420-4a3a-9716-74a4bbe07e2a">
          <AttributeID>Quarter</AttributeID>
          <RelationshipType>Rigid</RelationshipType>
          <Name>Quarter</Name>
        </AttributeRelationship>
        <AttributeRelationship dwd:design-time-name="18af9fa5-4450-4170-8e07-b1cb9f3eb7a2">
          <AttributeID>Quarter of Year</AttributeID>
          <RelationshipType>Rigid</RelationshipType>
          <Name>Quarter of Year</Name>
        </AttributeRelationship>
      </AttributeRelationships>
      <OrderBy>Key</OrderBy>
    </Attribute>
    <Attribute dwd:design-time-name="20493267-a112-4000-9a97-a89f7ab68248">
      <ID>Date</ID>
      <Name>Date</Name>
      <Type>Days</Type>
      <Usage>Key</Usage>
      <EstimatedCount>911</EstimatedCount>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="37219c05-3337-4448-b055-a23b2795eddf">
          <DataType>Date</DataType>
          <Source xsi:type="TimeAttributeBinding" dwd:design-time-name="796a1e95-2d24-4b53-a8b2-4989eb425486" />
        </KeyColumn>
      </KeyColumns>
      <NameColumn dwd:design-time-name="b2415ef3-10d0-4278-98f0-f88129ceebe3">
        <DataType>WChar</DataType>
      </NameColumn>
      <AttributeRelationships>
        <AttributeRelationship dwd:design-time-name="0025f2fb-df67-42bb-9c2f-b5eefdb7c417">
          <AttributeID>Month</AttributeID>
          <RelationshipType>Rigid</RelationshipType>
          <Name>Month</Name>
        </AttributeRelationship>
        <AttributeRelationship dwd:design-time-name="c76d6822-75f9-45e3-9b83-697f9dfd4441">
          <AttributeID>Month of Year</AttributeID>
          <RelationshipType>Rigid</RelationshipType>
          <Name>Month of Year</Name>
        </AttributeRelationship>
        <AttributeRelationship dwd:design-time-name="f126fa23-b275-4a85-ad33-e60660b07fc9">
          <AttributeID>Month of Quarter</AttributeID>
          <RelationshipType>Rigid</RelationshipType>
          <Name>Month of Quarter</Name>
        </AttributeRelationship>
        <AttributeRelationship dwd:design-time-name="ce5f2ceb-f6c7-4d0c-b004-183d7baa5aa8">
          <AttributeID>Day of Year</AttributeID>
          <Name>Day of Year</Name>
        </AttributeRelationship>
        <AttributeRelationship dwd:design-time-name="256f8e92-f08f-4d29-8f96-0e1a4e12cf2c">
          <AttributeID>Day of Quarter</AttributeID>
          <Name>Day of Quarter</Name>
        </AttributeRelationship>
        <AttributeRelationship dwd:design-time-name="fc42fe91-e3dc-42d4-83a4-96febcc5235b">
          <AttributeID>Day of Month</AttributeID>
          <Name>Day of Month</Name>
        </AttributeRelationship>
      </AttributeRelationships>
      <OrderBy>Key</OrderBy>
    </Attribute>
    <Attribute dwd:design-time-name="7cbb716a-9254-43a1-8528-9752358e4695">
      <ID>Day of Year</ID>
      <Name>Day of Year</Name>
      <Type>DayOfYear</Type>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="d57a586e-1fca-46c1-bbd5-5ebee1b21d05">
          <DataType>Integer</DataType>
          <Source xsi:type="TimeAttributeBinding" dwd:design-time-name="76402655-cd66-430c-a792-eb67ac0b0c2e" />
        </KeyColumn>
      </KeyColumns>
      <NameColumn dwd:design-time-name="ef842e79-0978-4e0a-9541-dd135da6fc93">
        <DataType>WChar</DataType>
      </NameColumn>
      <OrderBy>Key</OrderBy>
    </Attribute>
    <Attribute dwd:design-time-name="9965994e-e746-43cc-b662-1aae92d2a838">
      <ID>Day of Quarter</ID>
      <Name>Day of Quarter</Name>
      <Type>DayOfQuarter</Type>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="474fa9af-ffbd-4385-9b67-5284543d9c54">
          <DataType>Integer</DataType>
          <Source xsi:type="TimeAttributeBinding" dwd:design-time-name="8b8b9d67-405c-4f0c-a855-9ee6d42b59b3" />
        </KeyColumn>
      </KeyColumns>
      <NameColumn dwd:design-time-name="6c18a4cb-ec86-4e21-9bda-114447ee7592">
        <DataType>WChar</DataType>
      </NameColumn>
      <OrderBy>Key</OrderBy>
    </Attribute>
    <Attribute dwd:design-time-name="2c8ae28a-a394-484f-b431-3ac5a75cdde0">
      <ID>Day of Month</ID>
      <Name>Day of Month</Name>
      <Type>DayOfMonth</Type>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="6a4a37ad-765f-403c-86ff-1a579618a6b8">
          <DataType>Integer</DataType>
          <Source xsi:type="TimeAttributeBinding" dwd:design-time-name="2d7fcb21-1b41-4275-bbf8-1e015d232c9d" />
        </KeyColumn>
      </KeyColumns>
      <NameColumn dwd:design-time-name="3bb868a1-9889-4835-979e-a6eb4e188f4f">
        <DataType>WChar</DataType>
      </NameColumn>
      <OrderBy>Key</OrderBy>
    </Attribute>
    <Attribute dwd:design-time-name="e05f971a-d271-4d1a-8c0a-cde1ab1b9993">
      <ID>Month of Year</ID>
      <Name>Month of Year</Name>
      <Type>MonthOfYear</Type>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="5ca3d253-cbc5-4c5a-8709-01b06ab2eaf0">
          <DataType>Integer</DataType>
          <Source xsi:type="TimeAttributeBinding" dwd:design-time-name="84228554-2f83-4550-916a-ca076f567454" />
        </KeyColumn>
      </KeyColumns>
      <NameColumn dwd:design-time-name="3bce34dc-b5b5-44fe-82c6-98cc0ca4f57c">
        <DataType>WChar</DataType>
      </NameColumn>
      <OrderBy>Key</OrderBy>
    </Attribute>
    <Attribute dwd:design-time-name="f711e98d-97a3-4fd1-8c3f-8459c4ce23df">
      <ID>Month of Quarter</ID>
      <Name>Month of Quarter</Name>
      <Type>MonthOfQuarter</Type>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="d77b0af3-9336-495e-99c8-98eea4682c51">
          <DataType>Integer</DataType>
          <Source xsi:type="TimeAttributeBinding" dwd:design-time-name="2200656c-7d91-4805-ae23-71a24dba8853" />
        </KeyColumn>
      </KeyColumns>
      <NameColumn dwd:design-time-name="f5aedf95-1950-48a7-8036-824c145becfe">
        <DataType>WChar</DataType>
      </NameColumn>
      <OrderBy>Key</OrderBy>
    </Attribute>
    <Attribute dwd:design-time-name="497bc3f1-2dea-4fbb-97cb-e6fa526c0a6e">
      <ID>Quarter of Year</ID>
      <Name>Quarter of Year</Name>
      <Type>QuarterOfYear</Type>
      <KeyColumns>
        <KeyColumn dwd:design-time-name="59a1ee20-03f9-45b5-a173-529e679a1186">
          <DataType>Integer</DataType>
          <Source xsi:type="TimeAttributeBinding" dwd:design-time-name="0c385265-3b58-4789-81eb-c62ea176dd37" />
        </KeyColumn>
      </KeyColumns>
      <NameColumn dwd:design-time-name="203a151c-ca9c-4ffd-b8dd-a017aadc5b19">
        <DataType>WChar</DataType>
      </NameColumn>
      <OrderBy>Key</OrderBy>
    </Attribute>
  </Attributes>
  <Hierarchies>
    <Hierarchy dwd:design-time-name="b3d095ce-784e-48bb-8fe9-3dee1e2bf6a6">
      <ID>Year -  Quarter -  Month -  Date</ID>
      <Name>Year -  Quarter -  Month -  Date</Name>
      <Levels>
        <Level dwd:design-time-name="61399d90-db57-4f0d-a65d-fcb255c7149b">
          <ID>Year</ID>
          <Name>Year</Name>
          <SourceAttributeID>Year</SourceAttributeID>
        </Level>
        <Level dwd:design-time-name="7aa8b607-10e2-49e6-988f-d56749c3e835">
          <ID>Quarter</ID>
          <Name>Quarter</Name>
          <SourceAttributeID>Quarter</SourceAttributeID>
        </Level>
        <Level dwd:design-time-name="cbe32d14-03e7-4c66-90c8-1427d06b7c1f">
          <ID>Month</ID>
          <Name>Month</Name>
          <SourceAttributeID>Month</SourceAttributeID>
        </Level>
        <Level dwd:design-time-name="f2844c40-d507-4e25-b3b8-777b43eca45b">
          <ID>Date</ID>
          <Name>Date</Name>
          <SourceAttributeID>Date</SourceAttributeID>
        </Level>
      </Levels>
    </Hierarchy>
  </Hierarchies>
</Dimension>