Creating Functions in the Function Builder

In the Function Builder, you select a function and specify the connection and members that you want the function to use. The Function Builder then creates the function using the proper syntax and enters it into the selected cell. You can edit these functions.

The selections available to you in a given Function Builder field are limited by your selections in other fields of the Function Builder. For example, only the functions supported by the data source you select are displayed, and only the dimensions supported by the function you select are displayed.

Function Descriptions

  To create functions using the Function Builder:

  1. Connect to all data sources that your functions will access.

  2. Click the cell in which you want to enter the function.

  3. From the Smart View ribbon, select Functions, then Function Builder.

  4. From Select Connection, select a data source.

  5. From Select Function, select a function.

  6. From Select Member, select a dimension.

  7. In the Member column, click Select Member to select a member. (If you want to use the POV default members for the dimension, do not select a member.)

    You can also double-click in the column and type in a member name or cell reference.

  8. Double-click in the Member Type column. From the drop-down list, select Member or Cell Reference (cell references cannot be used with HsLabel).

    When you select Cell Reference, the value in the referenced cell is used in the function.

  9. HsSetValue only: Select Data or Cell Reference and enter the value to submit.

  10. HsSetText only: Select Comment or Cell Reference and enter the text to submit.

  11. Repeat step 6 through step 10 as needed.

  12. Click Add to Function.

  13. Optional: To add another function, click Add to Function.

  14. Optional: If you have edited the function in the Function field, to validate the function syntax before inserting it into the worksheet, click Validate Syntax.

    Note:

    Validate Syntax validates only the syntax you are using for the function. It does not validate the members you have selected.

  15. Click OK to insert the function in the selected cell.

    The OK button is enabled only if you have first selected Add to Function.

  16. To execute the function, select Refresh.