BI-Java & AS ABAP connection two separate servers

[Former Member]

Hi,

Noticed that new ECC 6.0 client 000 supports BI by default. (eg: t-code RSA1 works) So BI & R/3 can have same SID and one system..I hope this is the new direction of SAP.

But my question is, I am installing AS-Java, BI-Java & EP on one server with SID BWD and another server (physically different box) with AS-ABAP, BI (add-on) with another SID (RTD)

Since BI NW 04s needs BI, AS-ABAP,AS-Java,BS-JAVA,EP and SAP's recommendation is to have ABAP and JAVA servers separate, then

How do we connect these two systems to use full BI use? (AS-ABAP & BI-JAVA system)

Which will be the actual SID to be given to BI end users?

Please let me know if there any other documents available than the standard Master Guides.

Thanks,

Mathew

[allaine_tabilin · Accepted solution]

Hi Mathew,

Connect the two systems by having entries in the table RSPOR_T_PORTAL (assuming that trusted connection has been setup between ABAP and JAVA servers). This can be done by running the CTC template in the JAVA server or the report (via SA38 or SE38) RSPOR_SETUP in the ABAP server). Check SAP note 917950 and the other links mentioned there.

Give the BWD SID to the users.

Thanks,

Allaine

[Abuzar · Accepted solution]

Hi Allaine

I have sucessfully configured BEX. now my requirement is as below:-

Actually my scenario is..

1. From SAP Front BI Explorer end i execute Query Designer.

2. It prompts to put BI ABAP user ID and Password.

3. After putting login id password it opens BEX query Designer.

4.Here i seleted one query and press Execute .

5. After Pressign execute button it opens a URL

( http://sap-bw.domain.com:50100/irj/servlet/prt/portal/prtroot/pcd!3aportal_content!2fcom.sap.pct!2fp...

In this screen it prompts to put Portal/java userd ID password. when i Put here login ID and password of portal user then it executes the query successfully.

My requirement is :- user dont want to put java userd id and password . Query should be executed without putting JAVA user ID password.

Please help to to solve this requirement.

-

---

BEX Query Designer version is

BI Addon 7.X based on 7.10

SP 10 Patch 1

J2EE version 7.01 SP3

ABAP Veriosn 7.01 EHP1 BW Patch level 0003 BI_CONT Release 704

-

---

Thanks

Abuzar.

[Abuzar · Accepted solution]

Hi Allaine

I have sucessfully configured BEX. now my requirement is as below:-

Actually my scenario is..

1. From SAP Front BI Explorer end i execute Query Designer.

2. It prompts to put BI ABAP user ID and Password.

3. After putting login id password it opens BEX query Designer.

4.Here i seleted one query and press Execute .

5. After Pressign execute button it opens a URL

( http://sap-bw.domain.com:50100/irj/servlet/prt/portal/prtroot/pcd!3aportal_content!2fcom.sap.pct!2fp...

In this screen it prompts to put Portal/java userd ID password. when i Put here login ID and password of portal user then it executes the query successfully.

My requirement is :- user dont want to put java userd id and password . Query should be executed without putting JAVA user ID password.

Please help to to solve this requirement.

-

---

BEX Query Designer version is

BI Addon 7.X based on 7.10

SP 10 Patch 1

J2EE version 7.01 SP3

ABAP Veriosn 7.01 EHP1 BW Patch level 0003 BI_CONT Release 704

-

---

Thanks

Abuzar.

[Former Member]

Abuzar,

Were you able to get a solution to your requirement. We are in a similar situation but different scenarios. We have BI ABAP and BI JAVA on two different physical servers and we have used Application Integration to create BI iViews on the Enterprise Portals server (Central Portal). The question would be as to which system info should be put in RSPOR_T_PORTAL table, would it be the Enterprise portal server or would it be the BI JAVA server info?

What we have observed is that for the BI Bookmarks to work, you need to have the Enterprise Portal server as the default connection in the RSPOR_T_PORTAL table in which case your BEx Web does not work and gives the error. If you change the RSPOR_T_PORTAL entry to point to BI JAVA server as the default then your bookmarks stop working and the BEx Web works fine.

We are trying to figure out a way to have both of these features works. Does anyone know how to make this work?

Amish

[Former Member]

This is done using the BEx Web Template Installer as described in OSS Note 917950.

[Former Member]

Hi,

In case of seperate installation of BI Java & ABAP on different servers:

1. Is it must that these servers should be in same domain?

2. What should be output of report RSBB_URL_PREFIX_GET , ABAP hostname & port or Java instance hostname & port?

Regards,

Apurva

[Former Member]

As far as i know, you should install both the applications, i.e., BI ABAP stack and Java stack in same domain.

but you can install in different application servers. Because if the end users want to access the reports which are created in BW front end in EP, then it should be in same domain right?