Unable to Create Essbase 11.1.2 Private Connection in SmartView

Applies to:

Hyperion Essbase - Version: 11.1.2.0.00 and later   [Release: 11.1 and later ]
Information in this document applies to any platform.

Symptoms

Unable to create Essbase 11.1.2 private connection in SmartView on Excel 2003 and 2007.

Provider Services 11.1.2.

Entering the URL http://hostname:port/aps/SmartView does not populate server list in the "Application/Cube" connection dialog.

Cause

During configuration it did not update all the files.

Solution

1. Stop all the services where Shared Services installed.

2. Reconfigure Web Server.

3. Start first Oracle ohsinstance, then Hyperion Foundation service, then the rest.

4. Configure Shared Connections first. Here is the URL.

http://HSSmachinename:19000/workspace/SmartViewProviders

5. Add Essbase servers.

 

6. If the first steps did not fix the issue, then do the following manual steps:

A: Connect to the interop url: http://:19000/interop

B: Expand Application group->Foundation->Deployment Metadata->Shared Services Registry->Essbase-> And locate APS LWA

C: Right click on the 'datasources.xml' file and select “Export for Edit”

D: Modify the file add APS servers under Essbase type:

E: Right click on datasource.xml and select “Import after Edit” and import the file back in.

For further details regarding working with the registry please refer to the following guide:

http://download.oracle.com/docs/cd/E12825_01/epm.111/epm_backup_recovery.pdf
Chapter 3

F: Restart the APS Server.