Using Essbase Macros

When using macros, you must first insert a macro worksheet into the workbook. Follow these steps for an example of how to use the Essbase macro EssConnect.

Note:

When using macros, ensure that the worksheet contains only the macros. The macros do not work on worksheets containing other information. Oracle recommends using the VBA equivalent functions of Essbase macros whenever possible.

  To run Essbase macros:

  1. In Excel, select a worksheet tab in the workbook.

  2. Right-click the worksheet tab, and select Insert.

  3. In Insert, select MS Excel 4.0 Macro icon., and then click OK.

    Excel creates a worksheet name called Macro 1 to the left of the selected worksheet in the active workbook.

  4. Next to the formula bar, click Insert Function, Insert Function icon..

  5. In Or select a category, select Essbase Add-in.

  6. Select a function; for example, EssConnect.

  7. Click OK.

    A dialog box for filling in the parameters for the EssConnect macro is displayed.

  8. Enter the information, and then click OK.

  9. In the cell directly below the macro, enter =RETURN().

  10. To run this macro:

    1. Select the cell in which the macro is located.

    2. Select Tools, then Macro, and then Macros.

    3. Click Run.

    Note:

    To associate a button with a macro, draw a button using the Button icon. from the Excel Forms toolbar. To view the Forms toolbar, select View, then Toolbars, and then Form. In the Assign Macro dialog box, enter EssConnect in the Macro Name box. Click Run.