HsGetValue
Description
HsGetValue retrieves data from the data source for selected dimension members of a Point of View (POV).
When HsGetValue retrieves no data, the value specified for the Missing/No Data Label replacement option is used (see Data Options).
When HsGetValue and HsSetValue are on the same sheet, and you select Refresh, only HsGetValue is called. If you select Submit, HsSetValue is called. If HsSetValue returns successfully, then you must then select Refresh to call HsGetValue.
HsGetValue supports the use of one attribute dimension and member with Planning, Planning Modules, Financial Consolidation and Close, Tax Reporting data sources (see Example 17-2).
Example 17-1 Example without Attribute
In this example, HsGetValue returns the value from the Vision application, Plan1 cube (represented by the MyVision connection name), for the specified POV.
=HsGetValue("MyVision","Account#Amount","Period#Jan","Years#2017","Scenario#Annual Contract","Version#Final","Entity#AR02-Argentina-IS_Adjustments","Package#Depreciation","Currency#Local Currency")
Example 17-2 Example with Attribute
In this example, HsGetValue returns the value from the Vision application, Plan1 cube (represented by the MyVision connection name), and the POV includes an attribute dimension and member, Entity_Regions#NA_Reg.
Note:
HsGetValue supports only one attribute dimension and member per function.
=HsGetValue("MyVision","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")