Oracle Smart View for Office supports these connection types. You see the same data irrespective of the connection type you use.
Shared connections: Use public URL of an environment, which is also used to access the environment through a browser, to establish a connection between Smart View and an Oracle Enterprise Performance Management Cloud environment. See Configuring a Shared Connection
Private connections: Use the an environment-specific URL to establish a connection between Smart View and an EPM Cloud environment. See Configuring a Private Connection.
See "Shared Connections and Private Connections" in Oracle Smart View for Office User's Guide for more information on these connection types.
Note:Account Reconciliation does not use Smart View.