Skip to end of metadata
Go to start of metadata

Product versions:
Crystal Reports 2008
NW BW 7.01

In this article you will find best practices when configuring a deployment of Crystal Reports to report off BW.

Integration with Crystal Reports

There are different components in the SAP integration kit. The following diagram shows the components and functionality related to Crystal Reports.

Installation and Configuration

Crystal Reports client machines

Install:

  1. SAP GUI with BW Add On
  2. Crystal Reports 2008
  3. BusinessObjects XI Integration for SAP

Supporting material

The following articles, blogs, product guides contain detailed information on how to install the components listed previously
Articles
Getting started with SAP BusinessObjects BI content
Integration Kit for SAP Installation and Configuration
Product Guides
Crystal Reports Installation Guide

Blogs
Crystal Reports Installation - BusinessObjects and SAP -Installation and Configuration Part2 of 4

Recommendations

  • Make sure to install SAP GUI along with BW Add On before installing Crystal Reports and BusinessObjects XI for SAP Integration.
  • Verify that you have the required version and the required patch level of SAP GUI. These are listed in the list of supported platforms for the BusinessObjects Integration Kit for SAP.
  • The SAP toolbar does not show up in Crystal Reports when using SAP Frontend 7.x. SAP Frontend 7.x requires the BW Add On 3.x to display and work with the SAP toolbar in Crystal Report.
  • It is recommended that you update to SP2 (Crystal Reports, SAP integration kit, BusinessObjects Enterprise). This is because in SP2 there were two improvements that greatly reduced the response times:
    The MDX generated by Crystal Reports Data access components when handling characteristics that have no specified hierarchy was changed.
    The BOE CMS query that is generated when a BW managed report is requestet was also changed. This improves the response time when requesting report in BOE using a BWID for example, when using portal i-views or the role menus.

BusinessObjects Enterprise server

Install:

  1. SAP GUI with BW Add On
  2. SAP Java Connector
  3. BusinessObjects Enterprise XI 3.1
  4. BusinessObjects XI Integration for SAP

Configure after installation:
SAP Authentication in CMC and import SAP roles as groups in CMC
CMC configuration for SSO/SNC in SAP - this is optional

Supporting material

The following articles, blogs, product guides contain detailed information on how to install and configure the components listed previously
Articles
Getting started with SAP BusinessObjects BI content
Integration Kit for SAP Installation and Configuration
Setting simple SAP authentication in XI 3.1 CMC
How to configure SNC in XI3.1 CMC
Product Guides
BusinessObjects XI Integration for SAP Solutions Installation and Administration guide
Blogs
BusinessObjects and SAP-Installation and Configuration Part 4 of 4
BusinessObjects and SAP - Configure SAP Authentication

Recommendations

  • BusinessObjects Enterpise or BusinessObjects Edge are required for the implementation of Crystal Reports with BW.You need Crystal Reports to create reports and BusinessObjects Enterprise to share them with others. Neither Crystal Reports viewer or Crystal Reports Server are supported for implementation with BW.
  • Verify that you have the required version and the required patch level of SAP GUI and SAP Java Connector. These are listed in the list of supported platforms for the BusinessObjects Integration Kit for SAP. BusinessObjects XI3.1 SP2 for SAP
  • Install SAP GUI and Java Connector before installing BusinessObjects XI Integration for SAP.
  • If you have a distributed installation of BusinessObjects Enterprise, consult the BusinessObjects XI SAP Integration Installation guide to make sure you install the different BusinessObjects XI Integration for SAP Solutions components on the appropriate machines. Distributed install
  • BusinessObjects Enterprise servers will be processing the reports, sizing BusinessObjects Enterprise correctly is fundamental for a sucessful implementation. Sizing Guide

BW

Configure:

  1. Import required transports
  2. For SSO based on tickets with the BusinessObjects Enterprise and the BW System (either from the SAP GUI or via the SAP Enterprise Portal) you need to configure profile parameters in the SAP BW System.
  3. For BW Publisher configure RFC destination and configure Content Administration Workbench
  4. Configure 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.

Supporting material

Articles
SAP Integration Kit Step by Step transport installation
Configuring BW Publisher Service for Crystal Reports 2008
BW Publisher and SNC configuration
Product Guides
BusinessObjects XI Integration for SAP Solutions Installation and Administration guide- Configuring SAP Authentication
BusinessObjects XI Integration for SAP Solutions Installation and Administration guide- Configuring the BW Publisher Authentication
Blogs
BusinessObjects and SAP - Publishing of Crystal Reports Part 1 of 3
BusinessObjects and SAP - Publishing Configuration Part 2
BusinessObjects and SAP - Publishing Configuration Part 3

Recommendations

  • Review supported platforms document in order to find out which patch level is required on the SAP server side in order for the connectivity with Crystal Reports and BusinessObjects Enterprise to work.
  • BW 7 Enhancement Pack1 it is recommended when using MDX Query driver as there are MDX enhancements in BW that benefit Crystal Reports.
  • Transports
    • In order for the SAP Integration kit native drivers to communicate with the SAP system, it makes remote function calls (RFCs) to specific function modules that must be stored in the RFC layer on the SAP server. That is, the drivers generate code and pass that code to the SAP server; the server then uses specified function modules to execute the code. The required function modules are provided in the form of transport files, which are included as part of the Integration kit for SAP. You must import these transports into your SAP system and configure a number of authorization objects in order for users to connect to SAP through Crystal Reports and BusinessObjects Enterprise.
    • Transports do not depend on whether the system is Unicode or non-Unicode. It is only the Basis level that determine whether to install the Ansi vs. Unicode compatible transports.
    • Check the transports.txt document on the Integration Kit for SAP installation media for a list of all available transports
  • BW Publisher and Content Administation Workbench
    • It is not mandatory to use the BW Publisher to publish reports from BW to BOE, but not using it means missing functionality such as:
      • Online list of values for prompts
      • Hierarchical display for hierarchical node prompts
      • SAP variable personalization
      • Doing life cycle management of Crystal Reports (from DEV to QA to PROD) with the SAP transports
    • When defining a new enterprise system in the Content Administration Workbench the Default System check box makes this entitlement system the default one to publish to if a role is not defined in any entitlement system. Generally, this option is not use as part of the configuration you specific role, this is considered an assigned role.
    • A role can only be assigned to one BOE Enterprise System. Thus by selecting a role and adding it to your entitlement system, this role will not be available for other entitlement systems.
    • BW Publisher is only for Crystal Reports.

SAP Enterprise Portal

If desired you can integrate your Crystal Reports into EP, there are different options:

  • URL iview
  • BOE iView (specific to Crystal Reports)
  • Knowledge Management

BOE iview configuration

  • Import BOE iView template into EP
  • Create a System Landscape in EP
  • Create required iviews using BOE iview template

URL iview configuration
The URL iview template is not BOE specific, this is a SAP Enterprise Portal standard template and does not require any additional configuration, besides the prerequisites listed in the recommendations below.

KM Configuration

  • Import and configure BOE Repository Manager package
  • Configure KM Layout

Supporting material

Articles
Integration of BOE XI3.1 into the SAP Enterprise Portal 7.x
Product Guides
BusinessObjects XI Integration for SAP Solutions Installation and Administration guide- Managing theSAP Portal

Recommendations

To implement URL iView/BOE iView or KM there are some prerequisites:

    • SAP Enterprise Portal (EP) and SAP ABAP system configured for SSO
      **SAP Enterprise Portal, SAP ABAP and BOE Web Application Server in the same DNS domain.
    • BOE server with SAP Integration Kit
    • SAP ABAP system configured as an entitlement system in CMC
    • SAP roles imported into CMC
    • BOE InfoView configured to support single sign-on
  • No labels