Not able to see the data of XS advance HDI calculation view in Tableau report

[former_member590265]

Hi All,

I am working first time on the XSA and HDI containers. I am following below link for the developments.

https://blogs.sap.com/2017/12/18/consume-calculation-views-from-xs-advanced-via-information-access/

In HANA WebIde; I have created one Project, under that I have one HANA Database Module. In HANA Database module under the src folder; I have created one table using this table I have created one calculation view. For this calculation view; I have created one role. In role I have given the object privileges on the calculation view and table plus schema privileges. I assigned this role to one of the DB user. Using this DB user I am connecting to the HANA system from Tableau. In Tableau I am able to see the calculation view under the schema but I am not able to view the meta data and data of the calculation view. But I am able to see the metadata and data from the tables used in the calculation view.

Please could you suggest what steps I am missing in my developments or authorizations because of which I am not able to see the meta data and data of the calculation view in Tableau? Could you suggest any step by step blog on how to do this or any video tutorial on this topic explaining end to end scenario and steps.

Thanks in advance.

Thanks.

Best Regards,

Vivek.

[former_member196019]

Vivek,

We are facing the same issue and it is with XSA based cal views not with XS Classic cal views . Is there any solution from you guys figured wither from SAP or tableau?

[former_member592042]

I'm also wondering the same thing... Have any of you tried posting the question on the Tableau forums?

[former_member590265]

Hi Erik Froberg,

Thanks for the help. We contacted to the Tableau regarding this issue and they said in current version they do not support to Hana 2.0 XSA. This functionality will be available from version 2019.2 onward. Till that time we need to use this workaround on server also. As you have also implemented this on server; I wanted to check on the column labels. When we add the calculation view in the report it only shows technical name of the columns but do not show the labels of the column. Do you have any trick to show the labels for column instead of column technical name.

Thanks.

Best Regards,

Vivek.