SAP Queries in Xcelsius/Crystal Dashboard Designer
my name is David and actually i compose my bachelor thesis.
In the first step of my project I have generated the relevant SAP-Queries via Infosets (sq03 --> sq02 --> sq01) in SAP. Now i try to get a connection between Crystal/Xcelsius and my ERP-System (reports), but i dont know how...the problem is i need a direct connection from the BO-System(Crystal/Xcelsius) to SAP.
The first idea was to use the web service connection in crystal/xcelius, but i dont know how to get an access to the reports in SAP (which transaction did i need, what have i to do?) A http connection via transaction "sicf" is available.
If it is not possible to get a direct connection to my generated reports, whats about to generate a function module (Web Service in ECC) to get access to a table who already exists in SAP ?
I hope someone can give me assistance and tips to get my project done
Thank you so much for your help!
Here is one more option you can consider.
You can make a direct connection to the ECC InfoSet using Crystal Reports.
You can also embed a Dashboard/Xcelsius in Crystal Reports.
This is a back-door way of getting your InfoSet data into Xcelsius but it works well.
This also works for ECC Function Modules.