Where are Smart View’s Shared Connections Stored and How to Configure them?

Where are Smart View’s Shared Connections Stored and How to Configure them?


Hyperion Essbase - Version 11.1.2.0.00 and later
Information in this document applies to any platform.
***Checked for relevance on 26-Nov-2012***


Where are Smart View’s shared connections stored and how do you configure them?

Fix

Smart View Shared connections are stored in a central location and are available to multiple users through the SmartView Panel. They are created and maintained by your administrator.

These connections are stored in the Shared Services Registry, which is part of the Shared Services relational database schema.  Access to them is via a web services call to the EPM Workspace Web application.

To configure Smart View Shared Connections:

1. Launch Excel and go to the Smart View -> Options -> Advanced tab
2. Enter the EPM Workspace URL as the Shared Connections URL in the format of:

http://:/workspace/SmartViewProviders 

For example: http://MyServer:19000/workspace/SmartViewProviders