HsSetValue
Describes the Smart View function, HsSetValue.
Cloud data source types: Oracle 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 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.
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")URL connection:
HsSetValue (value,"URLFN|URL|Server|Application|Database","POV")For detailed syntax information, see Creating Functions Manually.
Example 17-5 Basic Example
Cloud data source types: 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")URL connection:
HsSetValue(H4, "URLFN|http://<servername:port>/hfmadf/../hfmadf/officeprovider|<servername:port>|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 17-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")URL connection:
HsSetValue("Trips", "URLFN|https://<servername:port>/HyperionPlanning/SmartView|<servername:port>|Vision|Plan1","Account#7110: Advertising","Period#x---------x","HSP_View#BaseData","Year#FY16","Scenario#Forecast","Version#Driver","Entity#International Sales","Product#No Product")Example 17-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")URL connection:
HsSetValue("Enter Some Text", "URLFN|https://<servername:port>/HyperionPlanning/SmartView|<servername:port>|Vision|Plan1","Account#7110: Advertising","Period#Jun","HSP_View#BaseData","Year#FY16","Scenario#Plan","Version#Commentary","Entity#International Sales","Product#No Product")Example 17-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")URL connection:
HsSetValue("01/03/2003","URLFN|https://<servername:port>/HyperionPlanning/SmartView|<servername:port>|Vision|Plan1","Account#Request Date","Period#x---------x","HSP_View#BaseData","Year#FY16","Scenario#Plan","Version#Working","Entity#No Department","Product#No Product")
Example 17-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")URL connection:
HsSetValue(TEXT(TODAY(),"mm/dd/yyyy"),"URLFN|https://<servername:port>/HyperionPlanning/SmartView|<servername:port>|Vision|Plan1","Account#Request Date","Period#x---------x","HSP_View#BaseData","Year#FY16","Scenario#Plan","Version#Working","Entity#No Department","Product#No Product")