Modify functions by using the Function Editor

You can modify the members that are used in a function by using the Function Editor. You can also modify functions directly, but the Function Editor can be easier to use.

Before you begin

You must be connected to the data source referenced in the server:cube parameter.
Tip: To open the data source, right-click the cell and selectIBM® Planning Analytics > Display Package. The source tree displays the data source.

Procedure

  1. Click a cell that contains a function and click the Microsoft Excel function button.
    The Function Editor is displayed. The Arguments list shows the parameter values currently used by the function. The Formula Result field will display RECALC_#_# as the formula result may change when recalculated.
  2. Modify the members that are used in the parameters by using any of the following techniques:
    • To specify a value directly, type a member name into the field. For example, to change the member for the first dimension in the cube, type a member name into the first field.
    • To use a cell reference, click Cell Reference button. Click a cell and then click OK.
    • To use the set editor, right-click the dimension, select IBM Planning Analytics > Edit set. Use the set editor to select a member, and then click Apply and close.
    Note: You might need to scroll down in the Function Editor to see all of the parameters.
  3. Click OK.
    The function is updated in the worksheet.