Connectivity of Xcelsius/ Crystal Dashboard Design with SAP ECC/ERP

In Order to Integrate /connect Xcelsius or Dashboard design to SAP systems there could be two approach to it:-

1. Need to implement SAP BW to fetch data from ERP to InfoCube (aggregated) and DSO (for details) to push the same to Xcelsius dashboard. 
2. Or we can get the same data by directly accessing ERP (ECC 6 EHP 4) to XCelsius, without going into BW implementation?

But there is always business requirement to connect Xcelsius to direct SAP ECC system so that latest data can be seen without any delay. Like rather seeing data through BW which could take time fetching data from the ECC system performing ETL activity and applying business rules to it which takes  time . 

So to connect Xcelsius (2008) as mentioned below with  SAP ERP and BW system you can do via live office and Query as web service or directly connecting with SAP Bex queries.

Ex: - With Xcelsius 2008 Service Pack 02 and SAP NetWeaver 7.01 SP05 you are able to create a direct connectivity from Xcelsius to your BW system.

So just to give heads up on Connectivity with SAP ERP system in xcelsius you can follow the three steps path like:-

• Connect Crystal report to Infoset.Try launching Crystal Reports, create a new report, and choose the "SAP Info sets" connection.

and Crystal report you can directly connect to SAP InfoSets (SAP ERP ECC system queries)

• Use Crystal report in Live Office
• And Live office can be used to connect to Xcelsius

Now with the latest release of business Objects Business Intelligence 4.1, connectivity to Xcelsius can be done via IDT (Information Design Tool).still no direct connection is available but you can have SAP ERP data via IDT. So it’s one level ahead what we had in previous version.

So now you can connect

                                     SAP ERP --> IDT (information design Tool) --> Xcelsius 

so no need to have live office connectivity.