createdatabase.xmla

< SQL Server2005程序设计>

                </Hierarchy>
                <Hierarchy>
                  <ID>Media Type</ID>
                  <Name>Media Type</Name>
                  <Levels>
                    <Level>
                      <ID>Media Type</ID>
                      <Name>Media Type</Name>
                      <SourceAttributeID>media_type</SourceAttributeID>
                    </Level>
                    <Level>
                      <ID>Promotion Id</ID>
                      <Name>Promotion Id</Name>
                      <SourceAttributeID>promotion_id</SourceAttributeID>
                    </Level>
                  </Levels>
                </Hierarchy>
              </Hierarchies>
            </Dimension>
            <Dimension>
              <ID>Customer</ID>
              <Name>Customer</Name>
              <Source xsi:type="DataSourceViewBinding">
                <DataSourceViewID>Food Mart 2000</DataSourceViewID>
              </Source>
              <Attributes>
                <Attribute>
                  <ID>Customer Name</ID>
                  <Name>Customer Name</Name>
                  <Usage>Key</Usage>
                  <KeyColumns>
                    <KeyColumn>
                      <DataType>Integer</DataType>
                      <Source xsi:type="ColumnBinding">
                        <TableID>Customer</TableID>
                        <ColumnID>customer_id</ColumnID>
                      </Source>
                    </KeyColumn>
                  </KeyColumns>
                  <NameColumn>
                    <DataType>WChar</DataType>
                    <Source xsi:type="ColumnBinding">
                      <TableID>Customer</TableID>
                      <ColumnID>full_name</ColumnID>
                    </Source>
                  </NameColumn>
                  <AttributeRelationships>
                    <AttributeRelationship>
                      <AttributeID>City</AttributeID>
                      <RelationshipType>Flexible</RelationshipType>
                    </AttributeRelationship>
                    <AttributeRelationship>
                      <AttributeID>marital_status</AttributeID>
                      <RelationshipType>Flexible</RelationshipType>
                    </AttributeRelationship>
                    <AttributeRelationship>
                      <AttributeID>customer_education</AttributeID>
                      <RelationshipType>Flexible</RelationshipType>
                    </AttributeRelationship>
                    <AttributeRelationship>
                      <AttributeID>customer_occupation</AttributeID>
                      <RelationshipType>Flexible</RelationshipType>
                    </AttributeRelationship>
                  </AttributeRelationships>
                </Attribute>
                <Attribute>
                  <ID>City</ID>
                  <Name>City</Name>
                  <AttributeHierarchyDisplayFolder>Geographic</AttributeHierarchyDisplayFolder>
                  <KeyColumns>
                    <KeyColumn>
                      <DataType>WChar</DataType>
                      <DataSize>50</DataSize>
                      <Source xsi:type="ColumnBinding">
                        <TableID>Customer</TableID>
                        <ColumnID>city</ColumnID>
                      </Source>
                    </KeyColumn>
                    <KeyColumn>
                      <DataType>WChar</DataType>
                      <DataSize>50</DataSize>
                      <Source xsi:type="ColumnBinding">
                        <TableID>Customer</TableID>
                        <ColumnID>state_province</ColumnID>
                      </Source>
                    </KeyColumn>
                    <KeyColumn>
                      <DataType>WChar</DataType>
                      <DataSize>50</DataSize>
                      <Source xsi:type="ColumnBinding">
                        <TableID>Customer</TableID>
                        <ColumnID>country</ColumnID>
                      </Source>
                    </KeyColumn>
                  </KeyColumns>
                  <NameColumn>
                    <DataType>WChar</DataType>
                    <Source xsi:type="ColumnBinding">
                      <TableID>Customer</TableID>
                      <ColumnID>city</ColumnID>
                    </Source>
                  </NameColumn>
                  <AttributeRelationships>
                    <AttributeRelationship>
                      <AttributeID>State Province</AttributeID>
                      <RelationshipType>Flexible</RelationshipType>
                    </AttributeRelationship>
                  </AttributeRelationships>
                </Attribute>
                <Attribute>
                  <ID>State Province</ID>
                  <Name>State Province</Name>
                  <AttributeHierarchyDisplayFolder>Geographic</AttributeHierarchyDisplayFolder>
                  <KeyColumns>
                    <KeyColumn>
                      <DataType>WChar</DataType>
                      <DataSize>50</DataSize>
                      <Source xsi:type="ColumnBinding">
                        <TableID>Customer</TableID>
                        <ColumnID>state_province</ColumnID>
                      </Source>
                    </KeyColumn>
                    <KeyColumn>
                      <DataType>WChar</DataType>
                      <DataSize>50</DataSize>
                      <Source xsi:type="ColumnBinding">
                        <TableID>Customer</TableID>
                        <ColumnID>country</ColumnID>
                      </Source>
                    </KeyColumn>
                  </KeyColumns>
                  <NameColumn>
                    <DataType>WChar</DataType>
                    <Source xsi:type="ColumnBinding">
                      <TableID>Customer</TableID>
                      <ColumnID>state_province</ColumnID>
                    </Source>
                  </NameColumn>
                  <AttributeRelationships>
                    <AttributeRelationship>
                      <AttributeID>Country</AttributeID>
                      <RelationshipType>Flexible</RelationshipType>
                    </AttributeRelationship>
                  </AttributeRelationships>
                </Attribute>
                <Attribute>
                  <ID>Country</ID>
                  <Name>Country</Name>
                  <AttributeHierarchyDisplayFolder>Geographic</AttributeHierarchyDisplayFolder>
                  <KeyColumns>
                    <KeyColumn>
                      <DataType>WChar</DataType>
                      <Source xsi:type="ColumnBinding">
                        <TableID>Customer</TableID>
                        <ColumnID>country</ColumnID>
                      </Source>
                    </KeyColumn>
                  </KeyColumns>
                  <NameColumn>
                    <DataType>WChar</DataType>
                    <Source xsi:type="ColumnBinding">
                      <TableID>Customer</TableID>
                      <ColumnID>country</ColumnID>
                    </Source>
                  </NameColumn>
                </Attribute>
                <Attribute>
                  <ID>marital_status</ID>
                  <Name>marital_status</Name>
                  <KeyColumns>
                    <KeyColumn>
                      <DataType>WChar</DataType>
                      <Source xsi:type="ColumnBinding">
                        <TableID>Customer</TableID>
                        <ColumnID>marital_status</ColumnID>
                      </Source>
                    </KeyColumn>
                  </KeyColumns>
                  <NameColumn>
                    <DataType>WChar</DataType>
                    <Source xsi:type="ColumnBinding">
                      <TableID>Customer</TableID>
                      <ColumnID>marital_status</ColumnID>
                    </Source>
                  </NameColumn>
                </Attribute>
                <Attribute>
                  <ID>customer_education</ID>
                  <Name>customer_education</Name>
                  <KeyColumns>
                    <KeyColumn>
                      <DataType>WChar</DataType>
                      <Source xsi:type="ColumnBinding">
                        <TableID>Customer</TableID>
                        <ColumnID>education</ColumnID>
                      </Source>
                    </KeyColumn>
                  </KeyColumns>
                  <NameColumn>
                    <DataType>WChar</DataType>
                    <Source xsi:type="ColumnBinding">
                      <TableID>Customer</TableID>
                      <ColumnID>education</ColumnID>
                    </Source>
                  </NameColumn>
                </Attribute>
                <Attribute>
                  <ID>customer_occupation</ID>
                  <Name>customer_occupation</Name>
                  <KeyColumns>
                    <KeyColumn>
                      <DataType>WChar</DataType>
                      <Source xsi:type="ColumnBinding">
                        <TableID>Customer</TableID>
                        <ColumnID>occupation</ColumnID>
                      </Source>
                    </KeyColumn>
                  </KeyColumns>
                  <NameColumn>
                    <DataType>WChar</DataType>
                    <Source xsi:type="ColumnBinding">
                      <TableID>Customer</TableID>
                      <ColumnID>occupation</ColumnID>
                    </Source>
                  </NameColumn>
                </Attribute>
              </Attributes>
              <Hierarchies>
                <Hierarchy>
                  <ID>Location</ID>
                  <Name>Location</Name>
                  <DisplayFolder>Geographic</DisplayFolder>
                  <Levels>
                    <Level>
                      <ID>Country</ID>
                      <Name>Country</Name>
                      <SourceAttributeID>Country</SourceAttributeID>
                    </Level>
                    <Level>
                      <ID>State Province</ID>
                      <Name>State Province</Name>
                      <SourceAttributeID>State Province</SourceAttributeID>
                    </Level>
                    <Level>
                      <ID>City</ID>
                      <Name>City</Name>
                      <SourceAttributeID>City</SourceAttributeID>
                    </Level>
                    <Level>
                      <ID>Customer Name</ID>
                      <Name>Customer Name</Name>
                      <SourceAttributeID>Customer Name</SourceAttributeID>
                    </Level>
                  </Levels>
                </Hierarchy>
                <Hierarchy>
                  <ID>Education</ID>
                  <Name>Education</Name>
                  <Levels>
                    <Level>
                      <ID>Education</ID>
                      <Name>Education</Name>
                      <SourceAttributeID>customer_education</SourceAttributeID>
                    </Level>
                    <Level>
                      <ID>Customer Name</ID>
                      <Name>Customer Name</Name>
                      <SourceAttributeID>Customer Name</SourceAttributeID>
                    </Level>
                  </Levels>
                </Hierarchy>
                <Hierarchy>
                  <ID>Marital Status</ID>
                  <Name>Marital Status</Name>
                  <Levels>
                    <Level>
                      <ID>Marital Status</ID>
                      <Name>Marital Status</Name>
                      <SourceAttributeID>marital_status</SourceAttributeID>
                    </Level>
                    <Level>
                      <ID>Customer Name</ID>
                      <Name>Customer Name</Name>
                      <SourceAttributeID>Customer Name</SourceAttributeID>