Skip to Content
May 15, 2018 at 09:37 PM

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?