Reporting on non BW systems
I'm relatively new to BOBJ but understand that it is possible to use external systems and/or flatfiles for reporting in BOBJ tools rather than have to develop the extract and data flow to bring the data into BW. Does anyone have any experience with this in a high user base environment and are there any points that I should avoid when using this feature? Examples of clients where this technology has been used would also be really useful.
on this variety of Datasources i would recommend that you check one of our Enterprise Information Management Tools like Data Federator or Data Services.
It would make more sense to first consolidate the data from all the sources into one DWH and report off from that. You would have greater Performance and cross reporting would be possible.
f.e. in the current release its sometimes not possible to join multiple datasources into one report. This will change wit the BI 4.0 release.
But going for a DWH is the better way.