Creating a connection using Shared Connections
You can create a connection using Shared Connections, if you know the URL.
To add a connection using a URL:
To set the Shared Connection URL: From Smart View > Options > Advanced Tab > Shared Connections URL: http://[server]:[port]/workspace/SmartViewProviders
From the Smart View ribbon, select Panel.
From the Smart View panel, select the arrow next to the Home button, and then select Shared Connections.
Provide the user authentication details and then using the Shared Connection drop-down list select the Oracle Hyperion Strategic Planning, Fusion Edition connection provider.
Expand the Strategic Finance server node.
Expand the Strategic Finance Database that you want to add to the connection and click OK.
For more information, see Oracle Hyperion Smart View for Office User's Guide.