cancel
Showing results for 
Search instead for 
Did you mean: 

Advanced Analysis SAP BW Connectivity

Former Member
0 Kudos
279

Dear Gurus,

I've installed SAP BO Advanced Analysis tool 1.0 in my client successfully but the BW system connections are not showing in the list of connections.

in the "Insert Data Source" dialog box in Advanced Analysis I can't find the BW system connections , I've the SAPLOGON.INI file in the correct path i.e C:\Users\user\AppData\Local\VirtualStore\Windows

and even maintained in the Environment variables but still Advance Analysis is not picking up the list of available BW connections.

Any help will be appreciated.

Regards,

-Neha

Accepted Solutions (1)

Accepted Solutions (1)

0 Kudos

<please ignore>

Edited by: Efstratios Karaivazoglou on Dec 25, 2010 12:34 PM

Former Member
0 Kudos

Hi Stratos,

Thanks for your reply , even I'm not sure as per the document it states the following :

" Local usage

In this case, you define the connected BW systems in the saplogon.ini file in the Windows directory on

your local machine. SAP BusinessObjects Advanced Analysis receives the list of available BW systems

in the saplogon.ini file and creates direct access to the defined systems for data exchange".

I do have BOE XI 3.1 server also , so you mean to say that In the Central Management Console (CMC) of SAP BusinessObjects Enterprise, I've to define connections to SAP NetWeaver BW system ?.

Regards,

-Neha

0 Kudos

Sorry my mistake: Local usage is possible by pressing the Skip button in the BO server login screen.

Please try to save the saplogon.ini as UTF-8 as described in my previous post. I assume that some of your BW systems may have non-english characters in their names. Correct?

Regards,

Stratos

Former Member
0 Kudos

Hi Stratos,

I tried saving saplogin.ini files as UTF-8 , still its not working !

I don't see any non-English characters being used.

May be I've saved saplogin.ini file in wrong path ?

Regards,

-Neha

0 Kudos

Try to add an system environment variable called SAPLOGON_INI_FILE containing the path to your SAP logon.ini file including the file name

eg. if your saplogon.ini file is in c:\temp then the value of the variable should be c:\temp\saplogon.ini

Regards,

Stratos

PS: When you tried to overwrite the file with UTF-8 encoding did you make sure the set the Save as type field to All files ?

0 Kudos

In your case set SAPLOGON_INI_FILE to C:\Users\user\AppData\Local\VirtualStore\Windows\saplogon.ini

Do not forget to start the AA client again after changing the variable.

If this does not work try to copy the saplogon.ini file under c:\windows\system32

Regards,

Stratos

Former Member
0 Kudos

Hi Stratos,

Thanks a ton !! it worked ......I've added saplogon.ini in the environment variables as you've mentioned and it worked.

I've been trying to do this for the last 3 days !!

I'm closing this thread !!!

Thanks & Regards,

-Neha

Former Member
0 Kudos

Hi Nehabibo,

Can you please let me know what is the source (query, infoprovider)for BO AA to fetch data from BW system.

Can you please explain the stpes involved in connecting BO AA to BW system, & the source for BO AA.

Thanks.

Henry_Banks
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi,

this thread is over 1 year inactive. so i will reply and lock it. please create your own thread if you need follow-up.

FWIW :- AA-Office needs to consume BEx Queries (like BEx Analyzer)

AA-Office can log on in 2 ways: via a web service to BI 4.0 platform to authenticate against the CMS, to retrieve published BICS connections.

or, via SAP GUI, connecting "in the normal way" directly to the BW application server's SID, to Roles.

Regards,

H

Answers (2)

Answers (2)

0 Kudos

Open your SAPlogon.ini file using Notepad and choose File->Save as . In the save-as browser select the UTF-8 encoding and overwrite the existing file.

Regards,

Stratos

0 Kudos

< please ignore>

Edited by: Efstratios Karaivazoglou on Dec 25, 2010 12:29 PM