How to connect to CAL SAP HANA SP10 [Developer Edition] using Analysis for Office 2.4

[Former Member]

The objective is perform testing on a BPC Embedded installation using the 'Analysis for Office 2.4' plug-in.

I have setup the CAL - (Cloud Appliance Library) solution called 'SAP NetWeaver AS ABAP and SAP BW 7.5 SP01 on SAP HANA SP10 [Developer Edition]'.

It is running in the AWS cloud platform.

I have installed the MS Excel addin locally called 'Analysis for Office 2.4'.

The web-based BPC Administration console is working from my local machine to the above AWS CAL.

The EPM plug-in is also able to connect to the BPC standard installation in the above CAL.

I am not able to establish a connection to the CAL HANA server using Analysis for Office.

Steps to reproduce:

1. Open 'Analysis for Microsoft Excel'
2. Select 'Analysis' -> 'Insert Data Source' -> Select Data Source'
3. Select 'Create new SAP HANA Connection...'
4. Enter Description: HANA_BPC
5. Scheme: HTTP
6. HostName: < IP Address > (Linux External IP Address)
7. Port: 8000: (Confirmed Port through HANA DB Studio Administration->Configuration->webdispatcher.ini-Profile)
8. Click 'Next'
9. Enter Username (administrator or SYSTEM) and password
10. Message - Unable to connect to the remote server.

I have tested using the HTTP (8000) and HTTPS (4300) ports.

AWS firewall ports remain as the default installation from the initial CAL setup. I am connecting from my home connection where all firewall ports are open.

I have tested from my local (external) PC using the following test link:

http://<Linux Server IP external >:8000/sap/bc/ina/service/v2/GetServerInfo

I have tested the same link from the SAP Internal Front End

http://<Linux Server IP internal >:8000/sap/bc/ina/service/v2/GetServerInfo

I am also not able to connect using the 'Insert Analysis View' in the Analysis for Office plug-in.

Any help appreciated to suggest how I can connect Excel ‘Analysis for Office’ to the AWS CAL - 'SAP NetWeaver AS ABAP and SAP BW 7.5 SP01 on SAP HANA SP10 [Developer Edition]'

Kind Regards,

David