Table Column Not Visible(VARBINARY Type)

[former_member587559]

Hello, I have a calculation view;

My table column, (which has VARBINARY data type) is not visible on Analysis Section, Distinct Value Section and upper Calculation View's nodes in the SAP HANA Studio.

Table Column Name: MESSAGEFROM

First Picture Explanation: SMART Projection includes MESSAGEFROM column.

Second Picture Explanation: SMART projection's analysis and distinct values doesn't show related column. So i didn't analyse.

Third Picture Explanation: Column correctly be found, we can see.

How can I understand that strange situation?

Kind Regards

[KonradZaleski · Accepted solution]

Columns of VARBINARY data type are not available for Analysis in HANA. Similairly if you are using Analysis for Office as frontend tool, you will not see in the output any columns of VARBINARY data type, even if in semantics of calc view you provided them. If you really need it, then you can create calculated column of VARCHAR type, when you convert VARBINARY to STRING and use that calculated column in Analysis tab.

If you want to make some analysis on specific node, you can take the sql query which is generated in Raw Data tab (after clicking Show Log you will have the SQL query for that node) and then you can adjust the query in SQL console according to your requirements and run it.

[former_member587559 · Accepted solution]

Thanks Konrad.

I have created one calculation column and than implemented that script: TO_NVARCHAR("column_name")

HANA Studio accepted that operations, so problem solved.