SAP Message RSCRM019 - Could not generate MDX because query is incorrect; redesign query

Diagnosis
The underlying SELECT statement could not be generated.

System Response
MDX or OLAP error

Procedure
Redesign the query in the BEx Query Designer.