1 Reply Latest reply on Oct 21, 2016 3:07 PM by Patrick A Van Der Hyde

    How to open report with latest month on top of SSAS cube

    Sumit Sharma

      Hi All,

       

      I need my Tableau report to always show the last month from my time dimension filter when it opens so that I don't always have to re-deploy the reports every month. The report is on top of SSAS cube. I have tried using months on the rows and having a calculation for LAST() but that impacts performance. I also need the month quick filter so that a user can select any previous month as well Is there a easier way to do this without impacting performance? Or is there a way in which Tableau can automatically use the default member of month attribute from cube?

       

      Thanks,

      Sumit