HsGetVariable
Data sources: Oracle Analytics Cloud - Essbase
Description
HsGetVariable retrieves the associated value for a substitution variable.
You cannot use HsGetVariable with Smart Slices.
Syntax
HsGetVariable can use the default connection name, a private connection name, a shared connection, or an Excel named range on a multiple-range grid, as follows:
-
Default connection:
HsGetVariable("substitution variable name")
-
Private connection:
HsGetVariable("PrivateConnectionName","substitution variable name")
-
Shared connection:
HsGetVariable("WSFN|ProviderType|Server|Application|Database","substitution variable name")
-
Named range on a multiple-range grid:
HsGetVariable("range name","substitution variable name")
For detailed syntax information, see Creating Functions Manually.
Examples
-
Default connection:
HsGetVariable("CurMonth")
-
Private connection:
HsGetVariable("stm10026_Sample_Basic","CurMonth")
-
Shared connection:
HsGetVariable("WSFN|Essbase|esbsvr|Sample|Basic","CurMonth"
-
Named range:
HsGetVariable("stm10026_Sample_Basic","CurMonth")
Note:
An ampersand (&) is generally used to refer to a substitution variable, but is optional in this function.