⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 foodmartsale as.asdatabase

📁 SQL SERVER 2005数据挖掘与商务智能完全解决方案随书光盘,作者：朱德利,出版日期：2007-10-01 页　数： 383 出 版 社： 电子工业
💻 ASDATABASE
📖 第 1 页 / 共 5 页
字号:
🔍
12345 
<Database xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
  <ID>foodmartsale AS</ID>
  <Name>foodmartsale AS</Name>
  <CreatedTimestamp>0001-01-01T00:00:00Z</CreatedTimestamp>
  <LastSchemaUpdate>0001-01-01T00:00:00Z</LastSchemaUpdate>
  <LastProcessed>0001-01-01T00:00:00Z</LastProcessed>
  <State>Unprocessed</State>
  <LastUpdate>0001-01-01T00:00:00Z</LastUpdate>
  <DataSourceImpersonationInfo>
    <ImpersonationMode>Default</ImpersonationMode>
    <ImpersonationInfoSecurity>Unchanged</ImpersonationInfoSecurity>
  </DataSourceImpersonationInfo>
  <Dimensions>
    <Dimension>
      <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">
        <DataSourceViewID>Foodmartsale DW</DataSourceViewID>
      </Source>
      <Type>Time</Type>
      <CurrentStorageMode>Molap</CurrentStorageMode>
      <Attributes>
        <Attribute>
          <ID>年</ID>
          <Name>the_year</Name>
          <Type>Years</Type>
          <KeyColumns>
            <KeyColumn>
              <DataType>SmallInt</DataType>
              <DataSize>-1</DataSize>
              <Source xsi:type="ColumnBinding">
                <TableID>dbo_time_by_day</TableID>
                <ColumnID>the_year</ColumnID>
              </Source>
            </KeyColumn>
          </KeyColumns>
          <NameColumn>
            <DataType>WChar</DataType>
            <DataSize>-1</DataSize>
            <Source xsi:type="ColumnBinding">
              <TableID>dbo_time_by_day</TableID>
              <ColumnID>the_year</ColumnID>
            </Source>
          </NameColumn>
          <OrderBy>Key</OrderBy>
        </Attribute>
        <Attribute>
          <ID>季度</ID>
          <Name>quarter</Name>
          <Type>Quarters</Type>
          <KeyColumns>
            <KeyColumn>
              <DataType>WChar</DataType>
              <DataSize>2</DataSize>
              <Source xsi:type="ColumnBinding">
                <TableID>dbo_time_by_day</TableID>
                <ColumnID>quarter</ColumnID>
              </Source>
            </KeyColumn>
          </KeyColumns>
          <NameColumn>
            <DataType>WChar</DataType>
            <DataSize>2</DataSize>
            <Source xsi:type="ColumnBinding">
              <TableID>dbo_time_by_day</TableID>
              <ColumnID>quarter</ColumnID>
            </Source>
          </NameColumn>
          <OrderBy>Key</OrderBy>
        </Attribute>
        <Attribute>
          <ID>月份</ID>
          <Name>the_month</Name>
          <Type>Months</Type>
          <KeyColumns>
            <KeyColumn>
              <DataType>WChar</DataType>
              <DataSize>15</DataSize>
              <Source xsi:type="ColumnBinding">
                <TableID>dbo_time_by_day</TableID>
                <ColumnID>the_month</ColumnID>
              </Source>
            </KeyColumn>
          </KeyColumns>
          <NameColumn>
            <DataType>WChar</DataType>
            <DataSize>15</DataSize>
            <Source xsi:type="ColumnBinding">
              <TableID>dbo_time_by_day</TableID>
              <ColumnID>the_month</ColumnID>
            </Source>
          </NameColumn>
          <OrderBy>Key</OrderBy>
        </Attribute>
        <Attribute>
          <ID>日期</ID>
          <Name>the_day</Name>
          <Type>Days</Type>
          <KeyColumns>
            <KeyColumn>
              <DataType>WChar</DataType>
              <DataSize>15</DataSize>
              <Source xsi:type="ColumnBinding">
                <TableID>dbo_time_by_day</TableID>
                <ColumnID>the_day</ColumnID>
              </Source>
            </KeyColumn>
          </KeyColumns>
          <NameColumn>
            <DataType>WChar</DataType>
            <DataSize>15</DataSize>
            <Source xsi:type="ColumnBinding">
              <TableID>dbo_time_by_day</TableID>
              <ColumnID>the_day</ColumnID>
            </Source>
          </NameColumn>
          <OrderBy>Key</OrderBy>
        </Attribute>
        <Attribute>
          <ID>time_id</ID>
          <Name>time_id</Name>
          <Usage>Key</Usage>
          <KeyColumns>
            <KeyColumn>
              <DataType>Integer</DataType>
              <DataSize>-1</DataSize>
              <Source xsi:type="ColumnBinding">
                <TableID>dbo_time_by_day</TableID>
                <ColumnID>time_id</ColumnID>
              </Source>
            </KeyColumn>
          </KeyColumns>
          <NameColumn>
            <DataType>WChar</DataType>
            <DataSize>-1</DataSize>
            <Source xsi:type="ColumnBinding">
              <TableID>dbo_time_by_day</TableID>
              <ColumnID>time_id</ColumnID>
            </Source>
          </NameColumn>
          <AttributeRelationships>
            <AttributeRelationship>
              <AttributeID>年</AttributeID>
              <Name>the_year</Name>
            </AttributeRelationship>
            <AttributeRelationship>
              <AttributeID>季度</AttributeID>
              <Name>quarter</Name>
            </AttributeRelationship>
            <AttributeRelationship>
              <AttributeID>月份</AttributeID>
              <Name>the_month</Name>
            </AttributeRelationship>
            <AttributeRelationship>
              <AttributeID>日期</AttributeID>
              <Name>the_day</Name>
            </AttributeRelationship>
          </AttributeRelationships>
          <OrderBy>Key</OrderBy>
        </Attribute>
      </Attributes>
      <Hierarchies>
        <Hierarchy>
          <ID>the_year -  quarter -  the_month -  the_day</ID>
          <Name>the_year -  quarter -  the_month -  the_day</Name>
          <Levels>
            <Level>
              <ID>the_year</ID>
              <Name>the_year</Name>
              <SourceAttributeID>年</SourceAttributeID>
            </Level>
            <Level>
              <ID>quarter</ID>
              <Name>quarter</Name>
              <SourceAttributeID>季度</SourceAttributeID>
            </Level>
            <Level>
              <ID>the_month</ID>
              <Name>the_month</Name>
              <SourceAttributeID>月份</SourceAttributeID>
            </Level>
            <Level>
              <ID>the_day</ID>
              <Name>the_day</Name>
              <SourceAttributeID>日期</SourceAttributeID>
            </Level>
          </Levels>
        </Hierarchy>
      </Hierarchies>
    </Dimension>
    <Dimension>
      <ID>Promotion</ID>
      <Name>Promotion</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">
        <DataSourceViewID>Foodmartsale DW</DataSourceViewID>
      </Source>
      <UnknownMember>Visible</UnknownMember>
      <CurrentStorageMode>Molap</CurrentStorageMode>
      <Attributes>
        <Attribute>
          <ID>Promotion</ID>
          <Name>Promotion</Name>
          <Usage>Key</Usage>
          <EstimatedCount>1864</EstimatedCount>
          <KeyColumns>
            <KeyColumn>
              <NullProcessing>UnknownMember</NullProcessing>
              <DataType>Integer</DataType>
              <Source xsi:type="ColumnBinding">
                <TableID>dbo_promotion</TableID>
                <ColumnID>promotion_id</ColumnID>
              </Source>
            </KeyColumn>
          </KeyColumns>
          <AttributeRelationships>
            <AttributeRelationship>
              <AttributeID>Promotion District Id</AttributeID>
              <Name>Promotion District Id</Name>
            </AttributeRelationship>
            <AttributeRelationship>
              <AttributeID>Promotion Name</AttributeID>
              <Name>Promotion Name</Name>
            </AttributeRelationship>
            <AttributeRelationship>
              <AttributeID>Media Type</AttributeID>
              <Name>Media Type</Name>
            </AttributeRelationship>
            <AttributeRelationship>
              <AttributeID>Cost</AttributeID>
              <Name>Cost</Name>
            </AttributeRelationship>
            <AttributeRelationship>
              <AttributeID>Start Date</AttributeID>
              <Name>Start Date</Name>
            </AttributeRelationship>
            <AttributeRelationship>
              <AttributeID>End Date</AttributeID>
              <Name>End Date</Name>
            </AttributeRelationship>
          </AttributeRelationships>
          <OrderBy>Key</OrderBy>
          <InstanceSelection>FilteredList</InstanceSelection>
        </Attribute>
        <Attribute>
          <ID>Promotion District Id</ID>
          <Name>Promotion District Id</Name>
          <EstimatedCount>25</EstimatedCount>
          <KeyColumns>
            <KeyColumn>
              <DataType>Integer</DataType>
              <Source xsi:type="ColumnBinding">
                <TableID>dbo_promotion</TableID>
                <ColumnID>promotion_district_id</ColumnID>
              </Source>
            </KeyColumn>
          </KeyColumns>
          <OrderBy>Key</OrderBy>
          <InstanceSelection>DropDown</InstanceSelection>
        </Attribute>
        <Attribute>
          <ID>Promotion Name</ID>
          <Name>Promotion Name</Name>
          <EstimatedCount>51</EstimatedCount>
          <KeyColumns>
            <KeyColumn>
              <DataType>WChar</DataType>
              <DataSize>255</DataSize>
              <Source xsi:type="ColumnBinding">
                <TableID>dbo_promotion</TableID>
                <ColumnID>promotion_name</ColumnID>
12345

⌨️ 快捷键说明

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