Skip to Content

Crystal reports 2013 , SAP MDX Driver not able to connect with BW BEX Query

Hi All,

We just installed Crystal 2013, and want to create crystal report on SAP BW CUBE/BEX Query through SAP MDX Driver.

1.When start connecting through SAP MDX Query option from new connection , SAP Systems which are in SAPLOGON are not appearing in initial screen. where as from OLAP Connection we are able to connect to SAP BEX Query.

2.Even from SAP Tool kit we are not able to connect to BEX query, we are getting ERROR MESSAGE.

and we are using SAP BI BO PLATFORM 4.1 sp01 .

Please suggest me , if I am missing any configuration settings.

Regards,

Joseph

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    Posted on Jul 26, 2014 at 12:14 PM

    Hi Joseph,

    Before you start building the report, make sure the right transports have been loaded on the SAP System. The right Transport files are the ones found inside the installation zip you download from SAP's server. They're under the "Collaterals\Add-Ons\SAP\Transports" folder.

    For more info on Transports, authorizations etc, please have your BASIS admin go through this wiki:

    Crystal Reports 2008 and BW - Installation and Configuration - Business Intelligence (BusinessObjects) - SCN Wiki

    To resolve your first issue, please follow the steps from this thread:

    P.S: Crystal Reports for Enterprise 4.1 does a better job at handling BEx queries that the CR 2013 designer. It directly connects to BEx queries via the BICS connectivity driver and doesn't need the Transports to be there on the SAP System. You might want to give this flavour of CR a try too.

    -Abhilash

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.