EP-BW integration

[Former Member]

Hi All,

I have done the EP + BW system integration & all connection test for all the 4(DEQ,WAS,ITS & Connector) are tested OK. When i try to pull out reports & show as a dash board it still comes with a popup asking the user/pwd. I tested with IE/mozilla and facing the same issue. Can any one hep me in this?

thanks in adv

Unni

[Former Member]

Please refer to SAP Note :593640

Regards

Anand

[Former Member]

Hi Unni

Put the FQDN (host.domian.com) for host name property for ITS and WAS.

regards,

kaushal

[Former Member]

Hi kaushal,

Thanks for the response. Well i have already given them like that & the connection test seems to be working well. When i pull out reports from the BW to EP, this asks for th e uid/pwd.

thanks

Unni

[Former Member]

Hi unni,

When doing Bw EP integration you got to take into account what kind of user id /password authentication you require. what have you opted for SSO through logon tickets or userid password. If it is logon tickets there are twelve important steps you need to go through for integration. If it is user id password steps for sso only can be skipped.

See Integration between BW 3.5 and EP 6.0 in help.sap.com for more help. If you have any quiries reply back.

Regards,

Ramesh

[Former Member]

Hi Unni

Which logon method u use for user mapping?

Since ur test connection is Ok, means no problem with User mapping.

BW report is basically running from BW WAS (abap was)

which required Fully qualified Host name.(host.domain.com)

In Bw Check the following profile parameter.

using RZ10 open instance profile.

look at following parameter

icm/host_name_full --->bwhost.domin.com

regards,

kaushal

[Former Member]

Hi Kaushal,

Thanks again. I did not find the entry "icm/host_name_full" in the instance profile. Should i go ahead and add the same?

Regards

[Former Member]

Hi Unni

yes save it and u have to restart the BW server for changes.

could u plese specify ur setting for BW was system which u define in portal

ragards,

kaushal

[Former Member]

Hi Kaushal,

path = /sap/bw/BEx

WAS host name = sdsap02.bis1.bisamerica.com:8002.

"sdsap02.bis1.bisamerica.com" was in the windows/host file entry

Unni

[Former Member]

Hi Unni

the setting was ok.

u specified the FQDN in BW (RZ10)

which is look like sdsap02.bis1.bisamerica.com

and ur portal launching URL is look like

http://portalhost.bis1.bisamerica.com:port/irj

regards,

kaushal

[Former Member]

Hi kaushal,

"sdsap02.bis1.bisamerica.com" was in the windows/host file entry & not in the RZ10 (instace profile)

regards

Unni

[Former Member]

Hi Unni

In BW crete new instance profile parameter using RZ10

icm/host_name_full --->sdsap02.bis1.bisamerica.com

reagrds,

kaushal

[Former Member]

Hi kushal,

It still comes with the popup asking the user & password. When i enter them it shows up the BW report.

I am calling a URL iView - does it ask(uid/pwd) always if i use them?

regards

Unni

[Former Member]

Hi Unni,

U calling the BW query (report) using URL iview,

instead of that use following

1.Right-click on the iViews folder and choose New ->iView.

The iView Wizard appears.

2.In the iView Wizard

a.Select SAP BW Report iView and choose Next.

b.Enter a name, iView ID and iView ID Prefix choose Next.

c.Select the SAP BW system alias SAP_BW and in the BEx Web Application Query String, copy the query id from the URL of your desired query from the string text &INFOCUBE on wards (for example, &INFOCUBE=0SD_C04&QUERY=0SD_C04_Q0001) and choose Next.

Note: If you do not have the URL for the query you wish to create an iView for, simply log into the SAP BW system and launch the Query in the Web Browser. Select the query string in the URL navigation bar by highlighting it and copying it. You can paste this into the iView Wizard field, BEx Web Application Query String.

d.Select the check box for Open for editing when Wizard completes and choose Finish.

e.Make modifications to the Attributes by changing Height Type to FULL_PAGE.

f.Save your changes and select Preview. Ensure your user is mapped to the SAP BW system already, or you will not be able to launch the query

regards,

kaushal