Last Modified Date: 10 Dec 2018
Environment
- Tableau Desktop
- SAP HANA calculation view
Resolution
As a workaround, try to emulate the different tables that make up the SAP HANA calculation view inside different Tableau extracts. The goal would be to have one extract that contains only fields from the one table.To do so, please follow the steps below:
- Connect to the live data source.
- Create the view.
- Click "Hide all unused fields" from the drop-down on the Data pane menu. For more information, see Hide or Unhide Fields.
- Create an extract by right-clicking the data source and selecting Extract data.
- Repeat above steps for each required view.
- Combine the views on a dashboard. Each view will be based on its own extract.
Cause
If a SAP HANA calculation view is based on multiple raw tables, then mixing fields from the various tables can lead to incorrect results.Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Continue Searching
Knowledge Base
Community
Product Help
Training and Tutorials