How to bring specific URL`s as Shared connection in Excel smartview

Requirement 

There are two URL`s which needs to be used and connected  as shared connection in excel smartview.

Users don`t have to enter the URL manually when they want to connect to that environment.

Rather they want an option where if they click on Shared connection and click on the drop down it should list those two required URL`s

Create a XML file in the below format, Save and name that file as "SharedConnection"

<?xml version="1.0" encoding="UTF-8"?>

<res_GetProvisionedDataSources>

<Product id="HP" name="name" displayVersion="version">

<Server name="ENVIRONMENT 1" context="https://<URL>/SmartView"></Server>

</Product>

<Product id="HP1" name="name" displayVersion="version">

<Server name="ENVIRONMENT 2" context="https://<URL>/SmartView"></Server>

</Product>

</res_GetProvisionedDataSources>

Save the file to the location where smartview is installed "C:\Oracle"

Then Close Excel and reopen - You will find those two URL as shown below 

How to overcome Blank page issue during Drill-through via Smartview in EPM Cloud

In EPM Cloud, (PBCS,EPBCS) users might face an issue while doing a drill-through to data management or drill-through to source values.
Users might get a Blank page during the process.

The Smart View extension (add-in) for the browser would have not been installed.

To install the add-ins, refer the steps below

Chrome: 

Download the Smart View for Office extension from the Chrome web store.

Firefox:

Information about the Firefox add-in -
https://docs.oracle.com/applications/smartview/720/SVNST/firefox_extension_100x0867c8ee.htm#SVNST-GUID-DA412821-E7CD-40E4-9CA0-9739D8CAC0D8

For, IE11 - The following settings changes have to be completed -


Go to Tools > Internet Options > General > Tabs

Choose Open links from other programs : The current tab or window