Modify a range of DBR and DBRW functions

You can modify the DBR or DBRW functions that are used in a range of cells by using the DBR Function Editor.

Before you begin

The DBR Function Editor is available when the following conditions are met:
  • The first cell in the range contain a DBR or DBRW function.
  • All DBR or DBRW functions in the range have the same value for the server:cube parameter.
  • You are connected to the data source referenced in the server:cube parameter.
    Tip: To open the data source, right-click the cell and select IBM® Planning Analytics > Display Package. The source tree displays the data source.

About this task

You can select a range of cells that contain DBRW functions and change one or more members that are used by all of the DBRW functions in the range. Dimensions that have multiple members within the range are not available for editing.

For example, if all DBRW functions in a column use Jan for the Month dimension and Europe for the Region dimension, you can change Jan to Feb and Europe to France. If the member used for the Account dimension varies within the column, the Account field is disabled in the DBR Function Editor. When you click OK, the DBRW functions in the column are updated with Feb and France. All other members that are used by the DBRW functions remain unchanged.

Procedure

  1. Select a range of cells.
  2. Select the range and select the Insert Function button.
    The Excel Function Editor is displayed. The Arguments list shows the parameter values that are used by the functions. The members that are common to all of the cells in the range are available for editing.
  3. 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.
    Note: You might need to scroll down in the Function Editor to see all of the parameters.
  4. Click OK.
    The functions are updated in the worksheet.