cancel
Showing results for 
Search instead for 
Did you mean: 

How to Design a Universe from SAP R/3 data ?

Former Member
0 Kudos

Hi,

I have data in SAP R/3 system . i need to design a universe based on that R/3 system data. But we can't create a universe using R/3 data. what i need to do ?

What i know is, Either we need to covert R/3 system data to SAP BI system or we need to migrate that to SQL server using any ETL tool. Is it true ? If so which one is better?

Please help me on this issue as soon as possible.

Thanks in advance..

Accepted Solutions (0)

Answers (1)

Answers (1)

0 Kudos

currently (you have the following options:

1. You load your R/3 data into an SAP BW and use universes based on BEx queries to create WebI reports

2. You can use SAP rapid marts. They contain Data integrator mappings (you need an installation of the DI for this) to extract and load your SAP R/3 data into a relational database. Additionally they provide universes (based on a relational schema) hich ill allo you to build WebI reports.

3. You can use the R/3 connector for the Data Federator (You need a DF installation for this). Please note that the R/3 connector is not yet a product rather just a PROTOTYPE. Take a look here: [original link is broken]

4. You can try to access the underlying database directly using the appropriate DB drivers. Please note that this is NOT RECOMMENDED. This way you cannot leverage security defined on the R/3 side in your WebI reports and you will not be able to access all data as available in R/3 since some of them are stored encoded/compressed in the underlying tables.

5. Instead of WebI you can use Crystal Reports and the R/3 drivers (eg. SAP Tables, Functions, Cluster) provided when installing the integration kit for SAP.

Since your data come from an SAP R/3 system the best option in my opinion is to load them into an SAP BW installation.

Regards,

Stratos

Former Member
0 Kudos

Hi Efstratios,

Thanks for your help. Is there any issue if i migrate that to SQL server using any ETL tool? Please explain the difference. I need to explain this to client.

Thanks,

Swathi.

0 Kudos

You have to build your on data model on the SQL server and then fill it up using the ETL tool. I do believe that it can be faster to design the load processes that get your data into SAP BW than to build your own data model in a relational database from the scratch and then design the appropriate ETL processes to load the data. But this depends also from the exact requirements of your customer.

Regards,

Stratos

Former Member
0 Kudos

Hi Efstratios,

Thanks for your help.

Thanks,

Swathi.