Has anybody experience relative date filtering issues in Tableau using SSAS? I tried with MDM and Tabular and both still struggle with implementing a functional relative date filter over a date hierarchy.
I have search everywhere and only found 2 suggestions but netiher of the two can do the trick
The First option is the nearest but still has some problems. Let's say I want to filter 01-Jul-2013 to 15-Aug-2013:
The second option is little worse. Let's say I want to filter 01-Jul-2013 to 15-Aug-2013:
Does anyone know any other solutions apart from the two options above where I can use relative date filter in a date dimension? One way to get around this is to design the dashboard as static date range so the end user cannot do any roll up aggregation/drill down but this defects the purpose of the self-service data visualisation.