When try to connect to Essbase via SmartView on my client p.c. I get the following message.
"Cannot connect to the provider because: Cannot connect to provider. The attempt to connect to the server failed. Make sure the server is running in the specified URL."
I am following the instructions from "SampleApp V207 - Virtual Machine Image Deployment Guide"; -
"Note: In order to use SmartView, first install Smartview client on your desktop. Then launch an Microsoft Office product like Excel. Create a Private Connection by providing the URL as http://localhost:13080/aps/SmartView Add the server name as obieesampleapp.us.oracle.com:1423. When prompted for credentials, enter admin/password"
In the above, where it cites; - http://localhost:13080/aps/SmartView - does it mean exactly that - as on my client p.c. (not inside the virtualbox as Excel does not work in the Linux environment) the localhost will be my p.c.'s IP address, not the virtualbox?!
Or is it telling me to try; -
http://obieesampleapp.us.oracle.com:1423:13080/aps/SmartView - which does not seem right either, I am assuming the obieesampleapp etc is what you select once you are connected to the server(?)
Can anyone advise - what localhost should substitute for in the above, how to find out what my VM Box is running as for SmartView?
You should be entering the host name (or possibly the ip depending on your network) of the Virtual Box if you are accessing from a client pc to the VM, make sure you can ping and telnet to the VM from your client pc.
I try the link (with localhost) in the VM and I get a web page successfully; Hyperion Provider Services
The logs are 'clean'
I do have a firewall on my p.c. - and will try completely turning it off to trial (once I have disabled wifi et al) but can you advise what I would explicitly need to leave open in the firewall as I do not see provision to allow the VM program?