Beschreibt die Smart View-Funktion "HsSetValue".
Cloud-Datenquellentypen: Oracle Essbase, Planning, Planning Modules, Financial Consolidation and Close, Tax Reporting
On-Premise-Datenquellentypen:Oracle Essbase, Oracle Hyperion Financial Management, Oracle Hyperion Planning
Beschreibung
HsSetValue sendet einen Datenwert aus einem Arbeitsblatt an die Datenquelle für ausgewählte Dimensionselemente eines POV (Point of View). Attributdimensionen und -elemente werden in HsSetValue nicht unterstützt.
Um Daten an eine Datenquelle zu senden, müssen Sie über die entsprechende Laderegel und über Schreibzugriff auf die Datenquelle verfügen.
In Smart View 11.1.2.5.810+ kann HsSetValue verwendet werden, um Aufzählungsdatentypen, wie z.B. Smart List, Text und Datumsangaben, zu senden.
Syntax
Private Verbindung:
HsSetValue (value,"PrivateConnectionName","POV")
Gemeinsame Verbindung:
HsSetValue (value,"WSFN|ProviderType|Server|Application|Database","POV")
URL-Verbindung:
HsSetValue (value,"URLFN|URL|Server|Application|Database","POV")
Ausführliche Syntaxinformationen finden Sie unter Funktionen manuell erstellen.
Beispiel 17-5 Grundlegendes Beispiel
Cloud-Datenquellentypen: Essbase, Planning, Planning Modules, Financial Consolidation and Close, Tax Reporting
On-Premise-Datenquellentypen: Essbase, Financial Management, Planning
In diesem Beispiel sendet HsSetValue den Wert aus Zelle H4 an die HFM01-Anwendung.
Private Verbindung:
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")
Gemeinsame Verbindung:
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-Verbindung:
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")
Beispiel 17-6 Beispiel mit Smart List
Clouddatenquellentypen: Planning, Planning-Modulanwendung, Financial Consolidation and Close, Tax Reporting
In diesem Beispiel ähnelt die Syntax der Syntax, die für Text verwendet wird. Der Text muss jedoch einem der Textwerte in der Smart List entsprechen.
Private Verbindung:
HsSetValue("Trips", "Vision","Account#7110: Advertising","Period#x---------x","HSP_View#BaseData","Year#FY16","Scenario#Forecast","Version#Driver","Entity#International Sales","Product#No Product")
Gemeinsame Verbindung:
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-Verbindung:
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")Beispiel 17-7 Beispiel mit Text
Clouddatenquellentypen: Planning, Planning-Modulanwendung, Financial Consolidation and Close, Tax Reporting
Wenn Sie einen Textwert in der Funktion verwenden, müssen Sie ihn in Anführungszeichen setzen.
Private Verbindung:
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")
Gemeinsame Verbindung:
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-Verbindung:
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")Beispiel 17-8 Beispiel mit Datum
Clouddatenquellentypen: Planning, Planning-Modulanwendung, Financial Consolidation and Close, Tax Reporting
Wenn Sie den Datumswert in der Funktion verwenden, müssen Sie ihn in Anführungszeichen setzen.
Private Verbindung:
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")
Gemeinsame Verbindung:
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-Verbindung:
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")
Beispiel 17-9 Beispiel mit Datum und TODAY-Funktion für heutiges Datum
Clouddatenquellentypen: Planning, Planning-Modulanwendung, Financial Consolidation and Close, Tax Reporting
Sie können auch die TODAY-Funktion für das heutige Datum verwenden.
Private Verbindung:
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")
Gemeinsame Verbindung:
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-Verbindung:
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")