Measure Groups Spec Exercise Steps

1. From an editor such as Notepad, Notepad++, or Visual Studio's XML editor, create a new XML document called OLAP.MDXScript.xml.

2. Paste the following into the document.

   <MeasureGroupDeploymentInfo>
     <Cube>BBDW</Cube>
     <DSVTable></DSVTable>
     <MeasureGroupName></MeasureGroupName>
     <Measures>
       <Measure>
         <Name></Name>
         <AggregateFunction></AggregateFunction>
         <Visible></Visible>
         <!-- This field is actually not needed for counts -->
         <Column></Column>
       </Measure>
     </Measures>
   </MeasureGroupDeploymentInfo>

3. Adjust the markup for a new measure group. For example:

   <MeasureGroupDeploymentInfo>
     <Cube>BBDW</Cube>
     <DSVTable>v_FACT_INTERACTIONRESPONSE_EXT</DSVTable>
     <MeasureGroupName>Interaction response</MeasureGroupName>
     <Measures>
       <Measure>
         <Name>Interaction response count</Name>
         <AggregateFunction>Count</AggregateFunction>
         <Visible>false</Visible>
       </Measure>
     </Measures>
   </MeasureGroupDeploymentInfo>

4. Save the file.