介绍 Smart View 函数 HsSetValue。
云数据源类型:Oracle Essbase、Planning、Planning 模块、Financial Consolidation and Close、Tax Reporting
内部部署数据源类型:Oracle Essbase、Oracle Hyperion Financial Management 和 Oracle Hyperion Planning
说明
HsSetValue 将视点 (POV) 的选定维成员在工作表中的数据值发送到数据源。HsSetValue 不支持属性维和成员。
要向数据源发送数据,您必须具有该数据源的相应加载规则和写权限。
在 Smart View 11.1.2.5.810+ 中,HsSetValue 可以用来发送枚举的数据类型,例如智能列表、文本和日期。
语法
专用连接:
HsSetValue (value,"PrivateConnectionName","POV")
共享连接:
HsSetValue (value,"WSFN|ProviderType|Server|Application|Database","POV")
URL 连接:
HsSetValue (value,"URLFN|URL|Server|Application|Database","POV")
有关详细的语法信息,请参阅“手动创建函数”。
示例 17-5 基本示例
云数据源类型:Essbase、Planning、Planning 模块、Financial Consolidation and Close、Tax Reporting
内部部署数据源类型:Essbase、Financial Management 和 Planning
在本例中,HsSetValue 会将 H4 单元格的值发送到 HFM01 应用程序。
专用连接:
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")
共享连接:
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 连接:
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")
示例 17-6 包含智能列表的示例
云数据源类型:Planning、Planning 模块、Financial Consolidation and Close、Tax Reporting
在此示例中,语法类似于用于文本的语法,但是文本必须与智能列表中的文本值之一匹配。
专用连接:
HsSetValue("Trips", "Vision","Account#7110: Advertising","Period#x---------x","HSP_View#BaseData","Year#FY16","Scenario#Forecast","Version#Driver","Entity#International Sales","Product#No Product")
共享连接:
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 连接:
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")
示例 17-7 包含文本的示例
云数据源类型:Planning、Planning 模块、Financial Consolidation and Close、Tax Reporting
在函数内使用文本值时,应在文本值两侧加引号。
专用连接:
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")
共享连接:
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 连接:
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")
示例 17-8 包含日期的示例
云数据源类型:Planning、Planning 模块、Financial Consolidation and Close、Tax Reporting
在函数内使用日期值时,应在日期值两侧加引号。
专用连接:
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")
共享连接:
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 连接:
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")
示例 17-9 包含日期的示例,其中使用 TODAY 函数作为今天的日期
云数据源类型:Planning、Planning 模块、Financial Consolidation and Close、Tax Reporting
还可以使用 TODAY 函数作为今天的日期。
专用连接:
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")
共享连接:
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 连接:
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")