HsGetValue

Applies to: Planning, Planning Modules, Financial Consolidation and Close, Tax Reporting, Oracle Essbase

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).

Syntax

HsGetValue("ConnectionName","POV")

For detailed syntax information, see Syntax Guidelines.

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")