Data sources: Oracle Hyperion Financial Management
HsSetText sends cell text to a data source. You can use all dimension members, cell references, the default POV, or a combination of all three.
Note:
Users must click Submit Data in order to save the cell text.
Syntax
Private connection:
HsSetText("CellTextComments","PrivateConnectionName","POV","CellTextLabel")
Shared connection:
HsSetText("CellTextComments","WSFN|ProviderType|Server|Application|Database","POV","CellTextLabel")
For detailed syntax information, see Creating Functions Manually.
Example
In this example, HsSetText sends the text from cell H3 to the HFM01 application.
Private connection:
HsSetText("H3","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:
HsSetText("H3","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")