介绍 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 模块、Financial Consolidation and Close、Tax Reporting数据源（请参阅“示例 18-2”）。
在 Smart View 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 模块、Financial Consolidation and Close、Tax Reporting
在此示例中，HsGetValue 从 Vision 应用程序、Plan1 数据库返回一个智能列表值。本例中的智能列表查找 "Cleaning and Maintenance "的动因值。可能会返回的值包括："% of Revenue"、"Units"、"FTE Hours"、"Sales Calls"、"Trips"、"Square Feet" 和 "None"。
专用连接：
=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")