Data sources: Financial Management, Essbase, Planning; Hyperion Enterprise (private connection only)
HsSetValue sends a data value from a worksheet to a data source selected members of a dimension. To send data to a data source, you must have the appropriate load rule and write
access for the data source.
HsSetValue (dollar amount,"PrivateConnectionName","POV")
HsSetValue (dollar amount,"WSFN|ProviderType|Server|Application|Database","POV")
Refer Page 202 of http://docs.oracle.com/cd/E40248_01/epm.1112/smart_view_user.pdf
We are using Hyperion 188.8.131.52 and the application is Planning ASO. When i'm using Private connection it is working fine for Essbase cube
In the Shared connection, can you pls. give me the syntax of what to use for Planning ? Do i've to keep like "WSFN|Planning|server_name|Application|Database" for the connection name ?
Is HsSet works for Planning ??
Also as it is planning ASO Application, users are unable to see Essbase database with in Essbase Add-in / SmartView. Pls. advice
I think direct connection to Essbase might not work. Have you tried using the Planning connection and Adhoc? HSGetValue works only with Essbase connection. Correct me if I am wrong
Are you using private connection to connect to Planning via Smartview?