Question:
Hi
CAN XML DO A DATA UPDATE TO CUBE/ODS/INFO OBJECT ?
Regards
Pal
Answer:
yes , there is a white paper on how to create a XML datasource , here is a summary
The use of the delta queue from the Service API is the basis of a solution as an inbound queue for the XML document data that was parsed in the SOAP service and converted in ABAP fields.
Special DataSources are generated for this within the BW system and have the following properties: They have the BW system as a source system, they are exclusively intended for uploading delta records, and they have an interface for supplying the delta queue.
The interface, that was released for developing extractors within the framework of SAPI for uploading the delta queue, is wrapped for this by using a DataSource-specific, RFC-capable function module that is generated for the DataSource. Based on the RFC-capability, this function module can be automatically identified by using the assigned HTTP handler from Basis for supporting the SOAP log.
The starting point for generating such a special DataSource is a file DataSource. You can use the file DataSource for supplying BW with large amounts of data that do not need to be run by using the XML interface. It serves to characterize the XML data in BW. Actually, the entire solution consists of two DataSources that logically belong together. One of these is for a file source system, and the other is generated within the BW system.
This connection is deliberately not assigned for DataSources from other sources. The assumption should not be made that copies of these DataSources would create the desired XML procedures. It is up to the person responsible for the application to decide whether they want to deliver their own solution based on the generic solution described here.