Skip to Content

This weblog presents how to integrate Enterprise Portal and Business Warehouse using SAP Logon Tickets

1.Enterprise Portal Configuration

1.1.System parameters

System Administration->System Configuration->System Landscape

Parameter name: Parameter value

Application host: dns of system that is to be integrated with EP

Logon method: SAPLOGONTICKET

SAP Client: number of system client that is to be integrated with EP

SAP System ID (SID): SID of system that is to be integrated with EP

SAP System Number: number of system that is to be integrated with EP

Server Port: port number of system that is to be integrated with EP

Session Cookie Name: mysapsso2

Session URL Name: mysapsso2

System Type: SAP_BW

WAS Host Name: dns of WAS

WAS Path: /sap/bw/BEx

WAS Protocol: http

image

Setting parameters of BW in Enterprise Portal

1.2.Exporting the Enterprise Portal certificate

Start the SAP J2EE Administrator

Connect to appropriate server

Choose portal_sid/Server<…>/Services/Key storage

Select the TicketKeystore under Views

If the SAPLogonTicketKeypair-cert does not exist, there is a need to generate the certificate

Enter appropriate values in Key and Certificate Generation:

Parameter name: Parameter value

Subject properties: CN=portal_sid

Entry name: SAPLogonTicketKeypair

Store certificate: X

Algorithm: DSA

Choose Generate

Select SAPLogonTicketKeypair-cert under Entries

Choose Export

Change the name of certificate to portal_sid_certificate.crt

2.Business Warehouse configuration

2.1.Configuration of instance profile

Setting parameters of instance profile using transaction

RZ10

Edit profile

Mark checkbox ‘extended maintenance’

image

image

</br></br>

Importing the portal certificate</br></br>

Integration of EP and BW by SAP Logon Tickets enables using BW without second authorization</br>

To report this post you need to login first.

24 Comments

You must be Logged on to comment or reply to a post.

  1. Juan Carlos Vidaller
    Hello Julia,

    First of all, congratulations for your guide. I think it’s a useful and unified guide when you want to integrate BW in EP.

    But I’ve followed your instructions and when I’m viewing an standard BW iView and then I press “Log off” on the TLN, after confirm I want to log off from the portal it appears a logon popup window.

    Have you ever seen this problem? Do you know how I can solve it?

    My best regards and thanks in advance,

    Juan Carlos

    (0) 
    1. Julia Kielbasiewicz Post author
      I have never had the problem that you described. If I meet similar problem and find the solution I will write about it on sdn.

      Best regards,

      Julia Kielbasiewicz

      (0) 
        1. Martin McCormick
          Hello,

          I’ve come across this problem before and have posted a solution in the following forum post:

          /message/81881#81881 [original link is broken]

          Hope this helps,
          Marty

          (0) 
  2. Juan Carlos Vidaller
    Hello Julia,

    First of all, congratulations for your guide. I think it’s a useful and unified guide when you want to integrate BW in EP.

    But I’ve followed your instructions and when I’m viewing an standard BW iView and then I press “Log off” on the TLN, after confirm I want to log off from the portal it appears a logon popup window.

    Have you ever seen this problem? Do you know how I can solve it?

    My best regards and thanks in advance,

    Juan Carlos

    (0) 
    1. Julia Kielbasiewicz Post author
      I have never had the problem that you described. If I meet similar problem and find the solution I will write about it on sdn.

      Best regards,

      Julia Kielbasiewicz

      (0) 
        1. Martin McCormick
          Hello,

          I’ve come across this problem before and have posted a solution in the following forum post:

          /message/81881#81881 [original link is broken]

          Hope this helps,
          Marty

          (0) 
  3. Juan Carlos Vidaller
    Hello Julia,

    First of all, congratulations for your guide. I think it’s a useful and unified guide when you want to integrate BW in EP.

    But I’ve followed your instructions and when I’m viewing an standard BW iView and then I press “Log off” on the TLN, after confirm I want to log off from the portal it appears a logon popup window.

    Have you ever seen this problem? Do you know how I can solve it?

    My best regards and thanks in advance,

    Juan Carlos

    (0) 
    1. Julia Kielbasiewicz Post author
      I have never had the problem that you described. If I meet similar problem and find the solution I will write about it on sdn.

      Best regards,

      Julia Kielbasiewicz

      (0) 
        1. Martin McCormick
          Hello,

          I’ve come across this problem before and have posted a solution in the following forum post:

          /message/81881#81881 [original link is broken]

          Hope this helps,
          Marty

          (0) 
  4. Mathew Rodgers
    Julia,

    Have you worked extensively with Crystal to BW and Portal integration?  I managed to get our BW reports published to the Crystal Enterprise Server last night.  I later created Crystal Enterprise iViews in the Portal.  SSO is working great.  Just looking for best practices considering there are several options when creating the Crystal Enterprise Report iViews.

    -Matt

    (0) 
    1. Haffiz Momodu
      Hi Matt,

      I have successfully published the BW reports in Crystal Enterprise Server. But i am having issues creating Crystal Enterprise iViews in the Portal.

      I do not have SSO created which i believe should not be a problem. When i created a Crystal Enterprise iViews for a report it worked fine but asking for input.

      How do i create the iView not to ask for input?
      Also, must i have all reports in “Home >
      Folders> SAP > 2.0 > “ folder in Business object.

      Please kindly assist me in getting my issues resolved.

      –Haffiz

      (0) 
    2. Haffiz Momodu
      Hi Matt,

      I have successfully published the BW reports in Crystal Enterprise Server. But i am having issues creating Crystal Enterprise iViews in the Portal.

      I do not have SSO created which i believe should not be a problem. When i created a Crystal Enterprise iViews for a report it worked fine but asking for input.

      How do i create the iView not to ask for input?
      Also, must i have all reports in “Home >
      Folders> SAP > 2.0 > “ folder in Business object.

      Please kindly assist me in getting my issues resolved.

      –Haffiz

      (0) 
  5. Mathew Rodgers
    Julia,

    Have you worked extensively with Crystal to BW and Portal integration?  I managed to get our BW reports published to the Crystal Enterprise Server last night.  I later created Crystal Enterprise iViews in the Portal.  SSO is working great.  Just looking for best practices considering there are several options when creating the Crystal Enterprise Report iViews.

    -Matt

    (0) 
    1. Haffiz Momodu
      Hi Matt,

      I have successfully published the BW reports in Crystal Enterprise Server. But i am having issues creating Crystal Enterprise iViews in the Portal.

      I do not have SSO created which i believe should not be a problem. When i created a Crystal Enterprise iViews for a report it worked fine but asking for input.

      How do i create the iView not to ask for input?
      Also, must i have all reports in “Home >
      Folders> SAP > 2.0 > “ folder in Business object.

      Please kindly assist me in getting my issues resolved.

      –Haffiz

      (0) 
    2. Haffiz Momodu
      Hi Matt,

      I have successfully published the BW reports in Crystal Enterprise Server. But i am having issues creating Crystal Enterprise iViews in the Portal.

      I do not have SSO created which i believe should not be a problem. When i created a Crystal Enterprise iViews for a report it worked fine but asking for input.

      How do i create the iView not to ask for input?
      Also, must i have all reports in “Home >
      Folders> SAP > 2.0 > “ folder in Business object.

      Please kindly assist me in getting my issues resolved.

      –Haffiz

      (0) 
  6. Mathew Rodgers
    Julia,

    Have you worked extensively with Crystal to BW and Portal integration?  I managed to get our BW reports published to the Crystal Enterprise Server last night.  I later created Crystal Enterprise iViews in the Portal.  SSO is working great.  Just looking for best practices considering there are several options when creating the Crystal Enterprise Report iViews.

    -Matt

    (0) 
    1. Haffiz Momodu
      Hi Matt,

      I have successfully published the BW reports in Crystal Enterprise Server. But i am having issues creating Crystal Enterprise iViews in the Portal.

      I do not have SSO created which i believe should not be a problem. When i created a Crystal Enterprise iViews for a report it worked fine but asking for input.

      How do i create the iView not to ask for input?
      Also, must i have all reports in “Home >
      Folders> SAP > 2.0 > “ folder in Business object.

      Please kindly assist me in getting my issues resolved.

      –Haffiz

      (0) 
    2. Haffiz Momodu
      Hi Matt,

      I have successfully published the BW reports in Crystal Enterprise Server. But i am having issues creating Crystal Enterprise iViews in the Portal.

      I do not have SSO created which i believe should not be a problem. When i created a Crystal Enterprise iViews for a report it worked fine but asking for input.

      How do i create the iView not to ask for input?
      Also, must i have all reports in “Home >
      Folders> SAP > 2.0 > “ folder in Business object.

      Please kindly assist me in getting my issues resolved.

      –Haffiz

      (0) 
  7. Andrew Lewis
    In all the documentation I have read, including your site, you all say set the create_sso2_ticket to 1 or 2, based on whether it is signed by SAP CA or self signed.

    How do I determine how it has been signed.

    How do I sign the certificate, as exported from EP, by SAP CA (is this free), or self sign ?

    (0) 
  8. Andrew Lewis
    In all the documentation I have read, including your site, you all say set the create_sso2_ticket to 1 or 2, based on whether it is signed by SAP CA or self signed.

    How do I determine how it has been signed.

    How do I sign the certificate, as exported from EP, by SAP CA (is this free), or self sign ?

    (0) 
  9. Andrew Lewis
    In all the documentation I have read, including your site, you all say set the create_sso2_ticket to 1 or 2, based on whether it is signed by SAP CA or self signed.

    How do I determine how it has been signed.

    How do I sign the certificate, as exported from EP, by SAP CA (is this free), or self sign ?

    (0) 

Leave a Reply