Tips on Xcelsius and SAP NetWeaver BW connection : #2032 error

[Former Member]

In this my first blog i explain a solution about a problem that can be appear during the creation of a SAP NetWeaver BW connection on Xcelsius.

First at all, I would remember the basis requirement’s for create a SAP BW connection on Xcelsius:·        

• on the client side : Xcelsius Enterprise Designer 2008 SP2 (trial or engage versions do not offer this connectivity) and SAP GUI patch 901 or above·        
• on the server side : NW 7.0 EhP1 SP5 with ABAP and Java stacks. 

The problem that can be raised during the creation of SAP Netwever BW connection on Xcelsius is the popup window with the mysterious error message: #2032:

To find the cause of this error,  i have  monitored the HTTP request and  HTTP response during the creation of a SAP BW connection on Xcelsius by  freeware software Fiddler2  that it can download by this link: http://www.fiddler2.com/.  
By this software, I finded the reason behind the error message #2032:  Xcelsius wasn’t able to translate the host name of SAP BW application server to a valid IP address .

So as a workaround, i have written a map rule for the hostname used by Xcelsius ( that in the example image is server.ibi.it )  and the IP address of SAP BW application server in the hosts file. 

 

The hosts file’s is  a computer file used in an operating system to map hostnames to IP addresses and his location is: %SystemRoot%\system32\drivers\etc\. 

Then i created a  SAP Netweaver BW connection on Xcelsius with successful.