介绍 Smart View 函数 HsGetText。
数据源类型:Oracle Hyperion Financial Management
说明
HsGetText 从数据源检索维成员、单元格引用、默认 POV 或上述三者组合的单元格文本。
注:
用户必须单击刷新以检索单元格文本。
语法
专用连接:
HsGetText ("PrivateConnectionName","POV","CellTextLabel")
共享连接:
HsGetText ("WSFN|ProviderType|Server|Application|Database","POV","CellTextLabel")
URL 连接:
HsGetText ("URLFN|URL|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")
URL 连接:
HsGetText("URLFN|https://<servername:port>/hfmadf/../hfmofficeprovider/OfficeProvider|<servername:port>|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")