Report based on SAP data source returns no data when migrated to BO 4.0 environment

[Former Member]

Hello everyone,

We need help for the following problem:

On a BO Edge 3.1 Server we daily run Reports developed with Crystal Reports 2008.

The Reports use the SAP Integration Kit Connection “SAP Table, cluster, or Function”

For several Years the Reports run fine now.

Now, we need to move the Reports to the newly set up Busines Objects 4.0 SP 5

For this we used the Upgrade Management Tool (UPD).

The reports were successfully copied to the new Server but they don’t work anymore.

The refresh of the data does not obtain any data from the SAP Table connected.

So we have Crystal Report 2008 on BO 3.1 Working Properly (Data from SAP Table ok)

And the UPD Copy of it on BO 4.0 which pretends to fetch data from the same table (no error/info/warning-message at all). But the report stays empty.

A newly created Report, with the same fields from the SAP Table as the original, but without any filters (just to see if anything from the source can be seen) does only fetch data for the field “date”. All other fields stay empty.

Any ideas what’s the matter could be ?

Apparently something is missing or changed in the “new” (4.0) SAP Integration Kit.

But since there is no Message at all, just an empty report after refresh we have no clue what to do.

Please give us guidance to solve this.

[Former Member · Accepted solution]

We Solved the problem as follows:

The SAP integration Kit in BO 4.0 istalls by default but there are stil some Transports for the backend which need to be installed by the SAP Basis.

You will find them in the istallation packige for BO4 Server at this path :

51043404\DATA_UNITS\BusinessObjectsServer_win\Collaterals\Add-Ons\SAP\Transports.

After this step our migrated reports work well.

Regards

AnnK

[former_member182521]

Hi Ann,

Please be informed SAP Integration kit is not required in BI4.0 as it is integrated.I would Suggest you to check whether you configured the required SAP systems & RFC's as part of Post installation configuration activity.

Regards

Mani

[Former Member]

Hi Mani,

Thank you for your answer.  It’s good to get a confirmation about that.

In the in the meantime I compared the 3.1 and 4.0 environments and I was surprised about the missing folder for “SAP Intergration Kit” underneath of the 4.0 installation folder. I relay on the documentation, but is it possible to prove if the SAP Integration Kit installed properly?

As to the post installation configuration of the SAP System: could you please provide us some more information on this?

I remember, with the 3.1 integration Kit there were some Transports for the backend included. This is done (the 3.1 Reports still work fine)

Is there something similar needed for the 4.0 Integration? If yes where to find it?

If there are any configurations to do, could you please advice us on this?

Many thanks and have a good weekend.

AnnK

[Former Member]

In BO 4.0 there are no transports for the BW systems.

I don't see a clue why this datasource shouldn't work with BO 4.0.

However we haven't used cluster table functionality until now, so i can't help you with this.

Regards,

Marco