HsGetVariable

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.