3 Replies Latest reply on Aug 27, 2013 3:20 PM by Peter Thomsen

    Date type not recognised in date dimension (with Hierarchies) in OLAP cube

    Felix Chou



      Does anyone know how to make Tableau recognise date dimension as date type in the cube so I can make use of the date features Tableau offer? eg: Relative date filtering...etc


      My current date dimension as follow:


      Calendar Date:

      - Calendar Year

            -Calendar Quarter

                -Calendar Month

                     -Calendar Day


      Tableau seems to treat all the above fields within the hierarchy as label (text) hence the date features not available as well as the graph timeline. I know to create another non-hierarchy field reference date dsv column or calculated member as a work around but is there any alternative out there?