Integration of XCelsius with SAP ERP (ECC)
Client has a requirement to graphically present Total POs and Total GRNs of Total PRs. On drill-down any calculated value we get its detail for selected period in the form of grid.
My question is, what architecture should be followed:
1. Either we need to implement SAP BI 7.01 (Warehouse) 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?
The above is just a single requirement, however, we would be having many of the dashboards to design. So typically, the question becomes, how can we perform complex calculations if we directly connect ERP to XCelsius?