We are using Planning v220.127.116.11.00. We have a load balancing url that can connect to either one of two planning servers. Is there any way to setup a SmartView Planning connection using "Common Provider Connection" so that we can take advantage of the GUI interface to access folders/forms rather than creating a connection via "Independent Provider Connections"?
The problem I am having is the config screen does not like the url (https://ABC/HyperionPlanning/Smartview) that I enter for "Product Server URL" input field. I even try to put the port number :8300 as part of the url but it does not like it. The only way I got it to work is by entering one of the two planning servers, but this will restrict that connection that particular server and we want it to use a different server based on the load balancer.
Really appreciate your help on this.
SmartView is looking for the response that Planning typically sends when you give it the Planning URL.
If you can get your load balancer to provide that same output (which would come from one of the Planning servers) then SmartView should accept that connections.
John A. Booth
In Data Source Manager, select 'All' for views
Right click on 'Oracle Hyperion Planning' and select 'Add'
Select 'Oracle Hyperion Planning'
Type in a short name
Enter a URL which when you browse to it shows: "Hyperion Planning Server for SmartView"
Enter admin and admin's passwod.
Once you have done this procedure people selecting 'All' in data source manager should see the configured data source.
John A. Booth
This is the URL I use: "https://ABCx/HyperionPlanning/SmartView" and get the following info when I access this URL via an IE browser session:
Hyperion Planning Server for SmartView
Smartview Installer Version: 18.104.22.168.00
When I try to use this same URL in setting up the connection as you have indicated using an administration account I get the following error:
"Please check if the Server / URL you provided is correct and the server is up an running"
Planning is up as I use the normal planning app URL (https://ABCx/HyperionPlanning/)
What am I doing wrong?
If you give one of the planning URL's directly it works? If you do that is it http or https?
You may want to get an Oracle case going if you haven't already.
John A. Booth
Did you ever find a resolution to this issue? We are currently experiencing the same issue, and have not found any direction or resolution yet. We are currently working with Oracle to diagnose, but haven't made headway.
I have issue with my SmartView. I am running SmartView, essbase and planning 22.214.171.124
Everything is running fine until one of my user download SmartView 126.96.36.199 and set up a shared connection to my provider services server.
Not only it doesn't work, saying that the URL is not valid, however, it wipe out the Oracle Hyperion Planning option when you try to add new connection in Common Provider Connection.
Is there any utility or setting that I should change to add the Oracle Hyperion Planning option back to my tree in SmartView 188.8.131.52?
I also see my provider service server under Oracle Essbase tree and i cannot remove it, connect to it.
However My connection to my real essbase server seems to be fine.
Any help would be greatly appreciated.