Skip to Content
avatar image
Former Member

Crystal Reports - Using NodeId returning MDX error

I am using a very basic BeX query based on 0ACCOUNT with a hierarchy enabled. When I include the "NodeId" under 0ACCOUNT in the CR deisgner and run the report, I get the following error:

Failed to retrieve data from the database.

This error is followed by

"Database Connector Error: 'BAPI Error #;0 Invalid MDX command with 0ACCOUNT'

Running the sql generated from the CR Report in BW transaction MDXTEST gives a generic error "Invalid MDX Command with 0ACCOUNT".

I tried different infoobjects and different hierarchies but the error is the same. The error doesn't occur if there is no nodeid or parentnodeid involved.

Has anyone else run into this issue?

Thanks.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • May 18 at 02:29 PM

    The first and important step in troubleshooting connectivity to SAP datasources is verifying Integration Kit transports, see:

    https://apps.support.sap.com/sap/support/knowledge/public/en/1921554

    Add comment
    10|10000 characters needed characters exceeded