描述 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 資料來源 (請參閱 範例 18-2)。
在智慧型檢視 11.1.2.5.720+ 中，HsGetValue 可以用來傳回列舉資料類型，例如，智慧型列示、文字，以及日期 (請參閱範例 18-3)。
使用 Narrative Reporting 24.02 版或更新的版本時，利用 Excel 儲存格參照所建立的 HsGetValue() 函數支援伺服器起始的重新整理功能。
語法
專用連線：
HsGetValue("PrivateConnectionName","POV")
共用連線：
HsGetValue("WSFN|ProviderType|Server|Application|Database","POV")
URL 連線：
HsGetValue("URLFN|URL|Server|Application|Database","POV")
如需詳細的語法資訊，請參閱手動建立函數。
範例 18-1 不含屬性的範例
雲端資料來源類型：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")
範例 18-2 含屬性的範例
雲端資料來源類型：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")
範例 18-3 含智慧型列示的範例
雲端資料來源類型：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")範例 18-4 儲存格參照至來源連線的範例
針對資料來源連線的儲存格參照所建立的 HsGetValue 函數，則在 Excel 檔案中，使用 URL 連線格式來定義該函數的連線：
URLFN|URL:Port|Server|Application|Database
註：
如果您的工作簿包含 HsGetValue 函數，且該函數使用指向專用連線名稱的儲存格參照，請注意，專用連線無法在不同機器之間移轉，因此不會受到伺服器起始的重新整理功能的支援。Oracle 建議您將這些函數轉換成使用 URLFN 格式。
針對下列範例，假設儲存格 B1 包含連線資訊。請以下列格式輸入連線資訊，並在開頭加上 URLFN：
URLFN|http://<serviceURL>:<port>/HyperionPlanning/SmartView|<serverName>|App|Database
然後，利用參考儲存格 B1 的連線參數來建立函數，如下所示：
=HsGetValue(B1,"Scenario#Actual","Year#2004","Period#July","View#YTD","Entity#UnitedStates.Utah","Value#USD","Account#Sales","ICP#[ICP None]","Custom1#GolfBalls","Custom2#Customer2","Custom3#[None]","Custom4#Increases")