No idea. Maybe using a .tdc file? You may want to contact Tableau Support about this issue.
Concerning this topic I would like to advise you to evaluate the capability of Theobald Software or get SAP BW on HANA. The Tableau-SAP BW integration is one with it's challenges where Tableau-SAP HANA is almost a "Plug & Play"
Thanks. It looks like that is how beta or custom functionality gets into connections. We are researching the standard functionality at this time. I will be reaching out to support.
At this point I am trying to get basic functionality working. Additional capital investments are not under consideration. And a HANA install is a major project and investment... not for the squeamish or those without a clear business case for its functionality.
Your point is clear. Performance will remain a major challenge in a SAP BW environment. The user experience will highly indicate the adoption of the reporting-service delivered.
3 of 3 people found this helpful
Tableau Support has provided two pieces of guidance:
1- BW Hierarchies with a large population of "Not Assigned" elements are a problem. Tableau recommends that BW developers use the BW option to turn this off. (It's a Hierarchy design option).
2- The BW Connector is designed to download all available hierarchies as part of the initial connection. There is no option to turn this off. The request has been sent to product management for consideration.
Note that I have successfully connected to SAP BW using infoobjects that have a dozen hierarchies of relatively small size (Less than 5,000 elements). It appear to be just the very large master data infoobjects that have this problem.
Therefore, I recommend that SAP BW Connector users avoid queries or infocubes that contain infoobjects that have a large number of hierarchies, or very large hierarchies, assigned to them. For BW users this would involve infoobjects with hundreds of thousands of entries- for example, 0MATERIAL.
Hi Charles, thanks for sharing the advices, they were quite helpful!
I was wondering if the guidence regarding the download of all hierarchies preceeds on the server. I mean, when we are developing a panel, we choose which hierarchy will be displayed, and then we publish the panel, so I understand it will use only that hierarchy, isn't that correct?
I am currently looking at using the SAP BW connector in 10.3 and i understand the desktop installation has to be installed on the machine that has SAP GUI installed. I am new to SAP BW and my boss has said he heard at the conference in London there would be some improvements in 10.4 SAP BW connector.
I wanted to ask in your expert opinion what are the improvements with the connector since 10.3.
Hello Norbert. Just a quick question. In the above answer you are suggesting BW on HANA and we are using the hierarchies in BW . Do you suggest any tips or suggestions when connecting Tableau to SAP BW on HANA and also which way you suggest 1) traditional BW way , connecting to BW/Bex query or exposing the BW Objects in HANA studio as views ( Att, Analytical and calc) and consuming them in Tableau. Could you please let me know when you get a chance.