SAP BE connection is able to connect but fails when filtering a column

[piterab]

I'm having an issue with the SAP BW Connector when applying a filter.   I first connect fine... it previews the data fine, but then when i go to filter down to 1 years data, it fails as the screenshot below:

"Invalid MDX command with ON"

Error Code: -2147467259

Invalid MDX Command with ON

[UltimoDidi]

Hi Piterab,

My colleague has experienced the exact same problem and found out that if you use "contains" instead "equals to" as operator in your filter, it works fine (at least for a text column).

That's clearly a bug in the way filters are translated to MDX queries against SAP BW.

Unfortunately, our experience so far with this connector has not been very good 😞