Issue in connecting from Crystal reports to SAP BW or SAP R/3

After Installing Crystal reports 2008 , I was able to create a new connections to BW and R/3 systems. I was able to access Bex queries but when is tried to access ODS's in BW, It gave me this problem.

Cause :

Certain transports needs to be installed in BW and R/3 side  for Crytal reports to access these tables.

Solution:

 BO integration Kit downloaded  from the SAP market place also has transport files in it.
There are two sets of transport files, which can be used with BusinessObjects Enterprise Integration Kit for SAP. One set is ANSI and the other set is Unicode enabled.

The set of transports you must use depends on the BASIS system your SAP system is running on. Additionally, each transport consists of a data file and a cofiles. should be

If your SAP system is running on a BASIS system earlier than 6.20, you must use the files listed below:
(These files are ANSI.)


* Open SQL Connectivity transport (K900084.r22 and R900084.r22)
* Info Set Connectivity transport (K900085.r22 and R900085.r22)
* Row-level Security Definition transport (K900086.r22 and R900086.r22)
* Cluster Definition transport (K900093.r22 and R900093.r22)
* Authentication Helpers transport (K900088.r22 and R900088.r22)

If your SAP system is running on a 6.20 BASIS system or later, you must use the files listed below:

(These files are Unicode enabled.)
* Open SQL Connectivity transport (K900574.r21 and R900574.r21)
* Info Set Connectivity transport (K900575.r21 and R900575.r21)
* Row-level Security Definition transport (K900576.r21 and R900576.r21)
* Cluster Definition transport (K900585.r21 and R900585.r21)
* Authentication Helpers transport (K900578.r21 and R900578.r21)

The following files must be used on an SAP BW system:

(These files are Unicode enabled.)
* Content Administration transport (K900579.r21 and R900579.r21)
* Personalization transport (K900580.r21 and R900580.r21)
* MDX Query Connectivity transport (K900581.r21 and R900581.r21)
* ODS Connectivity transport (K900582.r21 and R900582.r21)

Steps :

1. On the R/3 or BW side look up the following folders sapservername\usr\sap\trans and here you will have   two folder: data and cofiles.

2. You have to copy the data and cofiles content  to the corresponding folder on the SAP Server

3. Logon to SAP -> STMS T-code ->select the  System Domain ->then choose Import Overview and double click on the queue.
4. Then go to Extras Menu ->Other Requests ->Add

5.  select file and click Request Import (import only files contained in the cofiles folder)

The installation of BusinessObjects XI Integration for SAP Solution cannot continue because WACS has been installed with Business Objects Enterprise

This is the issue i encountered during installation of the BO Integration Kit. SAP note 1408550 will solve the issue.
Resolution :

To solve this issue, uninstall the Web Application Container Server (WACS)

- From the Control Panel select Add or Remove Programs
- Select the installation of Business Objects xi 3.1 and click Change
- Within the Installer select Modify
- Select Server Components > Web Application Container Server
- Choose the option : The entire Feature will be unavailable
- Click Next

Cause :

The Web Application Container Server (WACS) is not a supported application server for the Business Objects XI Integration for SAP Solutions.

To use .NET InfoView on IIS together with BusinessObjects XI Integration for SAP Solutions, you are still required to install backend applications such as CMCor Web Services on a supported Java application server.

Some BW ramblings

Info cube design Check :
FM : RSDEW_INFOCUBE_DESIGNS
ABAP Program: SAP_INFOCUBE_DESIGNS
***************************************************************************************
Copy data from one cube to another:
Function (SE37) RSDRT_INFOCUBE_DATA_COPY.This feature will allow you to directly copy data from one cube to another one***********************************************************************************
RSOSFIELDMAPSShadow Table: Mapping between OLTPs, Fields and IOBJs

to remove '#' value in Bex report

http://www.sap-img.com/business/removing-hex-sign-in-analyzer-report.htm

Sub SAPBEXonRefresh(queryID As String, resultArea As Range)
Dim c As Range
For Each c In resultArea.Cells
If c.Value = "#" Then c.Value = ""
If c.Value = "Not assigned" Then c.Value = ""
Next c
End Sub