Skip to Content
avatar image
Former Member

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!

kind regards!


Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    May 27, 2013 at 09:21 AM
    Add comment
    10|10000 characters needed characters exceeded

  • Jun 04, 2013 at 01:46 PM

    You need to install the Crystal Transports in the ECC system.

    These are available in the Crystal installation folder

    I recommend working with your Basis team to get those installed.



    Add comment
    10|10000 characters needed characters exceeded

  • May 27, 2013 at 09:19 AM


    You need to use a "multi source" enabled .UNX universe, published to the BIPlatform as a pre-requisite.

    To do this, go via IDT, open "repository resources", and create your Relational connection from there.

    This will invoke the Data Federator engine (part of the Adaptive Processing Server) on the BIPlatform.

    From here, you can point to your ERP structure in your table foundation. 

    After building a Business Layer atop of the federated tables, you Publish the universe.

    Then you will be able to consume the ECC structure into Dashboard Designer, and all other BI Client tools.



    Add comment
    10|10000 characters needed characters exceeded