Sorry if this problem was already explained, but I cant find it. I use SSAS as datasource and i cant do drill down when adding attributes into a table when the hierarchy is not already created in the cube. My question is: Is it possible to create hierarchies in Tableau Desktop when the datasource is multidimensional data as SSAS? Its a pity that the drill down is not possible .....
I attach an example. The purpose is easy, I want to drilldown those rows...
Thanks for help.
Hi Jon -
It is not. Since cubes are much more "buttoned down" in terms of metadata, you'll find there is less Tableau can do for you when connected to them. Creating hierarchies is one of the things the cube owner will need to do (versus allowing Tableau to do it for you).