Today my colleague found the following post “Tableau 9.0 Calculated fields” (http://community.tableau.com/thread/161992) by Maddy Pena. She also describes that she cannot use dimensions from a SAP BW Query for Calculated fields.
I read another article by Tableau “Changing Data Type to Date in Cubes” (http://kb.tableau.com/articles/knowledgebase/changing-data-type-to-date-cubes)
In this article an MDX-Statement is used to change the data type of a cube dimension by using calculated members. I tried to adapt the example to my needs but I didn’t manage.
Is the MDX statement (via defining calculated members) a solution for customizing dimensions from SAP BW Queries?
Looking forward to your replies.