createdatabase.xmla

< SQL Server2005程序设计>

                    </Level>
                  </Levels>
                </Hierarchy>
                <Hierarchy>
                  <ID>Occupation</ID>
                  <Name>Occupation</Name>
                  <Levels>
                    <Level>
                      <ID>Occupation</ID>
                      <Name>Occupation</Name>
                      <SourceAttributeID>customer_occupation</SourceAttributeID>
                    </Level>
                    <Level>
                      <ID>Customer Name</ID>
                      <Name>Customer Name</Name>
                      <SourceAttributeID>Customer Name</SourceAttributeID>
                    </Level>
                  </Levels>
                </Hierarchy>
              </Hierarchies>
            </Dimension>
          </Dimensions>
          <Cubes>
            <Cube>
              <ID>Warehouse and Sales</ID>
              <Name>Warehouse and Sales</Name>
              <Dimensions>
                <Dimension>
                  <ID>Product</ID>
                  <Name>Product</Name>
                  <DimensionID>Product</DimensionID>
                  <Attributes>
                    <Attribute>
                      <AttributeID>Product Name</AttributeID>
                    </Attribute>
                    <Attribute>
                      <AttributeID>Brand Name</AttributeID>
                    </Attribute>
                    <Attribute>
                      <AttributeID>Product Subcategory</AttributeID>
                    </Attribute>
                    <Attribute>
                      <AttributeID>Product Category</AttributeID>
                    </Attribute>
                    <Attribute>
                      <AttributeID>Product Department</AttributeID>
                    </Attribute>
                    <Attribute>
                      <AttributeID>product_family</AttributeID>
                    </Attribute>
                  </Attributes>
                  <Hierarchies>
                    <Hierarchy>
                      <HierarchyID>Product Family</HierarchyID>
                    </Hierarchy>
                  </Hierarchies>
                </Dimension>
                <Dimension>
                  <ID>Store</ID>
                  <Name>Store</Name>
                  <DimensionID>Store</DimensionID>
                  <Attributes>
                    <Attribute>
                      <AttributeID>Store Name</AttributeID>
                    </Attribute>
                    <Attribute>
                      <AttributeID>store_type</AttributeID>
                    </Attribute>
                    <Attribute>
                      <AttributeID>Store City</AttributeID>
                    </Attribute>
                    <Attribute>
                      <AttributeID>Store State</AttributeID>
                    </Attribute>
                    <Attribute>
                      <AttributeID>Store Country</AttributeID>
                    </Attribute>
                  </Attributes>
                  <Hierarchies>
                    <Hierarchy>
                      <HierarchyID>Store Type</HierarchyID>
                    </Hierarchy>
                    <Hierarchy>
                      <HierarchyID>Store Location</HierarchyID>
                    </Hierarchy>
                  </Hierarchies>
                </Dimension>
                <Dimension>
                  <ID>Promotion</ID>
                  <Name>Promotion</Name>
                  <DimensionID>Promotion</DimensionID>
                  <Attributes>
                    <Attribute>
                      <AttributeID>promotion_id</AttributeID>
                    </Attribute>
                    <Attribute>
                      <AttributeID>promotion_name</AttributeID>
                    </Attribute>
                    <Attribute>
                      <AttributeID>media_type</AttributeID>
                    </Attribute>
                  </Attributes>
                  <Hierarchies>
                    <Hierarchy>
                      <HierarchyID>Promotion Name</HierarchyID>
                    </Hierarchy>
                    <Hierarchy>
                      <HierarchyID>Media Type</HierarchyID>
                    </Hierarchy>
                  </Hierarchies>
                </Dimension>
                <Dimension>
                  <ID>Customer</ID>
                  <Name>Customer</Name>
                  <DimensionID>Customer</DimensionID>
                  <Attributes>
                    <Attribute>
                      <AttributeID>Customer Name</AttributeID>
                    </Attribute>
                    <Attribute>
                      <AttributeID>City</AttributeID>
                    </Attribute>
                    <Attribute>
                      <AttributeID>State Province</AttributeID>
                    </Attribute>
                    <Attribute>
                      <AttributeID>Country</AttributeID>
                    </Attribute>
                    <Attribute>
                      <AttributeID>marital_status</AttributeID>
                    </Attribute>
                    <Attribute>
                      <AttributeID>customer_education</AttributeID>
                    </Attribute>
                    <Attribute>
                      <AttributeID>customer_occupation</AttributeID>
                    </Attribute>
                  </Attributes>
                  <Hierarchies>
                    <Hierarchy>
                      <HierarchyID>Location</HierarchyID>
                    </Hierarchy>
                    <Hierarchy>
                      <HierarchyID>Education</HierarchyID>
                    </Hierarchy>
                    <Hierarchy>
                      <HierarchyID>Marital Status</HierarchyID>
                    </Hierarchy>
                    <Hierarchy>
                      <HierarchyID>Occupation</HierarchyID>
                    </Hierarchy>
                  </Hierarchies>
                </Dimension>
              </Dimensions>
              <MeasureGroups>
                <MeasureGroup>
                  <ID>Inventory Fact</ID>
                  <Name>Inventory Fact</Name>
                  <IgnoreUnrelatedDimensions>false</IgnoreUnrelatedDimensions>
                  <Measures>
                    <Measure>
                      <ID>Units Ordered</ID>
                      <Name>Units Ordered</Name>
                      <Source>
                        <DataType>Double</DataType>
                        <Source xsi:type="ColumnBinding">
                          <TableID>inventory_fact_1997</TableID>
                          <ColumnID>units_ordered</ColumnID>
                        </Source>
                      </Source>
                      <FormatString>Standard</FormatString>
                      <BackColor>65535</BackColor>
                      <ForeColor>0</ForeColor>
                      <FontName>Arial</FontName>
                      <FontSize>10</FontSize>
                      <FontFlags>15</FontFlags>
                    </Measure>
                    <Measure>
                      <ID>Units Shipped</ID>
                      <Name>Units Shipped</Name>
                      <Source>
                        <DataType>Integer</DataType>
                        <Source xsi:type="ColumnBinding">
                          <TableID>inventory_fact_1997</TableID>
                          <ColumnID>units_shipped</ColumnID>
                        </Source>
                      </Source>
                      <FormatString>#,#</FormatString>
                    </Measure>
                    <Measure>
                      <ID>Warehouse Sales</ID>
                      <Name>Warehouse Sales</Name>
                      <Source>
                        <DataType>Currency</DataType>
                        <Source xsi:type="ColumnBinding">
                          <TableID>inventory_fact_1997</TableID>
                          <ColumnID>warehouse_sales</ColumnID>
                        </Source>
                      </Source>
                      <FormatString>Currency</FormatString>
                    </Measure>
                    <Measure>
                      <ID>Warehouse Cost</ID>
                      <Name>Warehouse Cost</Name>
                      <Source>
                        <DataType>Currency</DataType>
                        <Source xsi:type="ColumnBinding">
                          <TableID>inventory_fact_1997</TableID>
                          <ColumnID>warehouse_cost</ColumnID>
                        </Source>
                      </Source>
                      <FormatString>Currency</FormatString>
                    </Measure>
                    <Measure>
                      <ID>Order Count</ID>
                      <Name>Order Count</Name>
                      <AggregateFunction>Count</AggregateFunction>
                      <Source>
                        <DataType>Double</DataType>
                        <Source xsi:type="ColumnBinding">
                          <TableID>inventory_fact_1997</TableID>
                          <ColumnID>units_ordered</ColumnID>
                        </Source>
                      </Source>
                      <FormatString>#,#</FormatString>
                    </Measure>
                  </Measures>
                  <StorageMode>Molap</StorageMode>
                  <ProcessingMode>Regular</ProcessingMode>
                  <Dimensions>
                    <Dimension xsi:type="RegularMeasureGroupDimension">
                      <CubeDimensionID>Store</CubeDimensionID>
                      <Attributes>
                        <Attribute>
                          <AttributeID>Store Name</AttributeID>
                          <Type>Granularity</Type>
                        </Attribute>
                      </Attributes>
                    </Dimension>
                    <Dimension xsi:type="RegularMeasureGroupDimension">
                      <CubeDimensionID>Product</CubeDimensionID>
                      <Attributes>
                        <Attribute>
                          <AttributeID>Product Name</AttributeID>
                          <Type>Granularity</Type>
                        </Attribute>
                      </Attributes>
                    </Dimension>
                  </Dimensions>
                  <Partitions>
                    <Partition>
                      <ID>Inventory Fact 1997</ID>
                      <Name>Inventory Fact 1997</Name>
                      <Source xsi:type="TableBinding">
                        <DataSourceID>Food Mart 2000</DataSourceID>
                        <DbTableName>inventory_fact_1997</DbTableName>
                      </Source>
                      <StorageMode>Molap</StorageMode>
                      <ProcessingMode>Regular</ProcessingMode>
                    </Partition>
                    <Partition>
                      <ID>Inventory Fact 1998</ID>
                      <Name>Inventory Fact 1998</Name>
                      <Source xsi:type="TableBinding">
                        <DataSourceID>Food Mart 2000</DataSourceID>
                        <DbTableName>inventory_fact_1998</DbTableName>
                      </Source>
                      <StorageMode>Molap</StorageMode>
                      <ProcessingMode>Regular</ProcessingMode>
                    </Partition>
                  </Partitions>
                </MeasureGroup>
                <MeasureGroup>
                  <ID>Sales Fact</ID>
                  <Name>Sales Fact</Name>
                  <IgnoreUnrelatedDimensions>false</IgnoreUnrelatedDimensions>
                  <Measures>
                    <Measure>
                      <ID>Store Sales</ID>
                      <Name>Store Sales</Name>
                      <Source>
                        <DataType>Currency</DataType>
                        <Source xsi:type="ColumnBinding">
                          <TableID>sales_fact_1997</TableID>