querycubechapter18.xmla

来自「< SQL Server2005程序设计>」· XMLA 代码 · 共 16 行

<Execute xmlns="urn:schemas-microsoft-com:xml-analysis">
  <Command>
    <Statement>
      SELECT	Shippers.[Shipper Name].MEMBERS ON COLUMNS,
              Time.Year.MEMBERS ON ROWS
      FROM	  Sales
      WHERE	  Measures.[Total Sales]
    </Statement>
  </Command>
  <Properties>
    <PropertyList>
      <Catalog>Chapter18</Catalog>
    </PropertyList>
  </Properties>
</Execute>