介绍 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数据源(请参阅“示例 17-3”)。
在 Smart View 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 模块、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")