HsSetValue

Cloud data source types: Oracle Analytics Cloud - Essbase, Planning, Planning Modules, Financial Consolidation and Close, Tax Reporting

On-premises data source types: Oracle Essbase, Oracle Hyperion Financial Management, Oracle Hyperion Planning,

Description

HsSetValue sends a data value from a worksheet to a data source for selected members of a dimension. To send data to a data source, you must have the appropriate load rule and have write access for the data source.

In Smart View 11.1.2.5.810+, HsSetValue can be used to send enumerated data types, such as Smart List, text, and dates.

Syntax

Private connection:

HsSetValue (value,"PrivateConnectionName","POV")

Shared connection:

HsSetValue (value,"WSFN|ProviderType|Server|Application|Database","POV")

For detailed syntax information, see Creating Functions Manually.

Example 24-5 Basic Example

Cloud data source types: Oracle Analytics Cloud - Essbase, Planning, Planning Modules, Financial Consolidation and Close, Tax Reporting

On-premises data source types: Essbase, Financial Management, Planning,

In this example, HsSetValue sends the value from cell H4 to the HFM01 application.

Private connection:

HsSetValue(H4, "HFM01","Scenario#Actual;Year#2004;Period#"&B$2&";View#<Scenario View>;Entity#UnitedStates.Connecticut;Value#<Entity Currency>;Account#"&$A4&";ICP#[ICP None];Custom1#GolfBalls;Custom2#Customer2;Custom3#[None];Custom4#
Increases")

Shared connection:

HsSetValue(H4, "WSFN|HFM|hfm_svr|HFM01|HFM01","Scenario#Actual;Year#2004;Period#"&B$2&";View#<Scenario View>;Entity#UnitedStates.Connecticut;Value#<Entity Currency>;Account#"&$A4&";ICP#[ICP None];Custom1#GolfBalls;Custom2#Customer2;Custom3#[None];Custom4#
Increases")

Example 24-6 Example with Smart List

Cloud data source types: Planning, Planning Modules, Financial Consolidation and Close, Tax Reporting

In this example, the syntax is similar to that used for text, but the text but has to match one of the text values in the Smart List.

Private connection:

HsSetValue("Trips", "Vision","Account#7110: Advertising","Period#x---------x","HSP_View#BaseData","Year#FY16","Scenario#Forecast","Version#Driver","Entity#International Sales","Product#No Product")

Shared connection:

HsSetValue("Trips", "WSFN|HP|serviceURL|Vision|Plan1","Account#7110: Advertising","Period#x---------x","HSP_View#BaseData","Year#FY16","Scenario#Forecast","Version#Driver","Entity#International Sales","Product#No Product")

Example 24-7 Example with Text

Cloud data source types: Planning, Planning Modules, Financial Consolidation and Close, Tax Reporting

When using a text value inside the function, surround the text value with quotation marks.

Private connection:

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

Shared connection:

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

Example 24-8 Example with Date

Cloud data source types: Planning, Planning Modules, Financial Consolidation and Close, Tax Reporting

When using the date value inside the function, surround the date value with quotation marks.

Private connection:

HsSetValue("01/03/2003","Vision","Account#Request Date","Period#x---------x","HSP_View#BaseData","Year#FY16","Scenario#Plan","Version#Working","Entity#No Department","Product#No Product")

Shared connection:

HsSetValue("01/03/2003","WSFN|HP|serviceURL|Vision|Plan1","Account#Request Date","Period#x---------x","HSP_View#BaseData","Year#FY16","Scenario#Plan","Version#Working","Entity#No Department","Product#No Product")

Example 24-9 Example with Date Using TODAY Function for Today's Date

Cloud data source types: Planning, Planning Modules, Financial Consolidation and Close, Tax Reporting

You can also use the TODAY function for today's date.

Private connection:

HsSetValue(TEXT(TODAY(),"mm/dd/yyyy"),"Vision","Account#Request Date","Period#x---------x","HSP_View#BaseData","Year#FY16","Scenario#Plan","Version#Working","Entity#No Department","Product#No Product")

Shared connection:

HsSetValue(TEXT(TODAY(),"mm/dd/yyyy"),"WSFN|HP|serviceURL|Vision|Plan1","Account#Request Date","Period#x---------x","HSP_View#BaseData","Year#FY16","Scenario#Plan","Version#Working","Entity#No Department","Product#No Product")