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. Former Member 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. Marty 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. Former Member 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. Marty 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. Former Member 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. Marty 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. Former Member Post author
    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. Former Member
      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. Former Member
      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. Former Member Post author
    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. Former Member
      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. Former Member
      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. Former Member Post author
    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. Former Member
      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. Former Member
      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. Former Member
    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. Former Member
    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. Former Member
    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