MDX Scripts Spec Exercise

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.

   <MDXScriptDeploymentInfo>
     <Cube>BBDW</Cube>
     <MDXScript>
   
     </MDXScript>
   </MDXScriptDeploymentInfo>

3. Adjust the markup for a new MDX script. For example, between <MDXScript></MDXScript>, insert:

       CREATE MEMBER CURRENTCUBE.[Measures].[Marketing Effort Budget Amount]
       AS Val([Marketing Segment].[Marketing Effort].Properties("Marketing Effort Budget Amount")),
       FORMAT_STRING = "Currency", VISIBLE = 1 , ASSOCIATED_MEASURE_GROUP = 'Marketing Constituent';

4. Save the file.