HsSetText

介绍 Smart View 函数 HsSetText。

数据源类型:Oracle Hyperion Financial Management

说明

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

注:

用户必须单击提交数据以保存单元格文本。

语法

专用连接:

HsSetText("CellTextComments","PrivateConnectionName","POV","CellTextLabel")

共享连接:

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

URL 连接:

HsSetText("CellTextComments","URLFN|URL|Server|Application|Database","POV","CellTextLabel")

有关详细的语法信息,请参阅“手动创建函数”。

示例

在本例中,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")

URL 连接:

HsSetText("H3","URLFN|https://<servername:port>/hfmadf/../hfmofficeprovider/OfficeProvider|<servername:port>|<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")