createdatabase.xmla

< SQL Server2005程序设计>

                      </Source>
                    </KeyColumn>
                  </KeyColumns>
                  <NameColumn>
                    <DataType>WChar</DataType>
                    <Source xsi:type="ColumnBinding">
                      <TableID>store</TableID>
                      <ColumnID>store_name</ColumnID>
                    </Source>
                  </NameColumn>
                  <AttributeRelationships>
                    <AttributeRelationship>
                      <AttributeID>store_type</AttributeID>
                      <RelationshipType>Flexible</RelationshipType>
                    </AttributeRelationship>
                    <AttributeRelationship>
                      <AttributeID>Store City</AttributeID>
                      <RelationshipType>Flexible</RelationshipType>
                    </AttributeRelationship>
                  </AttributeRelationships>
                </Attribute>
                <Attribute>
                  <ID>store_type</ID>
                  <Name>store_type</Name>
                  <KeyColumns>
                    <KeyColumn>
                      <DataType>WChar</DataType>
                      <Source xsi:type="ColumnBinding">
                        <TableID>store</TableID>
                        <ColumnID>store_type</ColumnID>
                      </Source>
                    </KeyColumn>
                  </KeyColumns>
                  <NameColumn>
                    <DataType>WChar</DataType>
                    <Source xsi:type="ColumnBinding">
                      <TableID>store</TableID>
                      <ColumnID>store_type</ColumnID>
                    </Source>
                  </NameColumn>
                </Attribute>
                <Attribute>
                  <ID>Store City</ID>
                  <Name>Store City</Name>
                  <AttributeHierarchyDisplayFolder>Geographic</AttributeHierarchyDisplayFolder>
                  <KeyColumns>
                    <KeyColumn>
                      <DataType>WChar</DataType>
                      <DataSize>50</DataSize>
                      <Source xsi:type="ColumnBinding">
                        <TableID>store</TableID>
                        <ColumnID>store_city</ColumnID>
                      </Source>
                    </KeyColumn>
                    <KeyColumn>
                      <DataType>WChar</DataType>
                      <DataSize>50</DataSize>
                      <Source xsi:type="ColumnBinding">
                        <TableID>store</TableID>
                        <ColumnID>store_state</ColumnID>
                      </Source>
                    </KeyColumn>
                    <KeyColumn>
                      <DataType>WChar</DataType>
                      <DataSize>50</DataSize>
                      <Source xsi:type="ColumnBinding">
                        <TableID>store</TableID>
                        <ColumnID>store_country</ColumnID>
                      </Source>
                    </KeyColumn>
                  </KeyColumns>
                  <NameColumn>
                    <DataType>WChar</DataType>
                    <Source xsi:type="ColumnBinding">
                      <TableID>store</TableID>
                      <ColumnID>store_city</ColumnID>
                    </Source>
                  </NameColumn>
                  <AttributeRelationships>
                    <AttributeRelationship>
                      <AttributeID>Store State</AttributeID>
                      <RelationshipType>Flexible</RelationshipType>
                    </AttributeRelationship>
                  </AttributeRelationships>
                </Attribute>
                <Attribute>
                  <ID>Store State</ID>
                  <Name>Store State</Name>
                  <AttributeHierarchyDisplayFolder>Geographic</AttributeHierarchyDisplayFolder>
                  <KeyColumns>
                    <KeyColumn>
                      <DataType>WChar</DataType>
                      <DataSize>50</DataSize>
                      <Source xsi:type="ColumnBinding">
                        <TableID>store</TableID>
                        <ColumnID>store_state</ColumnID>
                      </Source>
                    </KeyColumn>
                    <KeyColumn>
                      <DataType>WChar</DataType>
                      <DataSize>50</DataSize>
                      <Source xsi:type="ColumnBinding">
                        <TableID>store</TableID>
                        <ColumnID>store_country</ColumnID>
                      </Source>
                    </KeyColumn>
                  </KeyColumns>
                  <NameColumn>
                    <DataType>WChar</DataType>
                    <Source xsi:type="ColumnBinding">
                      <TableID>store</TableID>
                      <ColumnID>store_state</ColumnID>
                    </Source>
                  </NameColumn>
                  <AttributeRelationships>
                    <AttributeRelationship>
                      <AttributeID>Store Country</AttributeID>
                      <RelationshipType>Flexible</RelationshipType>
                    </AttributeRelationship>
                  </AttributeRelationships>
                </Attribute>
                <Attribute>
                  <ID>Store Country</ID>
                  <Name>Store Country</Name>
                  <AttributeHierarchyDisplayFolder>Geographic</AttributeHierarchyDisplayFolder>
                  <KeyColumns>
                    <KeyColumn>
                      <DataType>WChar</DataType>
                      <Source xsi:type="ColumnBinding">
                        <TableID>store</TableID>
                        <ColumnID>store_country</ColumnID>
                      </Source>
                    </KeyColumn>
                  </KeyColumns>
                  <NameColumn>
                    <DataType>WChar</DataType>
                    <Source xsi:type="ColumnBinding">
                      <TableID>store</TableID>
                      <ColumnID>store_country</ColumnID>
                    </Source>
                  </NameColumn>
                </Attribute>
              </Attributes>
              <Hierarchies>
                <Hierarchy>
                  <ID>Store Type</ID>
                  <Name>Store Type</Name>
                  <Levels>
                    <Level>
                      <ID>Store Type</ID>
                      <Name>Store Type</Name>
                      <SourceAttributeID>store_type</SourceAttributeID>
                    </Level>
                    <Level>
                      <ID>Store Name</ID>
                      <Name>Store Name</Name>
                      <SourceAttributeID>Store Name</SourceAttributeID>
                    </Level>
                  </Levels>
                </Hierarchy>
                <Hierarchy>
                  <ID>Store Location</ID>
                  <Name>Store Location</Name>
                  <DisplayFolder>Geographic</DisplayFolder>
                  <Levels>
                    <Level>
                      <ID>Store Country</ID>
                      <Name>Store Country</Name>
                      <SourceAttributeID>Store Country</SourceAttributeID>
                    </Level>
                    <Level>
                      <ID>Store State</ID>
                      <Name>Store State</Name>
                      <SourceAttributeID>Store State</SourceAttributeID>
                    </Level>
                    <Level>
                      <ID>Store City</ID>
                      <Name>Store City</Name>
                      <SourceAttributeID>Store City</SourceAttributeID>
                    </Level>
                    <Level>
                      <ID>Store Name</ID>
                      <Name>Store Name</Name>
                      <SourceAttributeID>Store Name</SourceAttributeID>
                    </Level>
                  </Levels>
                </Hierarchy>
              </Hierarchies>
            </Dimension>
            <Dimension>
              <ID>Promotion</ID>
              <Name>Promotion</Name>
              <Source xsi:type="DataSourceViewBinding">
                <DataSourceViewID>Food Mart 2000</DataSourceViewID>
              </Source>
              <Attributes>
                <Attribute>
                  <ID>promotion_id</ID>
                  <Name>promotion_id</Name>
                  <Usage>Key</Usage>
                  <KeyColumns>
                    <KeyColumn>
                      <DataType>Integer</DataType>
                      <Source xsi:type="ColumnBinding">
                        <TableID>promotion</TableID>
                        <ColumnID>promotion_id</ColumnID>
                      </Source>
                    </KeyColumn>
                  </KeyColumns>
                  <NameColumn>
                    <DataType>WChar</DataType>
                    <Source xsi:type="ColumnBinding">
                      <TableID>promotion</TableID>
                      <ColumnID>promotion_id</ColumnID>
                    </Source>
                  </NameColumn>
                  <AttributeRelationships>
                    <AttributeRelationship>
                      <AttributeID>promotion_name</AttributeID>
                      <RelationshipType>Flexible</RelationshipType>
                    </AttributeRelationship>
                    <AttributeRelationship>
                      <AttributeID>media_type</AttributeID>
                      <RelationshipType>Flexible</RelationshipType>
                    </AttributeRelationship>
                  </AttributeRelationships>
                </Attribute>
                <Attribute>
                  <ID>promotion_name</ID>
                  <Name>promotion_name</Name>
                  <KeyColumns>
                    <KeyColumn>
                      <DataType>WChar</DataType>
                      <Source xsi:type="ColumnBinding">
                        <TableID>promotion</TableID>
                        <ColumnID>promotion_name</ColumnID>
                      </Source>
                    </KeyColumn>
                  </KeyColumns>
                  <NameColumn>
                    <DataType>WChar</DataType>
                    <Source xsi:type="ColumnBinding">
                      <TableID>promotion</TableID>
                      <ColumnID>promotion_name</ColumnID>
                    </Source>
                  </NameColumn>
                </Attribute>
                <Attribute>
                  <ID>media_type</ID>
                  <Name>media_type</Name>
                  <KeyColumns>
                    <KeyColumn>
                      <DataType>WChar</DataType>
                      <Source xsi:type="ColumnBinding">
                        <TableID>promotion</TableID>
                        <ColumnID>media_type</ColumnID>
                      </Source>
                    </KeyColumn>
                  </KeyColumns>
                  <NameColumn>
                    <DataType>WChar</DataType>
                    <Source xsi:type="ColumnBinding">
                      <TableID>promotion</TableID>
                      <ColumnID>media_type</ColumnID>
                    </Source>
                  </NameColumn>
                </Attribute>
              </Attributes>
              <Hierarchies>
                <Hierarchy>
                  <ID>Promotion Name</ID>
                  <Name>Promotion Name</Name>
                  <Levels>
                    <Level>
                      <ID>Promotion Name</ID>
                      <Name>Promotion Name</Name>
                      <SourceAttributeID>promotion_name</SourceAttributeID>
                    </Level>
                    <Level>
                      <ID>Promotion Id</ID>
                      <Name>Promotion Id</Name>
                      <SourceAttributeID>promotion_id</SourceAttributeID>
                    </Level>
                  </Levels>