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_member592042]

Really late answer – sorry for that – but I'll post anyway in case someone is still struggling with this.

We also had the issue with labels not being transferred earlier, but now in Tableau 2019.2 (maybe already in 2019.1, don't remember) we do get the column labels from calc. views as field names in Tableau, which is great.

Another issue we had earlier was that Tableau didn't recognize input parameters defined in the XSA calc.views, but that's also working now in 2019.2. So looks like Tableau spent quite some effort making their product more HANA XSA ready for 2019.2, which is great.

Best regards,

Erik