Question:
Hi there,
In the current project we are facing a request to use the result of a report as a source to a third party system (BW report as the source -> Siebel as the target system). This report is based in a Multicube and we have quite a few RKF and CKF, this is the reson why we are not using the infocube as the source.
Until now the only option is:
- Use report agent to run the report;
- Use the download scheduller to save the result in the network;
- Heve the destination system (Siebel) reading the file from the network and do the upload.
Have any of you came across with a similar request? What here the solution implemented.
Regards,
Nelson
Answer:
Any ideas on this topic???
Answer:
The only options I can think of are (a) use OpenHub to extract the information to file (cost $$ for use of this), (b) use ABAP to query the information and pull it out, or (c) use SQL or MDX in SQL to query the information and extract it.
- Stephen
_________________
As a rule I don't answer Questions in PM.
(this is not to be a d**k, but it is to allow everyone to benefit from information. Not just one person.) Ask a question in the forum and I will answer it if I can.
Answer:
In the query properties, you can select 'Release for OLE DB Connect', or something like this.
It should be used for other reporting tools, or to push data back to CRM help to the query.
Have you tried that ?
Regards
_________________
Laurent THIBERT
Business Connection Amerique