1 Reply Latest reply on Jun 15, 2016 1:15 PM by Patrick A Van Der Hyde

    Tableau and SSAS hierarchies

    Pasi Tyni



      I'm creating Tableau dashboard and I need to hide or unhide columns based on user selections in hierarchy

      My data comes from Microsoft SSAS multidimensional cube. In the cube there is a hierarchy, that is like level 1, level 2, level 3, level 4


      I want to show target and actual values in the level 1, but when user opens the level 2, report should unhide some new columns, like value 1, value 2 and value 3


      How can I manage this ?


      Other question is that can I drill down and up in my hierarchy in rows .. not in columns. I mean that the hierarchy is in rows and I can drill hierarchy down by one row at the time ?


      I also want to know is there any way determine the level of the hierarchy that user has selected ?


      I'm using Tableau desktop 9.3