cancel
Showing results for 
Search instead for 
Did you mean: 

SAP HANA DirectQuery Issue

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.

Status: Accepted
Comments
Moderator

Hi @mtaubman,

 

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

 

Best Regards,
Qiuyun Yu 

Established Member
Status changed to: Accepted
 
Moderator

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 

Moderator

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

Frequent Visitor

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.

Moderator

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. Smiley Happy

 

Best Regards,
Qiuyun Yu

Moderator

Hi @mtaubman,

 

May I know if the issue is solved now? 

 

Best Regards,
Qiuyun Yu