HsGetText

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

HsGetText 从数据源检索维成员、单元格引用、默认 POV 或上述三者组合的单元格文本。

语法

专用连接:

      HsGetText ("
      PrivateConnectionName
      ","
      POV
      ","
      CellTextLabel
      ")
   

共享连接:

      HsGetText ("WSFN|
      ProviderType
      |
      Server
      |
      Application
      |
      Database
      ","
      POV
      ","
      CellTextLabel
      ")
   

示例

在本例中,HsGetText 将从 HFM01 数据源中返回默认 POV 的单元格文本。

专用连接:

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

共享连接:

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