HsSetValue

Describes the Smart View function, HsSetValue.

Data source types: Oracle Essbase, 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.

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

Data source types: 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")

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

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

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

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

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