Data sources: Oracle Essbase, 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.