Retriving Members from SAP seems 100% correct. Adding the Dimension_Unique_Name inside the call getMembers will produce a XMLAnalysisError.0x80000005 Error. Checking the SOAP Call with curl a change on the RestrictionList brings the expected result.
Bad Statement: $INFOCUBE[ZD_PROD]
Working Statement: $INFOCUBE$ZD_SALES[ZD_PROD] It seems that the CUBE_NAME is required for SAP BW.
Removing the wildcard() call on cubeNamePattern inside the function getMembers from the class XmlaOlap4jDatabaseMetaData produces
the right output.