Posted on February 14, 2013 by skoosam under HFM
Connectivity of HFM Application via Financial Reporting Studio
Issue:Error:Failed To Connect To HFM Application When Using Financial Reporting Studio : “Error connecting to database connection : Server/Cluster is incorrectly configured.
In Financial Reporting Studio, users are trying to run reports that use a HFM datasource are getting an error.
“Error connecting to database connection [name]: Server/Cluster is incorrectly configured. Please reconfigure your Cluster or Server connection.”
RootCause: Financial Reporting Studio is not able to locate the HFM cluster.
Testing also determined that the HFM client could not connect to the HFM cluster.
The HFM cluster was not correctly configured.
Solution: Set up the HFM cluster on the FR Studio machine.
1. Go to Start > All Programs > Hyperion >Financial Management >Server and Web Configuration
2. Go to the Server/Cluster Registration tab.
3. Enter the computer name of the HFM server used to get cluster information or the name of the single server if using a
non-clustered environment. The HFM server needs to be referenced exactly as it is on the HFM server
(hostname/IP/FQDN/clustername, as well as case-sensitivity for any letters).
4. Apply and OK.
5. Restart FR Studio.
Note: if HFM client is not on the FR Studio box, it will need to be installed prior to set up of the HFM cluster as listed
above.