Skip to Content

SAP CRM WEBUI: Mash-up to execute BW query, closing session

Hi SAP CRM Webui Friends,

I implemented a mash-up in a view which is located on an overview page in the interaction center. The mash-up executes a query in BW to get the revenue figures for a confirmed account. Each time when the user navigates to the overview page (similar to a “factsheet page”) the revenue figures are loaded.

I used “embedded view” tool in the configuration of the overview page and added following URL. No abap coding.

-----------------------------------------------------------------------

http://sapobpdb.xxxxxxxxxxxxxxx.local:50100/irj/servlet/prt/portal/prtroot/pcd!3aportal_content!2fcom.sap.pct!2fplatform_add_ons!2fcom.sap.ip.bi!2fiViews!2fcom.sap.ip.bi.bex?TEMPLATE=ZWAD_SC_COCUSTOMER_002&

&BI_COMMAND_1-BI_COMMAND_TYPE=SET_VARIABLES_STATE

&BI_COMMAND_1-VARIABLE_VALUES-VARIABLE_VALUE_1-VARIABLE_TYPE=VARIABLE_IN

PUT_STRING

&BI_COMMAND_1-VARIABLE_VALUES-VARIABLE_VALUE_1-VARIABLE=ZSCP_KUNDE_01

&BI_COMMAND_1-VARIABLE_VALUES-VARIABLE_VALUE_1-VARIABLE_TYPE-VARIABLE_IN

PUT_STRING=<VALUE[BOL:BP_ACCOUNT:ID]>

---------------------------------------------------------------------

Result see screen 1:

screen1.png


Working so far, but when I click somewhere else or leave the screen a new tab “closing session” is opened and it takes a long time until the tab disappears. See screen 2 below.

If I click on a Webui link to ERP to display an offer via transaction launcher than the closing screen will go away immediately. If I stay in CRM than it stays for a longtime 10-20 seconds (You can see in screen 1 on the right side a link to an ERP offfer via Transaction launcher).

screen2.png


The URL in the clossing session screen:

javascript:document.write('<html><body>Closing sessions...</body></html>');document.close();setTimeout('window.close()',15000)

In BW it seems that while the user is working in WEBUI and clicking here and clicking there multiple sessions are still open or not closed.

Anybody out there who understands what is happening?

All in all it seems that the sessions in BW are not finished when the user navigates or logs off from WEBUI.

How can we get rid long waiting time of the “closing session”?

How can we avoid that multiple sessions are open in BW?

Thanks a lot for your help,

Simon

screen1.png (117.6 kB)
screen2.png (27.9 kB)
Add comment
10|10000 characters needed characters exceeded

  • Hi Simon,

    I think the pop up window is used to closed the session for backend system. Can you try if you see the same if you logon to portal directly to close any session, will you see the same pop-up windows? If so, then I think we may need to involve portal experts.

    Best regards,

    Bruce

  • Hi Bruce,

    thanks for your answer.

    I will have another session with my customer this week and we will play around including also your suggestion.

    Thanks,

    Simon

  • Follow
  • Get RSS Feed

1 Answer

  • Jun 27, 2018 at 06:09 AM

    Hi Simon,

    As discussed before in comments, I think the pop up window is used to closed the session for backend system. Can you try if you see the same if you logon to portal directly to close any session, will you see the same pop-up windows? What is the current situation now?

    Best regards,

    Bruce

    Add comment
    10|10000 characters needed characters exceeded