You (or one of your ICT gurus) can write an MDX statement via the Calculated Member function in Tableau which will result in a new field that converts the date from the hierarchy into a format that then allows you to select the different date filter options.
This is one of the limitations of cube connections in tableau but as with most of the others, its possible to work around it.
Are you able to shed some light how to implement this calculated field? I am very limited in MDX so wouldn't have a clue how to do this. Appreciate your help.
There may be other ways to do this, but this is how we got it working;
Create a calculated member statement that refrences your date hierarchy (in my case, Metric Date.Fiscal Year) and set the result type as Date
Add the original date (in my case Dim Date) to the level of detail shelf and then add the calculated field as a filter and you should get the relative date options. You may encounter a problem with totals not displaying so right click on your measure and select total using Sum.
I have been writing a couple of articles on designing, building and using cubes with Tableau.
You can read the article here:
Hope that it helps you
in the past there were some performance issues while using continous date dimensions as relative date filters.
The issues appears, if cour Date Dimension has a Data Attribut and you are doing a typecast in Tableau to Date.
Then the query perfomrnace was going down.
Do you know if this issue is still present?