Creating Functions Manually
See Microsoft documentation and support site for information about character and other Excel function limitations.
To create a function manually:
Example 21-1 Syntax Guidelines
See Function Descriptions for the syntax of individual functions.
-
To work with a shared connection, you must add to the function the WSFN identifier, which specifies a workspace function, along with a connection string. The format is:
WSFN|ProviderType|Server|Application|DatabasePOV
For example, in the HsGetValue function for a shared connection to an Oracle Essbase data source, the WSFN identifier and connection string is added to the function as follows:
=HsGetValue("WSFN|Essbase|myserver|Sample|Basic","Market#South")
For
ProviderType
, use one of the following case-sensitive strings:-
Essbase
(for Oracle Analytics Cloud - Essbase) -
HP
(for Oracle Planning and Budgeting Cloud, Oracle Enterprise Planning and Budgeting Cloud, Oracle Financial Consolidation and Close Cloud, Oracle Tax Reporting Cloud)
-
-
Private connection parameters can have these values:
-
Empty: the default connection
-
HsActive: the active associated connection
-
The user-defined name for a private connection
If you specify a private connection, it must precede the POV.
-
-
The POV is composed of dimension#member pairs, for example, Entity#Connecticut.
-
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 semicolon (;), for example, “My_connection;Entity#UnitedStates;Account#Sales”.