HsSetValue

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

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.

HsSetValue can also be used to send enumerated data types, such as Smart List, text, and dates.

Note:

HsSetValue function should not be used to set value for a data cell containing supporting details. If used, the HsSetValue function cannot identify if a cell contains supporting details or not, and proceeds to update and submit the cell value with the new function-fetched value. This leads to an incorrect behavior. The original value continues to appear in the Supporting Details dialog box for the cell. So it is recommended not to use HsSetValue function to set value in cells with supporting details.

Syntax

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

For detailed syntax information, see Syntax Guidelines.

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

Example 13-4 Example with Text

Quotation marks are required when text is used for the value parameter in HsSetValue.

HsSetValue("Enter Some Text", "MyVision","Account#7110: Advertising","Period#Jun","HSP_View#BaseData","Year#FY16","Scenario#Plan","Version#Commentary","Entity#International Sales","Product#No Product")