Analytics Software

Hi Folks,

I'm getting the following error msg while trying to establish a new db connection on HFR Studio:

*"Error connecting to database connection Sample: Sample"*

I'm using the following values in DB Connection Properties:

DB Connection Name: Sample
Type: Essbase
Server: axe
UserID: hypuser
Password: password
Application: Sample
Database: Basic

I have made sure that my Sample:Basic application is started using EAS. I am also able to access Sample:Basic fine via Excel Addin and Smartview, but when I try to create a new db conn. using HFR Studio or Workspace and the above conn values, I get either the +"Error connecting..."+ msg or a +'Null'+ error msg in case of Workspace.

Could this problem have something to do with user privileges? I have one Admin user that I've provisioned on SS for all available roles, including all Hyperion System 9 BI+ roles. Also my hosts file has proper mapping between +'axe'+ and host IP address. I even tried using localhost instead of axe, but to no avail. Do I need to specify a port number following the server name? I have also tried re-starting all Hyperion services in the prescribed order, but this doesn't help either. Fyi- my db is Oracle 10g XE.. and I have given +'hypuser'+ all possible privileges

Appreciate any guidance. This is the first time I'm working w/ HFR.

thanks,

Akshay