You may be surprised to know that the Get and Set Value functions can use a shared connection. Rather than using the private connection name, the following can be specified to use a shared connection in place of the private connection name.
Private connection syntax:
HsSetValue (dollar amount,”PrivateConnectionName”,”POV”)
Shared connection syntax:
HsSetValue (dollar amount,”WSFN|ProviderType|Server|Application|Database”,”POV”)
- “WSFN” is a static string and never changes
- The provider type for planning is “HP” regardless of whether the server is a cloud server or on premise server
- The server specifies the location of the server housing the application. For PBCS, use the URL provided by Oracle (planning-test-domain.pbcs.us2.oraclecloud.com)
- The application is the application name
- The database is the plan type, or database name
Put that all together and the string looks like this.
Although there are a few drawbacks to using a shared connection (users could use the wrong connection and not get the expected result), my experience has been that the pros (no setup of private connections, can be used in multiple environments without changing anything, etc.) far outweigh the cons.