描述 Smart View 函數 HsSetValue。
雲端資料來源類型:Oracle Essbase、Planning、Planning 模組、Financial Consolidation and Close、Tax Reporting
內部部署資料來源類型:Oracle Essbase、Oracle Hyperion Financial Management、Oracle Hyperion Planning
描述
HsSetValue 會將工作表中的資料值傳送到檢視點 (POV) 之已選取維度成員的資料來源。在 HsSetValue 中,屬性維度和成員並不受支援。
若要傳送資料至資料來源,您必須要具有適當的載入規則以及資料來源的寫入存取權。
在智慧型檢視 11.1.2.5.810+ 中,HsSetValue 可用來傳送列舉資料類型,例如,智慧型列示、文字,以及日期。
語法
專用連線:
HsSetValue (value,"PrivateConnectionName","POV")
共用連線:
HsSetValue (value,"WSFN|ProviderType|Server|Application|Database","POV")
URL 連線:
HsSetValue (value,"URLFN|URL|Server|Application|Database","POV")
如需詳細的語法資訊,請參閱手動建立函數。
範例 17-5 基本範例
雲端資料來源類型:Essbase、Planning、Planning 模組、Financial Consolidation and Close、Tax Reporting
內部部署資料來源類型:Essbase、Financial Management、Planning、
在此範例中,HsSetValue 會將值從儲存格 H4 傳送到 HFM01 應用程式。
專用連線:
HsSetValue(H4, "HFM01","Scenario#Actual;Year#2004;Period#"&B$2&";View#<Scenario View>;Entity#UnitedStates.Connecticut;Value#<Entity Currency>;Account#"&$A4&";ICP#[ICP None];Custom1#GolfBalls;Custom2#Customer2;Custom3#[None];Custom4# Increases")
共用連線:
HsSetValue(H4, "WSFN|HFM|hfm_svr|HFM01|HFM01","Scenario#Actual;Year#2004;Period#"&B$2&";View#<Scenario View>;Entity#UnitedStates.Connecticut;Value#<Entity Currency>;Account#"&$A4&";ICP#[ICP None];Custom1#GolfBalls;Custom2#Customer2;Custom3#[None];Custom4# Increases")
URL 連線:
HsSetValue(H4, "URLFN|http://<servername:port>/hfmadf/../hfmadf/officeprovider|<servername:port>|HFM01|HFM01","Scenario#Actual;Year#2004;Period#"&B$2&";View#<Scenario View>;Entity#UnitedStates.Connecticut;Value#<Entity Currency>;Account#"&$A4&";ICP#[ICP None];Custom1#GolfBalls;Custom2#Customer2;Custom3#[None];Custom4# Increases")
範例 17-6 含智慧型列示的範例
雲端資料來源類型:Planning、Planning Modules、Financial Consolidation and Close、Tax Reporting
在此範例中,語法和用於文字的語法類似,但文字必須符合「智慧型列示」中的其中一個文字值。
專用連線:
HsSetValue("Trips", "Vision","Account#7110: Advertising","Period#x---------x","HSP_View#BaseData","Year#FY16","Scenario#Forecast","Version#Driver","Entity#International Sales","Product#No Product")
共用連線:
HsSetValue("Trips", "WSFN|HP|serviceURL|Vision|Plan1","Account#7110: Advertising","Period#x---------x","HSP_View#BaseData","Year#FY16","Scenario#Forecast","Version#Driver","Entity#International Sales","Product#No Product")
URL 連線:
HsSetValue("Trips", "URLFN|https://<servername:port>/HyperionPlanning/SmartView|<servername:port>|Vision|Plan1","Account#7110: Advertising","Period#x---------x","HSP_View#BaseData","Year#FY16","Scenario#Forecast","Version#Driver","Entity#International Sales","Product#No Product")
範例 17-7 使用文字的範例
雲端資料來源類型:Planning、Planning Modules、Financial Consolidation and Close、Tax Reporting
當您在函數中使用文字值時,請使用引號括住文字值。
專用連線:
HsSetValue("Enter Some Text", "Vision","Account#7110: Advertising","Period#Jun","HSP_View#BaseData","Year#FY16","Scenario#Plan","Version#Commentary","Entity#International Sales","Product#No Product")
共用連線:
HsSetValue("Enter Some Text", "WSFN|HP|serviceURL|Vision|Plan1","Account#7110: Advertising","Period#Jun","HSP_View#BaseData","Year#FY16","Scenario#Plan","Version#Commentary","Entity#International Sales","Product#No Product")
URL 連線:
HsSetValue("Enter Some Text", "URLFN|https://<servername:port>/HyperionPlanning/SmartView|<servername:port>|Vision|Plan1","Account#7110: Advertising","Period#Jun","HSP_View#BaseData","Year#FY16","Scenario#Plan","Version#Commentary","Entity#International Sales","Product#No Product")
範例 17-8 使用日期的範例
雲端資料來源類型:Planning、Planning Modules、Financial Consolidation and Close、Tax Reporting
在函數內使用日期值時,請使用引號括住日期值。
專用連線:
HsSetValue("01/03/2003","Vision","Account#Request Date","Period#x---------x","HSP_View#BaseData","Year#FY16","Scenario#Plan","Version#Working","Entity#No Department","Product#No Product")
共用連線:
HsSetValue("01/03/2003","WSFN|HP|serviceURL|Vision|Plan1","Account#Request Date","Period#x---------x","HSP_View#BaseData","Year#FY16","Scenario#Plan","Version#Working","Entity#No Department","Product#No Product")
URL 連線:
HsSetValue("01/03/2003","URLFN|https://<servername:port>/HyperionPlanning/SmartView|<servername:port>|Vision|Plan1","Account#Request Date","Period#x---------x","HSP_View#BaseData","Year#FY16","Scenario#Plan","Version#Working","Entity#No Department","Product#No Product")
範例 17-9 使用 TODAY 函數表示今天的日期的日期範例
雲端資料來源類型:Planning、Planning Modules、Financial Consolidation and Close、Tax Reporting
您也可以使用 TODAY 函數表示今天的日期。
專用連線:
HsSetValue(TEXT(TODAY(),"mm/dd/yyyy"),"Vision","Account#Request Date","Period#x---------x","HSP_View#BaseData","Year#FY16","Scenario#Plan","Version#Working","Entity#No Department","Product#No Product")
共用連線:
HsSetValue(TEXT(TODAY(),"mm/dd/yyyy"),"WSFN|HP|serviceURL|Vision|Plan1","Account#Request Date","Period#x---------x","HSP_View#BaseData","Year#FY16","Scenario#Plan","Version#Working","Entity#No Department","Product#No Product")
URL 連線:
HsSetValue(TEXT(TODAY(),"mm/dd/yyyy"),"URLFN|https://<servername:port>/HyperionPlanning/SmartView|<servername:port>|Vision|Plan1","Account#Request Date","Period#x---------x","HSP_View#BaseData","Year#FY16","Scenario#Plan","Version#Working","Entity#No Department","Product#No Product")