5 Replies Latest reply on Nov 20, 2013 11:41 PM by davidclaen

    Relative Date Filtering in SSAS Cube

    Felix Chou

      Hi,

       

      How do I add Relative date filtering in SSAS cube hierarchy date dimension? eg: I want the dashboard to only show the last 2 weeks data from the date opened. Currently when I try to apply a filter to the date I can only do check boxes within the date hierarchy levels or Condition and Top tabs. Does that mean Tableau is treating the SSAS date dimension as non date type hence lost all the Tableau date features?

       

      I can use the relative date filtering in relational database connection so I assumed all the Tableau date features should be available via this connection type?

       

      I searched everywhere in the forum and apparently this is the limitation of SSAS connection?

       

       

      Thanks.