createdatabase.xmla

< SQL Server2005程序设计>

<Execute xmlns="urn:schemas-microsoft-com:xml-analysis">
  <Command>
    <Create AllowOverwrite="true" xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
      <ParentObject></ParentObject>
      <ObjectDefinition>
        <Database xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
          <ID>Foodmart</ID>
          <Name>Foodmart</Name>
          <Dimensions>
            <Dimension>
              <ID>Product</ID>
              <Name>Product</Name>
              <Source xsi:type="DataSourceViewBinding">
                <DataSourceViewID>Food Mart 2000</DataSourceViewID>
              </Source>
              <Attributes>
                <Attribute>
                  <ID>Product Name</ID>
                  <Name>Product Name</Name>
                  <Usage>Key</Usage>
                  <KeyColumns>
                    <KeyColumn>
                      <DataType>Integer</DataType>
                      <Source xsi:type="ColumnBinding">
                        <TableID>product</TableID>
                        <ColumnID>product_id</ColumnID>
                      </Source>
                    </KeyColumn>
                  </KeyColumns>
                  <NameColumn>
                    <DataType>WChar</DataType>
                    <Source xsi:type="ColumnBinding">
                      <TableID>product</TableID>
                      <ColumnID>product_name</ColumnID>
                    </Source>
                  </NameColumn>
                  <AttributeRelationships>
                    <AttributeRelationship>
                      <AttributeID>Brand Name</AttributeID>
                      <RelationshipType>Flexible</RelationshipType>
                    </AttributeRelationship>
                  </AttributeRelationships>
                </Attribute>
                <Attribute>
                  <ID>Brand Name</ID>
                  <Name>Brand Name</Name>
                  <KeyColumns>
                    <KeyColumn>
                      <DataType>Integer</DataType>
                      <DataSize>-1</DataSize>
                      <Source xsi:type="ColumnBinding">
                        <TableID>product</TableID>
                        <ColumnID>product_class_id</ColumnID>
                      </Source>
                    </KeyColumn>
                    <KeyColumn>
                      <DataType>WChar</DataType>
                      <DataSize>255</DataSize>
                      <Source xsi:type="ColumnBinding">
                        <TableID>product</TableID>
                        <ColumnID>brand_name</ColumnID>
                      </Source>
                    </KeyColumn>
                  </KeyColumns>
                  <NameColumn>
                    <DataType>WChar</DataType>
                    <Source xsi:type="ColumnBinding">
                      <TableID>product</TableID>
                      <ColumnID>brand_name</ColumnID>
                    </Source>
                  </NameColumn>
                  <AttributeRelationships>
                    <AttributeRelationship>
                      <AttributeID>Product Subcategory</AttributeID>
                      <RelationshipType>Flexible</RelationshipType>
                    </AttributeRelationship>
                  </AttributeRelationships>
                </Attribute>
                <Attribute>
                  <ID>Product Subcategory</ID>
                  <Name>Product Subcategory</Name>
                  <KeyColumns>
                    <KeyColumn>
                      <DataType>WChar</DataType>
                      <DataSize>50</DataSize>
                      <Source xsi:type="ColumnBinding">
                        <TableID>product_class</TableID>
                        <ColumnID>product_subcategory</ColumnID>
                      </Source>
                    </KeyColumn>
                    <KeyColumn>
                      <DataType>WChar</DataType>
                      <DataSize>50</DataSize>
                      <Source xsi:type="ColumnBinding">
                        <TableID>product_class</TableID>
                        <ColumnID>product_category</ColumnID>
                      </Source>
                    </KeyColumn>
                    <KeyColumn>
                      <DataType>WChar</DataType>
                      <DataSize>50</DataSize>
                      <Source xsi:type="ColumnBinding">
                        <TableID>product_class</TableID>
                        <ColumnID>product_department</ColumnID>
                      </Source>
                    </KeyColumn>
                    <KeyColumn>
                      <DataType>WChar</DataType>
                      <DataSize>50</DataSize>
                      <Source xsi:type="ColumnBinding">
                        <TableID>product_class</TableID>
                        <ColumnID>product_family</ColumnID>
                      </Source>
                    </KeyColumn>
                  </KeyColumns>
                  <NameColumn>
                    <DataType>WChar</DataType>
                    <Source xsi:type="ColumnBinding">
                      <TableID>product_class</TableID>
                      <ColumnID>product_subcategory</ColumnID>
                    </Source>
                  </NameColumn>
                  <AttributeRelationships>
                    <AttributeRelationship>
                      <AttributeID>Product Category</AttributeID>
                      <RelationshipType>Flexible</RelationshipType>
                    </AttributeRelationship>
                  </AttributeRelationships>
                </Attribute>
                <Attribute>
                  <ID>Product Category</ID>
                  <Name>Product Category</Name>
                  <KeyColumns>
                    <KeyColumn>
                      <DataType>WChar</DataType>
                      <DataSize>50</DataSize>
                      <Source xsi:type="ColumnBinding">
                        <TableID>product_class</TableID>
                        <ColumnID>product_category</ColumnID>
                      </Source>
                    </KeyColumn>
                    <KeyColumn>
                      <DataType>WChar</DataType>
                      <DataSize>50</DataSize>
                      <Source xsi:type="ColumnBinding">
                        <TableID>product_class</TableID>
                        <ColumnID>product_department</ColumnID>
                      </Source>
                    </KeyColumn>
                    <KeyColumn>
                      <DataType>WChar</DataType>
                      <DataSize>50</DataSize>
                      <Source xsi:type="ColumnBinding">
                        <TableID>product_class</TableID>
                        <ColumnID>product_family</ColumnID>
                      </Source>
                    </KeyColumn>
                  </KeyColumns>
                  <NameColumn>
                    <DataType>WChar</DataType>
                    <Source xsi:type="ColumnBinding">
                      <TableID>product_class</TableID>
                      <ColumnID>product_category</ColumnID>
                    </Source>
                  </NameColumn>
                  <AttributeRelationships>
                    <AttributeRelationship>
                      <AttributeID>Product Department</AttributeID>
                      <RelationshipType>Flexible</RelationshipType>
                    </AttributeRelationship>
                  </AttributeRelationships>
                </Attribute>
                <Attribute>
                  <ID>Product Department</ID>
                  <Name>Product Department</Name>
                  <KeyColumns>
                    <KeyColumn>
                      <DataType>WChar</DataType>
                      <DataSize>50</DataSize>
                      <Source xsi:type="ColumnBinding">
                        <TableID>product_class</TableID>
                        <ColumnID>product_department</ColumnID>
                      </Source>
                    </KeyColumn>
                    <KeyColumn>
                      <DataType>WChar</DataType>
                      <DataSize>50</DataSize>
                      <Source xsi:type="ColumnBinding">
                        <TableID>product_class</TableID>
                        <ColumnID>product_family</ColumnID>
                      </Source>
                    </KeyColumn>
                  </KeyColumns>
                  <NameColumn>
                    <DataType>WChar</DataType>
                    <Source xsi:type="ColumnBinding">
                      <TableID>product_class</TableID>
                      <ColumnID>product_department</ColumnID>
                    </Source>
                  </NameColumn>
                  <AttributeRelationships>
                    <AttributeRelationship>
                      <AttributeID>product_family</AttributeID>
                      <RelationshipType>Flexible</RelationshipType>
                    </AttributeRelationship>
                  </AttributeRelationships>
                </Attribute>
                <Attribute>
                  <ID>product_family</ID>
                  <Name>product_family</Name>
                  <KeyColumns>
                    <KeyColumn>
                      <DataType>WChar</DataType>
                      <Source xsi:type="ColumnBinding">
                        <TableID>product_class</TableID>
                        <ColumnID>product_family</ColumnID>
                      </Source>
                    </KeyColumn>
                  </KeyColumns>
                  <NameColumn>
                    <DataType>WChar</DataType>
                    <Source xsi:type="ColumnBinding">
                      <TableID>product_class</TableID>
                      <ColumnID>product_family</ColumnID>
                    </Source>
                  </NameColumn>
                </Attribute>
              </Attributes>
              <Hierarchies>
                <Hierarchy>
                  <ID>Product Family</ID>
                  <Name>Product Family</Name>
                  <Levels>
                    <Level>
                      <ID>Product Family</ID>
                      <Name>Product Family</Name>
                      <SourceAttributeID>product_family</SourceAttributeID>
                    </Level>
                    <Level>
                      <ID>Product Department</ID>
                      <Name>Product Department</Name>
                      <SourceAttributeID>Product Department</SourceAttributeID>
                    </Level>
                    <Level>
                      <ID>Product Category</ID>
                      <Name>Product Category</Name>
                      <SourceAttributeID>Product Category</SourceAttributeID>
                    </Level>
                    <Level>
                      <ID>Product Subcategory</ID>
                      <Name>Product Subcategory</Name>
                      <SourceAttributeID>Product Subcategory</SourceAttributeID>
                    </Level>
                    <Level>
                      <ID>Brand Name</ID>
                      <Name>Brand Name</Name>
                      <SourceAttributeID>Brand Name</SourceAttributeID>
                    </Level>
                    <Level>
                      <ID>Product Name</ID>
                      <Name>Product Name</Name>
                      <SourceAttributeID>Product Name</SourceAttributeID>
                    </Level>
                  </Levels>
                </Hierarchy>
              </Hierarchies>
            </Dimension>
            <Dimension>
              <ID>Store</ID>
              <Name>Store</Name>
              <Source xsi:type="DataSourceViewBinding">
                <DataSourceViewID>Food Mart 2000</DataSourceViewID>
              </Source>
              <Attributes>
                <Attribute>
                  <ID>Store Name</ID>
                  <Name>Store Name</Name>
                  <Usage>Key</Usage>
                  <KeyColumns>
                    <KeyColumn>
                      <DataType>Integer</DataType>
                      <Source xsi:type="ColumnBinding">
                        <TableID>store</TableID>
                        <ColumnID>store_id</ColumnID>