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

      Hi,

       

      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?

       

       

      Thanks.

      Felix