cancel
Showing results for 
Search instead for 
Did you mean: 

Business Objects With ERP

Former Member
0 Kudos

Actually I need your advice for a requirement I have a customer that donu2019t want to implement BW at all but he is very interested in SAP Business Objects BI Tools This customer has a huge amount of data and the manager insisting not using BW or BWA So my only choice is to use only form BOBJ BI package: Xcelsius and Crystal Reports But I am also wanted to provide WebI and explorer but I know this impossible

I had read in SDN Articles that I can use Federator to connect to the ERP directly and so I can create a universe and so I can deliver Webi Document and Explorer

So I need your advice and your recommendations for this

Accepted Solutions (0)

Answers (1)

Answers (1)

0 Kudos

Hi

currently you have the following options:

1. 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.

2. 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]

3. 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.

4. 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.

Regards,

Stratos

Former Member
0 Kudos

Thanks a lot Mr.Efstratios

Actually the customer didn't want Crystal Reports he is interested in the following:

(Webi,Explorer,Xcelsius)

For Rapid Mart I have a question if there is a solution for Real Estate beside the customer will need this Data Mart to be online(Meaning if there is a new record in ERP it will be directly shown in the Data Mart"Online Enterprise Data Warehouse Concept")

For Data Federator:I have the opportunity to use it but is there is any plan for SAP to support ERP connection in the near future

0 Kudos

The data from SAP ERP have to be loaded (ETL process) in your data mart otherwise they will not be available for reporting.

As far as I know one of the possible solutions will be HANA. It will hold ERP transactional data in memory and the future releases of the SAP BO BI tools should be able to report on those data.

For an official statement I would recommend to contact SAP sales or open a support case (http://service.sap.com/message)

Regards,

Stratos