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?
does this thread help out - Relative Date Filtering in SSAS Cube
My brain is mud on Cubes but there are a few good articles an threads from others here in the community. Search terms: MSAS, OLAP, and Cube - that might help out.