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]

I created a case with Tableau and got the following solution which works for me:

a. Close all instances of Tableau Desktop
b. Download and save the attached "SAP_HANA _import_hidden.tdc" file in the My Tableau Repository > Datasources folder
c. Launch Tableau Desktop and connect to a calculation view

I have attached the SAP_HANA _import_hidden.tdc file to the post, only renamed as .txt (as this was required in order to select it for attachment). Just rename it back to .tdc and put it in the folder:

sap-hana-import-hidden.txt

Hope it works for you guys as well.

/Erik

[mike_howles4]

Erik,

I'm running into the exact same issue in Tableau Desktop 2018.1 (Windows) and Power BI. I tried to follow your instructions and placed the file user the My Tableau Repository\Datasources\2018.1 folder, however it's not behaving any differently. Do you know if your Tableau case mentioned it must be 2018.2 to work?

EDIT: Just tried 2018.2 on a different machine (Macbook), I still cannot get any metadata back. I see the Calculation Views but there are no fields available.

EDIT #2: Another update: I tried 2018.2 on a Windows machine and the .tdc file worked! I guess since the Mac Tableau HANA driver is JDBC based, that the .tdc had no effect. I also guess that Tableau must be 2018.2 since 2018.1 did not work for me.

EDIT #3: Final update? 🙂 - I went back and tried again on 2018.1, and I realized I was putting the .tdc file in the 2018.1 sub-folder rather than just under Datasources. It also now works in 2018.1.

Thanks so much for sharing the .tdc file. Googling this issue really only leads to your post and nothing else helpful. Nothing on SAP or Tableau's site yet in the form of a KB on this issue. I would have just assumed it was impossible had it not been for your post. Thanks again!

[former_member569145]

HI Erik,

Thanks for posting those guidelines. Saving TDC file opened up the fields, however it is only showing column names. However our users are interested in knowing/ seeing business friendly names/ description. Is there a way by which we could expose the Comment/ Description/ Label instead of field names/ technical names?

Is there a setting we could from HANA that would enable one field vs another for external access (BO, AO, Tableau, etc as against HANA studio where we could see both).

Thanks in advance.

[former_member590265]

Hi Eric,

Thanks for solution. Your solution work for the Tableau Desktop version, but we are using Tableau server and we cannot do this work around on the server. It will be very helpful if you are able to provide some information or SAP Note which explain this issue and how to resolve on Tableau server or is there any patch release from SAP for Tableau server.

Thanks.

Best Regards,

Vivek.

[former_member592042]

Hi Vivek,

Actually, we did the same "trick" with the file on our Tableau server and that seems to work for us. If it doesn't work for you - I would recommend raising a ticked with the Tableau support.

Best regards,

Erik

[former_member395301]

Hi Erik,

We tried your solution for Desktop and it works, thanks!

Could you please advice Tableau Server folder for SAP_HANA _import_hidden.tdc file?

Best regards,

Ulad

[former_member790434]

Hi Erik,

I am facing similar kind of problem, we have SAP HANA CDS View as data source and when we tried to connect it through tableau desktop it only show Schema and Table option but we did not able to find where is CDS View or how to connect it. Do we are missing any thing in Tableau or HANA configuration ? If you know any thing please let me know.

Thanks !

Sachin

[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

[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.