Creating Functions Manually

Functions can contain a maximum of 256 characters.To create a function manually:

In Excel, click the cell in which you want to enter the function.
Enter = (equal sign).
Enter the function name, HsSetValue, for example.
Enter parameters for the function, using the information specific to each function in Function Descriptions.
Connection parameters can have these values:
- Empty: the default connection
- HsActive: the active associated connection
- The user-defined name for a private connection
To refresh the worksheet, from the Smart View menu, select Refresh.
Functions are validated only when you refresh them.

Syntax Guidelines

See Function Descriptions for the syntax of individual functions.

The POV is composed of dimension#member pairs, for example, Entity#Connecticut.
If you specify a connection name, it must precede the POV.
Parent-child relationships are designated by a period, for example, Entity#UnitedStates.Maine.
The connection and POV can be grouped as one parameter, for example “My_connection;Entity#UnitedStates”.
Alternatively, they can be split up into multiple function parameters, for example, “My_connection”, “Entity#UnitedStates”, “Account#Sales”.
If the connection and POV are in the same parameter, the connection and each dimension#member pair are separated by a semi-colon (;), for example, “My_connection;Entity#UnitedStates;Account#Sales”.