HsSetText

Data source types: Oracle Hyperion Financial Management

Description

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")

URL connection:

HsSetText("CellTextComments","URLFN|URL|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")

URL connection:

HsSetText("H3","URLFN|https://<servername:port>/hfmadf/../hfmofficeprovider/OfficeProvider|<servername:port>|<servername:port>
|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")