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

The Function Builder, containing selections for HsGetValue as described in this section

  To create functions using the Function Builder:

  1. Ensure that your connection is a private connection. If it is a shared connection, save it as a private connection before connecting.

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

  3. From the Smart View ribbon, select Functions, and 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. HsGetText and HsSetText only:

    • Select Comments or Cell Reference, and then enter the cell text to submit

    • Select Cell Text Label, and then select a label from the drop-down menu.

  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. It is enabled only if the syntax is invalid or if the syntax has not already been validated.

  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, follow the procedure in Running Functions.