HsSetText

Data sources: Financial Management, Planning; Hyperion Enterprise (private connection only)

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.

Syntax

Private connection:

HsSetText("Cell Text Comments","PrivateConnectionName";"POV")

Shared connection:

HsSetText("Cell Text Comments","WSFN|ProviderType|Server|Application|Database";"POV")

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