Question:
Is there a way my ABAP program runs and go to the OLAP to get data instead of the users get the data from OLAP and save it as text file to then use the FM UPLOAD to get it into SAP?
Thanks.
Answer:
Maybe using RFC function ?
When you talk about OLAP, do you mean BW or a non-SAP system ?
If you use a new version of BW, you can try using the open hub infospoke technology (transaction RSBO) with a process chain to have automatic transfert.
Answer:
Yes. But there is no such software (or data source) as OLAP, it's just a general name. I bet that all the vendors provide a way to access their data from outside. You should provide more details to get some kind of answer.
_________________
ilya
More input data: http://abaplog.wordpress.com
Sapfans ABAP FAQ: /forums/viewtopic.php?t=94198
R's ABAP Knowledge Corner: http://www.Rard-harper.net/kb/kb.html
Function modules documentation: http://www.se37.com
Answer:
Maybe using RFC function ?
When you talk about OLAP, do you mean BW or a non-SAP system ?
If you use a new version of BW, you can try using the open hub infospoke technology (transaction RSBO) with a process chain to have automatic transfert.
Our OLAP is an non-SAP system, some sort of Microsoft tool, not BW.
I read the help for RFC but not really understand it.
Thanks.
Answer:
So you have to look in your microsoft olap sytem how they can extract data and "push" it to the external world. Once the data will be extracted from you MS apps, come back here, there is plenty of methods to import data from outside world depending on the format and the platform where this data is.
Answer:
So you have to look in your microsoft olap sytem how they can extract data and "push" it to the external world. Once the data will be extracted from you MS apps, come back here, there is plenty of methods to import data from outside world depending on the format and the platform where this data is.
That's the reason I posted the question. I don't want the users (or the users don't want) to do this extra step. I know how to get the data out of the OLAP and use the upload to get it into SAP.
Thanks.
Answer:
You seem a bit confused we are using Microsoft OLAP instead of SAP BW at our site. The features of Microsoft OLAP are so powerful and the tool is so easy to use we move our SAP R/3 data everyday into Microsoft OLAP for analysis and reporting. I cannot understand why you are trying to move data from Microsoft OLAP into SAP R/3. To me it does not sound correct. Check your strategy!!
Data Warehouse Guru
Answer:
You seem a bit confused we are using Microsoft OLAP instead of SAP BW at our site. The features of Microsoft OLAP are so powerful and the tool is so easy to use we move our SAP R/3 data everyday into Microsoft OLAP for analysis and reporting. I cannot understand why you are trying to move data from Microsoft OLAP into SAP R/3. To me it does not sound correct. Check your strategy!!
Data Warehouse Guru
Marketing is using a third party software to do their planning, then dump their planning data into the Microsoft OLAP. I need to go to that OLAP to get the data to bring into SAP for production planning purposes.
Answer:
Ok, Your extracted data from your Ms OLAP system is a flatfile ? reside on a pc ? create a small program and use the function WS_UPLOAD.
Data Warehouse Guru : Sometime you want to update your OLTP system from your OLAP because data come from a legacy system or if you want to do a close-the-loop scenario : olap store data from oltp, determine new values based on aggregation / calculation and you want to update your oltp back again. Any ABCindicator could be a good example.
Answer:
Just an example: i2 Demand Planner (can be considered as OLAP) is providing ODBC driver. You install it and then can get your data into Excel or other tools, including SAP (e.g. by calling Microsoft ADO objects from ABAP). Check if your software provides similar options. To my mind, the key for this problem should be on OLAP side (at least when you are asking for help on ABAP forum), because you can easily call external functions from ABAP (using OLE, if running in foreground, or RFC or external OS commands if in background). If you will know any API that your external software provides, get back here - we can discuss how to call it.
_________________
ilya
More input data: http://abaplog.wordpress.com
Sapfans ABAP FAQ: /forums/viewtopic.php?t=94198
R's ABAP Knowledge Corner: http://www.Rard-harper.net/kb/kb.html
Function modules documentation: http://www.se37.com