HsSetValue

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

Description

HsSetValue sends a data value from a worksheet to the data source for selected dimension members of a Point of View (POV). Attribute dimensions and members are not supported in HsSetValue.

To send data to a data source, you must have the appropriate load rule and have write access for the data source.

Syntax

HsSetValue (value,"ConnectionName","POV")

For detailed syntax information, see Syntax Guidelines.

Example 17-3 Basic Example

In this example, HsSetValue sends the value 123 to the Vision application (represented by the MyVision connection name).

=HSSETVALUE(123, "MyVision","Account#7110: Advertising","Period#x---------x","HSP_View#BaseData","Year#FY19","Scenario#Forecast","Version#Driver","Entity#International Sales","Product#No Product")