Question:
This is a BW question.
therefore, it has been moved in the BW forum
_________________
SapFans Moderator
NetWeaver ‘04–SAP Web AS for ORACLE certified
Search: /forums/search.php
SAP Notes: http://service.sap.com/notes
SAP Help: http://help.sap.com
Basic Rules: /forums/viewtopic.php?t=222759
Answer:
Open Hub is really the general answer here. Other interfaces like OLEDB or XMLA are not really built for replicating largae volumes of data (100,000++ records) (although I lelieve there are some cases where this worked). If the data are just sitting in the ODS, you might be able to use the ODS API to access directly from here.
Answer:
I assume you are the same who posted before.....
/forums/viewtopic.php?t=57898&highlight=
Answer:
I do not understand why you keep asking the same questions again and again. Please do not waste others time.
Remember if you need data from BW you have to pay tax to SAP - why on earth are you putting data into BW that you need elsewhere if it is SAP data generate flat files directly from SAP R/3 to these external sources. Don't move SAP data into BW and generate extracts from BW SAP will audit BW and ask your customer for money at end of year for data pulled from BW.
If your problem is consolidating multiple data sources put it into SQL database consolidate and take it don't try to bring all this data into BW to consolidate. Unless you deliberately want your company to go broke.
Does it all make sense desist from asking same question again and again.
DB Guru
Answer:
Hi guys,
If you notice, i have posted only 2 messages so far of the 'same' sort. And this was the 1st one i posted. As this one looked very generic i tried to refine my questions and there came my 2nd msg(which you guys already commented in there )
So sorry for all the confusions and frustrations caused by my messages and thank you all for your generous and critical comments.
Be cool..
AdrienHi guys,
Is there any way we can schedule the extraction of data from BW(through OPEN HUB*) into a local flatfile??
As far as I know the SCRMS_BAPI can only download data into a flatfile in SAP dir(AL11). Is there a parameter which would allow us to download/update the flatfiles directly into the local??
Any comments very much appreciated!
(* assuming we decided to use open hub to do the extraction from BW)
Adrien