MicroStrategy ONE

Importing custom functions

You create custom functions in the MicroStrategy Function Plug-in Wizard, a stand-alone utility independent of MicroStrategy Developer. Before you can use a custom function, you must import it into MicroStrategy Developer. Once imported, they behave as an integrated part of the product and are indistinguishable from any other functions or operators, such as Sum or Average.

Prerequisites

Before beginning this procedure, you must do the following:

  • Create the function, as described in the Functions Reference.

  • Log in to a MicroStrategy project so that you can access the Import Functions menu option.

To import a custom function

  1. In MicroStrategy Developer, select Import Functions from the Schema menu. The Import Functions dialog box opens.

  2. Click ... (the browse button) to select your function plug-in DLL. You must select the myFPhlp.dll helper DLL, which you created in the out-of-process implementation process described in the Functions Reference. Once you have selected a valid DLL, the function library name and description are displayed. Also, all available functions are displayed in the Available functions pane. Any functions that have already been imported from this library are listed under Functions already in the project.

  3. Select the functions to import from the Available functions list. Click > to move them to the Add these functions to project list.

  4. Click OK to import the selected functions.

  5. If these are the first functions that have been imported from the selected library, the Browse for Folder dialog box opens. Select the folder into which to import the functions and click OK.

    If functions have been previously imported from the selected library, the selected functions are imported into the same library as the previously imported functions.