Cloud data source types: Oracle Analytics Cloud - Essbase, Oracle Planning and Budgeting Cloud, Oracle Enterprise Planning and Budgeting Cloud, Oracle Financial Consolidation and Close Cloud, Oracle Tax Reporting Cloud
On-premise 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.
Syntax
Private connection:
HsSetValue (dollar amount,"PrivateConnectionName","POV")
Shared connection:
HsSetValue (dollar amount,"WSFN|ProviderType|Server|Application|Database","POV")
For detailed syntax information, see Creating Functions Manually.
Example
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")