Listing A: XMLA Script That Creates Calculated Members from the Sales Cube

<Alter ObjectExpansion="ObjectProperties" 
xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
  <Object>
    <DatabaseID>FoodMart 2005</DatabaseID>
    <CubeID>Food Mart</CubeID>
    <MdxScriptID>MdxScript</MdxScriptID>
  </Object>
  <ObjectDefinition>
    <MdxScript xmlns:xsd="http://www.w3.org/2001/XMLSchema" 
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
      <ID>MdxScript</ID>
      <Name>MdxScript</Name>
      <Commands>
          <Command>
            <Text>CALCULATE;</Text>
          </Command>
          <Command>
            <Text>
              CREATE MEMBER Sales.Measures.[Profit] AS '[Measures].[Store Sales]-
[Measures].[Store Cost]', FORMAT_STRING = 'Standard';
            </Text>
          </Command>
          <Command>
            <Text>
              CREATE MEMBER Sales.Measures.[Sales Average] AS '[Measures].[Store 
Sales]/[Measures].[Sales Count]', FORMAT_STRING = 'Standard';
            </Text>
          </Command>
      </Commands>
    </MdxScript>
  </ObjectDefinition>
</Alter>










1