cancel
Showing results for 
Search instead for 
Did you mean: 

BusinessObjects Analysis for Office 2.2 and SAPUILandscapeGlobal.xml

42
Explorer
0 Kudos

Hi there,

we are planning on updating some client components parallel to a scheduled system upgrade.

As a test Installation we have just updated, amongst other things, SAP Gui from 7.30 to 7.40 and BO Analysis for Office from 1.4 to 2.2. AO is used as a BeX replacement. There is no BO server, so Analysis connects to backend Systems defined in SAPLogon. SSO and SNC are used, too. Excel version is 14.0, 32 bit. SAP Gui configuration files have changed from saplogon.ini (7.30) to SAPUILandscape.xml and SAPUILandscapeGlobal.xml (7.40).

Analysis for Office (Excel) worked fine until the update, but since then there is an issue connecting to a backend System. The popup "choose data source" doesn't show any system connection.

Analysing the cause we found a problem looking like AO were not able to use the (new) system configuration xml files in a correct way. Both files are stored in a workdir to which is pointed with environment variable SAPLOGON_LSXML_FILE. SAPUILandscape.xml is (initially) empty and used for user selfdefined connections, e.g. for SAP Business Client. SAPUILandscapeGlobal.xml contains all the (predefined) usable system connections, centrally distributed. SAP Gui works fine with that, AO doesn't.

When using NOT SAPUILandscapeGlobal.xml and instead only SAPUILandscape.xml WITH system configuration in it, Analysis for Office works as it should. No issues, So we found that AO obviously has a problem utilizing the SAPUILandscapeGlobal.xml file.

We have opened an incident on SAP Service Marketplace more than one week ago, no reaction so far...

What can we do? Any ideas? Is it a program error? A configuration issue? Why isn't SAPUILandscapeGlobal.xml used by AO?

Any help is appreciated.

Thank you and best regards,

Dirk Eßling

Accepted Solutions (0)

Answers (3)

Answers (3)

filipe_zeuch
Advisor
Advisor
0 Kudos

Hi Dirk and Nicolas,

The topic #1 in Wiki page below may help with your scenarios:

>> BI-RA-AO-CON Connection and Authentication - SAP NetWeaver Business Warehouse - SCN Wiki

Can you check it? Make sure everything is in place and that you also check the scenario in AO 2.3 SP2.

Regards,

Filipe

Former Member
0 Kudos

Anybody with the same issue ?

We are using BO Analysis for office 2.3 and it doesn`t recognize SAPUILandscapeGlobal.xml

Former Member
0 Kudos

Hi,

Did you find your answer. We have the same issue here !

Regards,

Nicolas