Skip to Content
Author's profile photo Ingo Hilgefort

BusinessObjects and SAP – Publishing of Crystal Reports Part 2 of 3

This is the second part of three where I explain how you can configure the BusinessObjects system and the SAP BI system to leverage the publishing workflow with Crystal Reports.

 

In case you followed the first part you should now have the publishing service running, a RFC Destination in transaction SM59 configured and a configured BusinessObjects server definition in transaction /CRYSTAL/RPTADMIN.

Now we continue with the configuration steps.

 

Configure the SAP source parameters

In addition to the definition of the BusinessObjects server you also need to configure the SAP Server settings that should get used for the reports in the BusinessObjects server. You could – as an example – design a report against an application server but then when publishing it switching to a message server with a logon group.

 

I start the transaction /CRYSTAL/RPTADMIN(Content Administration Workbench)….

And navigate to the SAP System settings in the Publish reports area.

 

I select the item Set BW source parameter.

 

… and click on the button New Entries.

I can now enter either a combination of application server and system number or a combination of application / message server and logon group. These settings will then be used and configured in the actual Crystal Report object when the report is being pushed from the BI system to the BusinessObjects server.

   

 

Configuring the SAP HTTP request handler

To enable viewing of reports in BW via the role menu (for example, opening a Crystal Report from the SAP GUI), you need to  configure BW to use the HTTP request handler that is included as part of the Crystal Content Administration Workbench transport. Then, when a BW user opens a Crystal report from within the SAP GUI, BW is able to route the viewing request over the web appropriately to BusinessObjects Enterprise.

I start transaction SICF(Maintain services)… 

…and navigate to the the folder default_host / SAP / BW

 

I double-click on the service ce_url.

 

… and select the tab “Handler List” .

 

I then change the list to ensure the entry /CRYSTAL/CL_BW_HTTP_HANDLER is the top entry.

This specific handler is part of the ABAP Transports (see the Installation and Configuration for details).

 

This configuration allows the user to also start a report from inside the SAP GUI (for example: from the role menu) and thenecessary server details are then resolved dynamically based on the configuration we made earlier in the transaction /CRYSTAL/RPTADMIN.

 

In Part 3 I will explain the necessary steps in regards to security on the BusinessObjects server.

 

For those that missed the installation parts, here are the links to the blogs:

BusinessObjects and SAP – Installation and Configuration Part 1 of 4

BusinessObjects and SAP – Installation and Configuration Part 2 of 4

BusinessObjects and SAP – Installation and Configuration Part 3 of 4

BusinessObjects and SAP – Installation and Configuration Part 4 of 4

BusinessObjects and SAP – Configure SAP Authentication

BusinessObjects and SAP – Publishing of Crystal Reports Part 1 of 3

Assigned Tags

      9 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Glen Spalding
      Glen Spalding
      hi ingo, i have managed to get this far and feel like i've been on a journey comparative to lord of the rings. but, oh so close.

      i am running an NSP with the 3.1 BO Edge. All works well individually, however, these last crystal report publishing steps have caught me out.

      trying to follow as close as possible.

      the message i am having is a popup when saving the crystal report.

      "An error occurred while saving and/or publishing. The return code 1 was returned from the server. An error occurred when synchronizing folder hierarchy for role: SAP_BW_ALL(EAS 30001)"

      i have had to use the SAP_BW_ALL role because other roles you mentioned did not exist in my setup.

      so maybe you can help me narrow down where the problem is.
      thanks
      glen

      Author's profile photo Ingo Hilgefort
      Ingo Hilgefort
      Blog Post Author
      Hi Glen,

      in general I would suggest you also use the forums for technical issues - much easier.

      on the role part I used examples - you can use any roles.

      Did you :
      - import the roles as part of the SAP Authentication ?
      - did you assign the role to the Enterprise system in transaction /crystal/rptadmin ?
      - did you assign the necessary rights for these roles on the BusinessObjects server ?

      Ingo

      Author's profile photo Glen Spalding
      Glen Spalding
      1. i did import the role successfully in the CMC.
      2. the role is assigned in SAP /crystal/rptadmin
      3. my sap folder has the role assigned with all possible authoriztion

      can i confirm that the /crystal/rptadmin http setting for web server host and port is the tomcat? e.g. mac:8080, and not the ABAP web server.

      Author's profile photo Ingo Hilgefort
      Ingo Hilgefort
      Blog Post Author
      Hi Glen,

      yes - it is the app server from the BusinessObjects system. You can find these details also in the installation guide for the SAP Integration Kit.

      Ingo

      Author's profile photo Ingo Hilgefort
      Ingo Hilgefort
      Blog Post Author
      Hell Glen,

      I would also suggest that you use the forum for the SAP IntegrationKit .

      the roles can be any roles.

      - did you import the role using the SAP authentication configuration ?
      - did you configure the role as one possible role in the transaction /crystal/rptadmin ?
      - did you assign the necessary rights on the BusinessObjects Server for the role ?

      thanks
      Ingo

      Author's profile photo Former Member
      Former Member
      HI Ingo,

      Is it possible to setup setup BW publisher on two different BW systems ?

      if yes where ? I can only enter one system details during SAP integration kit installation or in Registry edit for BW publisher.

      Thanks

      Author's profile photo Ingo Hilgefort
      Ingo Hilgefort
      Blog Post Author
      Hi,
      I would suggest you create an entry in the Forums and describe what you trying to do.

      Is it  1 BW and N BusinessObjects or N BW and 1 BOE ?

      ingo

      Author's profile photo Former Member
      Former Member

      Hi Ingo, thanks for instruction.

      But after all is done, we have error EAS 30001 at publication process((((

      SAP BOE XI 3.1. Build number 1188, ProductVersion (12.4.1.188)

      SAP BW 7.1

      Author's profile photo Ingo Hilgefort
      Ingo Hilgefort
      Blog Post Author

      Hello Mergen,

      I would suggest you open a case with the support team.

      regards

      Ingo Hilgefort, SAP