Data sources: Oracle Hyperion Financial Management, Oracle Essbase, Oracle Analytics Cloud - Essbase, Oracle Hyperion Planning, Oracle Planning and Budgeting Cloud, Oracle Enterprise Planning and Budgeting Cloud, Oracle Enterprise Performance Reporting Cloud
Description
HsGetValue retrieves data from the data source for selected members of a dimension.
When HsGetValue retrieves no data, the value specified for the #NoData/Missing Label replacement option is used (see Table 21-6).
When users select Refresh or Refresh All, only HsGetValue is called. When users select Submit, HsSetValue is called first, HsGetValue is then called only if HsSetValue returns successfully.
Syntax
Private connection:
HsGetValue("PrivateConnectionName","POV")
Shared connection:
HsGetValue("WSFN|ProviderType|Server|Application|Database","POV")
For detailed syntax information, see Creating Functions Manually.
Example
In this example, HsGetValue returns the value from the HFM01 application for the default POV.
Private connection:
HsGetValue("HFM01";"Scenario#Actual;Year#2004;Period#July;View#YTD; Entity#UnitedStates.Connecticut;Value#USD;Account#Sales;ICP#[ICP None];Custom1#GolfBalls;Custom2#Customer2;Custom3#[None]; Custom4#Increases")
Shared connection:
HsGetValue("WSFN|HFM|hfm_svr|HFM01|HFM01”;"Scenario#Actual;Year#2004;Period#July; View#YTD;Entity#UnitedStates.Connecticut;Value#USD;Account#Sales;ICP#[ICP None];Custom1#GolfBalls;Custom2#Customer2;Custom3#[None];Custom4#Increases")