HsSetValue

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

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 21-5 Basic Example

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

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 21-6 Example with Smart List

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 21-7 Example with Text

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

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 21-8 Example with Date

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 21-9 Example with Date Using TODAY Function for Today's Date

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