SAP Community Network Forums » Business Objects » Integration Kits - SAP

Thread: Reporting out of SAP R/3 4.7

This question is answered.


Permlink Replies: 2 - Pages: 1 - Last Post: Nov 3, 2009 7:37 PM Last Post By: Ravi Yalamanchili Threads: [ Previous | Next ]
Krishanu Saha

Posts: 17
Registered: 3/3/09
Forum Points: 10
 
Reporting out of SAP R/3 4.7  
Posted: Oct 29, 2009 7:01 AM
Click to report abuse...   Click to reply to this thread Reply
My client wants reports in WEBI and dashboards in Xcelsius.

The data source is SAP R/3 4.7

I was wondering if we can report from WEBI.

With Crystal Reports 2008 it is possible and Xcelsius dashboards are also possibe using Live Office. But the major challenge here is Reporting on WEBI using R/3.

Can any one suggest a feasible solution?

Thanks,
Krishanu
Efstratios Kara...

Posts: 2,081
Registered: 7/21/08
Forum Points: 3,512
 
Re: Reporting out of SAP R/3 4.7   Correct
Posted: Oct 29, 2009 8:46 AM   in response to: Krishanu Saha in response to: Krishanu Saha
Click to report abuse...   Click to reply to this thread Reply
Hi,

the first option is to deploy SAP BW in your organization and load/organize your R/3 data into the deployed warehouse. You can then build universes (based on SAP BW queries) and thus use WebI to report on your data.

You can also have a look at the BusinessObjects Rapid Marts. These include Data Integrator mappings which allow you to extract R/3 data into a given relational database DWH scheme. Additionally the package includes universes which allow you to report on the extracted data. Prerequisite is a relational database installation like DB2, Microsoft SQL Server or Oracle.

A generic solution for accessing R/3 data directly using WebI is not available.

Regards,

Stratos
Ravi Yalamanchili

Posts: 6
Registered: 12/17/07
Forum Points: 26
 
Re: Reporting out of SAP R/3 4.7  
Posted: Nov 3, 2009 7:37 PM   in response to: Krishanu Saha in response to: Krishanu Saha
Click to report abuse...   Click to reply to this thread Reply
Krishanu,

A direct method of reporting on SAP data using Xcelsius dashboards is to create web services over function modules in SAP and using the web service URL as a data connection in Xcelsius. The process is the same as creating dashboards using QaaWS URLs.

For WebI reports, we cannot directly create Universes on SAP data. We have to load the data into BW, and use the SAP Integration Kit, like the earlier poster commented.

Ravi

Point your RSS reader here for a feed of the latest messages in all forums