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|Database","POV"
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 Essbase on-premises only;Oracle Analytics Cloud - Essbase requires private connection syntax) -
HP
(for Planning, Planning Modules, Financial Consolidation and Close, Tax Reporting)
-
-
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 each POV dimension#member pair can be split into separate function parameters, each parameter enclosed in quotation marks, (
"
), and separated by a comma, (,
); for example:"My_connection","Entity#UnitedStates","Account#Sales"
Alternatively, the connection can be separated from the POV by a comma, (
,
), with the entire POV enclosed in quotation marks, ("
), and with each dimension#member pair separated by semicolon, (;
); for example:"My_connection","Entity#UnitedStates;Account#Sales"