HsSetValue

Data sources: Financial Management, Hyperion Enterprise, Essbase

HsSetValue sends a data value from a worksheet to a data source selected members of a dimension.To send data to a data source, you must have the appropriate load rule and write access for the data source.

Syntax

HsSetValue (dollar amount,“Connection”,”POV”)

Example

In this example, HsSetValue sends the value from cell H4 to the HFM01 application.

HsSetValue(H4, "HFM01","Scenario#Actual;Year#2004;Period#"&B$2&";View#<Scenario View>;Entity#UnitedStates.Connecticut;Value#<Entity Currency>;Account#"&$A4&";ICP#[ICP None];Custom1#GolfBalls;Custom2#Customer2;Custom3#[None];Custom4#
Increases")