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