SAP HANA DirectQuery Issue

[mtaubman]

I have a report with an SAP HANA DirectQuery source.  I have a column with text that has values like '0000000ABCD'.  I add a Report level filter with the condition "Is not blank" for this column.  I display this on a table visual and it shows correctly.  When I create a calculated column with the formula

Col No Zero = SUSBSTITUTE([my text column], "0", "")

and add this column to the table visual, the table visual no longer displays the data correctly.  Col No Zero is populated, but the original text column now shows many blanks, and the few values that do show up do not match the Col No Zero values in any way.

[v-qiuyu-msft]

Hi @mtaubman,

I have reported this issue internally: CRI 49244433. Will update here once I get any feedback. 

Best Regards,
Qiuyun Yu 

[v-qiuyu-msft]

Hi @mtaubman,

Please see below response from PG team: 

We investigated the issue and our conclusion is that the problem is in SAP Hana Driver. Also, the issue seems limited to the SUBSTITUTE DAX function, which is translated to SQL REPLACE, other text functions work fine. Since this is an external product defect, we recommend to ask the customer to try updating their driver or report the issue to SAP to get help.

Best Regards,
Qiuyun Yu 

[v-qiuyu-msft]

Hi @mtaubman,

How's the issue going now? 

Have you tried updating their driver or report the issue to SAP to get help?

Best Regards,
Qiuyun Yu

[mtaubman]

Thank you for asking.  We are working with SAP, but I don't know how quickly they will be able to help.  We are eagrly awaiting the new HANA Connector, which may also resolve this issue.

[v-qiuyu-msft]

Hi @mtaubman,

Thanks for your update. If you get information from SAP side, please feel free to update here which will benefit other members who have the same issue. 🙂

Best Regards,
Qiuyun Yu

[v-qiuyu-msft]

Hi @mtaubman,

May I know if the issue is solved now? 

Best Regards,
Qiuyun Yu