HsSetValue

数据源：Financial Management、Essbase、Planning；Hyperion Enterprise（仅限专用连接）

HsSetValue 将数据值从工作表发送到所选维成员的数据源。要向数据源发送数据，您必须具有该数据源的相应加载规则和写入权限。

语法

专用连接：

      HsSetValue (dollar amount,"
      PrivateConnectionName
      ","
      POV
      ")
   

共享连接：

      HsSetValue (dollar amount,"WSFN|
      ProviderType
      |
      Server
      |
      Application
      |
      Database
      ","
      POV
      ")
   

示例

在本例中，HsSetValue 会将 H4 单元格的值发送到 HFM01 应用程序。

专用连接：

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

共享连接：

      HsSetValue(H4, "WSFN|HFM|hfm_svr|HFM01|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")