Run the MDX Script Wizard

This is applicable to the SDK for Blackbaud CRM versions 2.93 and higher.

1. Ensure you have created an extensions solution. For more information, see Create a New Extensions Solution.

2. From Visual Studio 2010, open the extensions solution. Click File > Open > Project/Solution.

3. Browse to the UDM project or the extensions solution that contains it and click Open. The UDM project appears.

   

4. Right-click the UDM project node and select Add > New Item. The Add New Item - UDM screen appears.

   

5. Browse to Installed Templates > Common Items > Blackbaud AppFx OLAP.

   

6. Select MDX Script Wizard, enter a name, and click Add. The MDX Script Wizard appears.

   

7. Click the binoculars next to the Cube field. The Select a cube screen appears.

   

8. In the Server field, enter the name of the Analysis Services server for your Blackbaud Data Warehouse OLAP Cube. Then click Connect. The wizard connects to the server and populates the Database drop-down field.

   

9. Select the Database and the Cube.

   

10. Click OK. The wizard populates the Cube field. From the MDX Script field, enter the MDX script extension. For example, enter:

        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';

11. Click OK. The wizard creates the spec and the spec is displayed.

    

    <MDXScriptDeploymentInfo xmlns="bb_olap_mdxscript">
      <Cube>BBDW</Cube>
      <MDXScript>    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';</MDXScript>
    </MDXScriptDeploymentInfo>

    The spec appears in the project as an item: