...

Using Composite for SAP R3 Query Reporting Tip or Technique

by user

on
Category: Documents
1

views

Report

Comments

Transcript

Using Composite for SAP R3 Query Reporting Tip or Technique
Tip or Technique
Using Composite for SAP R3
Query Reporting
Product(s): Composite Software 4.0.1
Area of Interest: Infrastructure
2
Copyright
Copyright © 2008 Cognos ULC (formerly Cognos Incorporated). Cognos ULC
is an IBM Company. While every attempt has been made to ensure that the
information in this document is accurate and complete, some typographical
errors or technical inaccuracies may exist. Cognos does not accept
responsibility for any kind of loss resulting from the use of information
contained in this document. This document shows the publication date. The
information contained in this document is subject to change without notice.
Any improvements or changes to the information contained in this document
will be documented in subsequent editions. This document contains
proprietary information of Cognos. All rights are reserved. No part of this
document may be copied, photocopied, reproduced, stored in a retrieval
system, transmitted in any form or by any means, or translated into another
language without the prior written consent of Cognos. Cognos and the
Cognos logo are trademarks of Cognos ULC (formerly Cognos Incorporated)
in the United States and/or other countries. IBM and the IBM logo are
trademarks of International Business Machines Corporation in the United
States, or other countries, or both. All other names are trademarks or
registered trademarks of their respective companies. Information about
Cognos products can be found at www.cognos.com
This document is maintained by the Best Practices, Product and Technology
team. You can send comments, suggestions, and additions to
[email protected] .
IBM Cognos Proprietary Information
3
Contents
1
INTRODUCTION ............................................................................................ 4
1.1
1.2
1.3
PURPOSE .............................................................................................................. 4
APPLICABILITY ....................................................................................................... 4
EXCLUSIONS AND EXCEPTIONS .................................................................................... 4
2
INSTALLING THE SAP R/3 CONNECTIVITY ADD-ON .................................... 4
3
INSTALLING THE SAP JAVA CONNECTOR LIBRARY ..................................... 5
4
IMPORTING SAP METADATA ........................................................................ 6
5
PUBLISHING SAP METADATA FOR CONSUMPTION IN IBM COGNOS .......... 8
IBM Cognos Proprietary Information
4
1
Introduction
1.1
Purpose
This document outlines the steps required to use Composite Information
Server to report on SAP R/3 ABAP queries and Infosets.
1.2
Applicability
The techniques and product behaviours outlined in this document apply to
Composite Software 4.0.1 using the 2.1.6 SAP JCo adaptor.
1.3
Exclusions and Exceptions
The method and settings outlined in this document are subject to change in
future releases.
2
Installing the SAP R/3 Connectivity Add-On
By default Data Services for SAP are not included with the standard
Composite Information Server install. This functionality will need to be
applied via an installation add on.
The following section has been extracted from the DataServicesforSAP.pdf
which is shipped as core Composite Information Server documentation. It
has been added to this document to provide a single point of information.
To install Data Services for SAP on Windows
1. Shut down the Composite Server, if it’s running. On Windows desktop,
you can select Start > All Programs > Composite Software x.x > Server >
Stop Composite Server vx.x.
2. Double-click the installer, DataServicesForSAP_CISxx-3_0_1.exe to
begin the installation process. This must be performed on the machine
where Composite Information Server is installed.
3. The installer window should appear. Click the Next button to display
the license agreement page. If the license agreement is acceptable
click the I Agree
4. Select the components to be installed. Each component is described
below.
• Data Services for SAP — Installs the SAP Driver, enabling
access to SAP Data Sources. Also copies CAR files to the
Composite installation directory, Data Services subdirectory.
IBM Cognos Proprietary Information
5
5. When finished selecting components, click the Next button to proceed
to the next page.
6. Enter the directory containing the Composite Server, or click the
Browse… button to locate the directory by navigating the file system.
When the correct directory has been selected, click the Install button
to begin the installation. When installation completes, click the Next
button to proceed to the final page.
7. Click the Finish button to quit the installer.
3
Installing the SAP Java Connector Library
The SAP Java Connector (JCo) 2.1.7 requires a Java Runtime Environment
(JRE) version 1.3 or higher. Additionally, an RFC runtime library version 6.40
or higher must be installed on the system on which you would like to run JCo.
A sufficient version of the RFC library is already shipped with this distribution
package but you may also download a newer one from
http://service.sap.com/patches.
The latest version of the SAP Java Connector can be downloaded from the
SAP Service Marketplace at http://service.sap.com/connectors. There you will
also find all available distribution packages for the various supported
platforms and processors.
The information in this section has been extracted from the \jco\installation
.html which is supplied with the download of the JCo. It has been added to
this document to provide a single point of information.
1. To install JCo for Windows unzip the appropriate distribution package
into an arbitrary directory {sapjco-install-path}.
2. If an older librfc32.dll in the {windows-dir}\system32 directory, please
replace it with the one that comes with JCo.
3. Copy the sapjcorfc.dll to the {windows-dir}\system32 directory. If an
older one exists please replace it with the one that comes with JCo.
4. Then add {sapjco-install-path}\sapjco.jar to your CLASSPATH
environment variable.
IBM Cognos Proprietary Information
6
5. Alternatively, the sapjco.jar can be copied to the Composite
Information Server installed directory under
..\server\apps\dlm\ds_sap\lib. Once the Composite Information
Server services are restarted the jar file should be loaded by the
application.
4
Importing SAP Metadata
Now that the connectivity pieces has been installed on the Composite
Information Server. An SAP data source can now be created via Composite
Studio.
To do this:
1. After signing into Composite Studio, Right click on the Shared folder
and select the “New Data Source”
2. Within the Add Physical Data Source dialog box, Select SAP from the
list and hit the Next button.
3. Enter
•
•
•
•
•
•
the following information and click Next.
Name: This is a friendly name
Application Server: This is the host name for the SAP system
System Number:
Client:
User: This is the SAP user userid
Password: This the SAP user password
IBM Cognos Proprietary Information
7
4. Below is an example of the available metadata.
5. For the purpose of this demo an ABAP Query has been selected from
the Global Area for import.
IBM Cognos Proprietary Information
8
6. Click Finish to complete the import. The Metadata should now be
available on within the resource tree as per the image below.
5
Publishing SAP Metadata for Consumption in IBM
Cognos
In order for the SAP metadata to be consumable within IBM Cognos 8.2,
the metadata needs to be published to a database under the Composite
Data Services. To do this:
1. Within the Composite Studio, under Composite Data Services, right
click on the Databases folder and select “New Composite Data
Service”
2. Provide a Database name and select OK. For this example the
database will be named “SAP”.
IBM Cognos Proprietary Information
9
3. Framework Manager requires that the Composite Information Server
metadata is contained in a Catalog and Schema. Select the “SAP”
data base and right-click. Form the available menu select “New
Catalog”
4. Provide a catalog name and select OK. For this example the catalog
name will be “Catalog”.
5. Right click on “Catalog” and Select “New Schema”. Provide a new
Schema name and select “OK”. For the purpose of this document the
schema name will be ‘Schema” as illustrated below.
IBM Cognos Proprietary Information
10
6. Right click on “Catalog” and Select “New Schema”. Provide a new
Schema name and select “OK”. For the purpose of this document the
schema name will be ‘Schema” as illustrated below.
7. Locate the metadata object under the “SAP” data source and rightclick. From the available commands, select “Publish”
8. From the available database select the schema under SAP\Catalog and
press OK.
The data is now available to be imported by IBM Cognos 8.2
Framework Manager.
IBM Cognos Proprietary Information
11
IBM Cognos Proprietary Information
Fly UP