Data sources: Oracle Hyperion Financial Management
HsGetText retrieves cell text from the data source for dimension members, cell references, the default POV, or a combination of all three.
Note:
Users must click Refresh in order to retrieve the cell text.
Syntax
Private connection:
HsGetText ("PrivateConnectionName","POV","CellTextLabel")
Shared connection:
HsGetText ("WSFN|ProviderType|Server|Application|Database","POV","CellTextLabel")
For detailed syntax information, see Creating Functions Manually.
Example
In this example, HsGetText returns the cell text from the HFM01 data source for the default POV.
Private connection:
HsGetText("HFM01","Scenario#Actual;Year#2004;Period#"&B$2&";View#
<Scenario View>;Entity#UnitedStates.Connecticut;Value#<Entity Currency>;Account#"&$A3&";ICP#[ICP None];Custom1#GolfBalls;Custom2#Customer2;Custom3#[None],Custom4#
Increases")
Shared connection:
HsGetText("WSFN|HFM|hfm_svr|HFM01|HFM01","Scenario#Actual;Year#2004;Period#"&B$2&";View#
<Scenario View>;Entity#UnitedStates.Connecticut;Value#<Entity Currency>;Account#"&$A3&";ICP#[ICP None];Custom1#GolfBalls;Custom2#Customer2;Custom3#[None],Custom4#
Increases")