Configuring a Private Connection

Steps to configure a private Oracle Smart View for Office connection for Oracle Fusion Cloud Enterprise Performance Management.

See Using the Quick Connection Method in Smart View for Office User's Guide 24 for an alternate way to create a private connection.

To configure a private connection using the Private Connection Wizard:

  1. Start Microsoft Excel.
  2. Click Smart View and then Panel.
  3. In Smart View Panel, click the arrow next to Switch to button (Switch to), and then select Private Connections.
  4. Click Create new connection at the bottom of the panel.
  5. From Smart View, select Smart View HTTP Provider.
  6. In URL, enter the connection URL. See URL Syntax for Smart View Connections for connection syntax.
  7. Click Next.
  8. In Login, enter the user name and password for accessing the service, and then click Sign In.
  9. In Add Connection - Application/Cube, navigate to the application and cube to work with, select it, and then click Next.
  10. In Add Connection - Name/Description, enter a name for the connection and an optional description.
  11. Click Finish.