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 18.104.22.168 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