HsSetText

数据源:Financial Management、Planning;Hyperion Enterprise(仅限专用连接)

HsSetText 向数据源发送单元格文本。您可以使用所有维成员、单元格引用、默认 POV,或使用上述三者的组合。

语法

专用连接:

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

共享连接:

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

示例

在本例中,HsSetText 会将 H3 单元格的文本发送到 HFM01 应用程序。

专用连接:

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

共享连接:

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