cancel
Showing results for 
Search instead for 
Did you mean: 

How to change the Web report URL with BEx?

Former Member
0 Kudos

Hi,

We have a problem here with the Web reports. We have reports on the portal on internet and we have created rules on reverse proxy as http://www.xyz.com/bw1 mapped to http://<internal_FQDN>:<Port>/bw1 where bw1 is the service defined in SICF pointing to sap ..so all reports are now internally available as http://..../bw1/sap/bw/BEx?<reports>. Now the problem is with mimes, the mimes are always pointing to /sap/bw/mimes..how can we change the url for mimes in reports to /bw1/sap/bw/mimes ..?

Thanks

Manish

Accepted Solutions (0)

Answers (3)

Answers (3)

former_member181887
Active Contributor
0 Kudos

Hi,

The solutions provided in this thread will work but there is an ongoing maintenance that will be required. All new Web Templates/Mimes/etc will have to be manually modified (even if this is by executing the ABAP). Additionally you cannot you the same web template (and URL) for internal and external users, you require two web templates!

Additionally it becomes more difficult to load balance your reporting if you are hard coding hosts and ports.

I would suggest that you simplify the solution by using the SAP Web Dispatcher functionality. You install the SAP Web Dispatcher in your DMZ and this provides the mapping from the dispatchers <host>:<port> to the real <BW_host>:<BW_port>. SAP Web Dispatchers work with your reverse proxy and automatically hide your BW systems info from the external users.

The benefit is that you do not need to modify your BW web template URLs! <low admin is always good! >

In addition the Web dispatcher itself can do load balancing or you can still use the BW message server to load balance. Your choice!

There is a large amount of detailed information on the SAP Web Dispatcher in the help portal (http://help.sap.com). It is a SAP Web AS component so look in that section.

The new 6.40 version have some nice SSL termination features too!

I hope this helps and gives you another, maybe simpler, option.

Regards,

Mike.

Former Member
0 Kudos

Hi Manish,

It's easy to award points, and it's a way to say "thanks".

See: <u>/people/mark.finnern/blog/2004/08/10/spread-the-love for directions.

Click on the Yellow Star icon in each reply.

You can give:

1 - 10 pointer (solves problem, marks as answered)

2 - 6 pointers (very helpful)

Lots of 2 pointers (helpful)

Cheers,

Joan (and Mark Finnern)

Former Member
0 Kudos

You can change the mime reference to point to the new URL. The program 'RSZW_REPLACE_TEMPLATE_STRINGS' can be used for mass replacement of text in the web template, this also writes into a transport request.

Thanks.

Former Member
0 Kudos

Hi Deepu,

I tried to run it as stylesheet old = "/sap/bw/Mime/" and stylesheet new = "/bw1/sap/bw/Mime/" but it says 0 stylesheets changed. Do you have any idea why?

Thanks for your reply,

Manish

Former Member
0 Kudos

Copy the exact string from the template which needs to be replaced and give the new string, it should work.

Thanks.

MarcelRabe
Advisor
Advisor
0 Kudos

Hi Deepu,

great tip (i want to reward some points but i do not know how...). However, is this also possible per http alias?

in our environment, amongst several BSP's from different SAP servers, we publish BW reports 'through' the portal via the IIS reverse proxy. The mimes indeed are read by default from /sap/... which causes big problems when multiple sap systems use the same reverse proxy.

Therefore I'd like to use HTTP aliasses for bw reports. The reports are started without a problem but the mimes still use the old /sap/... reference.

I've implemented your solution and i see that 1 template has been changed, but no changes in the URL take place. Not even after a restart of the BW server. What do you mean when you say it has to point to the exact template? What template?

Also I'm wondering if this change affects ALL future BW web report calls, in other words, also for the dafault URLs (/sap/bw/bex?....)

Thnk you

Marcel

Message was edited by: Marcel Rabe

Message was edited by: Marcel Rabe