描述 Smart View 函數 HsGetValue。
雲端資料來源類型：Oracle Essbase、Planning、Planning 模組、Financial Consolidation and Close、Tax Reporting、Narrative Reporting
內部部署資料來源類型：Oracle Essbase、Oracle Hyperion Financial Management、Oracle Hyperion Planning
描述
HsGetValue 會從檢視點 (POV) 之已選取維度成員的資料來源擷取資料。
當 HsGetValue 擷取不到資料時，將會使用對 #NoData/Missing 標籤取代選項指定的值 (請參閱表格 5-7)。
當使用者選取「重新整理」或「全部重新整理」時，只會呼叫 HsGetValue。當使用者選取「提交」時，會先呼叫 HsSetValue，如果 HsSetValue 成功傳回，才會接著呼叫 HsGetValue。
HsGetValue 函數支援和 Essbase 資料來源搭配使用一個屬性維度和成員。在 Oracle Smart View for Office 11.1.2.5.710+ 中，HsGetValue 將屬性支援擴充至 Planning、Planning Modules、Financial Consolidation and Close、Tax Reporting 資料來源 (請參閱 範例 17-3)。
在智慧型檢視 11.1.2.5.720+ 中，HsGetValue 可以用來傳回列舉資料類型，例如，智慧型列示、文字，以及日期 (請參閱範例 17-4)。
語法
專用連線：
HsGetValue("PrivateConnectionName","POV")
共用連線：
HsGetValue("WSFN|ProviderType|Server|Application|Database","POV")
URL 連線：
HsGetValue("URLFN|URL|Server|Application|Database","POV")
如需詳細的語法資訊，請參閱手動建立函數。
範例 17-2 不含屬性的範例
雲端資料來源類型：Essbase、Planning、Planning 模組、Financial Consolidation and Close、Tax Reporting、Narrative Reporting
內部部署資料來源類型：Essbase、Financial Management、Planning
在此範例中，HsGetValue 會從 HFM01 應用程式傳回預設 POV 的值。
專用連線：
=HsGetValue("HFM01","Scenario#Actual","Year#2004","Period#July","View#YTD","Entity#UnitedStates.Connecticut","Value#USD","Account#Sales","ICP#[ICP None]","Custom1#GolfBalls","Custom2#Customer2","Custom3#[None]","Custom4#Increases")
共用連線：
=HsGetValue("WSFN|HFM|hfm_svr|HFM01|HFM01","Scenario#Actual","Year#2004","Period#July","View#YTD","Entity#UnitedStates.Connecticut","Value#USD","Account#Sales","ICP#[ICP None]","Custom1#GolfBalls","Custom2#Customer2","Custom3#[None]","Custom4#Increases")
URL 連線：
=HsGetValue("URLFN|http://<servername:port>/hfmadf/../hfmadf/officeprovider|<servername:port>|HFM01|HFM01","Scenario#Actual","Year#2004","Period#July","View#YTD","Entity#UnitedStates.Connecticut","Value#USD","Account#Sales","ICP#[ICP None]","Custom1#GolfBalls","Custom2#Customer2","Custom3#[None]","Custom4#Increases")
範例 17-3 含屬性的範例
雲端資料來源類型：Essbase、Planning、Planning 模組、Financial Consolidation and Close、Tax Reporting
內部部署資料來源類型：Essbase
在此範例中，HsGetValue 從 Vision 應用程式、Plan1 資料庫傳回值，POV 包含屬性維度和成員 Entity_Regions#NA_Reg。
註：
HsGetValue 僅對每個函數支援一個屬性維度和成員。
專用連線：
=HsGetValue("Vision","Account#Amount","Period#Jan","Years#2017","Scenario#Annual Contract","Version#Final","Entity#AR02-Argentina-IS_Adjustments","Package#Depreciation","Currency#Local Currency","Entity_Regions#NA_Reg")
共用連線：
=HsGetValue("WSFN|HP|serviceURL|Vision|Plan1","Account#Amount","Period#Jan","Years#2017","Scenario#Annual Contract","Version#Final","Entity#AR02-Argentina-IS_Adjustments","Package#Depreciation","Currency#Local Currency","Entity_Regions#NA_Reg")
URL 連線：
=HsGetValue("URLFN|https://<servername:port>/HyperionPlanning/SmartView
|<servername:port>|Vision|Plan1","Account#Amount","Period#Jan","Years#2017","Scenario#Annual Contract","Version#Final","Entity#AR02-Argentina-IS_Adjustments","Package#Depreciation","Currency#Local Currency","Entity_Regions#NA_Reg")
範例 17-4 含智慧型列示的範例
雲端資料來源類型：Planning、Planning Modules、Financial Consolidation and Close、Tax Reporting
在此範例中，HsGetValue 從 Vision 應用程式、Plan1 傳回智慧型列示。在此個案中，「智慧型列示」正在尋找「清除與維護」的「動因」值。可能傳回的值為「收入百分比」、「單位」、「約當全職人數時數」、「銷售電訪」、「差旅」、「平方英呎」以及「無」。
專用連線：
=HsGetValue("Vision","Account#7440: Cleaning and Maintenance","Period#x---------x","HSP_View#BaseData","Year#FY15","Scenario#Plan","Version#Driver","Entity#No Entity","Product#No Product")
共用連線：
=HsGetValue("WSFN|HP|serviceURL|Vision|Plan1","Account#7440: Cleaning and Maintenance","Period#x---------x","HSP_View#BaseData","Year#FY15","Scenario#Plan","Version#Driver","Entity#No Entity","Product#No Product")
URL 連線：
=HsGetValue("URLFN|https://<servername:port>/HyperionPlanning/SmartView|<servername:port>|Vision|Plan1","Account#7440: Cleaning and Maintenance","Period#x---------x","HSP_View#BaseData","Year#FY15","Scenario#Plan","Version#Driver","Entity#No Entity","Product#No Product")